From ab146c91c1862a5eb6b4d156e7cae1926afa6ec5 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 10 九月 2021 14:59:15 +0800 Subject: [PATCH] 设备点检计划单、编辑点检计划+设备点检记录单、编辑点检记录 --- WebAPI/Controllers/WebAPIController.cs | 32 +++++++++++++------------------- 1 files changed, 13 insertions(+), 19 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 0249ff2..b6c0485 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -713,14 +713,8 @@ /// <returns></returns> [Route("Web/GetMaterialList_Json")] [HttpGet] - public object GetMaterialList_Json(string Material) + public object GetMaterialList_Json(string sWhere) { - sWhere = " Where HStopFlag=0 and HEndFlag=1"; - //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); - if (Material != "") - { - sWhere = sWhere + " and ( HNumber like '%" + Material + "%' or HName like '%" + Material + "%' ) "; - } try { ds = webserver.GetMaterialList(sWhere, ref DBUtility.ClsPub.sErrInfo); @@ -1243,22 +1237,22 @@ objJsonResult.data = null; return objJsonResult; ; } - var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); - if (HStopflag) - { - oCN.RollBack();//鍥炴粴浜嬪姟 - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鏁版嵁宸插垹闄ゆ棤娉曞啀娆″垹闄わ紒"; - objJsonResult.data = null; - return objJsonResult; - } + //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); + //if (HStopflag) + //{ + // oCN.RollBack();//鍥炴粴浜嬪姟 + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鏁版嵁宸插垹闄ゆ棤娉曞啀娆″垹闄わ紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} - oCN.RunProc("update Gy_BadReason set HStopflag=1 where HItemID=" + HItemID); + oCN.RunProc("delete Gy_BadReason where HItemID=" + HItemID); oCN.Commit();//鎻愪氦浜嬪姟 objJsonResult.code = "0"; objJsonResult.count = 1; - objJsonResult.Message = "* 鏁版嵁鍒犻櫎鎴愬姛锛�"; + objJsonResult.Message = "鏁版嵁鍒犻櫎鎴愬姛锛�"; objJsonResult.data = null; return objJsonResult; ; -- Gitblit v1.9.1