From 0f54067a3e2370561613dd5c81325f821c5c8db6 Mon Sep 17 00:00:00 2001
From: 杨乐 <yang.le.192@qq.com>
Date: 星期五, 14 一月 2022 10:56:27 +0800
Subject: [PATCH] 器具维修派工单 审核 反审核
---
WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | 19 +++++++++----------
1 files changed, 9 insertions(+), 10 deletions(-)
diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
index b153a67..c452787 100644
--- a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
+++ b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
@@ -755,8 +755,15 @@
{
try
{
-
- ds = Sc_GetMoveStockBillList(sWhere);
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by 鏃ユ湡 desc", "h_v_IF_MoveStockBillList");
+ }
+ else
+ {
+ string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by 鏃ユ湡 desc";
+ ds = oCN.RunProcReturn(sql, "h_v_IF_MoveStockBillList");
+ }
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
objJsonResult.code = "0";
@@ -784,14 +791,6 @@
}
}
- #region sql璇彞
-
-
- public static DataSet Sc_GetMoveStockBillList(string sWhere)
- {
- return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MoveStockBillList order by 鏃ユ湡 desc", "h_v_IF_MoveStockBillList");
- }
- #endregion
/// <summary>
/// 閿�鍞嚭搴撳崟鍒楄〃
/// </summary>
--
Gitblit v1.9.1