| | |
|---|
| | | bool isCgjl = Security_Log("Cg_POOrderBill_PurchasManager", 1, true, user); |
|---|
| | | if (!isCgjl) |
|---|
| | | { |
|---|
| | | sWhere += $" and HEmpID in (select HEmpID from Gy_Czygl where Czymc='{user}' )"; |
|---|
| | | sWhere += $" and HEmpID in (select HEmpID from Gy_Czygl where Czymc='{user}' and HEmpID >0 )"; |
|---|
| | | } |
|---|
| | | string sql = "select * from h_v_IF_POOrderBillList where 1 = 1 " + sWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_POOrderBillList"); |
|---|
| | |
|---|
| | | { |
|---|
| | | foreach (DataColumn item in ds.Tables[0].Columns) |
|---|
| | | { |
|---|
| | | optionList.Add(@"{ field: 'hmainid', title: '"+ item.ToString() + "', sort: true, hide: false }"); |
|---|
| | | optionList.Add(@"{ field: 'hmainid', title: '" + item.ToString() + "', sort: true, hide: false }"); |
|---|
| | | } |
|---|
| | | string option = string.Join(",",optionList); |
|---|
| | | string option = string.Join(",", optionList); |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | |
|---|
| | | title = item.ToString(), |
|---|
| | | sort = true, |
|---|
| | | hide = false, |
|---|
| | | }); |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | string option = string.Join(",", optionList); |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | |
|---|
| | | |
|---|
| | | // |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
