From 46f04decbfe0f8347dc1ee2574fb10b36208e01e Mon Sep 17 00:00:00 2001 From: ch <37327@LLOOCCY> Date: 星期一, 07 十一月 2022 10:12:43 +0800 Subject: [PATCH] 修改了生产入库赋值API存储过程 --- WebAPI/Controllers/Sc_ProcessMangementController.cs | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/Sc_ProcessMangementController.cs b/WebAPI/Controllers/Sc_ProcessMangementController.cs index 9226e60..cd48eef 100644 --- a/WebAPI/Controllers/Sc_ProcessMangementController.cs +++ b/WebAPI/Controllers/Sc_ProcessMangementController.cs @@ -418,7 +418,8 @@ return objJsonResult; } // - DataSet ds1 = oCN.RunProcReturn("select * from h_v_TOERPProcduct_LastProc where HLastProc = '鏄�' and hbillno='" + BillNo.ToString() + "'", "h_v_TOERPProcduct_LastProc"); + //DataSet ds1 = oCN.RunProcReturn("select * from h_v_TOERPProcduct_LastProc where HLastProc = '鏄�' and hbillno='" + BillNo.ToString() + "'", "h_v_TOERPProcduct_LastProc"); + DataSet ds1 = oCN.RunProcReturn("exec h_p_TOERPProcduct_LastProc '" + BillNo + "'", "h_p_TOERPProcduct_LastProc"); DataRow dr1 = ds1.Tables[0].Rows[0]; JObject model = new JObject(); @@ -505,7 +506,7 @@ Fentity.Add(FentityModel); - Fentity.Add(FentityModel); + //Fentity.Add(FentityModel); } model.Add("FEntity", Fentity); //鏄庣粏淇℃伅 JObject jsonRoot = new JObject() @@ -543,7 +544,7 @@ oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = $"鐢熶骇鍏ュ簱鍗曞悓姝ラ噾铦朵簯澶辫触锛佸崟鍙�:{HBillNo.ToString()}" + result; + objJsonResult.Message = $"鐢熶骇鍏ュ簱鍗曞悓姝ラ噾铦朵簯澶辫触锛佸崟鍙�:{HBillNo.ToString()}" + result + jsonRoot; objJsonResult.data = null; return objJsonResult; } -- Gitblit v1.9.1