/// <summary> /// 保存用户组权限 /// </summary> /// <param name="roleId"></param> /// <param name="menuIdList"></param> public async Task SaveMenusByRoles(int roleId, List <int> menuIdList) { List <string> sqls = new List <string>(); //加入父级id //string sql = string.Format("select * from Menus where id in({0})", string.Join(",", menuIdList)); //var result = FindListBySql<Menus>(sql); //string parentIds = string.Empty; //if(result != null && result.Count > 0) //{ // menuIdList.AddRange(result.Where(u => u.ParentId != null).Select(u => (int)u.ParentId).ToList()); //} //删除原来的关系 sqls.Add("delete from RoleMenu where rolesid=" + roleId); //添加新关系 menuIdList.Distinct().ToList().ForEach(menuId => { RoleMenu roleMenu = new RoleMenu() { MenusId = menuId, RolesId = roleId }; sqls.Add(EntityToSql.AddSql(roleMenu)); }); await TransQuery(sqls); }
public async Task <int> Insert(TEntity entity) { string sql = EntityToSql.AddSql(entity); var result = Convert.ToInt32(await dbHelper.GetSingle(sql)); return(result); }
public async Task <int> Insert <T>(T entity) where T : class, new() { string sql = EntityToSql.AddSql <T>(entity); var result = await dbHelper.ExecuteSql(sql); return(result); }
public async Task <int> Insert(List <TEntity> entitys) { var sqls = new List <string>(); foreach (var entity in entitys) { string sql = EntityToSql.AddSql(entity); sqls.Add(sql); } await dbHelper.ExecuteSqlTran(sqls); return(sqls.Count); }
/// <summary> /// 角色绑定用户 /// </summary> public async Task BindUser(int roleId, List <int> userIdList) { List <string> sqls = new List <string>(); userIdList.ForEach(userId => { UserRole userRole = new UserRole() { RolesId = roleId, UserInfoId = userId }; sqls.Add(EntityToSql.AddSql(userRole)); }); await TransQuery(sqls); }