| | |
|---|
| | | 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"); |
|---|
