From 6ca4391a35cb940a5a27fd45811cce2d07f04b78 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期一, 17 三月 2025 16:58:31 +0800
Subject: [PATCH]  销售报价单 列表 和 编辑 页面; (见原型设计) 增加 客户拜访记录单 列表 和 编辑 页面; 工艺路线,产品工艺参数 车间管理:岗位技能清单,员工技能清单,设备启动点检清单列表,产品防错验证清单列表 质量管理:检验方案,安灯逐级呼叫规则,环境检测方案 增加; 保存前控制存储过程,保存后控制存储过程,审核前控制,审核后控制,删除前控制,删除后控制;作废前控制 作废后控制

---
 WebAPI/Controllers/SCGL/Sc_MESProductReportBillController.cs |   15 ++-------------
 1 files changed, 2 insertions(+), 13 deletions(-)

diff --git a/WebAPI/Controllers/SCGL/Sc_MESProductReportBillController.cs b/WebAPI/Controllers/SCGL/Sc_MESProductReportBillController.cs
index 5e24800..7344dad 100644
--- a/WebAPI/Controllers/SCGL/Sc_MESProductReportBillController.cs
+++ b/WebAPI/Controllers/SCGL/Sc_MESProductReportBillController.cs
@@ -26,30 +26,19 @@
             {
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp " + sWhere, "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
+                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp " + sWhere+ "order by 鍗曟嵁鍙� desc", "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
                 }
                 else
                 {
                     string sql1 = "select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp where 1 = 1 ";
-                    string sql = sql1 + sWhere;
+                    string sql = sql1 + sWhere+ " order by 鍗曟嵁鍙� desc";
                     ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
                 }
-                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 = "鏌ヨ鏁版嵁鎴愬姛锛�";
                     objJsonResult.data = ds.Tables[0];
                     return objJsonResult;
-                }
             }
             catch (Exception e)
             {

--
Gitblit v1.9.1