采购订单生成送货单保存方法修改 解决多次保存时的报错

王 垚

2022-09-16 3e58dee31a30ee20770803a7035deb4890156bb4

采购订单生成送货单保存方法修改 解决多次保存时的报错

 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,7 +770,8 @@

                            }
                        }
                        else {
                        else
                        {
                            LogService.Write("收料通知单审核无数据："+sql);
                        }
                    }