From 76e376b2a5da56a72292706259c4370d3bfc2959 Mon Sep 17 00:00:00 2001 From: zgq <519541279@qq.com> Date: 星期三, 25 八月 2021 22:22:48 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs | 52 +--------------------------------------------------- 1 files changed, 1 insertions(+), 51 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs index 465de7c..9606b19 100644 --- a/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_StockPlaceController.cs @@ -9,63 +9,13 @@ using WebAPI.Models; namespace WebAPI.Controllers { - public class Gy_DepartmentController : ApiController + public class Gy_StockPlaceController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; - - - /// <summary> - /// 杩斿洖閮ㄩ棬鍒楄〃 - ///鍙傛暟锛歴tring sql銆� - ///杩斿洖鍊硷細object銆� - /// </summary> - [Route("Gy_Department/list")] - [HttpGet] - public object list(string sWhere) - { - try - { - if (sWhere == null || sWhere.Equals("")) - { - ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentList " + sWhere, "h_v_IF_DepartmentList"); - } - else - { - string sql1 = "select * from h_v_IF_DepartmentList where 1 = 1 "; - string sql = sql1 + sWhere; - ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList"); - } - if (ds == null || ds.Tables[0].Rows.Count == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "false锛�"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "Sucess锛�"; - objJsonResult.data = ds.Tables[0]; - return objJsonResult; - } - } - catch (Exception e) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "Exception锛�" + e.ToString(); - objJsonResult.data = null; - return objJsonResult; - } - } - /// <summary> /// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍 -- Gitblit v1.9.1