public ActionResult GetAllRoleInfos()
{
//jquery easyUI:table:{total:32,rows:[{},{}]}//需要json数据格式
//jquery easyUI:table:在初始化时自动发送以下两个参数值
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
//short delFlagNormal = (short)gs.RolePermission.Model.Enum.DelFlagEnum.Normal;
//拿到过滤条件用户名和备注的值
string schName = Request["schName"];
string schRemark = Request["schRemark"];
var queryParam = new RoleQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = total,
SchName = schName,
SchRemark = schRemark
};
var pageData = RoleInfoBll.LoadPageData(queryParam);
//获取部分列
var temp = pageData.Select(u => new { ID = u.Id, u.ModifyOn, u.RoleName, u.Remark, u.SubTime });
//拿到当前页的数据
//var pageData=UserInfoBll.GetPageEntities(pageSize, pageIndex,out total, u => u.DelFlag == delFlagNormal,u=>u.Id,true).Select(u=>new { ID=u.Id,u.ModifyOn,u.Pwd,u.Remark,u.ShowName,u.SubTime,u.UName});
var data = new { total = queryParam.Total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult List(RoleQueryParam queryParam)
{
Expression <Func <Tapp_Role, bool> > predicate = c => true;
if (!string.IsNullOrEmpty(queryParam.RoleName))
{
predicate = predicate.And(c => c.RoleName.Contains(queryParam.RoleName));
}
HKSJRecruitmentContext ctx = HttpContext.GetDbContext <HKSJRecruitmentContext>();
IPageList <Tapp_Role> models = ctx.Tapp_Role
.Where(predicate)
.OrderUsingSortExpression(queryParam.Sort, queryParam.Order)
.ToPagedList(queryParam.PageIndex, queryParam.PageSize);
List <Tapp_Role> dtos = models.ToList();
return(Content(this.GetJSON(new { total = models.PageInfo.TotalCount, rows = dtos }), this.JsonContentType()));
}
public IQueryable <RoleInfo> LoadPageData(RoleQueryParam roleQueryParam)
{
short normalFlag = (short)gs.RolePermission.Model.Enum.DelFlagEnum.Normal;
//拿到未删除的数据 xx
var temp = DbSession.RoleInfoDal.GetEntities(u => u.DelFlag == normalFlag);
//过滤
if (!string.IsNullOrEmpty(roleQueryParam.SchName))
{
temp = temp.Where(u => u.RoleName.Contains(roleQueryParam.SchName)).AsQueryable();
}
if (!string.IsNullOrEmpty(roleQueryParam.SchRemark))
{
temp = temp.Where(u => u.Remark.Contains(roleQueryParam.SchRemark)).AsQueryable();
}
roleQueryParam.Total = temp.Count();
//分页
return(temp.OrderBy(u => u.Id)
.Skip(roleQueryParam.PageSize * (roleQueryParam.PageIndex - 1))
.Take(roleQueryParam.PageSize).AsQueryable());
}
