| | |
| | | ",HProcID='" + omodel.HProcID.ToString() + |
| | | "',HSourceOrgID='" + omodel.HSourceOrgID.ToString() + |
| | | "',HInspectOrgID='" + omodel.HInspectOrgID.ToString() + |
| | | "',HWorkShiftID='" + omodel.HWorkShiftID.ToString() + |
| | | "' where HInterID=" + lngBillKey.ToString()); |
| | | //鍒犻櫎鍏宠仈 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | |
| | | sql = "Insert Into QC_BackSampleCheckBillMain" + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType," + |
| | | "HDeptID,HEmp,HProcID,HSourceOrgID,HInspectOrgID) " + |
| | | "HDeptID,HEmp,HProcID,HSourceOrgID,HInspectOrgID,HWorkShiftID) " + |
| | | " values(" + |
| | | "'" + this.BillType + |
| | | "','" + this.HBillSubType + |
| | |
| | | "','" + omodel.HProcID.ToString() + |
| | | "','" + omodel.HSourceOrgID.ToString() + |
| | | "','" + omodel.HInspectOrgID.ToString() + |
| | | "','" + omodel.HWorkShiftID.ToString() + |
| | | "') "; |
| | | //涓昏〃 |
| | | oCn.RunProc(sql); |