From ff3736d94d36021f98ca1156e4522dbe1b636011 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期一, 07 十一月 2022 14:26:54 +0800 Subject: [PATCH] no --- WebAPI/Controllers/POOrderController.cs | 24 +++++++----------------- 1 files changed, 7 insertions(+), 17 deletions(-) diff --git a/WebAPI/Controllers/POOrderController.cs b/WebAPI/Controllers/POOrderController.cs index 59f6b8d..3578cf7 100644 --- a/WebAPI/Controllers/POOrderController.cs +++ b/WebAPI/Controllers/POOrderController.cs @@ -28,31 +28,21 @@ /// <param name="OnePage"></param> /// <returns></returns> [Route("GetPOOrderBill")] - [HttpGet] + [HttpPost] //閲囪喘璁㈠崟鍒楄〃 - public object GetPOOrderBill(string HSupNo, string sqlWhere) + public object GetPOOrderBill([FromBody] JObject msg) { - string msg = ""; + string HSupNo = msg["HSupNo"].ToString(); string sqlWhere = msg["sqlWhere"].ToString(); + //string msg = ""; try { string VsWhere = ""; string PcWhere = ""; 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; - // msg = " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)"; - } - else - { - msg += " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere; - //msg = msg + " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛=^^" + HSupNo.Trim() + "^^) " + sqlWhere; - // msg = msg + " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)"; - } + 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; @@ -63,7 +53,7 @@ //鑾峰彇鎬昏鏁� //Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POOrderBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo); //鑾峰彇杩斿洖鏁版嵁 - string sql = "exec H_p_SRM_POOrderBillList '" + PcWhere + "'"; + sql = "exec H_p_SRM_POOrderBillList '" + PcWhere + "'"; //LogService.WriteAsync(sql); ds = oCn.RunProcReturn("exec H_p_SRM_POOrderBillList '" + PcWhere + "'", "H_p_SRM_POOrderBillList"); -- Gitblit v1.9.1