public virtual List <T> GetPageList(string queryJson, PageModel pageModel, string orderby = null) { List <IConditionalModel> conditionalModels = new List <IConditionalModel>(); if (!string.IsNullOrEmpty(queryJson)) { var condtions = JToken.Parse(queryJson).Children <JProperty>(); if (condtions.Any()) { List <string> propertyNames = typeof(T).GetProperties().Select(t => t.Name).ToList(); foreach (JProperty item in condtions) { if (propertyNames.Contains(item.Name)) { conditionalModels.Add(new ConditionalModel() { ConditionalType = ConditionalType.Like, FieldName = item.Name, FieldValue = item.Value.ToString() }); } } } } int total = 0; bool isorderby = !string.IsNullOrEmpty(orderby); var result = CurrentDb.AsQueryable().Where(conditionalModels).OrderByIF(isorderby, orderby).ToPageList(pageModel.PageIndex, pageModel.PageSize, ref total); pageModel.PageCount = total; return(result); }
/// <summary> /// 分页 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public async Task <Tuple <List <TEntity>, int, int> > PageList(int pageIndex, int pageSize) { return(await Task.Run(() => { int totalNumber = 0; int totalPage = 0; var data = CurrentDb.AsQueryable().ToPageList(pageIndex, pageSize, ref totalNumber, ref totalPage); return new Tuple <List <TEntity>, int, int>(data, totalNumber, totalPage); })); }
public async Task <User> CheckLogin(string userName, string passWord) { return(await CurrentDb.AsQueryable().SingleAsync(i => i.UserName == userName && i.PassWord == passWord)); }