| | |
| | | ",HProcID=" + omodel.HProcID.ToString() + |
| | | ",HDeptID=" + omodel.HDeptID.ToString() + |
| | | ",HSampleSchemeID=" + omodel.HSampleSchemeID.ToString() + |
| | | ",HSourceID=" + omodel.HSourceID.ToString() + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //鍒犻櫎鍏宠仈 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HMaterID,HName,HMaterNumber,HMaterTypeID,HUnitID" + |
| | | ",HUnitNumber,HStandard,HProcID,HDeptID,HSampleSchemeID" + |
| | | ",HUnitNumber,HStandard,HProcID,HDeptID,HSampleSchemeID,HSourceID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'"+ |
| | | "," + omodel.HMaterID.ToString() + ",'" + omodel.HName + "','" + omodel.HMaterNumber + "'," + omodel.HMaterTypeID.ToString() + "," + omodel.HUnitID.ToString() + |
| | | ",'" + omodel.HUnitNumber + "', " + Convert.ToString(omodel.HStandard ? 1 : 0) + "," + omodel.HProcID.ToString() + "," + omodel.HDeptID.ToString() + |
| | | "," + omodel.HSampleSchemeID + ") "); |
| | | "," + omodel.HSampleSchemeID + ",'" + omodel.HSourceID + "') "); |
| | | //鎻掑叆瀛愯〃 |
| | | foreach (Model.ClsGy_QCCheckProjectSub oSub in DetailColl) |
| | | { |