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