| | |
| | | { |
| | | 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); |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region åºå/å·¥åº æ£éªåæ ¹æ®æºåç±»åè·åä¿¡æ¯-æºåä¸ºå·¥åºæµè½¬å¡ |
| | | #region è½¦é´æ£éªåæ ¹æ®æºåç±»åè·åä¿¡æ¯-æºåä¸ºå·¥åºæµè½¬å¡ |
| | | [Route("QC_WorkSelfCheckBill/get_ProcessExchangeBill")] |
| | | [HttpGet] |
| | | public object get_ProcessExchangeBill(string HInterID, string user) |