/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static Common.Model.PList <VModel.SyUserStudent.Grid> GetGrid(VModel.SyUserStudent.Index m)
{
Common.Model.PList <VModel.SyUserStudent.Grid> pl = new Common.Model.PList <VModel.SyUserStudent.Grid>();
pl.Data = new List <VModel.SyUserStudent.Grid>();
using (var db = new fz_basicEntities())
{
IQueryable <sy_user> dbList = db.sy_user.Where(w => w.Type == 26).OrderBy(o => o.Account);
switch (m.Type)
{
case 1:
dbList = dbList.Where(w => w.IsExpires == false && w.IsEnabled == true && w.sy_student.Any(a => a.IsGraduate == false));
break;
case 2:
dbList = dbList.Where(w => w.IsExpires == true || w.IsEnabled == false || w.sy_student.Any(a => a.IsGraduate == true));
break;
}
if (m.IndexGrade != null)
{
List <string> UserIds = SyStudentBll.GetList().Where(w => w.Grade == m.IndexGrade && w.UserId != null).Select(s => s.UserId).ToList();
dbList = dbList.Where(w => UserIds.Contains(w.Id));
if (m.IndexClass != null)
{
UserIds = SyStudentBll.GetList().Where(w => w.Class == m.IndexClass && w.UserId != null).Select(s => s.UserId).ToList();
dbList = dbList.Where(w => UserIds.Contains(w.Id));
}
}
if (!string.IsNullOrWhiteSpace(m.Key))
{
dbList = dbList.Where(w => w.Account.Contains(m.Key) || w.Name.Contains(m.Key));
}
pl.Pager = new Common.Model.Pager(m.Grid.Pager.PageIndex, m.Grid.Pager.PageSize, dbList.Count());
pl.Data = dbList.Skip((m.Grid.Pager.PageIndex - 1) * m.Grid.Pager.PageSize).Take(m.Grid.Pager.PageSize).Select(s => new VModel.SyUserStudent.Grid
{
Id = s.Id,
Account = s.Account,
Name = s.Name,
Sex = s.sy_student.Select(s2 => s2.Sex).FirstOrDefault(),
Grade = s.sy_student.Select(s2 => s2.Grade).FirstOrDefault(),
Class = s.sy_student.Select(s2 => s2.Class).FirstOrDefault(),
IsSystem = s.IsSystem,
ExpiresTime = s.ExpiresTime,
IsExpires = s.IsExpires,
IsEnabled = s.IsEnabled,
RoleNames = s.sy_user_and_role.Where(w1 => w1.sy_role.IsEnabled == true).Select(s1 => s1.sy_role.Name).ToList()
}).ToList();
}
return(pl);
}
/// <summary>
/// 根据角色ID获取用户
/// </summary>
/// <returns></returns>
public static Common.Model.PList <VModel.SyRole.UserGrid> GetUsers(VModel.SyRole.RUser m)
{
Common.Model.PList <VModel.SyRole.UserGrid> pl = new Common.Model.PList <VModel.SyRole.UserGrid>();
pl.Data = new List <VModel.SyRole.UserGrid>();
using (var db = new fz_basicEntities())
{
var query = db.sy_user.OrderBy(o => o.Account).Where(w => w.sy_user_and_role.Where(w1 => w1.RoleId == m.id).Select(s2 => s2.UserId).Contains(w.Id) && w.IsEnabled).AsQueryable();
pl.Pager = new Common.Model.Pager(m.Grid.Pager.PageIndex, m.Grid.Pager.PageSize, query.Count());
pl.Data = query.Skip((m.Grid.Pager.PageIndex - 1) * m.Grid.Pager.PageSize).Take(m.Grid.Pager.PageSize).Select(s => new VModel.SyRole.UserGrid
{
Account = s.Account,
Name = s.Name,
RoleNames = s.sy_user_and_role.Select(s1 => s1.sy_role.Name).ToList(),
Time = s.sy_user_and_role.Select(s1 => s1.Time).FirstOrDefault()
}).ToList();
}
return(pl);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static Common.Model.PList <VModel.SyUserManager.Grid> GetGrid(VModel.SyUserManager.Index m)
{
Common.Model.PList <VModel.SyUserManager.Grid> pl = new Common.Model.PList <VModel.SyUserManager.Grid>();
pl.Data = new List <VModel.SyUserManager.Grid>();
using (var db = new fz_basicEntities())
{
IQueryable <sy_user> dbList = db.sy_user.Where(w => w.Type == 4 && w.Id != "92E0AF7A-4C21-456C-82E8-B27E51CC3EDB").OrderBy(o => o.Account);
switch (m.Type)
{
case 1:
dbList = dbList.Where(w => w.IsExpires == false && w.IsEnabled == true);
break;
case 2:
dbList = dbList.Where(w => w.IsExpires == true || w.IsEnabled == false);
break;
}
if (!string.IsNullOrWhiteSpace(m.Key))
{
dbList = dbList.Where(w => w.Account.Contains(m.Key) || w.Name.Contains(m.Key));
}
pl.Pager = new Common.Model.Pager(m.Grid.Pager.PageIndex, m.Grid.Pager.PageSize, dbList.Count());
pl.Data = dbList.Skip((m.Grid.Pager.PageIndex - 1) * m.Grid.Pager.PageSize).Take(m.Grid.Pager.PageSize).Select(s => new VModel.SyUserManager.Grid
{
Id = s.Id,
Account = s.Account,
Name = s.Name,
IsSystem = s.IsSystem,
ExpiresTime = s.ExpiresTime,
IsExpires = s.IsExpires,
IsEnabled = s.IsEnabled,
RoleNames = s.sy_user_and_role.Where(w1 => w1.sy_role.IsEnabled == true).Select(s1 => s1.sy_role.Name).ToList()
}).ToList();
}
return(pl);
}
