From 091468bc308c7eb8141b47d02b704f7c53782a76 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 02 十二月 2021 17:38:50 +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