| | |
| | | |
| | | Int64 HGroupID = 0; |
| | | long HEmpID = 0; |
| | | string HCusModel = ""; //瀹㈡埛鐗╂枡瑙勬牸 |
| | | string HCusMaterName = ""; //瀹㈡埛鐗╂枡鍚嶇О |
| | | |
| | | DataSet Ds; |
| | | msg2 = msg2.Replace("\\", ""); |
| | |
| | | HheatNO = ClsPub.isStrNull(ordrlist[j].HheatNO); |
| | | HGroupID = ClsPub.isInt(ordrlist[j].HGroupID); |
| | | HEmpID = ClsPub.isLong(ordrlist[j].HEmpID); |
| | | HCusModel = ClsPub.isStrNull(ordrlist[j].HCusModel); |
| | | HCusMaterName = ClsPub.isStrNull(ordrlist[j].HCusMaterName); |
| | | //鏃ユ湡鑾峰彇鏂瑰紡 |
| | | sDate = DateTime.Now.ToString(); |
| | | // |
| | |
| | | |
| | | barcode.HGroupID2 = ordrlist[j].HGroupID; |
| | | barcode.HEmpID2 = ordrlist[j].HEmpID; |
| | | barcode.HCusModel2 = ordrlist[j].HCusModel; |
| | | barcode.HCusMaterName2 = ordrlist[j].HCusMaterName; |
| | | ListRows.Add(barcode); |
| | | k = k + 1; |
| | | n = n + 1; |
| | |
| | | DateTime HProduceDate; |
| | | DateTime HExpiryDate; |
| | | long HEmpID2 = 0; |
| | | string HCusModel2 = ""; |
| | | string HCusMaterName2 = ""; |
| | | |
| | | try |
| | | { |
| | |
| | | HExpiryDate = ClsPub.isDate(ListRows[i].HExpiryDate); |
| | | HGroupID2 = ClsPub.isInt(ListRows[i].HGroupID2); |
| | | HEmpID2 = ClsPub.isLong(ListRows[i].HEmpID2); |
| | | HCusModel2 = ClsPub.isStrNull(ListRows[i].HCusModel2); |
| | | HCusMaterName2 = ClsPub.isStrNull(ListRows[i].HCusMaterName2); |
| | | oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + |
| | | ",HGiveAwayFlag " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" + |
| | | ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID " + |
| | | ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName " + |
| | | ") values (" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() |
| | | + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID2.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString() |
| | |
| | | + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" |
| | | + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + "" |
| | | + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) |
| | | + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ")"); |
| | | + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "'" + ")"); |
| | | |
| | | |
| | | //HNumber = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterID2Col].Value); |