//获取分页数据
public ActionResult GetPageList()
{
long searchId;
bool isId = long.TryParse(Request["searchId"], out searchId);
string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"];
DateTime from, to;
bool fromIsDate = DateTime.TryParse(Request["from"], out from);
bool toIsDate = DateTime.TryParse(Request["to"], out to);
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5;
int totalCount;
WhereHelper <UserInfo> wh = new WhereHelper <UserInfo>();
wh.Equal("IsDeleted", (byte)0);
if (isId)
{
wh.Equal("UserId", searchId);
}
if (searchName != string.Empty)
{
wh.Contains("Username", searchName);
}
if (fromIsDate)
{
wh.StrGreater("AddTime", from.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (toIsDate)
{
wh.StrLess("AddTime", to.ToString("yyyy-MM-dd") + " 23:59:59");
}
var userList = UserInfoBll.GetPageList <long>(wh.GetExpression(), u => u.UserId, false, pageIndex, pageSize, out totalCount).ToList();
//var userList = UserInfoBll.GetPageList<int>(u => (u.IsDeleted == 0) && (isId ? u.UserId == searchId : true) && (searchName != string.Empty ? u.Username.Contains(searchName) : true), u => u.UserId, false, pageIndex, pageSize, out totalCount);
var uList = UserInfoBll.GetList <int>(us => true);
var result = from u in userList
from uu in uList
where u.SubBy == uu.UserId
select new UserViewModel
{
UserId = u.UserId,
Username = u.Username,
Remark = u.Remark,
AddTime = u.AddTime,
ModifiedTime = u.ModifiedTime,
SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username
};
return(Json(new { total = totalCount, rows = result }));
}
