From bfdba143a3228e23d40862b76a7b0ee2563f4d82 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期一, 08 十一月 2021 14:36:23 +0800 Subject: [PATCH] 基础资料列表优化 --- WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs | 33 +++++++++++---------------------- 1 files changed, 11 insertions(+), 22 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs index 6baaaa8..b41c069 100644 --- a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs +++ b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs @@ -25,7 +25,7 @@ /// </summary> [Route("Xt_ORGANIZATIONS/list")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere, string Organization) { try { @@ -39,22 +39,11 @@ string sql = sql1 + sWhere + "order by HItemID desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_ORGANIZATIONSList"); } - if (ds == null || ds.Tables[0].Rows.Count == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "Sucess锛�"; - objJsonResult.data = ds.Tables[0]; - return objJsonResult; - } + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; } catch (Exception e) { @@ -85,12 +74,12 @@ long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; - + long HParentID = list[0].HParentID; - + string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; - + if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; @@ -203,7 +192,7 @@ ",HStopflag,HMakeTime" + ",HRemark) " + " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() + - "," + HStopflag + "getdate()"+ + "," + HStopflag + "getdate()" + ",'" + HRemark + "')", ref DBUtility.ClsPub.sExeReturnInfo); //淇敼涓婄骇涓洪潪鏈骇浠g爜 @@ -246,7 +235,7 @@ /// </summary> /// <returns></returns> [Route("DeltetXt_ORGANIZATIONSList")] - + [HttpGet] public object DeltetXt_ORGANIZATIONSList(string HItemID) { -- Gitblit v1.9.1