From 6628d9bda9d34a7f611b951c931f7a465ee20c6d Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 12 一月 2024 10:30:47 +0800
Subject: [PATCH] 用户关联用户查询 删除
---
WebAPI/Controllers/BLL/Xt_UserController.cs | 39 +++++++++++++
WebAPI/Models/Gy_UserUser.cs | 2
WebAPI/Controllers/WebAPIController.cs | 75 +++++++++++++++++++++++++
WebAPI/Service/LuBaoSevice.cs | 24 ++++++++
4 files changed, 139 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs
index 2073814..1ee4d5b 100644
--- a/WebAPI/Controllers/BLL/Xt_UserController.cs
+++ b/WebAPI/Controllers/BLL/Xt_UserController.cs
@@ -914,6 +914,45 @@
}
#endregion
+ #region 鐢ㄦ埛鍏宠仈鐢ㄦ埛鍒楄〃鏌ヨ
+ [Route("Xt_User/Gy_UserByUserList")]
+ [HttpGet]
+ public object Gy_UserByUserList(string sWhere, string user)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+
+ string sql1 = "select * from h_v_Gy_UserByUserRelationList where 1 = 1";
+ string sql = sql1 + sWhere + " order by 鐢ㄦ埛浠ｇ爜 ";
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_UserStockRelation");
+
+ //娣诲姞鍒楀悕
+ foreach (DataColumn col in ds.Tables[0].Columns)
+ {
+ Type dataType = col.DataType;
+ string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+ columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞＄殑鍒楀悕
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = columnNameList;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
#region 鏍规嵁鐢ㄦ埛缂栫爜鏌ユ壘宸插垎閰嶇彮缁勫垪琛�
[Route("Xt_User/UserGrouplistPlaylist")]
[HttpGet]
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 74a7860..0c650fe 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -7872,6 +7872,69 @@
return model;
}
+ /// <summary>
+ /// 鐢ㄦ埛鍏宠仈鐢ㄦ埛鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [Route("Xt_User/Gy_UserByUserListDrop")]
+ [HttpGet]
+ public object DeltetGy_Material(string HItemID, string user)
+ {
+ DataSet ds;
+ try
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+
+ //鍒犻櫎鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_UserByUser_Drop", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犲垹闄ゆ潈闄�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ if (string.IsNullOrWhiteSpace(HItemID))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "HItemID涓虹┖锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oCN.BeginTran();//寮�濮嬩簨鍔�
+ ds = oCN.RunProcReturn("select * from Gy_UserByUserRelation where HItemID=" + HItemID, "Gy_UserByUserRelation");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ oCN.RollBack();//鍥炴粴浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁鏁版嵁锛屾棤娉曞垹闄わ紒";
+ objJsonResult.data = null;
+ return objJsonResult; ;
+ }
+
+ oCN.RunProc("delete from Gy_UserByUserRelation where HItemID=" + HItemID);
+
+ oCN.Commit();//鎻愪氦浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "* 鏁版嵁鍒犻櫎鎴愬姛锛�";
+ objJsonResult.data = null;
+ return objJsonResult; ;
+
+ }
+ catch (Exception e)
+ {
+ oCN.RollBack();//鍥炴粴浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍒犻櫎澶辫触锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
/// <summary>
/// 鐢ㄥ叧鑱旂墿鏂欒幏鍙栦俊鎭�
@@ -7899,6 +7962,18 @@
}
/// <summary>
+ /// 鐢ㄥ叧鑱旂敤鎴疯幏鍙栦俊鎭�
+ /// </summary>
+ /// <returns></returns>
+ [Route("Gy_UserByUserEdit")]
+ [HttpGet]
+ public ApiResult<DataSet> Gy_UserByUserEdit(string HID)
+ {
+ var model = LuBaoSevice.Gy_UserByUserEdit(HID);
+ return model;
+ }
+
+ /// <summary>
/// 鎶ュ簾鍘熷洜
/// </summary>
/// <returns></returns>
diff --git a/WebAPI/Models/Gy_UserUser.cs b/WebAPI/Models/Gy_UserUser.cs
index 35daf64..bd8bcba 100644
--- a/WebAPI/Models/Gy_UserUser.cs
+++ b/WebAPI/Models/Gy_UserUser.cs
@@ -7,7 +7,7 @@
{
public class Gy_UserUser
{
- public int HUserID2 { get; set; }
+ public string HUserID2 { get; set; }
public string HUserNumber2 { get; set; }
public string HUserName2 { get; set; }
}
diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs
index a9ce56d..a2956c3 100644
--- a/WebAPI/Service/LuBaoSevice.cs
+++ b/WebAPI/Service/LuBaoSevice.cs
@@ -342,6 +342,9 @@
return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄧ敤鎴峰叧鑱斾粨搴撴暟鎹�" };
return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet };
}
+
+
+
public static DataSet GetGy_UserStockRelationDb(string HID)
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
@@ -350,6 +353,27 @@
}
/// <summary>
+ /// 鐢ㄦ埛鍏宠仈鐢ㄦ埛鏍规嵁id鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> Gy_UserByUserEdit(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = Gy_UserByUserEdittDb(HID);
+ if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
+ return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄧ敤鎴峰叧鑱斾粨搴撴暟鎹�" };
+ return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet };
+ }
+
+ public static DataSet Gy_UserByUserEdittDb(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserByUserRelationList where 鐢ㄦ埛浠ｇ爜= '" + HID + "' ", "h_v_Gy_UserByUserRelationList");
+ return dataSet;
+ }
+
+
+ /// <summary>
/// 鐢ㄦ埛鍏宠仈鐗╂枡鏍规嵁id鑾峰彇淇℃伅
/// </summary>
public static ApiResult<DataSet> GetGy_UserMaterDetail(string HID)
--
Gitblit v1.9.1