From c9e16fa099de3442f005ba9c973de10b7905a963 Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期二, 26 一月 2021 15:18:27 +0800
Subject: [PATCH] 增加墙咔工资统计报表、进站单列表删除、出站单列表删除功能
---
WebAPI/Controllers/WebAPIController.cs | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index a811605..d73605a 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -329,6 +329,33 @@
}
+ //鍒犻櫎琛ㄨ褰�
+ [Route("Web/Delete_Table")]
+ [HttpGet]
+ public object Delete_Table(string sqlStr)
+ {
+ try
+ {
+ //SQLHelper oCn;
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ oCN.RunProc(sqlStr);
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎鎴愬姛锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ catch (Exception)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍒犻櫎澶辫触锛佸紓甯�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ }
+
#region 鍩虹璧勬枡
/// <summary>
/// 鑾峰彇浠撳簱鍒楄〃
--
Gitblit v1.9.1