| | |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | //鍒ゆ柇鏉冮檺 |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("QC_WorkSelfCheckBill_Query", 3, false, user)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "鎮ㄦ病鏈夎妯″潡鏉冮檺,璇蜂笌绠＄悊鍛樿仈绯伙紒"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | string sql1 = "select * from h_v_QC_WorkSelfCheckBill where 1 = 1 "; |
|---|
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_WorkSelfCheckBill"); |
|---|
| | |
|---|
| | | BillNew.omodel.HProcExchEntryID = ClsPub.isLong(mainList[0].HProcExchEntryID); |
|---|
| | | BillNew.omodel.HProcExchBillNo = ClsPub.isStrNull(mainList[0].HProcExchBillNo); |
|---|
| | | BillNew.omodel.HProcExchQty = ClsPub.isLong(mainList[0].HProcExchQty); |
|---|
| | | BillNew.omodel.HProcID = ClsPub.isLong(mainList[0].HProcID); |
|---|
| | | BillNew.omodel.HMaterID = ClsPub.isLong(mainList[0].HMaterID); |
|---|
| | | BillNew.omodel.HFirstCheckEmp = ClsPub.isLong(mainList[0].HFirstCheckEmp); |
|---|
| | | BillNew.omodel.HLastResult = ClsPub.isBool(mainList[0].HLastResult); |
|---|
| | |
|---|
| | | oSub.HUpOffSet= DBUtility.ClsPub.isStrNull(subList[i].HUpOffSet); |
|---|
| | | oSub.HDownOffSet= DBUtility.ClsPub.isStrNull(subList[i].HDownOffSet); |
|---|
| | | oSub.HAnalysisMethod = DBUtility.ClsPub.isStrNull(subList[i].HAnalysisMethod); |
|---|
| | | oSub.HKeyInspect = DBUtility.ClsPub.isLong(subList[i].HKeyInspect); |
|---|
| | | oSub.HKeyInspect = DBUtility.ClsPub.isBool(subList[i].HKeyInspect); |
|---|
| | | oSub.HInspectInstruMentID = DBUtility.ClsPub.isLong(subList[i].HInspectInstruMentID); |
|---|
| | | oSub.HInspectResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); |
|---|
| | | BillNew.DetailColl.Add(oSub); |
|---|
