/// <summary>
/// 根据搜索分页显示角色信息
/// </summary>
/// <param name="roleSearchParms"></param>
/// <returns></returns>
public IQueryable <RoleInfo> GetPageEntityBySearch(RoleSearchParms roleSearchParms)
{
short Normal = (short)DelFlagEnum.Normal; //删除标记为正常
var temp = DBSession.RoleInfoDal.GetEntities(r => r.DelFlag == Normal); //查询所有的角色信息
if (!string.IsNullOrEmpty(roleSearchParms.RoleName))
{
temp = temp.Where(r => r.RoleName.Contains(roleSearchParms.RoleName));//如果有角色名称 则筛选
}
if (!string.IsNullOrEmpty(roleSearchParms.Remark))
{
temp = temp.Where(r => r.Remark.Contains(roleSearchParms.Remark));//如果有备注 则筛选
}
roleSearchParms.total = temp.Count();//筛选完之后的总条数
return(temp = temp.OrderBy <RoleInfo, int>(r => r.ID)
.Skip(roleSearchParms.pageSize * (roleSearchParms.pageIndex - 1))
.Take(roleSearchParms.pageSize)); //分页后的数据
}
//获取角色信息
public ActionResult GetRoleInfo()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int total = 0;
string RoleName = Request["RoleName"];
string Remark = Request["Remark"];
RoleSearchParms roleSearchParms = new RoleSearchParms
{
pageIndex = pageIndex,
pageSize = pageSize,
total = total,
RoleName = RoleName,
Remark = Remark
};
//获取搜索后的数据
var roleInfoList = RoleInfoService.GetPageEntityBySearch(roleSearchParms);
var temp = from r in roleInfoList
select new { ID = r.ID, RoleName = r.RoleName,
SubTime = r.SubTime, ModfiedOn = r.ModfiedOn, Remark = r.Remark };
return(Json(new { rows = temp, total = roleSearchParms.total }, JsonRequestBehavior.AllowGet));
}
