public IActionResult Index(PageParameter pageParams) { PageDataResponse <CustomerUserDto> pageData = new PageDataResponse <CustomerUserDto>(); var parameterExpression = System.Linq.Expressions.Expression.Parameter(typeof(CustomerUser)); var filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(true); if (!string.IsNullOrEmpty(pageParams.Key)) { pageParams.Key = pageParams.Key.Trim(); filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(false); Guid guid = Guid.Empty; if (Guid.TryParse(pageParams.Key, out guid)) { filter = filter.GotoOrElse(parameterExpression.GotoEqual("ID", guid)); } } else { filter = filter.GotoOrElse(parameterExpression.GotoNotEqual("ID", Guid.Empty)); } if (pageParams.BeginTime != null && pageParams.EndTime != null && pageParams.BeginTime <= pageParams.EndTime) { filter = filter.GotoAndAlso(parameterExpression.GotoGreaterThanByDateTime("CreateTime", pageParams.BeginTime)); filter = filter.GotoAndAlso(parameterExpression.GotoLessThanByDateTime("CreateTime", pageParams.EndTime)); } var queryLambdaFilter = System.Linq.Expressions.Expression.Lambda <Func <CustomerUser, bool> >(filter, parameterExpression); int Count; List <CustomerUserDto> List = _CustomerUserAppService.PageList(queryLambdaFilter, pageParams.PageSize, pageParams.CurPage, out Count); pageData.Data = List; pageData.TotalItem = Count; pageData.QueryData = pageParams; pageData.PageHTML = base.PageHtml(Count, pageParams.CurPage, pageParams.PageSize, this.HttpContext); return(View(pageData)); }
public IActionResult Index(PageParameter pageParams) { PageDataResponse <UserMenuDto> pageData = new PageDataResponse <UserMenuDto>(); var parameterExpression = System.Linq.Expressions.Expression.Parameter(typeof(UserMenu)); var filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(true); if (!string.IsNullOrEmpty(pageParams.Key)) { pageParams.Key = pageParams.Key.Trim(); filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(false); Guid guid = Guid.Empty; if (Guid.TryParse(pageParams.Key, out guid)) { filter = filter.GotoOrElse(parameterExpression.GotoEqual("ID", guid)); } } else { filter = filter.GotoOrElse(parameterExpression.GotoNotEqual("ID", Guid.Empty)); } if (pageParams.BeginTime != null && pageParams.EndTime != null && pageParams.BeginTime <= pageParams.EndTime) { filter = filter.GotoAndAlso(parameterExpression.GotoGreaterThanByDateTime("CreateTime", pageParams.BeginTime)); filter = filter.GotoAndAlso(parameterExpression.GotoLessThanByDateTime("CreateTime", pageParams.EndTime)); } var queryLambdaFilter = System.Linq.Expressions.Expression.Lambda <Func <UserMenu, bool> >(filter, parameterExpression); int Count; List <UserMenuDto> List = _UserMenuAppService.PageList(queryLambdaFilter, pageParams.PageSize, pageParams.CurPage, out Count); if (List.Any()) { Guid[] langIds = List.Select(a => a.LanguageTypeID).Distinct().ToArray(); var langList = _languageTypeAppService.QueryList(a => langIds.Contains(a.ID)); Guid[] parentIds = List.Where(a => a.ParentId != Guid.Empty).Select(a => a.ID).ToArray(); var parentList = _UserMenuAppService.QueryList(a => parentIds.Contains(a.ID)); foreach (var item in List) { var temp = langList.FirstOrDefault(a => a.ID.Equals(item.LanguageTypeID)); if (temp != null) { item.LanguageTypeName = string.Format("{0}/{1}", temp.Code, temp.Title); } if (item.ParentId == Guid.Empty) { continue; } var parent = parentList.FirstOrDefault(a => a.ID == item.ParentId); if (parent != null) { item.ParentName = parent.Name; } } } pageData.Data = List; pageData.TotalItem = Count; pageData.QueryData = pageParams; pageData.PageHTML = base.PageHtml(Count, pageParams.CurPage, pageParams.PageSize, this.HttpContext); return(View(pageData)); }
public IActionResult Index(PageParameter pageParams) { PageDataResponse <ArticleDto> pageData = new PageDataResponse <ArticleDto>(); var parameterExpression = System.Linq.Expressions.Expression.Parameter(typeof(Article)); var filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(true); if (!string.IsNullOrEmpty(pageParams.Key)) { pageParams.Key = pageParams.Key.Trim(); filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(false); Guid guid = Guid.Empty; if (Guid.TryParse(pageParams.Key, out guid)) { filter = filter.GotoOrElse(parameterExpression.GotoEqual("ID", guid)); } } else { filter = filter.GotoOrElse(parameterExpression.GotoNotEqual("ID", Guid.Empty)); } if (pageParams.BeginTime != null && pageParams.EndTime != null && pageParams.BeginTime <= pageParams.EndTime) { filter = filter.GotoAndAlso(parameterExpression.GotoGreaterThanByDateTime("CreateTime", pageParams.BeginTime)); filter = filter.GotoAndAlso(parameterExpression.GotoLessThanByDateTime("CreateTime", pageParams.EndTime)); } var queryLambdaFilter = System.Linq.Expressions.Expression.Lambda <Func <Article, bool> >(filter, parameterExpression); int Count; List <ArticleDto> List = _ArticleAppService.PageList(queryLambdaFilter, pageParams.PageSize, pageParams.CurPage, out Count); if (List.Any()) { Guid[] langIds = List.Select(a => a.LanguageTypeID).Distinct().ToArray(); var langList = _languageTypeAppService.QueryList(a => langIds.Contains(a.ID)); Guid[] typeIds = List.Select(a => a.ArticleTypeID).Distinct().ToArray(); var typeList = _articleTypeAppService.QueryList(a => typeIds.Contains(a.ID)); foreach (var item in List) { var temp = langList.FirstOrDefault(a => a.ID.Equals(item.LanguageTypeID)); if (temp != null) { item.LanguageTypeName = string.Format("{0}/{1}", temp.Code, temp.Title); } var tempType = typeList.FirstOrDefault(a => a.ID == item.ArticleTypeID); if (temp != null) { item.ArticleTypeName = tempType.Title; } item.Images = Common.GetImgFullUrl(item.Images, Vic.Core.Utils.Enum.AM_Enum.ImgPathEnum.CmsImg, true); } } pageData.Data = List; pageData.TotalItem = Count; pageData.QueryData = pageParams; pageData.PageHTML = base.PageHtml(Count, pageParams.CurPage, pageParams.PageSize, this.HttpContext); return(View(pageData)); }
public IActionResult Index(PageParameter pageParams) { PageDataResponse <UserDto> pageData = new PageDataResponse <UserDto>(); var parameterExpression = System.Linq.Expressions.Expression.Parameter(typeof(User)); var filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(true); if (!string.IsNullOrEmpty(pageParams.Key)) { pageParams.Key = pageParams.Key.Trim(); filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(false); Guid guid = Guid.Empty; if (Guid.TryParse(pageParams.Key, out guid)) { filter = filter.GotoOrElse(parameterExpression.GotoEqual("ID", guid)); } } else { filter = filter.GotoOrElse(parameterExpression.GotoNotEqual("ID", Guid.Empty)); } if (pageParams.BeginTime != null && pageParams.EndTime != null && pageParams.BeginTime <= pageParams.EndTime) { filter = filter.GotoAndAlso(parameterExpression.GotoGreaterThanByDateTime("CreateTime", pageParams.BeginTime)); filter = filter.GotoAndAlso(parameterExpression.GotoLessThanByDateTime("CreateTime", pageParams.EndTime)); } filter = filter.GotoAndAlso(parameterExpression.GotoNotEqual("ID", ConstDefine.SuperAdminID)); var queryLambdaFilter = System.Linq.Expressions.Expression.Lambda <Func <User, bool> >(filter, parameterExpression); int Count; List <UserDto> List = _UserAppService.PageList(queryLambdaFilter, pageParams.PageSize, pageParams.CurPage, out Count); if (List.Any()) { var depIds = List.Select(a => a.DepartmentId).ToArray(); var depList = _departmentAppService.QueryList(c => depIds.Contains(c.ID)); foreach (var item in List) { var temp = depList.FirstOrDefault(a => a.ID == item.DepartmentId); if (temp != null) { item.DepartmentName = temp.Name; } } } pageData.Data = List; pageData.TotalItem = Count; pageData.QueryData = pageParams; pageData.PageHTML = base.PageHtml(Count, pageParams.CurPage, pageParams.PageSize, this.HttpContext); return(View(pageData)); }
public IActionResult Index(PageParameter pageParams) { PageDataResponse <LanguageTypeDto> pageData = new PageDataResponse <LanguageTypeDto>(); var parameterExpression = System.Linq.Expressions.Expression.Parameter(typeof(LanguageType)); var filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(true); if (!string.IsNullOrEmpty(pageParams.Key)) { pageParams.Key = pageParams.Key.Trim(); filter = (System.Linq.Expressions.Expression)System.Linq.Expressions.Expression.Constant(false); Guid guid = Guid.Empty; if (Guid.TryParse(pageParams.Key, out guid)) { filter = filter.GotoOrElse(parameterExpression.GotoEqual("ID", guid)); } } else { filter = filter.GotoOrElse(parameterExpression.GotoNotEqual("ID", Guid.Empty)); } if (pageParams.BeginTime != null && pageParams.EndTime != null && pageParams.BeginTime <= pageParams.EndTime) { filter = filter.GotoAndAlso(parameterExpression.GotoGreaterThanByDateTime("CreateTime", pageParams.BeginTime.Value)); filter = filter.GotoAndAlso(parameterExpression.GotoLessThanByDateTime("CreateTime", pageParams.EndTime.Value)); } var queryLambdaFilter = System.Linq.Expressions.Expression.Lambda <Func <LanguageType, bool> >(filter, parameterExpression); int Count; List <LanguageTypeDto> List = _LanguageTypeAppService.PageList(queryLambdaFilter, pageParams.PageSize, pageParams.CurPage, out Count); if (List.Any()) { foreach (var item in List) { item.Images = Common.GetImgFullUrl(item.Images, Vic.Core.Utils.Enum.AM_Enum.ImgPathEnum.SysImg, true); } } pageData.Data = List; pageData.TotalItem = Count; pageData.QueryData = pageParams; pageData.PageHTML = base.PageHtml(Count, pageParams.CurPage, pageParams.PageSize, this.HttpContext); return(View(pageData)); }