| | |
| | | //",HCREATEORGID=" + omodel.HCREATEORGID + |
| | | ",HDeptID=" + omodel.HDeptID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | |
| | | //鍒犻櫎鍏宠仈 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //鍒犻櫎瀛愯〃 |
| | |
| | | " (HInterID,HEntryID," + |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HPatrolCheckItem,HPatrolCheckPart,HClaim," + |
| | | "HPatrolCheckItem,HPatrolCheckItemID,HPatrolCheckPart,HClaim," + |
| | | "HManagerID,HPatrolCheckItemClassID,HPatrolCheckItemMethodID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HPatrolCheckItem + "','" + oSub.HPatrolCheckPart + "','" + oSub.HClaim + |
| | | ",'" + oSub.HPatrolCheckItem + "','" + oSub.HPatrolCheckItemID + "','" + oSub.HPatrolCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + "," + oSub.HPatrolCheckItemClassID + "," + oSub.HPatrolCheckItemMethodID + |
| | | ") "); |
| | | } |
| | |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HPatrolCheckItem,HPatrolCheckPart,HClaim," + |
| | | "HManagerID,HPatrolCheckItemClassID,HPatrolCheckItemMethodID" + |
| | | "HManagerID,HPatrolCheckItemClassID,HPatrolCheckItemID,HPatrolCheckItemMethodID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HPatrolCheckItem + "','" + oSub.HPatrolCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + "," + oSub.HPatrolCheckItemClassID + "," + oSub.HPatrolCheckItemMethodID + |
| | | "'," + oSub.HManagerID.ToString() + "," + oSub.HPatrolCheckItemClassID + "," + oSub.HPatrolCheckItemID + "," + oSub.HPatrolCheckItemMethodID + |
| | | ") "); |
| | | } |
| | | // |