/// <summary>
/// 给用户赋予角色
/// </summary>
/// <param name="userID"></param>
/// <param name="roleIDS"></param>
/// <returns></returns>
public static RtnMessage SetUserRoles(int userID, int[] roleIDS)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
using (var db = new Database(new MySqlConnection(ConnString)))
{
try
{
using (var scope = db.GetTransaction())
{
db.Delete <Sys_User_Role>($"WHERE UserID={userID}");
foreach (var item in roleIDS)
{
Sys_User_Role entity = new Sys_User_Role()
{
UserID = userID,
RoleID = item
};
db.Insert("Sys_User_Role", "ID", entity);
}
scope.Complete();
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
db.AbortTransaction();
rtnMsg.Message = ex.Message;
return(rtnMsg);
}
}
return(rtnMsg);
}
public static RtnMessage DeleteRoles(List <Sys_Roles> list)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
using (var db = new Database(new MySqlConnection(ConnString)))
{
using (var scope = db.GetTransaction())
{
try
{
foreach (var item in list)
{
db.Update <Sys_Roles>($"SET Status=99 WHERE ID={item.ID}");
}
scope.Complete();
}
catch (Exception ex)
{
db.AbortTransaction();
rtnMsg.Code = -1;
rtnMsg.Message = ex.Message;
return(rtnMsg);
}
}
}
return(rtnMsg);
}
public string GetModuleListByRole(int roleId)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysModuleBLL.GetModuleListByRole(roleId);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string SetRoleMenu(int roleID, int[] menuids)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysRolesBLL.SetRoleMenu(roleID, menuids);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public static RtnMessage SaveUserAtIndex(Sys_Users users)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
users.EditTime = DateTime.Now;
string sql = $"SET RealName='{users.RealName}',Sex={users.Sex},Phone='{users.Phone}',EditTime='{users.EditTime}' WHERE ID={users.ID}";
if (!(Convert.ToInt32(db.Update <Sys_Users>(sql)) > 0))
{
rtnMsg.Code = 1;
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
return(rtnMsg);
}
public string GetUserInfo()
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.GetUserInfo(_userId);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public static RtnMessage SetRoleMenu(int roleID, int[] menuids)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
using (var db = new Database(new MySqlConnection(ConnString)))
{
try
{
using (var scope = db.GetTransaction())
{
db.Delete <Sys_Role_Menu>($"WHERE RoleID={roleID}");
foreach (var item in menuids)
{
Sys_Role_Menu entity = new Sys_Role_Menu()
{
RoleID = roleID,
MenuID = item
};
db.Insert("Sys_Role_Menu", "ID", entity);
}
scope.Complete();
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
db.AbortTransaction();
rtnMsg.Message = ex.Message;
return(rtnMsg);
}
}
return(rtnMsg);
}
public static RtnMessage GetDictList(base_dict info)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
List <base_dict> list = new List <base_dict>();
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
Sql sql = Sql.Builder;
sql.Append("SELECT a.* FROM base_dict a WHERE a.State <>-1");
if (!string.IsNullOrEmpty(info.Name))
{
sql.Append($" AND a.Name like '%{info.Name}%'");
}
if (info.typeID != 0)
{
sql.Append($" AND a.TypeID ={info.typeID}");
}
list = db.Fetch <base_dict>(sql);
rtnMsg.Data = list;
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
return(rtnMsg);
}
public static RtnMessage Save(base_dict info)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
using (var db = new Database(new MySqlConnection(ConnString)))
{
try
{
if (info.ID == 0)
{
if (!(Convert.ToInt32(db.Insert("base_dict", "ID", info)) > 0))
{
rtnMsg.Code = 1;
}
}
else
{
if (!(Convert.ToInt32(db.Save(info)) > 0))
{
rtnMsg.Code = 1;
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
}
return(rtnMsg);
}
public string SaveDict(base_dict data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.BaseDictBLL.Save(data);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string SaveUserAtIndex(Sys_Users data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.SaveUserAtIndex(data);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public static RtnMessage DeleteModule(SysModule data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
//using (var db = new Database(new MySqlConnection(ConnString)))
//{
//using (var scope = db.GetTransaction())
//{
// try
// {
// foreach (var item in list)
// {
// db.Update<Sys_Module>($"SET Status=99 WHERE ID={item.ID}");
// }
// scope.Complete();
// }
// catch (Exception ex)
// {
// db.AbortTransaction();
// rtnMsg.Code = -1;
// rtnMsg.Message = ex.Message;
// return rtnMsg;
// }
//}
//}
return(rtnMsg);
}
public static RtnMessage GetRoleList(Sys_Roles roles)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
List <Sys_Roles> list = new List <Sys_Roles>();
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
Sql sql = Sql.Builder;
sql.Append("SELECT a.*,b.RealName UserRealName FROM Sys_Roles a left join sys_users b on a.UserId=b.ID WHERE a.Status <>99");
if (!string.IsNullOrEmpty(roles.RoleName))
{
sql.Append($" AND a.RoleName like '%{roles.RoleName}%'");
}
list = db.Fetch <Sys_Roles>(sql);
rtnMsg.Data = list;
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
return(rtnMsg);
}
public static RtnMessage ModifyPassword(int userID, string password, string newpwd)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
password = StringHelper.Encrypt(password, SysConfig.Key);
newpwd = StringHelper.Encrypt(newpwd, SysConfig.Key);
if (db.Update <Sys_Users>($"SET PassWord='******' WHERE ID={userID} AND PassWord='******'") <= 0)
{
rtnMsg.Code = 1;
rtnMsg.Message = "原密码错误";
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.Message;
return(rtnMsg);
}
return(rtnMsg);
}
public static RtnMessage GetUserList(Sys_Users users)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
List <Sys_Users> list = new List <Sys_Users>();
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
Sql sql = Sql.Builder;
sql.Append("SELECT * FROM Sys_Users WHERE Status <>99");
if (!string.IsNullOrEmpty(users.RealName))
{
sql.Append($" AND RealName like '%{users.RealName}%'");
}
list = db.Fetch <Sys_Users>(sql);
rtnMsg.Data = list;
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
return(rtnMsg);
}
public string CheckUserName(string username)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.CheckUserName(username);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string SetUserRoles(int userID, int[] roleIDS)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.SetUserRoles(userID, roleIDS);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string DeleteUsers(List <Sys_Users> list)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.DeleteUsers(list);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string ResetPwd(int userID)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.ResetPassword(userID);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string ModifyPwd(string pwd, string newpwd)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.ModifyPassword(_userId, pwd, newpwd);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public static RtnMessage GetModuleByUser(int userId)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
try
{
using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection)))
{
StringBuilder sql = new StringBuilder();
sql.Append($"select DISTINCT a.* from sys_module a LEFT JOIN sys_role_menu b on ");
sql.Append($"a.ID=b.MenuID left join sys_user_role c on b.RoleID=c.RoleID where c.UserID={userId}");
sql.Append($" UNION select * from sys_module where ID IN");
sql.Append($" (select a.ParentId from sys_module a LEFT JOIN sys_role_menu b on ");
sql.Append($" a.ID=b.MenuID left join sys_user_role c on b.RoleID=c.RoleID where c.UserID={userId} ) ");
var list = db.Fetch <SysModule>(sql.ToString());
rtnMsg.Data = list;
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
Common.LoggerHelper.Error(ex.ToString());
return(rtnMsg);
}
return(rtnMsg);
}
public static RtnMessage SaveRoles(Sys_Roles roles)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
if (roles.ID == 0)
{
roles.CreateTime = DateTime.Now;
if (!(Convert.ToInt32(db.Insert("sys_roles", "ID", roles)) > 0))
{
rtnMsg.Code = 1;
}
}
else
{
if (!(Convert.ToInt32(db.Save(roles)) > 0))
{
rtnMsg.Code = 1;
}
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.ToString();
return(rtnMsg);
}
return(rtnMsg);
}
/// <summary>
/// 保存模块数据
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static RtnMessage SaveSysModule(SysModule data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
try
{
using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection)))
{
if (data.Id == 0)
{
data.CreateTime = DateTime.Now;
if (!(Convert.ToInt32(db.Insert("Sys_Module", "ID", data)) > 0))
{
rtnMsg.Code = 1;
}
}
else
{
if (!(Convert.ToInt32(db.Save(data)) > 0))
{
rtnMsg.Code = 1;
}
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
Common.LoggerHelper.Error(ex.ToString());
return(rtnMsg);
}
return(rtnMsg);
}
public string CheckRoleName(string rolename)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysRolesBLL.CheckRoleName(rolename);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public static RtnMessage CheckRoleName(string rolename)
{
RtnMessage rtnMsg = new RtnMessage()
{
Code = 0
};
try
{
using (var db = new Database(new MySqlConnection(ConnString)))
{
var users = db.FirstOrDefault <Sys_Roles>($"WHERE RoleName='{rolename}' And Status<>99");
if (users != null)
{
rtnMsg.Code = 1;
rtnMsg.Message = "此用户名已存在";
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
rtnMsg.Message = ex.Message;
return(rtnMsg);
}
return(rtnMsg);
}
public string DeleteDict(List <base_dict> list)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.BaseDictBLL.DeleteDict(list);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string SaveRole(Sys_Roles data)
{
RtnMessage rtnMsg = new RtnMessage();
data.UserID = _userId;
rtnMsg = BLL.SysRolesBLL.Save(data);
return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg));
}
public string GetRoleList(Sys_Roles data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysRolesBLL.GetRoleList(data);
var list = BLL.SysModuleBLL.GetModuleList();
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rtnMsg, list }));
}
public string GetUserList(Sys_Users data)
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg = BLL.SysUsersBLL.GetUserList(data);
var roleList = BLL.SysRolesBLL.GetRoleList(new Sys_Roles());
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rtnMsg, roleList }));
}
public static RtnMessage GetModuleList()
{
RtnMessage rtnMsg = new RtnMessage();
rtnMsg.Code = 0;
List <SysModule> menuList = new List <SysModule>();
List <MenusTreeModel> treeList = new List <MenusTreeModel>();
try
{
using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection)))
{
menuList = db.Fetch <SysModule>($"SELECT * FROM sys_module");
#region 构造树形结构
var One_list = menuList.Where(e => e.ParentId == 0).ToList();
foreach (var item in One_list)
{
MenusTreeModel tree = new MenusTreeModel()
{
id = item.Id,
label = item.ModuleName,
children = new List <MenusTreeModel>()
};
var two_list = menuList.Where(e => e.ParentId == item.Id).ToList();
foreach (var _item in two_list)
{
MenusTreeModel _tree = new MenusTreeModel()
{
id = _item.Id,
label = _item.ModuleName,
};
tree.children.Add(_tree);
}
treeList.Add(tree);
//}
#endregion
rtnMsg.Data = treeList;
}
}
}
catch (Exception ex)
{
rtnMsg.Code = -1;
Common.LoggerHelper.Error(ex.ToString());
return(rtnMsg);
}
return(rtnMsg);
}
