From 7a9c63c6145b6592f89e3e89cf5b2e608d923cb8 Mon Sep 17 00:00:00 2001
From: 仲国强 <519541279@qq.com>
Date: 星期三, 25 八月 2021 21:58:12 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/BaseSet/Gy_SourceController.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
index 4433f25..a4ee1b4 100644
--- a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
@@ -34,11 +34,11 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 绂佺敤鏍囪='' ", "h_v_IF_SourceList");
+ ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 1=1 ", "h_v_IF_SourceList");
}
else
{
- string sql1 = "select * from h_v_IF_SourceList where 绂佺敤鏍囪='' ";
+ string sql1 = "select * from h_v_IF_SourceList where 1=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "h_v_IF_SourceList");
}
@@ -131,7 +131,7 @@
}
//鏌ヨ鏁版嵁涓槸鍚﹀瓨鍦ㄩ噸澶嶄唬鐮�
- ds = oCN.RunProcReturn("select * from Gy_Source where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Unit");
+ ds = oCN.RunProcReturn("select * from Gy_Source where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Source");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
@@ -306,7 +306,7 @@
return objJsonResult;
}
oCN.BeginTran();//寮�濮嬩簨鍔�
- ds = oCN.RunProcReturn("select * from Gy_Source where HItemID=" + HItemID, "Gy_Unit");
+ ds = oCN.RunProcReturn("select * from Gy_Source where HItemID=" + HItemID, "Gy_Source");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
--
Gitblit v1.9.1