From 5e718032954cc08d24d16c680ddee8ae218d7092 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 13 六月 2024 14:46:38 +0800 Subject: [PATCH] 单据删除 需要增加 写入日志;(谁删除,什么时候删除,删除了什么单据号) 基础资料删除 需要增加 写入日志;(谁删除,什么时候删除,删除了什么编码,名称) 日志采用原有的日志表, 编写一个 单据和基础资料的 案例(完成后与景焕章确认,确认案例后,安排其他研发分别完善其他模块) --- WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 27 +++++++++++++++++++++++++++ 1 files changed, 27 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs index 38d1b4c..a1495d2 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; -- Gitblit v1.9.1