public ActionResult GetRoleInfoList(int page, int rows, string RoleName, string Remark)
{
//int totalCount = 0;
short delFlag = (short)DeleteEnumType.Normal;
RoleInfoSearch roleInfoSearch = new RoleInfoSearch()
{
PageIndex = page,
PageSize = rows,
RoleName = RoleName,
Remark = Remark,
//TotalCount = totalCount
};
var RoleInfoList = RoleInfoService.LoadSerachEntities(roleInfoSearch, delFlag).Select(
u =>
new
{
u.ID,
u.RoleName,
u.Remark,
u.SubTime,
u.ModifiedOn,
u.Sort
});
//var RoleInfoList = RoleInfoService.LoadPageEntities(page, rows, out totalCount, u => u.DelFlag == delFlag, u => u.ID).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark });
string data = WebCommon.GetJsonList(roleInfoSearch.TotalCount, RoleInfoList);
return(Content(data));
}
public IQueryable <RoleInfo> LoadSerachEntities(RoleInfoSearch roleInfoSearch, short delFlag)
{
var temp = CurrentDal.LoadEntities(u => u.DelFlag == delFlag);
if (!string.IsNullOrEmpty(roleInfoSearch.RoleName))
{
temp = temp.Where(u => u.RoleName.Contains(roleInfoSearch.RoleName));
}
if (!string.IsNullOrEmpty(roleInfoSearch.Remark))
{
temp = temp.Where(u => u.Remark.Contains(roleInfoSearch.Remark));
}
roleInfoSearch.TotalCount = temp.Count();
return(temp.OrderBy(u => u.ID).Skip((roleInfoSearch.PageIndex - 1) * roleInfoSearch.PageSize).Take(roleInfoSearch.PageSize));
}
