From c3b14901031d985ef750027d4952264369a1d7b0 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 02 三月 2026 10:26:21 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/基础资料/基础资料/Gy_CostCenterController.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_CostCenterController.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_CostCenterController.cs"
index bc2d0f2..4e980f7 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_CostCenterController.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_CostCenterController.cs"
@@ -45,9 +45,9 @@
return objJsonResult;
}
- string sql1 = "SELECT * from h_v_Gy_CostCenter_1 where 1 = 1";
+ string sql1 = "SELECT * from h_v_Gy_CostCenterList where 1 = 1";
string sql = sql1 + sWhere + " order by 鎴愭湰涓績浠ｇ爜 ";
- ds = oCN.RunProcReturn(sql, "h_v_Gy_CostCenter_1");
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_CostCenterList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -97,7 +97,7 @@
return objJsonResult;
}
- var ds = oCN.RunProcReturn("select * from Gy_CostCenter_1 where HItemID=" + HInterID, "Gy_CostCenter_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostCenter where HItemID=" + HInterID, "Gy_CostCenter");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsAudit == 0) //瀹℃牳鍒ゆ柇
@@ -160,7 +160,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostCenter_1 set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostCenter set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
//瀹℃牳鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostCenter_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -218,7 +218,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostCenter_1 set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostCenter set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
//鍙嶅鏍稿悗鎺у埗========================h_p_Gy_CostCenter_AfterUnCheckCtrl=================
string sql2 = "exec h_p_Gy_CostCenter_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -296,7 +296,7 @@
}
oCN.BeginTran();//寮�濮嬩簨鍔�
- ds = oCN.RunProcReturn("select * from Gy_CostCenter_1 where HItemID=" + HItemID, "Gy_CostCenter_1 ");
+ ds = oCN.RunProcReturn("select * from Gy_CostCenter where HItemID=" + HItemID, "Gy_CostCenter ");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
@@ -351,7 +351,7 @@
//==================================================================================
- oCN.RunProc("delete Gy_CostCenter_1 where HItemID=" + HItemID);
+ oCN.RunProc("delete Gy_CostCenter where HItemID=" + HItemID);
//鍒犻櫎鍚庢帶鍒�=========================================
@@ -422,7 +422,7 @@
return objJsonResult;
}
- var ds = oCN.RunProcReturn("select * from Gy_CostCenter_1 where HItemID=" + HInterID, "Gy_CostCenter_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostCenter where HItemID=" + HInterID, "Gy_CostCenter");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsStop == 0) //绂佺敤鍒ゆ柇
@@ -486,7 +486,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostCenter_1 set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostCenter set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
//绂佺敤鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostCenter_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -544,7 +544,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostCenter_1 set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostCenter set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
//鍙嶇鐢ㄥ悗鎺у埗=========================================
string sql2 = "exec h_p_Gy_CostCenter_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -649,7 +649,7 @@
}
//鏌ヨ鏁版嵁涓槸鍚﹀瓨鍦ㄩ噸澶嶄唬鐮�
- ds = oCN.RunProcReturn("select * from Gy_CostCenter_1 where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostCenter_1");
+ ds = oCN.RunProcReturn("select * from Gy_CostCenter where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostCenter");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
@@ -700,7 +700,7 @@
{
//宸插鏍镐笉鍏佽淇敼
DataSet dss;
- dss = oCN.RunProcReturn("select * from Gy_CostCenter_1 where HItemID=" + oItem.HItemID, "Gy_CostCenter_1");
+ dss = oCN.RunProcReturn("select * from Gy_CostCenter where HItemID=" + oItem.HItemID, "Gy_CostCenter");
//鍒ゆ柇鏄惁鍙紪杈�
if (dss.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
{
@@ -803,8 +803,8 @@
try
{
List<object> columnNameList = new List<object>();
- string sql1 = $@"select * from h_v_Gy_CostCenter_1 where HItemID = {HID}";
- ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostCenter_1");
+ string sql1 = $@"select * from h_v_Gy_CostCenterList where HItemID = {HID}";
+ ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostCenterList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
{
--
Gitblit v1.9.1