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/XSGL/Xs_SeOrderBillController.cs | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs index a27934a..6f70605 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs @@ -1391,6 +1391,22 @@ oCN.RunProc("delete from Xs_SeOrderBillMain where HInterID = " + HInterID); oCN.RunProc("delete from Xs_SeOrderBillSub where HInterID='" + HInterID + "'"); + + //鍐欏叆鏃ュ織 + string Operation = "鍒犻櫎"; + string ComputerName = System.Net.Dns.GetHostName(); //璁惧鍚嶇О + string WorkList = Operation + "鍗曟嵁锛屽崟鎹彿锛�" + BillOld.omodel.HBillNo; + string MvarReportTitle = BillOld.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 + "')" + ); + + //鍒犻櫎鍚庢帶鍒�================================================================================== string sql2 = "exec h_p_Xs_SeOrderBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; ds = oCN.RunProcReturn(sql2, "h_p_Xs_SeOrderBill_AfterDelCtrl"); -- Gitblit v1.9.1