/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_Sys_Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Role set "); strSql.Append(" RoleName = @RoleName "); strSql.Append(" where RoleID=@RoleID "); SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@RoleStatus", SqlDbType.VarChar, 10), }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleID; parameters[2].Value = model.RoleStatus; int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string Delete(int roleid) { string msg = "删除失败。"; //判断是否有用户在使用该角色 if (HasUsers(roleid)) { msg = "该角色使用中,不能删除!"; return(new JsonMessage { Success = true, Data = "0", Message = msg }.ToString()); } var r = RoleDal.Instance.Get(roleid); //先删除角色中分配的权限 SqlEasy.ExecuteNonQuery("delete Sys_RoleNavBtns where roleid=@roleid", new SqlParameter("@roleid", roleid)); int k = RoleDal.Instance.Delete(roleid); if (k > 0) { msg = "删除成功。"; LogBll <Role> log = new LogBll <Role>(); log.DeleteLog(r); } return(new JsonMessage { Success = true, Data = k.ToString(), Message = msg }.ToString()); }
/// <summary> /// 角色授权 /// </summary> /// <param name="navJsonData">导航菜单、按钮数据</param> /// <returns></returns> public int RoleAuthorize(string navJsonData) { JObject jobj = JObject.Parse(navJsonData); var buttons = ButtonDal.Instance.GetAll().ToList(); var roleid = jobj["roleId"]; var menus = jobj["menus"]; var navs = menus.Select(menu => new{ navid = menu["navid"], btns = buttons.Where(n => menu["buttons"].Select(m => (string)m).Contains <string>(n.ButtonTag) ).Select(k => k) }); const string sql = "insert into Sys_RoleNavBtns(roleid,navid,btnid) values ('{0}','{1}','{2}')"; List <string> sb = new List <string>(); foreach (var nav in navs) { foreach (var btn in nav.btns) { sb.Add(string.Format(sql, roleid, nav.navid, btn.FID)); } } SqlEasy.ExecuteNonQuery("delete sys_roleNavBtns where roleid=:roleid", new OracleParameter("roleid", (string)roleid)); foreach (string s in sb) { SqlEasy.ExecuteNonQuery(s); } return(1); // return !string.IsNullOrEmpty(sb.ToString()) ? SqlEasy.ExecuteNonQuery( sb.ToString()) : 0; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Mod_Sys_Role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Role("); strSql.Append("RoleName"); strSql.Append(") values ("); strSql.Append("@RoleName"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@RoleStatus", SqlDbType.VarChar, 10) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.RoleStatus; object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 设置菜单按钮 /// </summary> /// <param name="navid">菜单ID</param> /// <param name="permissions">按钮</param> /// <returns></returns> public int SetNavButtons(string navid, string permissions) { const string sql = "insert into Sys_NavButtons (navid,buttonid,sortnum) values('{0}','{1}',{2})"; if (permissions != "" && navid != "") { var sb = new List <string>(); var arr = permissions.Split(','); int k = 0; foreach (var s in arr) { sb.Add(string.Format(sql, navid, s, k)); // sb.AppendLine(); k++; } if (sb.Count == 0) { throw new Exception("按钮数量为0或菜单ID未找到。"); } const string deleteSql = "delete Sys_NavButtons where navid=:Navid"; DbUtils.ExecuteNonQuery(deleteSql, new { Navid = navid }); foreach (string s in sb) { SqlEasy.ExecuteNonQuery(s); } return(1); } return(0); }
/// <summary> /// 用户授权 /// </summary> /// <param name="navJsonData">菜单、按钮JSON数据</param> /// <returns></returns> public int UserAuthorize(string navJsonData) { JObject jobj = JObject.Parse(navJsonData); var buttons = ButtonDal.Instance.GetAll().ToList(); var userId = jobj["userId"]; var menus = jobj["menus"]; var navs = menus.Select(menu => new { navid = menu["navid"], btns = buttons.Where(n => menu["buttons"].Select(m => (string)m).Contains <string>(n.ButtonTag) ).Select(k => k) }); const string sql = "insert into Sys_UserNavBtns(userid,navid,btnid) values ({0},{1},{2})"; var sb = new StringBuilder(); foreach (var nav in navs) { foreach (var btn in nav.btns) { sb.AppendFormat(sql, userId, nav.navid, btn.FID); sb.AppendLine(); } } SqlEasy.ExecuteNonQuery("delete Sys_UserNavBtns where userid=:userid", new OracleParameter("userid", (int)userId)); return(!string.IsNullOrEmpty(sb.ToString()) ? SqlEasy.ExecuteNonQuery(sb.ToString()) : 0); }
/// <summary> /// 设置菜单按钮 /// </summary> /// <param name="navid">菜单ID</param> /// <param name="permissions">按钮</param> /// <returns></returns> public int SetNavButtons(int navid, string permissions) { const string sql = "insert into Sys_NavButtons (navid,buttonid,sortnum) values({0},{1},{2})"; if (permissions != "" && navid > 0) { var sb = new StringBuilder(); var arr = permissions.Split(','); int k = 0; foreach (var s in arr) { sb.AppendFormat(sql, navid, s, k); sb.AppendLine(); k++; } if (string.IsNullOrEmpty(sb.ToString())) { throw new Exception("按钮数量为0或菜单ID未找到。"); } const string deleteSql = "delete Sys_NavButtons where navid=@Navid"; DbUtils.ExecuteNonQuery(deleteSql, new { Navid = navid }); return(SqlEasy.ExecuteNonQuery(sb.ToString())); } return(0); }
/// <summary> /// 批量删除一批数据 /// </summary> public bool DeleteList(string MenuIdlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Sys_Menu "); strSql.Append(" where ID in (" + MenuIdlist + ") "); int rows = SqlEasy.ExecuteNonQuery(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 为指定的用户分配角色 /// </summary> /// <param name="userId">用户ID</param> /// <param name="roleIds">角色ID</param> /// <returns></returns> public int AddUserTo(int userId, params int[] roleIds) { string sql = "insert into Sys_UserRoles (userid,roleid) values({0},{1})"; StringBuilder sb = new StringBuilder(); foreach (var rid in roleIds) { sb.AppendFormat(sql, userId, rid); sb.AppendLine(); } if (!string.IsNullOrEmpty(sb.ToString())) { return(SqlEasy.ExecuteNonQuery(sb.ToString())); } return(0); }
/// <summary> /// 为指定的用户分配角色 /// </summary> /// <param name="userId">用户ID</param> /// <param name="roleIds">角色ID</param> /// <returns></returns> public int AddUserTo(string userId, params string[] roleIds) { string sql = "insert into Sys_UserRoles (FID,userid,roleid) values('{0}','{1}','{2}')"; StringBuilder sb = new StringBuilder(); foreach (var rid in roleIds) { sb.AppendFormat(sql, Guid.NewGuid().ToString(), userId, rid); sb.AppendLine(); } if (!string.IsNullOrEmpty(sb.ToString())) { return(SqlEasy.ExecuteNonQuery(sb.ToString())); } return(0); }
public string Delete(string roleid) { string msg = "删除失败。"; var r = RoleDal.Instance.Get(roleid); //先删除角色中分配的权限 SqlEasy.ExecuteNonQuery("delete Sys_RoleNavBtns where roleid=:roleid", new OracleParameter("roleid", roleid)); int k = RoleDal.Instance.Delete(roleid); if (k > 0) { msg = "删除成功。"; LogBll <Role> log = new LogBll <Role>(); log.DeleteLog(r); } return(new JsonMessage { Success = true, Data = k.ToString(), Message = msg }.ToString()); }
public int SetDepartments(int roleid, string deps) { if (string.IsNullOrEmpty(deps)) { return(0); } string[] arrDep = deps.Split(','); string sql = "insert into Sys_Roles_Departments (roleid,depid) values({0},{1}) "; StringBuilder sb = new StringBuilder(); foreach (string depid in arrDep) { sb.AppendFormat(sql, roleid, depid); sb.AppendLine(); } return(sb.Length > 0 ? SqlEasy.ExecuteNonQuery(sb.ToString()) : 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_Sys_Menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Menu set "); strSql.Append(" Pid = @Pid , "); strSql.Append(" MenuName = @MenuName , "); strSql.Append(" Menu_Url = @Menu_Url , "); strSql.Append(" Icon = @Icon , "); strSql.Append(" Sort = @Sort "); strSql.Append(" where MenuId=@MenuId "); SqlParameter[] parameters = { new SqlParameter("@MenuId", SqlDbType.Int, 4), new SqlParameter("@Pid", SqlDbType.Int, 4), new SqlParameter("@MenuName", SqlDbType.NVarChar, 100), new SqlParameter("@Menu_Url", SqlDbType.NVarChar, 500), new SqlParameter("@Icon", SqlDbType.VarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4) }; parameters[0].Value = model.MenuId; parameters[1].Value = model.Pid; parameters[2].Value = model.MenuName; parameters[3].Value = model.Menu_Url; parameters[4].Value = model.Icon; parameters[5].Value = model.Sort; int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Sys_Role "); strSql.Append(" where RoleID=@RoleID"); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Mod_Sys_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" Update Sys_User SET "); strSql.Append(" UserName=@UserName, "); strSql.Append(" PassWord=@PassWord, "); strSql.Append(" RoleId=@RoleId, "); strSql.Append(" PassSalt=@PassSalt, "); strSql.Append(" IsDisabled=@IsDisabled "); strSql.Append(" where 1=1 and UserId=" + model.UserId); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@PassWord", SqlDbType.NVarChar, 100), new SqlParameter("@RoleId", SqlDbType.Int, 8), new SqlParameter("@PassSalt", SqlDbType.VarChar, 50), new SqlParameter("@IsDisabled", SqlDbType.Bit, 2) }; parameters[0].Value = model.UserName; parameters[1].Value = model.PassWord; parameters[2].Value = model.RoleId; parameters[3].Value = model.PassSalt; parameters[4].Value = model.IsDisabled; object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int MenuId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Sys_Menu "); strSql.Append(" where MenuId=@MenuId"); SqlParameter[] parameters = { new SqlParameter("@MenuId", SqlDbType.Int, 4) }; parameters[0].Value = MenuId; int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Mod_Sys_Menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_Menu("); strSql.Append("Pid,MenuName,Menu_Url,Icon,Sort"); strSql.Append(") values ("); strSql.Append("@Pid,@MenuName, @Menu_Url, @Icon, @Sort"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Pid", SqlDbType.Int, 4), new SqlParameter("@MenuName", SqlDbType.NVarChar, 100), new SqlParameter("@Menu_Url", SqlDbType.NVarChar, 500), new SqlParameter("@Icon", SqlDbType.VarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4) }; parameters[0].Value = model.Pid; parameters[1].Value = model.MenuName; parameters[2].Value = model.Menu_Url; parameters[3].Value = model.Icon; parameters[4].Value = model.Sort; object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Mod_Sys_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_User("); strSql.Append("UserName,PassWord,RoleId,PassSalt,IsDisabled"); strSql.Append(") values ("); strSql.Append("@UserName,@PassWord, @RoleId, @PassSalt, @IsDisabled"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 100), new SqlParameter("@PassWord", SqlDbType.NVarChar, 100), new SqlParameter("@RoleId", SqlDbType.Int, 8), new SqlParameter("@PassSalt", SqlDbType.VarChar, 50), new SqlParameter("@IsDisabled", SqlDbType.Bit, 2) }; parameters[0].Value = model.UserName; parameters[1].Value = model.PassWord; parameters[2].Value = model.RoleId; parameters[3].Value = model.PassSalt; parameters[4].Value = model.IsDisabled; object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }