| | |
| | | ",HErrMsgBackBillNo='" + omodel.HErrMsgBackBillNo + |
| | | "',HErrMsgBackInterID='" + omodel.HErrMsgBackInterID.ToString() + |
| | | "',HErrMsgBackEntryID='" + omodel.HErrMsgBackEntryID.ToString() + |
| | | |
| | | "',HBadReasonID='" + omodel.HBadReasonID.ToString() + |
| | | "' where HInterID=" + lngBillKey.ToString()); |
| | | //鍒犻櫎鍏宠仈 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | |
| | | sql = "Insert Into OA_ErrMsgBackHandleBillMain" + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType," + |
| | | "HDeptID,HReceiveID,HSendMan,HReceiveMan,HCopyMan,HLevel,HErrMsgBackTypeID,HContext,HDescription,HBillTypeName,HPlanBillNo,HMaterName,HMaterModel,HEquipID,HMouldID,HHandleEmpID,HHandleNote,HHandleResult,HHandleDate,HErrMsgBackBillNo,HErrMsgBackInterID,HErrMsgBackEntryID) " + |
| | | "HDeptID,HReceiveID,HSendMan,HReceiveMan,HCopyMan,HLevel,HErrMsgBackTypeID,HContext,HDescription,HBillTypeName,HPlanBillNo,HMaterName,HMaterModel,HEquipID,HMouldID,HHandleEmpID,HHandleNote,HHandleResult,HHandleDate,HErrMsgBackBillNo,HErrMsgBackInterID,HErrMsgBackEntryID,HBadReasonID) " + |
| | | " values(" + |
| | | "'" + this.BillType + |
| | | "','" + this.HBillSubType + |
| | |
| | | "','" + omodel.HErrMsgBackBillNo + |
| | | "','" + omodel.HErrMsgBackInterID.ToString() + |
| | | "','" + omodel.HErrMsgBackEntryID.ToString() + |
| | | |
| | | "','" + omodel.HBadReasonID.ToString() + |
| | | "') "; |
| | | //涓昏〃 |
| | | oCn.RunProc(sql); |