From fa61fd1b6e892f055656c3232e8cf643d3658002 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期五, 28 三月 2025 17:36:22 +0800
Subject: [PATCH] 项目费用分类 的基础资料编辑及列表 管径、管径材质 的 基础资料 项目费用 里 增加 项目费用分类和 金额HStdMoney 的字段 异常反馈验收单，班次开班单，员工技能矩阵，工序流转卡维护，设备开机单 ：增加 系统参数（参考 开工单，采购订单，采购入库单 之类的 ）保存后自动审核； 如果 系统参数 为 Y，则 自动审核； 如果否 则 不审核；
---
WebAPI/DLL/ClsGy_ProjectMoney_Ctl.cs | 23 ++++++++++++++++-------
1 files changed, 16 insertions(+), 7 deletions(-)
diff --git a/WebAPI/DLL/ClsGy_ProjectMoney_Ctl.cs b/WebAPI/DLL/ClsGy_ProjectMoney_Ctl.cs
index 5783fe6..be35af2 100644
--- a/WebAPI/DLL/ClsGy_ProjectMoney_Ctl.cs
+++ b/WebAPI/DLL/ClsGy_ProjectMoney_Ctl.cs
@@ -13,19 +13,23 @@
public string HOldNumber;
public Model.ClsGy_ProjectMoney_Model oModel = new Model.ClsGy_ProjectMoney_Model();
//鏂板
- public override bool AddNew()
+ public override bool AddNew()
{
- //
+
try
{
- oCn.BeginTran();
+ oCn.BeginTran();
+
oCn.RunProc("Insert into " + MvarItemKey + " " +
" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
- ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID) " +
+ ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID" +
+ ",HProjectMoneyClassID) " +
" Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() +
- "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
+ "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HCREATEORGID + "'" +
+ ",'"+ oModel.HProjectMoneyClassID + "','" + oModel.HStdMoney + "')", ref DBUtility.ClsPub.sExeReturnInfo);
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
- oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
+ oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
+
oCn.Commit();
return true;
}
@@ -48,9 +52,14 @@
",HName='" + oModel.HName + "'" +
",HShortNumber='" + oModel.HShortNumber + "'" +
",HHelpCode='" + oModel.HHelpCode + "'" +
- ",HModifyTime='" + DateTime.Now + "'" +
",HUSEORGID='" + oModel.HUSEORGID + "'" +
+ ",HCREATEORGID='" + oModel.HCREATEORGID + "'" +
+
+ ",HProjectMoneyClassID='" + oModel.HProjectMoneyClassID + "'" +
+ ",HStdMoney='" + oModel.HStdMoney + "'" +
+
",HModifyEmp ='" + oModel.HMakeEmp + "'" +
+ ",HModifyTime=getdate()" +
",HUseFlag='" + oModel.HUseFlag + "'" +
",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
--
Gitblit v1.9.1