From 6f7e999691fc768d427b7130c9fcc7f3017e1fbc Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 16 五月 2024 17:07:29 +0800
Subject: [PATCH] 1.销售管理,仓库管理 所有的 新增 审核 反审核 删除 增加 进行 会计期间 结账 的判断和控制 2.岗位技能清单 和 员工技能清单 表头 增加 2个 字段； HMaterID int --产品编码（gy_Material） HProcID int --工序（gy_Process）
---
WebAPI/DLL/ClsGy_PostSkill_Ctl.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs b/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs
index 9af16c8..8d34add 100644
--- a/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs
+++ b/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs
@@ -20,9 +20,9 @@
oCn.BeginTran();
oCn.RunProc("Insert into " + MvarItemKey + " " +
" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
- ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HERPItemID) " +
+ ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HPostID,HProcID) " +
" 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 + "','" + 0 + "')", 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.HUSEORGID + "','" +oModel.HPostID + "','" + oModel.HProcID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
oCn.Commit();
@@ -50,6 +50,8 @@
",HModifyTime='" + DateTime.Now + "'" +
",HUSEORGID='" + oModel.HUSEORGID + "'" +
",HModifyEmp ='" + oModel.HMakeEmp + "'" +
+ ",HPostID ='" + oModel.HPostID + "'" +
+ ",HProcID ='" + oModel.HProcID + "'" +
",HUseFlag='" + oModel.HUseFlag + "'" +
",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
--
Gitblit v1.9.1