From df377dc2934889af29440735123e713a9c569a4b Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期一, 31 十月 2022 14:48:39 +0800 Subject: [PATCH] get 改 post --- WebAPI/Controllers/POInStockController.cs | 18 ++++++------------ 1 files changed, 6 insertions(+), 12 deletions(-) diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs index 48a5e68..6b5d253 100644 --- a/WebAPI/Controllers/POInStockController.cs +++ b/WebAPI/Controllers/POInStockController.cs @@ -433,11 +433,11 @@ /// <param name="OnePage"></param> /// <returns></returns> [Route("GetPOInStockBill")] - [HttpGet] + [HttpPost] //閫佽揣鍗曞垪琛� - public object GetPOInStockBill(string HSupNo, string sqlWhere) + public object GetPOInStockBill([FromBody] JObject msg) { - string msg = ""; + string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString(); try { string VsWhere = ""; @@ -445,16 +445,10 @@ SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); DataSet ds; //鍏朵粬杩囨护 - if (msg.Trim() == "") - { - msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; - } - else - { - msg = msg + " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; - } + string sql = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; + //杞崲鐗规畩瀛楃 - if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false) + if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false) { objjson.code = "0"; objjson.count = 0; -- Gitblit v1.9.1