From b1d8f250ec3f20270615223aa5a622d73a260025 Mon Sep 17 00:00:00 2001
From: 仲国强 <519541279@qq.com>
Date: 星期六, 09 十月 2021 16:25:23 +0800
Subject: [PATCH] 新增不良明细良率报表
---
WebAPI/Controllers/Sc_MouldOtherInBillController.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs
index 05154c3..e0c8653 100644
--- a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs
+++ b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs
@@ -109,12 +109,12 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList ", "h_v_Sc_MouldOtherInBillList");
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherInBillList order by 鏃ユ湡 desc", "h_v_Sc_MouldOtherInBillList");
}
else
{
string sql1 = "select * from h_v_Sc_MouldOtherInBillList where 1 = 1 ";
- string sql = sql1 + sWhere;
+ string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc";
return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList");
}
@@ -125,13 +125,13 @@
#region[鍣ㄥ叿鍒嗗竷寮忚皟鍑哄崟缂栬緫鏃惰幏鍙栬〃澶存暟鎹甝
[Route("Sc_MouldOtherInBill/Sc_MouldOtherInBillListCheckDetai")]
[HttpGet]
- public ApiResult<DataSet> Sc_MouldOtherInBillListCheckDetai(string HID)
+ public ApiResult<DataSet> Sc_MouldOtherInBillListCheckDetai(string HID)
{
if (string.IsNullOrEmpty(HID))
return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
- var dataSet = oCN.RunProcReturn("select top 1 * from where hmainid= " + HID + " ", "h_v_Sc_MouldOtherInBillList");
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherInBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherInBillList");
if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄩ��搴撳崟鍙�" };
--
Gitblit v1.9.1