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));
}
