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