| | |
|---|
| | | |
|---|
| | | oCN.BeginTran(); |
|---|
| | | |
|---|
| | | //ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_Query where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_Query"); |
|---|
| | | //foreach (DataRow row in ds.Tables[0].Rows) |
|---|
| | | //{ |
|---|
| | | // // 获取当前行的 HSourceBillType 值 |
|---|
| | | // string hSourceBillType = row["HSourceBillType"].ToString(); |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_Query where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_Query"); |
|---|
| | | string hSourceBillType = ds.Tables[0].Rows[0]["HSourceBillType"].ToString(); |
|---|
| | | if (hSourceBillType == "1401") |
|---|
| | | { |
|---|
| | | //应收单 删除回填 销售订单 关联数量 |
|---|
| | | oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + HInterID); |
|---|
| | | } |
|---|
| | | else if (hSourceBillType == "1205") |
|---|
| | | { |
|---|
| | | //应收单 删除回填 销售出库单 关联数量 |
|---|
| | | oCN.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del " + HInterID); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // if (hSourceBillType == "1401") |
|---|
| | | // { |
|---|
| | | // //应收单 删除回填 销售订单 关联数量 |
|---|
| | | // oCN.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToPOStockIn_Del " + HInterID); |
|---|
| | | // } |
|---|
| | | // else if (hSourceBillType == "1205") |
|---|
| | | // { |
|---|
| | | // //应收单 删除回填 销售出库单 关联数量 |
|---|
| | | // oCN.RunProc("exec h_p_Xs_UpDateRelation_ICStockoPOStockIn_Del " + HInterID); |
|---|
| | | // } |
|---|
| | | //} |
|---|
| | | |
|---|
| | | |
|---|
| | | oCN.RunProc("delete from Xs_ReceivableBillMain where HInterID = " + HInterID); |
|---|
| | | oCN.RunProc("delete from Xs_ReceivableBillSub where HInterID= " + HInterID); |
|---|
| | | |
|---|
