From 0c39b5c0ed0f6d01c60bf5e738787ac305270590 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期三, 20 十月 2021 18:22:01 +0800
Subject: [PATCH] 新增设备分类列表
---
WebAPI/Controllers/BLL/Xt_UserController.cs | 64 +++++++++++++++++++++++++++++---
1 files changed, 58 insertions(+), 6 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs
index 29d996d..f77bd99 100644
--- a/WebAPI/Controllers/BLL/Xt_UserController.cs
+++ b/WebAPI/Controllers/BLL/Xt_UserController.cs
@@ -18,11 +18,7 @@
DataSet ds;
- /// <summary>
- /// 杩斿洖绯荤粺鐢ㄦ埛鍒楄〃
- ///鍙傛暟锛歴tring sql銆�
- ///杩斿洖鍊硷細object銆�
- /// </summary>
+ #region[鐢ㄦ埛鍒楄〃鏌ヨ]
[Route("Xt_User/list")]
[HttpGet]
public object list(string sWhere)
@@ -65,9 +61,65 @@
return objJsonResult;
}
}
+ #endregion
+ #region [鐢ㄦ埛鍒楄〃鍒犻櫎鍔熻兘]
+ /// <summary>
+ /// 鐢ㄦ埛淇℃伅鍒犻櫎鍔熻兘
+ /// </summary>
+ /// <returns></returns>
+ [Route("Xt_User/DeltetUser")]
+ [HttpGet]
+ public object DeltetUser(string HCzybm)
+ {
+ try
+ {
+ //缂栬緫鏉冮檺
+ //if (!DBUtility.ClsPub.Security_Log("Gy_UserByUserRelation_Delete", 1, true, DBUtility.ClsPub.CurUserName))
+ //{
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ //}
+ Int64 lngBillKey = 0;
+ lngBillKey = DBUtility.ClsPub.isLong(HCzybm);
+ if (lngBillKey == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鐢ㄦ埛缂栫爜涓虹┖锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oCN.BeginTran();
+ //鍒犻櫎鐢ㄦ埛淇℃伅
+ oCN.RunProc("delete from Gy_Czygl where Czybm='" + HCzybm + "'");
+ //鍒犻櫎鐢ㄦ埛瀵瑰簲鐨勮鑹蹭俊鎭�
+ oCN.RunProc("delete from System_UserGroupInfo where UserId='" + HCzybm + "'");
+ DBUtility.ClsPub.Add_Log(DBUtility.ClsPub.CurUserName, "鍒犻櫎鐢ㄦ埛:" + HCzybm, DBUtility.ClsPub.CurUserName);
+ oCN.Commit();
- //
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message ="鍒犻櫎淇℃伅鎴愬姛!";
+ objJsonResult.data = null;
+
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.Message;
+ objJsonResult.data = null;
+ }
+ return objJsonResult;
+ }
+
+ #endregion
+
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1