| | |
| | | ",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); |
| | | |
| | | //åé¦å¤çåä¿åå,æ´æ°å¼å¸¸åé¦åçç¶æ |
| | | string sql1 = "update OA_ErrMsgBackBillMain set HBillStatus='9' where HBillNo='" + omodel.HErrMsgBackBillNo + "' "; |
| | | oCn.RunProc(sql1); |
| | | |
| | | //=========================ä¿ååæ§å¶ |
| | | DataSet ds2 = oCn.RunProcReturn("Exec h_p_OA_ErrMsgBackHandleBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_OA_ErrMsgBackHandleBill_AfterSaveCtrl"); |
| | | if (ds2 == null) |