From 73b0bd21324fac6244493c42e8ee8a145d2c3bf3 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期二, 09 十一月 2021 13:31:33 +0800
Subject: [PATCH] 采购订单 发布成功后的撤销功能
---
WebAPI/Controllers/PublicPageMethodController.cs | 55 +++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 47 insertions(+), 8 deletions(-)
diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index 97ad142..6315e17 100644
--- a/WebAPI/Controllers/PublicPageMethodController.cs
+++ b/WebAPI/Controllers/PublicPageMethodController.cs
@@ -122,9 +122,9 @@
#endregion
- #region 閫夋嫨鐢ㄦ埛鍩虹璧勬枡
+ #region 閫夋嫨鑱屽憳鍩虹璧勬枡
- #region 鏉′欢鏌ヨ鐢ㄦ埛鍒楄〃
+ #region 鏉′欢鏌ヨ鑱屽憳鍒楄〃
[Route("PublicPageMethod/UserList")]
[HttpGet]
public object UserList(string sWhere)
@@ -161,7 +161,7 @@
}
#endregion
- #region 鏍规嵁鏍戝瀷id鏌ユ壘鐢ㄦ埛鍒楄〃
+ #region 鏍规嵁鏍戝瀷id鏌ユ壘鑱屽憳鍒楄〃
[Route("Gy_MaintenanceMode/UserCX")]
[HttpGet]
public object UserCX(long HInterID)
@@ -198,7 +198,7 @@
}
#endregion
- #region 鏍戝瀷鍒楄〃鐢ㄦ埛鍒楄〃鏁版嵁
+ #region 鏍戝瀷鍒楄〃鑱屽憳鍒楄〃鏁版嵁
[Route("Gy_MaintenanceMode/UserLoadTree")]
[HttpGet]
public object UserLoadTree(string sWhere)
@@ -1442,13 +1442,13 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where HStopflag=0 Order by HItemID", "Gy_EquipMent");
+ ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain Order by HInterID", "Gy_EquipFileBillMain");
}
else
{
- string sql1 = "Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where 1 = 1 ";
+ string sql1 = "Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 1 = 1 ";
string sql = sql1 + sWhere;
- ds = oCN.RunProcReturn(sql, "Gy_EquipMent");
+ ds = oCN.RunProcReturn(sql, "HEquipFileNumber");
}
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
@@ -3310,7 +3310,46 @@
#endregion
-
+ #region 閫夋嫨鐢ㄦ埛鍩虹璧勬枡
+ #region 鏉′欢鏌ヨ鐢ㄦ埛鍒楄〃
+ [Route("PublicPageMethod/PeopleList")]
+ [HttpGet]
+ public object PeopleList(string sWhere)
+ {
+ try
+ {
+
+ ds = oCN.RunProcReturn("Select czybm HNumber,czymc HName from h_v_Gy_UserList " + sWhere + " Order by czybm ", "h_v_Gy_UserList");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犵敤鎴锋暟鎹紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
}
}
--
Gitblit v1.9.1