| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | //LogService.Write(msg3); |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | |
| | | } |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2) |
| | | { |
| | | LogService.Write("循环第一次:" + oItemSub2.HSupID); |
| | | if (ClsPub.isLong(oItemSub2.HMaterID) != 0) |
| | | { |
| | | long sMaterID = ClsPub.isLong(oItemSub2.HMaterID); |
| | |
| | | bar2.HEndQty = WeiShu1; |
| | | bar2.HMTONO = oItemSub2.HMTONO; |
| | | ls3.Add(bar2); |
| | | LogService.Write("测试加+++" + oItemSub2.HSupID); |
| | | } |
| | | } |
| | | } |
| | |
| | | oCn.BeginTran(); |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2) |
| | | { |
| | | LogService.Write("循环第二次:" + oItemSub.HSupID); |
| | | if (ClsPub.isLong(oItemSub.HMaterID) != 0) |
| | | { |
| | | HBarCode = oItemSub.HBarCode.ToString(); |
| | |
| | | HUnitID = ClsPub.isLong(oItemSub.HUnitID); |
| | | HQty2 = ClsPub.isDoule(oItemSub.HQty); |
| | | HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo); |
| | | HSupID = ClsPub.isInt(oItemSub.HSupID); |
| | | HSupID =oItemSub.HSupID; |
| | | LogService.Write("HSupID:" + oItemSub.HSupID); |
| | | HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod); |
| | | HKFDate = ClsPub.isStrNull(oItemSub.HKFDate); |
| | | HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate); |
| | |
| | | + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate |
| | | + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1" |
| | | + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')"); |
| | | LogService.Write("insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " + |
| | | ") values (" |
| | | + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate |
| | | + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1" |
| | | + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')"); |
| | | oCn.RunProc("exec setLSH '" + DateTime.Today + "'"); |
| | | } |
| | | } |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls3) |
| | | { |
| | | LogService.Write("循环第三次:" + oItemSub.HSupID); |
| | | if (ClsPub.isLong(oItemSub.HMaterID) != 0) |
| | | { |
| | | HBarCode = oItemSub.HBarCode.ToString(); |
| | |
| | | HUnitID = ClsPub.isLong(oItemSub.HUnitID); |
| | | HQty2 = ClsPub.isDoule(oItemSub.HQty); |
| | | HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo); |
| | | HSupID = ClsPub.isInt(oItemSub.HSupID); |
| | | HSupID = oItemSub.HSupID; |
| | | HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod); |
| | | HKFDate = ClsPub.isStrNull(oItemSub.HKFDate); |
| | | HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate); |