public List<FullUser> Query(FullUserQueryForm form)
{
if (form.PageSize.HasValue && form.PageSize.Value > 0)
{
form.RecordCount = mapper.QueryForObject<int>("QueryFullUserRecordCount", form);
}
return mapper.QueryForList<FullUser>("QueryFullUser", form).ToList();
}
public PagingEntity<FullUser> QueryUser(FullUserQueryForm form)
{
var list = bll.Query(form);
PagingEntity<FullUser> users = new PagingEntity<FullUser>
{
Record = list,
PageCount = form.PageCount,
RecordCount = form.RecordCount,
};
return users;
}
public UserInitResultForm Init(FullUserQueryForm form)
{
var list = bll.Query(form);
PagingEntity<FullUser> users = new PagingEntity<FullUser>
{
Record = list,
PageCount = form.PageCount,
RecordCount = form.RecordCount,
};
RoleBLL rolebll = new RoleBLL();
var role = rolebll.Query(new RoleQueryForm { });
UserInitResultForm resultform = new UserInitResultForm
{
User = users,
Role = role,
};
return resultform;
}
/// <summary>
/// 查询所有用户
/// </summary>
/// <returns></returns>
public List<FullUser> Query(FullUserQueryForm form)
{
ISqlMapper mapper = Common.GetMapperFromSession();
FullUserDao dao = new FullUserDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
RoleDao roledao = new RoleDao(mapper);
var userlist = dao.Query(form);
var userids = (from u in userlist select u.ID).ToList();
var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids });
var roleids = (from ur in urs select ur.RoleID).Distinct().ToList();
var roles = roledao.Query(new RoleQueryForm { IDs = roleids });
foreach (var u in userlist)
{
var ur_temp = urs.FindAll(t => t.UserID == u.ID);
var rolelist = (from ur in ur_temp join r in roles on ur.RoleID equals r.ID select r).ToList();
u.RoleList = rolelist;
}
return userlist;
}