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