From 27d7b50f43c85f12507ab1a61290fa9551d4d780 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期二, 17 五月 2022 16:58:35 +0800
Subject: [PATCH] 不良评审单、工序进站单、工序出站单、委外接收单、委外发出单删除时增加制单人与删除人是否一致系统参数控制;不良明细良率报表修改优化,原报表取值数据代码里写死改为取存储过程里数据显示

---
 WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs |    5 ++---
 1 files changed, 2 insertions(+), 3 deletions(-)

diff --git a/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs b/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs
index b23a06c..0cade9e 100644
--- a/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs
@@ -41,11 +41,11 @@
                 string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where 缁勭粐鍚嶇О='" + Organization + "'");
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_DepartmentList");
+                    ds = oCN.RunProcReturn(sql1 + sWhere + "order by 閮ㄩ棬浠g爜", "h_v_IF_DepartmentList");
                 }
                 else
                 {
-                    string sql = sql1 + sWhere + "order by HItemID desc";
+                    string sql = sql1 + sWhere + "order by 閮ㄩ棬浠g爜 ";
                     ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList");
                 }
 
@@ -54,7 +54,6 @@
                 objJsonResult.Message = "Sucess锛�";
                 objJsonResult.data = ds.Tables[0];
                 return objJsonResult;
-
             }
             catch (Exception e)
             {

--
Gitblit v1.9.1