| | |
| | | ",HQty=" + omodel.HQty.ToString() + |
| | | ",HRecDeptID=" + omodel.HRecDeptID.ToString() + |
| | | ",HMaterNumber='" + omodel.HMaterNumber + "'" + |
| | | ",HHandleEmpID=" + omodel.HHandleEmpID.ToString() + |
| | | |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //删除关联 |
| | |
| | | ",HContext,HDeptID,HDescription,HSendMan,HReceiveMan" + |
| | | ",HCopyMan,HHasten,HLevel,HReTransmitMan,HBillTypeName"+ |
| | | ",HPlanBillNo,HMaterName,HMaterModel,HQty,HSendType"+ |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRecDeptID,HMaterNumber,HErrMsgBackTypeID" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRecDeptID,HMaterNumber,HErrMsgBackTypeID,HHandleEmpID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | |
| | | ",'" + omodel.HCopyMan + "'," + omodel.HHasten.ToString() + ",'" + omodel.HLevel + "','" + omodel.HReTransmitMan + "','" + omodel.HBillTypeName + "'" + |
| | | ",'" + omodel.HPlanBillNo + "','" + omodel.HMaterName + "','" + omodel.HMaterModel + "'," + omodel.HQty.ToString() + ",'" + omodel.HSendType + "'" + |
| | | ",'" + omodel.HMainSourceInterID + "','" + omodel.HMainSourceEntryID + "','" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" + |
| | | "," + omodel.HRecDeptID + ",'" + omodel.HMaterNumber + "'," + omodel.HErrMsgBackTypeID + |
| | | "," + omodel.HRecDeptID + ",'" + omodel.HMaterNumber + "'," + omodel.HErrMsgBackTypeID +", " + omodel.HHandleEmpID + |
| | | ") "); |
| | | //插入子表 |
| | | //foreach (Models.ClsOA_ErrMsgBackBillSub oSub in DetailColl) |