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_MouldProdInBillController.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
index f70f784..c3efce4 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
@@ -59,12 +59,12 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldProdInHouseBillList " + sWhere, "h_v_Sc_MouldProdInHouseBillList");
+ return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldProdInHouseBillList order by 鏃ユ湡 desc " + sWhere, "h_v_Sc_MouldProdInHouseBillList");
}
else
{
string sql1 = "select * from h_v_Sc_MouldProdInHouseBillList where 1 = 1 ";
- string sql = sql1 + sWhere;
+ string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc";
return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList");
}
@@ -113,7 +113,7 @@
objJsonResult.data = null;
return objJsonResult;
}
- if (oBill.omodel.HChecker != "")
+ if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker !=null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -450,7 +450,7 @@
/// <returns></returns>
[Route("Sc_MouldProdInHouseBill/SaveGetMouldProdInHouseBillList")]
[HttpPost]
- public object SaveGetMouldScrapInHouseBillList([FromBody] JObject msg)
+ public object SaveGetMouldProdInHouseBillList([FromBody] JObject msg)
{
var _value = msg["msg"].ToString();
string msg1 = _value.ToString();
--
Gitblit v1.9.1