public ActionResult List(string userKey,int? pageIndex, int? pageSize) { var repository = Repository.Current; var categoryFolder = new TextFolder(repository, "Category"); var articleFolder = new TextFolder(repository, "Article"); var articleQuery = articleFolder.CreateQuery(); //var userKey = Page_Context.Current.PageRequestContext.AllQueryString["UserKey"]; if (!string.IsNullOrEmpty(userKey)) { articleQuery = articleQuery.WhereCategory(categoryFolder.CreateQuery().WhereEquals("UserKey", userKey)); } if (!pageIndex.HasValue) { pageIndex = 1; } if (!pageSize.HasValue) { pageSize = 2; } var pageData = articleQuery.Skip((pageIndex.Value - 1) * pageSize.Value).Take(pageSize.Value); DataRulePagedList pagedList = new DataRulePagedList(pageData, pageIndex.Value, pageSize.Value, articleQuery.Count()); return View(pagedList); }
public ActionResult List(string userKey, int?pageIndex, int?pageSize) { var repository = Repository.Current; var categoryFolder = new TextFolder(repository, "Category"); var articleFolder = new TextFolder(repository, "Article"); var articleQuery = articleFolder.CreateQuery(); //var userKey = Page_Context.Current.PageRequestContext.AllQueryString["UserKey"]; if (!string.IsNullOrEmpty(userKey) && userKey != "--") { articleQuery = articleQuery.WhereCategory(categoryFolder.CreateQuery().WhereEquals("UserKey", userKey)); } if (!pageIndex.HasValue) { pageIndex = 1; } if (!pageSize.HasValue) { pageSize = 10; } var pageData = articleQuery.Skip((pageIndex.Value - 1) * pageSize.Value).Take(pageSize.Value); DataRulePagedList pagedList = new DataRulePagedList(pageData, pageIndex.Value, pageSize.Value, articleQuery.Count()); return(View(pagedList)); }
public static void Execute(ViewDataDictionary viewData, DataRuleContext dataRuleContext, IEnumerable<DataRuleSetting> dataRules) { foreach (var item in dataRules) { var contentQuery = item.DataRule.Execute(dataRuleContext); object data = contentQuery; if (item.DataRule is DataRuleBase) { var dataRuleBase = (DataRuleBase)item.DataRule; if (!string.IsNullOrEmpty(dataRuleBase.SortField)) { if (dataRuleBase.SortDirection == DataRule.SortDirection.Ascending) { contentQuery = contentQuery.OrderBy(dataRuleBase.SortField); } else { contentQuery = contentQuery.OrderByDescending(dataRuleBase.SortField); } } if (item.DataRule.EnablePaging.Value) { string pageIndexParameterName; var pageIndexValue = ParameterizedFieldValue.GetFieldValue(dataRuleBase.PageIndex, dataRuleContext.ValueProvider, out pageIndexParameterName); var intPageIndexValue = 1; int.TryParse(pageIndexValue, out intPageIndexValue); if (intPageIndexValue < 1) { intPageIndexValue = 1; } string pageSizeParameterName; var pageSizeValue = ParameterizedFieldValue.GetFieldValue(dataRuleBase.PageSize, dataRuleContext.ValueProvider, out pageSizeParameterName); var intPageSize = 10; int.TryParse(pageSizeValue, out intPageSize); if (intPageSize < 1) { intPageSize = 10; } var totalCount = contentQuery.Count(); data = new DataRulePagedList(contentQuery.Skip((intPageIndexValue - 1) * intPageSize).Take(intPageSize) , intPageIndexValue , intPageSize , totalCount) { PageIndexParameterName = pageIndexParameterName }; } else if (!string.IsNullOrEmpty(dataRuleBase.Top)) { string fieldName; var topValue = ParameterizedFieldValue.GetFieldValue(dataRuleBase.Top, dataRuleContext.ValueProvider, out fieldName); var intTopValue = 1; int.TryParse(topValue, out intTopValue); data = contentQuery.Take(intTopValue); } else { data = contentQuery; } } if (data is IContentQuery<ContentBase>) { data = GetData(item, (IContentQuery<TextContent>)data); } if (item.DataName.EqualsOrNullEmpty(ModelName, StringComparison.CurrentCultureIgnoreCase)) { viewData.Model = data; } viewData[item.DataName] = data; } }
public object Execute(DataRuleContext dataRuleContext, TakeOperation operation, int cacheDuration) { var contentQuery = this.GetContentQuery(dataRuleContext); object data = contentQuery; if (!string.IsNullOrEmpty(this.SortField)) { if (this.SortDirection == DataRule.SortDirection.Ascending) { contentQuery = contentQuery.OrderBy(this.SortField); } else { contentQuery = contentQuery.OrderByDescending(this.SortField); } } if (this.EnablePaging.Value) { string pageIndexParameterName; var pageIndexValue = ParameterizedFieldValue.GetFieldValue(this.PageIndex, dataRuleContext.ValueProvider, out pageIndexParameterName); var intPageIndexValue = 1; int.TryParse(pageIndexValue, out intPageIndexValue); if (intPageIndexValue < 1) { intPageIndexValue = 1; } var intPageSize = 10; if (string.IsNullOrEmpty(this.Top)) { string pageSizeParameterName; var pageSizeValue = ParameterizedFieldValue.GetFieldValue(this.PageSize, dataRuleContext.ValueProvider, out pageSizeParameterName); int.TryParse(pageSizeValue, out intPageSize); if (intPageSize < 1) { intPageSize = 10; } } else { string fieldName; var topValue = ParameterizedFieldValue.GetFieldValue(this.Top, dataRuleContext.ValueProvider, out fieldName); int.TryParse(topValue, out intPageSize); } var totalCount = contentQuery.Count(); data = new DataRulePagedList(contentQuery.Skip((intPageIndexValue - 1)*intPageSize).Take(intPageSize) , intPageIndexValue , intPageSize , totalCount) { PageIndexParameterName = pageIndexParameterName }; } else if (!string.IsNullOrEmpty(this.Top)) { string fieldName; var topValue = ParameterizedFieldValue.GetFieldValue(this.Top, dataRuleContext.ValueProvider, out fieldName); var intTopValue = 1; int.TryParse(topValue, out intTopValue); data = contentQuery.Take(intTopValue); } else { data = contentQuery; } if (data is IContentQuery<ContentBase>) { data = GetData((IContentQuery<TextContent>) data, operation, cacheDuration); } return data; }