| | |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckOtherBill where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | string sql = sql1 + sWhere + " order by 鍒跺崟鏃ユ湡 desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckOtherBill"); |
| | | |
| | | //娣诲姞鍒楀悕 |
| | |
| | | BillNew.omodel.HShiftsID = ClsPub.isLong(mainList[0].HShiftsID); |
| | | BillNew.omodel.HErrTreatment = ClsPub.isStrNull(mainList[0].HErrTreatment); |
| | | BillNew.omodel.HBatchNo = ClsPub.isStrNull(mainList[0].HBatchNo); |
| | | BillNew.omodel.HTakeSampleCheckBillID = ClsPub.isLong(mainList[0].HTakeSampleCheckBillID); |
| | | BillNew.omodel.HTakeSampleCheckBillNo = ClsPub.isStrNull(mainList[0].HTakeSampleCheckBillNo); |
| | | List<Model.ClsQC_PatrolProcCheckOtherBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_PatrolProcCheckOtherBillSub>>(msg3); |
| | | BillNew.DetailColl = new List<Model.ClsQC_PatrolProcCheckOtherBillSub>(); |
| | | for (int i = 0; i < subList.ToArray().Length; i++) |