| | |
| | | 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"); |
| | |
| | | //进行需要进行的关闭/反关闭操作 |
| | | if (IsAudit == 0) //关闭提交 |
| | | { |
| | | oBill.oCn.BeginTran(); |
| | | //关闭提交 |
| | | if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | { |
| | | //关闭后控制========================================= |
| | | string sql_afterClose = "exec h_p_Xs_SeOrderBill_AfterCloseCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; |
| | | DataSet ds_afterClose = oBill.oCn.RunProcReturn(sql_afterClose, "h_p_Xs_SeOrderBill_AfterCloseCtrl"); |
| | | if (ds_afterClose == null || ds_afterClose.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "关闭失败,原因:关闭后控制错误,请联系网络管理人员!"; |
| | | objJsonResult.data = null; |
| | | oBill.oCn.RollBack(); |
| | | |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | if (ds_afterClose.Tables[0].Rows[0]["HBack"].ToString() != "0") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "关闭失败,原因:" + ds_afterClose.Tables[0].Rows[0]["HRemark"].ToString(); |
| | | objJsonResult.data = null; |
| | | oBill.oCn.RollBack(); |
| | | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //========================================= |
| | | |
| | | oBill.oCn.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "关闭成功"; |
| | |
| | | } |
| | | else |
| | | { |
| | | oBill.oCn.RollBack(); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; |
| | |
| | | if (IsAudit == 0) //行关闭提交 |
| | | { |
| | | //行关闭提交 |
| | | if (oBill.CloseRow(lngBillKey,HEntryID,oBill.omodel.HBillNo,CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | if (oBill.CloseRow(lngBillKey,HEntryID,oBill.omodel.HBillNo,CurUserName, "h_p_Xs_SeOrderBill_AfterEntryCloseCtrl", ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |