| | |
| | | + ",HAddress='" + HAddress + "' ,HInnerBillNo='" + HInnerBillNo + "' where HInterID=" + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | | //退料通知单删除回填采购订单关联数量 |
| | | oCN.RunProc("exec h_p_Cg_UpDateRelation_POInStockBackToPOOrder_Del " + HInterID); |
| | | //删除子表 |
| | | oCN.RunProc("delete from Cg_POInStockBackBillSub where HInterID='" + HInterID + "'"); |
| | | } |
| | |
| | | |
| | | string sReturn = ""; |
| | | oCN.BeginTran(); |
| | | //退料通知单删除回填采购订单关联数量 |
| | | oCN.RunProc("exec h_p_Cg_UpDateRelation_POInStockBackToPOOrder_Del " + HInterID); |
| | | oCN.RunProc("Delete From Cg_POInStockBackBillMain where HInterID = " + HInterID); |
| | | oCN.RunProc("Delete From Cg_POInStockBackBillSub where HInterID = " + HInterID); |
| | | oCN.Commit(); |