/// <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);
}
