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