From 6d333439f8abe3f39de1ab393007009d570c6256 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 07 六月 2024 13:51:36 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/POInStockController.cs | 114 +++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 102 insertions(+), 12 deletions(-)
diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs
index 4aa897a..fb9a568 100644
--- a/WebAPI/Controllers/POInStockController.cs
+++ b/WebAPI/Controllers/POInStockController.cs
@@ -639,9 +639,9 @@
public object AuditPOInStockBill(string HInterID, string CurUserName, string HBillNo)
{
json objjson = new json();
+ SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
try
- {
- SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ {
//閲囪喘璁㈠崟 鐢熸垚閫佽揣鍗曞垪琛�
if (!String.IsNullOrEmpty(HBillNo))
HInterID = GetHinterIDByBillNo(HBillNo, "Aduit").ToString();
@@ -662,10 +662,42 @@
//var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString();
string HValue = "Y";
string CustomFields = "";//鑷畾涔夊瓧娈�
+
+ oCn.BeginTran(); //寮�濮嬩簨鐗�
+
if (HValue == "Y")
{
- if (FCusName == "澶忓疂鐢靛櫒")
+ //==================================== Begin 閫佽揣鍗曞鏍稿墠鎺у埗 Begin ====================================
+ DataSet ds;
+
+ string[] sArray = HInterID.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
+
+ for (int i = 0; i < sArray.Length; i++)
{
+ ds = oCn.RunProcReturn("exec h_p_SRM_Cg_POInStockBill_BeforeCheckCtrl " + sArray[i] + ",'" + HBillNo + "','" + CurUserName + "'", "h_p_SRM_Cg_POInStockBill_BeforeCheckCtrl");
+ if (ds == null)
+ {
+ oCn.RollBack(); //鍥炴粴浜嬬墿
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "瀹℃牳鍓嶅垽鏂け璐ワ紒鏃犳暟鎹繑鍥�";
+ objjson.data = null;
+ return objjson;
+ }
+ if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
+ {
+ oCn.RollBack(); //鍥炴粴浜嬬墿
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "瀹℃牳澶辫触锛�" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemarkBack"]);
+ objjson.data = null;
+ return objjson;
+ }
+ }
+
+ //====================================== End 閫佽揣鍗曞鏍稿墠鎺у埗 End ======================================
+ if (FCusName == "澶忓疂鐢靛櫒")
+ {
sql = string.Format(@"
SELECT T3.FNAME AS FTYPENAME,M.HBILLNO,B.HINTERID,B.HENTRYID,C.FID,C.FENTRYID, D.FBILLNO,B.HQTY,CD.FRECEIVEORGID,CDOO.FNUMBER AS FRECEIVENUMBER
,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER AS FSETTLEORGNUMBER,
@@ -829,6 +861,7 @@
,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER
,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber,B.HBatChNo,D.FBILLTYPEID
,isnull(VW.FNUMBER,'') AS FReceiverNUMBER,isnull(B.HKFDate,'') As FProduceDate,B.HTAXPRICE_T AS F_AAAA_PRICE1
+,C.FGiveAway AS FGiveAway
FROM CG_POINSTOCKBILLSUB B
JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID
JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID
@@ -933,10 +966,7 @@
FentityModel.Add("FSRCENTRYID", item["FENTRYID"].ToString());//婧愬崟鍒嗗綍鍐呯爜
FentityModel.Add("FORDERBILLNO", item["FBILLNO"].ToString());//婧愬崟鍗曞彿
FentityModel.Add("FPOORDERENTRYID", item["FENTRYID"].ToString());//婧愬崟鍒嗗綍鍐呯爜
- FentityModel.Add("FSRMENTRYID", item["HENTRYID"].ToString());//SRM hentryid
- FentityModel.Add("FPrice", item["FPRICE"].ToString());//鍗曚环
- FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//鍚◣鍗曚环
- FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//绋庣巼
+ FentityModel.Add("FSRMENTRYID", item["HENTRYID"].ToString());//SRM hentryid
FentityModel.Add("FLot", new JObject() { ["Fnumber"] = item["HBatChNo"].ToString() }); // 鎵瑰彿
FentityModel.Add("FProduceDate", item["FProduceDate"].ToString());//鐢熶骇鏃ユ湡
FentityModel.Add("F_aaaa_Price1", item["F_aaaa_Price1"].ToString());//鍚◣閲嶉噺鍗曚环/鍚�
@@ -946,7 +976,10 @@
FentityModel.Add("FDescription", item["HRemark"].ToString());//琛ㄤ綋澶囨敞 (鐟炵惇)
FentityModel.Add("F_bsv_dhrq", item["HPlanArrivalDate"].ToString());//鍒拌揣鏃ユ湡 (鐟炵惇)
FentityModel.Add("F_bsv_xh", item["HBoxNumber"].ToString());//绠卞彿 (鐟炵惇)
-
+ FentityModel.Add("FPrice", item["FPRICE"].ToString());//鍗曚环
+ FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//鍚◣鍗曚环
+ FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//绋庣巼
+ FentityModel.Add("FGiveAway", item["FGiveAway"].ToString());//鏄惁璧犲搧
JArray Fentity2 = new JArray();
JObject FentityModel2 = new JObject();
FentityModel2.Add("FDetailEntity_Link_FRULEID", "PUR_PurchaseOrder-PUR_ReceiveBill");
@@ -1193,7 +1226,30 @@
LogService.Write("鏀舵枡閫氱煡鍗曞鏍告棤鏁版嵁锛�" + sql);
}
}
-
+ //==================================== Begin 閫佽揣鍗曞鏍稿悗鎺у埗 Begin ====================================
+ for (int i = 0; i < sArray.Length; i++)
+ {
+ ds = oCn.RunProcReturn("exec h_p_SRM_Cg_POInStockBill_AfterCheckCtrl " + sArray[i] + ",'" + HBillNo + "','" + CurUserName + "'", "h_p_SRM_Cg_POInStockBill_AfterCheckCtrl");
+ if (ds == null)
+ {
+ oCn.RollBack(); //鍥炴粴浜嬬墿
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "瀹℃牳鍚庡垽鏂け璐ワ紒鏃犳暟鎹繑鍥�";
+ objjson.data = null;
+ return objjson;
+ }
+ if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
+ {
+ oCn.RollBack(); //鍥炴粴浜嬬墿
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "瀹℃牳澶辫触锛�" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemarkBack"]);
+ objjson.data = null;
+ return objjson;
+ }
+ }
+ //====================================== End 閫佽揣鍗曞鏍稿悗鎺у埗 End ======================================
}
////鏇存柊鐗╂祦瀛楁 锛堢憺涓庣惇锛�
@@ -1206,6 +1262,9 @@
HCheckDate = getdate()
where HInterID in ({1})", CurUserName, HInterID);
oCn.RunProc(sql);
+
+ oCn.Commit(); //鎻愪氦浜嬬墿
+
objjson.code = "1";
objjson.count = 1;
objjson.Message = "鎿嶄綔鎴愬姛";
@@ -1214,7 +1273,7 @@
}
catch (Exception ex)
{
-
+ oCn.RollBack(); //鍥炴粴浜嬬墿
objjson.code = "0";
objjson.count = 0;
objjson.Message = "鎿嶄綔澶辫触" + ex.Message.ToString();
@@ -1465,8 +1524,8 @@
/// <returns></returns>
public object TestSaverPOInStock(string ids, string entryids)
{
- List<string> mylist = new List<string>(ids.Split(',').Distinct());
- List<string> entryList = new List<string>(entryids.Split(',').Distinct());
+ List<string> mylist = new List<string>(ids.Split(','));//.Distinct()
+ List<string> entryList = new List<string>(entryids.Split(','));//.Distinct()
SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
if (FCusName == "澶忓疂鐢靛櫒" && mylist.Count > 1)
@@ -1479,11 +1538,39 @@
}
try
{
+ DataSet ds2;
+ oCn.BeginTran(); //寮�濮嬩簨鐗�
+
//閲囪喘璁㈠崟涓嬫帹鐢熸垚閫佽揣鍗� 鏃跺�� 鍒ゆ柇鏄惁鏈夌敓鎴愰噰璐鍗曞彉鏇村崟 濡傛灉鏈変笖鍙樻洿鍗曠姸鎬佷笉涓哄凡瀹℃牳 闄愬埗涓嬫帹
objJsonResult = TestPOOrder(entryids);
if (objJsonResult.code == "0")
return objJsonResult;
+
+ if (mylist.Count != entryList.Count)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "涓诲唴鐮佷笌瀛愬唴鐮佹暟閲忎笉涓�鑷达紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ for (int i = 0;i < mylist.Count;i++)
+ {
+ //閲囪喘璁㈠崟涓嬫帹鐢熸垚閫佽揣鍗曞墠鎺у埗
+ string sql = "exec h_p_SRM_POOrderBill_BeforePushDownCtrl " + mylist[i] + "," + entryList[i];
+ ds2 = oCn.RunProcReturn(sql, "h_p_SRM_POOrderBill_BeforePushDownCtrl");
+ if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
+ {
+ oCn.RollBack(); //鍥炴粴浜嬬墿
+ objjson.code = "0";
+ objjson.count = 0;
+ objjson.Message = "瀹℃牳鍓嶅垽鏂け璐ワ紒" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HRemarkBack"]);
+ objjson.data = null;
+ return objjson;
+ }
+ }
+
for (int i = 0; i < mylist.Count; i++)
{
//鏇存柊鍏宠仈鏁伴噺
@@ -1508,6 +1595,9 @@
return objJsonResult;
}
}
+
+ oCn.Commit(); //鎻愪氦浜嬬墿
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "鎿嶄綔鎴愬姛!";
--
Gitblit v1.9.1