| | |
| | | ",HWorkerID=" + omodel.HWorkerID.ToString() + |
| | | ",HWorkerBarCode='" + omodel.HWorkerBarCode + "'" + |
| | | ",HGroupID=" + omodel.HGroupID.ToString() + |
| | | ",HProcNo=" + omodel.HProcNo.ToString() + |
| | | ",HMainSourceInterID='" + omodel.HMainSourceInterID.ToString() + "'" + |
| | | ",HMainSourceEntryID='" + omodel.HMainSourceEntryID.ToString() + "'" + |
| | | ",HMainSourceBillNo='" + omodel.HMainSourceBillNo + "'" + |
| | |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + |
| | | ",HProcExchInterID,HProcExchEntryID,HProcExchBillNo,HICMOInterID,HICMOEntryID,HICMOBillNo" + |
| | | ",HSourceID,HProcID,HMaterID,HSourceBarCode,HEquipID,HWorkerID,HWorkerBarCode" + |
| | | ",HGroupID,HStockOrgID" + |
| | | ",HGroupID,HProcNo,HStockOrgID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate.ToShortDateString() + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | "," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" + |
| | | "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() + ",'" + omodel.HProcExchBillNo + "'," + omodel.HICMOInterID.ToString() + "," + omodel.HICMOEntryID.ToString() + ",'" + omodel.HICMOBillNo + "'" + |
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HMaterID.ToString() + ",'" + omodel.HSourceBarCode + "'," + omodel.HEquipID.ToString() + "," + omodel.HWorkerID.ToString() + ",'" + omodel.HWorkerBarCode + "'" + |
| | | "," + omodel.HGroupID.ToString() +"," + omodel.HSTOCKORGID.ToString() + |
| | | "," + omodel.HGroupID.ToString() + "," + omodel.HProcNo.ToString() + "," + omodel.HSTOCKORGID.ToString() + |
| | | ") "); |
| | | //鎻掑叆瀛愯〃 |
| | | foreach (Model.ClsSc_MaterToSourceBillSub oSub in DetailColl) |