From 5237d2bb6ed92b725b28aeebbbaa25a176dc2c60 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 13 一月 2022 11:35:39 +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