From 554cb4d840d2bd2a8c8b925d6e4242a949e88f24 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 16 六月 2022 21:13:54 +0800
Subject: [PATCH] 导入接口接口定义
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 182 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 176 insertions(+), 6 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index c9b4b59..6d47fc9 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -84,6 +84,7 @@
#region [缁勭粐鏋舵瀯鏌ユ壘涓婄骇鍗曚綅]
public static ToMessage PrentOrganization(string orgcode)
{
+ var sql = "";
var dynamicParams = new DynamicParameters();
string search = "";
try
@@ -116,11 +117,14 @@
dynamicParams.Add("@orgcode", orgcode);
break;
default:
+ orgcode = "";
+ search += "and description=@orgcode ";
+ dynamicParams.Add("@orgcode", orgcode);
break;
}
- var sql = @"select roletype_code,roletype_name
- from TRoleType
- where A.is_delete<>'1' " + search;
+ sql = @"select id,org_code,org_name
+ from TOrganization
+ where is_delete<>'1' " + search;
var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
@@ -564,6 +568,68 @@
}
#endregion
+ #region[鐢ㄦ埛娓呭崟瀵煎叆]
+ public static ToMessage ImportUserExcel(string username, string filesName)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ DataTable ds = new DataTable();
+ var dynamicParams = new DynamicParameters();
+
+ try
+ {
+ ds = NPOIHelper.GetExcelDatatable(filesName); //璋冪敤鑷畾涔夋柟娉�
+ int rowsnum = ds.Rows.Count;
+ if (rowsnum == 0)
+ {
+ mes.code = "300";
+ mes.Message = "Excel琛ㄦ牸涓虹┖,鏃犳暟鎹紒";
+ }
+ else
+ {
+ list.Clear();
+ for (int i = 0; i < ds.Rows.Count; i++)
+ {
+
+ if (ds.Rows[i][1].ToString() != "" && ds.Rows[i][1].ToString() != null)
+ {
+ sql = @"insert into TUser(usercode,username,enable,password,mobile,email,lm_user,lm_date,wagetype,stu_torgcode)
+ values(@usercode,@username,@enable,@password,@mobile,@email,@lm_user,@lm_date,@wagetype,@stu_torgcode)";
+ dynamicParams.Add("@usercode", ds.Rows[i][1].ToString());
+ dynamicParams.Add("@username", ds.Rows[i][2].ToString());
+ dynamicParams.Add("@enable", ds.Rows[i][3].ToString());
+ dynamicParams.Add("@password", ds.Rows[i][4].ToString());
+ dynamicParams.Add("@mobile", ds.Rows[i][5].ToString());
+ dynamicParams.Add("@email", ds.Rows[i][6].ToString());
+ dynamicParams.Add("@lm_user", username);
+ dynamicParams.Add("@lm_date", DateTime.Now.ToString());
+ dynamicParams.Add("@wagetype", ds.Rows[i][7].ToString());
+ dynamicParams.Add("@stu_torgcode", ds.Rows[i][8].ToString());
+ list.Add(new { str = sql, parm = dynamicParams });
+ }
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.Message = "瀵煎叆鎴愬姛!";
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "瀵煎叆澶辫触!";
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.Message = e.Message;
+ }
+ return mes;
+ }
+ #endregion
+
#region[瑙掕壊绫诲瀷鏌ヨ]
@@ -895,9 +961,14 @@
list.Clear();
if (json == null || json.Count <= 0)
{
- mes.code = "300";
- mes.Message = "璇峰厛閫夋嫨鍏宠仈瑙掕壊鐨勭敤鎴蜂俊鎭�";
- return mes;
+ //娓呴櫎鐢ㄦ埛鍏宠仈瑙掕壊琛ㄦ暟鎹�
+ sql = @"delete TUserRoleRelation where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
+ //鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
+ sql = @"update TRole set is_user='N' where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
}
else
{
@@ -939,6 +1010,105 @@
}
#endregion
+ #region[瑙掕壊娓呭崟鍏宠仈鍔熻兘鏌ヨ]
+ public static ToMessage RoleAssociationRight(string rolecode,string type)
+ {
+ Dictionary<object, object> dList = new Dictionary<object, object>();
+ List<object> list=new List<object>();
+ try
+ {
+ if (type == "" || type == null)
+ {
+ list.Add(SeachEncode.RightLocation(rolecode, "PC"));
+ list.Add(SeachEncode.RightLocation(rolecode, "APP"));
+ }
+ else if (type == "APP")
+ {
+ list.Add(SeachEncode.RightLocation(rolecode, type));
+ }
+ else {
+ list.Add(SeachEncode.RightLocation(rolecode, type));
+ }
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = list;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.Message = e.Message;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region [瑙掕壊娓呭崟鍏宠仈鍔熻兘淇濆瓨]
+ public static ToMessage SaveUserAssoctRight(string rolecode,string usercode, List<TreeDM> json)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ if (json == null || json.Count <= 0)
+ {
+ //娓呴櫎鐢ㄦ埛鍏宠仈鍔熻兘琛ㄦ暟鎹�
+ sql = @"delete TRoleRightRelation where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
+ //鏍囪瑙掕壊琛ㄥ叧鑱斿姛鑳芥爣璇�
+ sql = @"update TRole set is_right='N' where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
+ }
+ else
+ {
+ //娓呴櫎瑙掕壊鍏宠仈鍔熻兘琛ㄦ暟鎹�
+ sql = @"delete TRoleRightRelation where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
+ //寰幆鍐欏叆鐢ㄦ埛鍏宠仈瑙掕壊琛�
+ for (int i = 0; i < json.Count; i++) //PC銆丄PP灞�
+ {
+ for (int j = 0; j < json[i].children.Count; j++) //涓�绾ц彍鍗�
+ {
+ for (int k = 0; k < json[i].children[j].children.Count; k++) //浜岀骇鑿滃崟
+ {
+ sql = @"insert into TRoleRightRelation(role_code,right_code,lm_user,lm_date) values(@role_code,@right_code,@lm_user,@lm_date)";
+ dynamicParams.Add("@role_code", rolecode);
+ dynamicParams.Add("@right_code", json[i].children[j].children[k].code);
+ dynamicParams.Add("@lm_user", usercode);
+ dynamicParams.Add("@lm_date", DateTime.Now.ToString());
+ list.Add(new { str = sql, parm = dynamicParams });
+ }
+ }
+ }
+ //鏍囪瑙掕壊琛ㄥ叧鑱旂敤鎴锋爣璇�
+ sql = @"update TRole set is_right='Y' where role_code=@rolecode";
+ dynamicParams.Add("@rolecode", rolecode);
+ list.Add(new { str = sql, parm = dynamicParams });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.Message = "鎿嶄綔鎴愬姛!";
+ }
+ else
+ {
+ mes.code = "300";
+ mes.Message = "鎿嶄綔澶辫触!";
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.Message = e.Message;
+ }
+ return mes;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.3