From 7659bbba43cb690164bbf1fa3bc1d0fe74d883c9 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期五, 16 八月 2024 17:04:05 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 29 ++++++++++++++++++++++++++++- 1 files changed, 28 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs index 38d1b4c..a439450 100644 --- a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs @@ -854,6 +854,8 @@ return objJsonResult; } oCN.BeginTran();//寮�濮嬩簨鍔� + string HNumber = ""; + string HName = ""; ds = oCN.RunProcReturn("select * from Gy_Employee where HItemID=" + HItemID, "Gy_Employee"); if (ds == null || ds.Tables[0].Rows.Count == 0) { @@ -863,6 +865,13 @@ objJsonResult.data = null; return objJsonResult; ; } + else + { + HNumber = ds.Tables[0].Rows[0]["HNumber"].ToString(); + HName = ds.Tables[0].Rows[0]["HName"].ToString(); + } + + var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); if (HStopflag) { @@ -875,6 +884,24 @@ } oCN.RunProc("delete from Gy_Employee where HItemID=" + HItemID); + + + + //鍐欏叆鏃ュ織 + string Operation = "鍒犻櫎"; //鎿嶄綔 + string ComputerName = System.Net.Dns.GetHostName(); //璁惧鍚嶇О + string WorkList = Operation + "鑱屽憳锛岃亴鍛樹唬鐮侊細" + HNumber + "锛涜亴鍛樺悕绉帮細" + HName ; //鎿嶄綔璇︽儏 + string MvarReportTitle = "鑱屽憳鍒楄〃"; //鎿嶄綔妯″潡 + string SystemName = "LMES-" + MvarReportTitle + "妯″潡"; //鎿嶄綔妯″潡 + string IPAddress = ""; + //string IPAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList[0].ToString(); //IP鍦板潃 + //string IPAddress = System.Web.HttpContext.Current.Request.UserHostAddress; + + oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + + "(getdate(),'" + user + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','" + Operation + "')" + ); + + oCN.Commit();//鎻愪氦浜嬪姟 objJsonResult.code = "0"; objJsonResult.count = 1; @@ -1280,7 +1307,7 @@ ,HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HGroupID,HUseFlag,HMakeTime,HCREATEORGID,HUSEORGID ) values - ({jsonData.HItemID},{jsonData.HERPItemID},'{jsonData.HNumber}','{jsonData.HName}', + ({jsonData.HItemID},{jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}', '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}',{jsonData.HDeptID},{jsonData.HGroupID},'{jsonData.HUseFlag}','{jsonData.HMakeTime}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID})"; oCN.RunProc(sql); -- Gitblit v1.9.1