From 747da7d4ad824a5c4a0b93be7d32f353ed748bc7 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期二, 07 十二月 2021 09:15:27 +0800 Subject: [PATCH] nothing --- WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs index c20a7f8..c17c107 100644 --- a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs @@ -27,18 +27,18 @@ /// </summary> [Route("Gy_Employee/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string Organization) { try { + string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_EmployeeList where 绂佺敤鏍囪='' ", "h_v_IF_EmployeeList"); + ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_EmployeeList"); } else { - string sql1 = "select * from h_v_IF_EmployeeList where 绂佺敤鏍囪='' "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere + "order by HItemID desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList"); } objJsonResult.code = "1"; -- Gitblit v1.9.1