From 14c6521f67ddf822cca2b83fdca1bbdbaa0e7630 Mon Sep 17 00:00:00 2001 From: jingh <jingh@LAPTOP-I53VDLOO> Date: 星期三, 01 九月 2021 20:04:43 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index 960cbbd..54e7dbc 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -390,15 +390,15 @@ ///鍙傛暟锛歴tring sql銆� ///杩斿洖鍊硷細object銆� /// </summary> - [Route("Cj_StationOutBill/list")] + [Route("Cj_StationOutBill/get_Display")] [HttpGet] - public object list(string sWhere) + public object get_Display(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList " + sWhere, "h_v_MES_StationOutBillList"); + ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList " + sWhere + " order by 鍑虹珯鏃堕棿 desc", "h_v_MES_StationOutBillList"); } else { @@ -499,7 +499,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "涓婁紶澶辫触锛�"; + objJsonResult.Message = dyResult.returnval; objJsonResult.data = null; return objJsonResult; } @@ -646,8 +646,8 @@ { try { - - ds = oCN.RunProcReturn("delete from MES_AccessoriesList where HItemID ='" + HItemID + "'", "MES_AccessoriesList"); + + oCN.RunProc("delete from MES_AccessoriesList where HItemID =" + HItemID); string fileurl = Path.Combine(HttpContext.Current.Server.MapPath("~/../Files/" + HSourceBillNo), HFileName); File.Delete(fileurl); //鍒犻櫎鎸囧畾鏂囦欢 objJsonResult.code = "1"; -- Gitblit v1.9.1