From ae3c361a3f387e9d6963ff4d0a514ebb88ae3e32 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 25 三月 2026 10:39:46 +0800
Subject: [PATCH] 增加获取金蝶基础资料二开方法，工序流转卡派工时候，如果同意机台模具已派工，不允许二次派工
---
WebAPI/Controllers/基础资料/基础资料/Gy_CostItemAverageTypeController.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_CostItemAverageTypeController.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_CostItemAverageTypeController.cs"
index d11ae51..aadc583 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_CostItemAverageTypeController.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_CostItemAverageTypeController.cs"
@@ -45,9 +45,9 @@
return objJsonResult;
}
- string sql1 = "SELECT * from h_v_Gy_CostItemAverageType_1 where 1 = 1";
+ string sql1 = "SELECT * from h_v_Gy_CostItemAverageTypeList where 1 = 1";
string sql = sql1 + sWhere + " order by 鎴愭湰椤圭洰鍒嗛厤鏍囧噯浠ｇ爜";
- ds = oCN.RunProcReturn(sql, "h_v_Gy_CostItemAverageType_1");
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_CostItemAverageTypeList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
@@ -98,7 +98,7 @@
}
- var ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType_1 where HItemID=" + HInterID, "Gy_CostItemAverageType_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType where HItemID=" + HInterID, "Gy_CostItemAverageType");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsAudit == 0) //瀹℃牳鍒ゆ柇
@@ -161,7 +161,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItemAverageType_1 set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItemAverageType set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
//瀹℃牳鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostItemAverageType_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -219,7 +219,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItemAverageType_1 set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItemAverageType set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
//鍙嶅鏍稿悗鎺у埗=========================================
string sql2 = "exec h_p_Gy_CostItemAverageType_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -297,7 +297,7 @@
}
oCN.BeginTran();//寮�濮嬩簨鍔�
- ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType_1 where HItemID=" + HItemID, "Gy_CostItemAverageType_1");
+ ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType where HItemID=" + HItemID, "Gy_CostItemAverageType");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
@@ -352,7 +352,7 @@
//==================================================================================
- oCN.RunProc("delete Gy_CostItemAverageType_1 where HItemID=" + HItemID);
+ oCN.RunProc("delete Gy_CostItemAverageType where HItemID=" + HItemID);
//鍒犻櫎鍚庢帶鍒�=========================================
@@ -423,7 +423,7 @@
return objJsonResult;
}
- var ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType_1 where HItemID=" + HInterID, "Gy_CostItemAverageType_1");
+ var ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType where HItemID=" + HInterID, "Gy_CostItemAverageType");
if (ds.Tables[0].Rows.Count > 0)
{
if (IsStop == 0) //绂佺敤鍒ゆ柇
@@ -487,7 +487,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItemAverageType_1 set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItemAverageType set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
//绂佺敤鍚庢帶鍒�=========================================
string sql2 = "exec h_p_Gy_CostItemAverageType_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -545,7 +545,7 @@
}
//==================================================================================
- oCN.RunProc("update Gy_CostItemAverageType_1 set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
+ oCN.RunProc("update Gy_CostItemAverageType set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
//鍙嶇鐢ㄥ悗鎺у埗=========================================
string sql2 = "exec h_p_Gy_CostItemAverageType_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'";
@@ -650,7 +650,7 @@
}
//鏌ヨ鏁版嵁涓槸鍚﹀瓨鍦ㄩ噸澶嶄唬鐮�
- ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType_1 where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostItemAverageType_1");
+ ds = oCN.RunProcReturn("select * from Gy_CostItemAverageType where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_CostItemAverageType");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
@@ -701,7 +701,7 @@
{
//宸插鏍镐笉鍏佽淇敼
DataSet dss;
- dss = oCN.RunProcReturn("select * from Gy_CostItemAverageType_1 where HItemID=" + oItem.HItemID, "Gy_CostItemAverageType_1");
+ dss = oCN.RunProcReturn("select * from Gy_CostItemAverageType where HItemID=" + oItem.HItemID, "Gy_CostItemAverageType");
//鍒ゆ柇鏄惁鍙紪杈�
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_CostItemAverageType_1 where HItemID = {HID}";
- ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostItemAverageType_1");
+ string sql1 = $@"select * from h_v_Gy_CostItemAverageTypeList where HItemID = {HID}";
+ ds = oCN.RunProcReturn(sql1, "h_v_Gy_CostItemAverageTypeList");
//娣诲姞鍒楀悕
foreach (DataColumn col in ds.Tables[0].Columns)
{
--
Gitblit v1.9.1