From 1e892ab5de03cec47a5b7e80d005a0ab5bbc2398 Mon Sep 17 00:00:00 2001 From: YL <YL@LAPTOP-SE03PLUR> Date: 星期一, 06 十二月 2021 17:39:06 +0800 Subject: [PATCH] 异常汇报单删除 --- WebAPI/Controllers/GG_NoticeController.cs | 39 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 39 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/GG_NoticeController.cs b/WebAPI/Controllers/GG_NoticeController.cs index 74910c0..e52323c 100644 --- a/WebAPI/Controllers/GG_NoticeController.cs +++ b/WebAPI/Controllers/GG_NoticeController.cs @@ -255,5 +255,44 @@ } #endregion + #region 鍏憡鍒楄〃鍒犻櫎 + [Route("GG_Notice/Get_GG_Notice_DeleteBill")] + [HttpGet] + public object Get_GG_Notice_DeleteBill(string HInterID, string user) + { + try + { + //鍒犻櫎鏉冮檺 + //if (!DBUtility.ClsPub.Security_Log_second("", 1, true, user)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} + + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + oCN.RunProc("delete from OA_InformBillSub where HInterID=" + HInterID); + oCN.RunProc("delete from OA_InformBillMain where HInterID=" + HInterID); + oCN.Commit();//鎻愪氦浜嬪姟 + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏憡鏁版嵁鍒犻櫎鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; ; + + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏憡鏁版嵁鍒犻櫎澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + } } -- Gitblit v1.9.1