public JsonResult PlayerList() { PaginResult <UserInfo> user = new PaginResult <UserInfo>(); DbSet <UserInfo> uSet = mySQLDbContext.UserInfos; Expression <Func <UserInfo, bool> > expression = (u) => 1 == 1; string uid = HttpContext.Request.Form["uid"]; string uaccount = HttpContext.Request.Form["uaccount"].ToString(); string cdate = HttpContext.Request.Form["cdate"].ToString(); int pageIndex = int.Parse(HttpContext.Request.Form["page"].ToString()); int pageSize = int.Parse(HttpContext.Request.Form["limit"].ToString()); IQueryable <UserInfo> queryable = uSet; if (!string.IsNullOrEmpty(uid)) { queryable = queryable.Where(s => s.Id == int.Parse(uid)); } if (!string.IsNullOrEmpty(uaccount.Trim())) { queryable = queryable.Where((s) => s.Account.Contains(uaccount)); } if (!string.IsNullOrEmpty(cdate)) { DateTime sdate = DateTime.Parse(cdate.Split("~".ToCharArray())[0].Trim()); DateTime edate = DateTime.Parse(cdate.Split("~".ToCharArray())[1].Trim()); queryable = queryable.Where((u) => u.CreateDate >= sdate && u.CreateDate <= edate); } user.Code = 0; user.Msg = "success"; user.Count = queryable.Count(); user.Data = queryable.OrderByDescending(s => s.CreateDate).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); return(Json(user)); }
public JsonResult WordList() { int pageIndex = int.Parse(HttpContext.Request.Form["page"].ToString()); int pageSize = int.Parse(HttpContext.Request.Form["limit"].ToString()); string keyWord = HttpContext.Request.Form["word"].ToString(); IQueryable <KeyWord> query = mySQLDbContext.KeyWords; if (!string.IsNullOrEmpty(keyWord)) { query = query.Where(s => s.Word.Contains(keyWord)); } PaginResult <KeyWord> result = new PaginResult <KeyWord>(); result.Code = 0; result.Count = query.Count(); result.Msg = "success"; result.Data = query.OrderByDescending(s => s.CreateDate).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); return(Json(result)); }