public override List <CODep> GetDepByUser(int userId)
{
CODbContext _db = this._dbContext as CODbContext;
var q = from dep in _db.CODepCol
join relate in _db.CODepUserRelateCol
on dep.Id equals relate.DepId
join user in _db.COUserCol
on relate.UserId equals user.Id
where user.Id.Equals(userId)
select dep;
return(q.ToList());
}
public override List <CORole> GetUserStaticRoles(int userId)
{
CODbContext _db = this._dbContext as CODbContext;
var q = from role in _db.CORoleCol
join relate in _db.CORoleUserRelateCol
on role.Id equals relate.RoleId
join user in _db.COUserCol
on relate.UserId equals user.Id
where user.Id.Equals(userId)
select role;
return(q.ToList());
}
public override List <COUser> GetUserInDep(int depId)
{
CODbContext _db = this._dbContext as CODbContext;
var q = from dep in _db.CODepCol
join relate in _db.CODepUserRelateCol
on dep.Id equals relate.DepId
join user in _db.COUserCol
on relate.UserId equals user.Id
orderby relate.ShowOrder ascending
where dep.Id.Equals(depId)
select user;
return(q.ToList());
}
