首件检验单主表添加字段-批号;条码添加字段-操作员,班组
| | |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" + |
| | | ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HLastResult" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment,HBatchNo" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HICMOQty.ToString() + "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() + |
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + ", " + DBUtility.ClsPub.BoolToString(omodel.HLastResult) + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "'" + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "','" + omodel.HBatchNo + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsQC_FirstPieceCheckBillSub oSub in DetailColl) |
| | |
| | | |
| | | public Int64 HShiftsID; |
| | | public string HErrTreatment; |
| | | |
| | | public string HBatchNo; |
| | | } |
| | | } |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = "select top 1000 * from h_v_IF_BarCodeBillList where 1 = 1 "; |
| | | string sql1 = "select top 5000 * from h_v_IF_BarCodeBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_BarCodeBillList"); |
| | | |
| | |
| | | |
| | | public object HSourceOrderList(DataTable dt, HSouceOrderList ordrlist,string HBarCodeType) |
| | | { |
| | | oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | for (int i = 0; i < dt.Rows.Count; i++) |
| | | { |
| | | ordrlist.HQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); |
| | |
| | | ordrlist.HSourceName = dt.Rows[i]["ç产线"].ToString(); |
| | | ordrlist.HEndDate = dt.Rows[i]["计åå®å·¥æ¥æ"].ToString();//忥 ç产订å å¤±ææ¥æ |
| | | ordrlist.HMinQty = dt.Rows[i]["æå°å
è£
æ°"].ToString(); |
| | | |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "ä¹è±") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° 空ç½ä¸ºéç¨ |
| | | { |
| | | ordrlist.HGroupID = Convert.ToInt32(dt.Rows[i]["HBeginWorkGroupID"]); |
| | | ordrlist.HGroupNumber = dt.Rows[i]["å¼å·¥çç»ä»£ç "].ToString(); |
| | | ordrlist.HGroupName = dt.Rows[i]["å¼å·¥çç»åç§°"].ToString(); |
| | | ordrlist.HEmpID = Convert.ToInt32(dt.Rows[i]["HBeginWorkEmpID"]); |
| | | ordrlist.HEmpNumber = dt.Rows[i]["å¼å·¥äººä»£ç "].ToString(); |
| | | ordrlist.HEmpName = dt.Rows[i]["å¼å·¥äººåç§°"].ToString(); |
| | | } |
| | | |
| | | if (HBarCodeType == "仪å¨å¤è´ä»¶æ¡ç 容å¨è§å") |
| | | { |
| | | ordrlist.HMinQty = dt.Rows[i]["æªçææ¡ç æ°é"].ToString(); |
| | |
| | | BillNew.omodel.HBillStatus = 1; |
| | | BillNew.omodel.HShiftsID = ClsPub.isLong(mainList[0].HShiftsID); |
| | | BillNew.omodel.HErrTreatment = ClsPub.isStrNull(mainList[0].HErrTreatment); |
| | | BillNew.omodel.HBatchNo = ClsPub.isStrNull(mainList[0].HBatchNo); |
| | | List<Model.ClsQC_FirstPieceCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_FirstPieceCheckBillSub>>(msg3); |
| | | BillNew.DetailColl = new List<Model.ClsQC_FirstPieceCheckBillSub>(); |
| | | for (int i = 0; i < subList.ToArray().Length; i++) |