From b1d8f250ec3f20270615223aa5a622d73a260025 Mon Sep 17 00:00:00 2001
From: 仲国强 <519541279@qq.com>
Date: 星期六, 09 十月 2021 16:25:23 +0800
Subject: [PATCH] 新增不良明细良率报表
---
WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
index 13c3bde..3a2c3dd 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs
@@ -109,12 +109,12 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList");
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList order by 鏃ユ湡 desc", "h_v_Sc_MouldOtherOutBillList");
}
else
{
string sql1 = "select * from h_v_Sc_MouldOtherOutBillList where 1 = 1 ";
- string sql = sql1 + sWhere;
+ string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc";
return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList");
}
--
Gitblit v1.9.1