From 3e58dee31a30ee20770803a7035deb4890156bb4 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 16 九月 2022 13:25:26 +0800
Subject: [PATCH] 采购订单生成送货单保存方法修改 解决多次保存时的报错
---
WebAPI/Controllers/POInStockController.cs | 24 ++++++++++++++++++++----
1 files changed, 20 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs
index 9b87d03..0f433f5 100644
--- a/WebAPI/Controllers/POInStockController.cs
+++ b/WebAPI/Controllers/POInStockController.cs
@@ -281,6 +281,7 @@
[HttpPost]
public object SaverPOInStock([FromBody] JObject msg)
{
+ SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
var _value = msg["msg"].ToString();
string msg1 = _value.ToString();
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
@@ -297,6 +298,19 @@
msg2 = msg2.Replace("\\", "");
msg2 = msg2.Replace("\n", ""); //\n
lsmain = oListModels.getObjectByJson_POInStockMain(msg2);
+ string billno = lsmain[0].HBillNo;
+ string yzsql = $"select count(*) as rows from Cg_POInStockBillMain where HBillNo = '{billno}'";
+ DataTable yzdt = oCn.RunProcReturn(yzsql, "yzds").Tables[0];
+ if (Convert.ToInt32(yzdt.Rows[0][0]) > 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "淇濆瓨鎴愬姛锛�";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ //鏍规嵁鏀舵枡閫氱煡鍗曞彿鏍￠獙鏄惁宸茬敓鎴�
+ //string jysql = $"select * from ":
foreach (Model.ClsCg_POInStockBillMain oItem in lsmain)
{
//oItem.HMaker = "";
@@ -602,10 +616,11 @@
DataTable dt = new DataTable();
List<string> fidList = new List<string>();
string parameterSql = $"select HValue from Xt_SystemParameter where HKey ='Cg_POInStockBill_ErpAduit'";
- var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString();
+ //var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString();
+ string HValue = "Y";
if (HValue == "Y")
{
- if (FCusName == "鐟炰笌绁�" || FCusName == "" || FCusName.Contains("鍥涚淮灏�"))
+ if (FCusName == "鐟炰笌绁�" || FCusName == "" || FCusName.Contains("鍥涚淮灏�") || FCusName.Contains("鍑礉濂堢壒"))
{
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
@@ -755,8 +770,9 @@
}
}
- else {
- LogService.Write("鏀舵枡閫氱煡鍗曞鏍告棤鏁版嵁锛�"+sql);
+ else
+ {
+ LogService.Write("鏀舵枡閫氱煡鍗曞鏍告棤鏁版嵁锛�" + sql);
}
}
else if (FCusName == "澶忓疂鐢靛櫒")
--
Gitblit v1.9.1