From dbea797e494349fa7349b1940ee41cb6cb06501a Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期三, 25 二月 2026 08:54:31 +0800
Subject: [PATCH] 去掉-1
---
WebAPI/Controllers/基础资料/基础资料/Gy_CostItemController.cs | 28 ++++++++++++++--------------
1 files changed, 14 insertions(+), 14 deletions(-)
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CostItemController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CostItemController.cs"
index 1490405..bf0c0ad 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CostItemController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CostItemController.cs"
@@ -45,9 +45,9 @@
return objJsonResult;
}
- string sql1 = "SELECT * from h_v_Gy_CostItem_1 where 1 = 1";
+ string sql1 = "SELECT * from h_v_Gy_CostItemList where 1 = 1";
string sql = sql1 + sWhere + " order by 鎴愭湰椤圭洰浠ｇ爜 ";
- ds = oCN.RunProcReturn(sql, "h_v_Gy_CostItem_1");
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_CostItemList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -98,7 +98,7 @@
}
- var ds = oCN.RunProcReturn("select * from Gy_CostItem_1 where HItemID=" + HInterID, "Gy_CostItem_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostItem where HItemID=" + HInterID, "Gy_CostItem");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsAudit == 0) //瀹℃牳鍒ゆ柇
@@ -161,7 +161,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItem_1 set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItem set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
//瀹℃牳鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostItem_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -219,7 +219,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItem_1 set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItem set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
//鍙嶅鏍稿悗鎺у埗=========================================
string sql2 = "exec h_p_Gy_CostItem_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -297,7 +297,7 @@
}
oCN.BeginTran();//寮�濮嬩簨鍔�
- ds = oCN.RunProcReturn("select * from Gy_CostItem_1 where HItemID=" + HItemID, "Gy_CostItem_1 ");
+ ds = oCN.RunProcReturn("select * from Gy_CostItem where HItemID=" + HItemID, "Gy_CostItem ");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
@@ -352,7 +352,7 @@
//==================================================================================
- oCN.RunProc("delete Gy_CostItem_1 where HItemID=" + HItemID);
+ oCN.RunProc("delete Gy_CostItem where HItemID=" + HItemID);
//鍒犻櫎鍚庢帶鍒�=========================================
@@ -423,7 +423,7 @@
return objJsonResult;
}
- var ds = oCN.RunProcReturn("select * from Gy_CostItem_1 where HItemID=" + HInterID, "Gy_CostItem_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostItem where HItemID=" + HInterID, "Gy_CostItem");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsStop == 0) //绂佺敤鍒ゆ柇
@@ -487,7 +487,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItem_1 set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItem set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
//绂佺敤鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostItem_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -545,7 +545,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItem_1 set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItem set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
//鍙嶇鐢ㄥ悗鎺у埗=========================================
string sql2 = "exec h_p_Gy_CostItem_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -650,7 +650,7 @@
}
//鏌ヨ鏁版嵁涓槸鍚﹀瓨鍦ㄩ噸澶嶄唬鐮�
- ds = oCN.RunProcReturn("select * from Gy_CostItem_1 where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostItem_1");
+ ds = oCN.RunProcReturn("select * from Gy_CostItem where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostItem");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
@@ -701,7 +701,7 @@
{
//宸插鏍镐笉鍏佽淇敼
DataSet dss;
- dss = oCN.RunProcReturn("select * from Gy_CostItem_1 where HItemID=" + oItem.HItemID, "Gy_CostItem_1");
+ dss = oCN.RunProcReturn("select * from Gy_CostItem where HItemID=" + oItem.HItemID, "Gy_CostItem");
//鍒ゆ柇鏄惁鍙紪杈�
if (dss.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
{
@@ -804,8 +804,8 @@
try
{
List<object> columnNameList = new List<object>();
- string sql1 = $@"select * from h_v_Gy_CostItem_1 where HItemID = {HID}";
- ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostItem_1");
+ string sql1 = $@"select * from h_v_Gy_CostItemList where HItemID = {HID}";
+ ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostItemList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
{
--
Gitblit v1.9.1