From f002dca462390febf123891c62ae197c768219dc Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 02 二月 2024 10:29:44 +0800
Subject: [PATCH] 销售订单 删除方法，增加 调用 删除前控制 h_p_Xs_SeOrderBill_BeforeDelCtrl 和删除后控制 h_p_Xs_SeOrderBill_AfterDelCtrl的 存储过程。 销售出库单 删除方法，增加 调用 删除前控制 h_p_Kf_SellOutBill_BeforeDelCtrl 和删除后控制 h_p_Kf_SellOutBill_AfterDelCtrl的 存储过程。 收款单 删除方法，增加 调用 删除前控制 h_p_YS_ReceiveBill_BeforeDelCtrl 和删除后控制 h_p_YS_ReceiveBill_AfterDelCtrl的 存储过程。 应收退款单 删除方法，增加 调用 删除前控制 h_p_YS_ReceiveBackBill_BeforeDelCtrl 和删除后控制 h_p_YS_ReceiveBackBill_AfterDelCtrl的 存储过程。 销售订单变更单删除方法，增加 调用 删除前控制 h_p_Xs_SeOrderChangeBill_BeforeDelCtrl 和删除后控制 h_p_Xs_SeOrderChangeBill_AfterDelCtrl的 存储过程。 销售退货单删除方法，增加 调用 删除前控制 h_p_Kf_SellOutBackBill_BeforeDelCtrl 和删除后控制 h_p_Kf_SellOutBackBill_AfterDelCtrl的 存储过程。
---
WebAPI/Controllers/XSGL/YS_ReceiveBackBillController.cs | 48 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 48 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/YS_ReceiveBackBillController.cs b/WebAPI/Controllers/XSGL/YS_ReceiveBackBillController.cs
index f02f52e..b579fe2 100644
--- a/WebAPI/Controllers/XSGL/YS_ReceiveBackBillController.cs
+++ b/WebAPI/Controllers/XSGL/YS_ReceiveBackBillController.cs
@@ -351,11 +351,59 @@
return objJsonResult;
}
+ //鍒犻櫎鍓嶆帶鍒�=========================================
+ string sql1 = "exec h_p_YS_ReceiveBackBill_BeforeDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_YS_ReceiveBackBill_BeforeDelCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:鍒犻櫎鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ //==================================================================================
+
oCN.BeginTran();
oCN.RunProc("delete from YS_ReceiveBillMain where HInterID = " + HInterID);
oCN.RunProc("delete from YS_ReceiveBillSub where HInterID= " + HInterID);
+ //鍒犻櫎鍚庢帶鍒�==================================================================================
+ string sql2 = "exec h_p_YS_ReceiveBackBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
+ ds = oCN.RunProcReturn(sql2, "h_p_YS_ReceiveBackBill_AfterDelCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ s = "鍒犻櫎鍚庡垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + s;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ s = ds.Tables[0].Rows[0]["HRemark"].ToString();
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + s;
+ objJsonResult.data = null;
+ oCN.RollBack();
+ return objJsonResult;
+ }
+ //==============================================================================================
+
+
oCN.Commit();
objJsonResult.code = "1";
--
Gitblit v1.9.1