public IQueryable <FavoriteEntity> Get(int userid, PagerRequest pagerRequest, out int totalCount, FavoriteSortOrder sortOrder,
SourceType sourceType)
{
return(base.Get(GetFiller(userid, sourceType, DataStatus.Normal), out totalCount, pagerRequest.PageIndex,
pagerRequest.PageSize,
GetSort(sortOrder)));
}
public List <CommentEntity> GetPagedList(PagerRequest pagerRequest, out int totalCount, CommentSortOrder sortOrder, int?sourceId,
SourceType sourceType, int?userId)
{
return
(base.Get(Filter(DataStatus.Normal, null, sourceId, sourceType, userId), out totalCount, pagerRequest.PageIndex,
pagerRequest.PageSize, GetOrder(sortOrder)).ToList());
}
public ActionResult List(PagerRequest request,HotwordSearchOption search)
{
int totalCount;
var data = _hotwordRepo.Get(e => (!search.Type.HasValue || e.Type == search.Type.Value)
&& (string.IsNullOrEmpty(search.Word) || e.Word.Contains(search.Word))
&& e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Word);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var models = from d in data.ToList()
select new HotwordViewModel().FromEntity<HotwordViewModel>(d);
return View("List", new Pager<HotwordViewModel>(request, totalCount) { Data=models});
}
private FavoriteCollectionResponse Get(float version, int userId, PagerRequest pagerRequest, CoordinateInfo coordinate, FavoriteSortOrder sortOrder, SourceType sourceType)
{
FavoriteCollectionResponse response;
int totalCount;
if (version >= 2.1)
{
var entitys = _favoriteRepository.Get(userId, pagerRequest, out totalCount, sortOrder, sourceType);
var list = MappingManager.FavoriteCollectionResponseMapping(entitys, coordinate);
response = new FavoriteCollectionResponse(pagerRequest, totalCount)
{
Favorites = list
};
}
else
{
var entitys = _favoriteRepository.GetPagedList(userId, pagerRequest, out totalCount, sortOrder, sourceType);
response = MappingManager.FavoriteCollectionResponseMapping(entitys, coordinate);
response.Index = pagerRequest.PageIndex;
response.Size = pagerRequest.PageSize;
response.TotalCount = totalCount;
}
return(response);
}
public PagerInfo <DepartmentDto> GetPagedList(PagerRequest pagerRequest, DepartmentQueryRequest request)
{
var departmentFilter = Filter(request);
using (var db = GetYintaiHZhouContext())
{
var departments = db.Departments;
var stores = db.Stores;
var q = from department in departments.AsExpandable().Where(departmentFilter)
join store in stores on department.StoreId equals store.Id
select new DepartmentDto
{
Id = department.Id,
Name = department.Name,
StoreId = store.Id,
StoreName = store.Name,
SortOrder = department.SortOrder
};
var total = q.Count();
var lst = q.OrderByDescending(v => v.SortOrder).Skip(pagerRequest.SkipCount).Take(pagerRequest.PageSize).ToList();
return(new PagerInfo <DepartmentDto>(pagerRequest, total, lst));
}
}
public ActionResult List(PagerRequest request, int?sort, SourceType?sourceType, int?sourceId)
{
int totalCount;
var sortOrder = sort == null?ResourceSortOrder.CreateDate:(ResourceSortOrder)sort.Value;
List <ResourceEntity> data;
if (sourceType == null)
{
data = _resourceRepository.GetPagedList(request, out totalCount, sortOrder);
}
else
{
data = _resourceRepository.GetPagedList(request, out totalCount, sortOrder, sourceType, sourceId);
}
var vo = MappingManager.ResourceViewMapping(data);
var v = new ResourceCollectionViewModel(request, totalCount)
{
Resources = vo.ToList()
};
var dto = new ListDto
{
ResourceCollectionViewModel = v,
Sort = sort,
SourceId = sourceId,
SourceType = sourceType
};
return(View("List", dto));
}
public ActionResult List(PagerRequest pagerRequest, TagFilterOptions filter, TagSortOptions?sort)
{
filter.UserId = CurrentUser.CustomerId;
var paged = GetList(pagerRequest, filter, sort ?? TagSortOptions.Default);
return(View(paged));
}
public ActionResult ProductListP(ProductSearchViewModel search, PagerRequest request)
{
int totalCount;
var linq = Context.Set<ProductEntity>().Where(p => p.SkuCode == search.SkuCode && p.Status != (int)DataStatus.Deleted)
.Join(Context.Set<InventoryEntity>(), o => o.Id, i => i.ProductId, (o, i) => new { P = o, I = i })
.Join(Context.Set<ProductPropertyValueEntity>(), o => o.I.PColorId, i => i.Id, (o, i) => new { P = o.P, I = o.I, Color = i })
.Join(Context.Set<ProductPropertyValueEntity>(), o => o.I.PSizeId, i => i.Id, (o, i) => new { P = o.P, I = o.I, Color = o.Color, Size = i });
totalCount = linq.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
linq = skipCount == 0 ? linq.OrderBy(l => l.P.Id).Take(request.PageSize) : linq.OrderBy(l => l.P.Id).Skip(skipCount).Take(request.PageSize);
var vo = new List<dynamic>();
foreach (var l in linq)
{
vo.Add(new {
Id = l.P.Id,
Name = l.P.Name,
ColorValueName = l.Color.ValueDesc,
SizeValueName = l.Size.ValueDesc,
Amount = l.I.Amount,
GenerateId = search.PackageType==(int)WxPackageType.Product?l.P.Id:l.I.Id,
PackageType = search.PackageType
});
}
var v = new Pager<dynamic>(request, totalCount) { Data = vo.ToList() };
return Json(v);
}
public ActionResult List(PagerRequest request, int? sort, SourceType? sourceType, int? sourceId)
{
int totalCount;
var sortOrder = sort ==null?ResourceSortOrder.CreateDate:(ResourceSortOrder)sort.Value;
List<ResourceEntity> data;
if (sourceType == null)
{
data = _resourceRepository.GetPagedList(request, out totalCount, sortOrder);
}
else
{
data = _resourceRepository.GetPagedList(request, out totalCount, sortOrder, sourceType, sourceId);
}
var vo = MappingManager.ResourceViewMapping(data);
var v = new ResourceCollectionViewModel(request, totalCount) { Resources = vo.ToList() };
var dto = new ListDto
{
ResourceCollectionViewModel = v,
Sort = sort,
SourceId = sourceId,
SourceType = sourceType
};
return View("List", dto);
}
public JsonResult ListP(CategorySearchOption search, PagerRequest request)
{
int totalCount;
var linq = Context.Set<CategoryEntity>().Where(p => (string.IsNullOrEmpty(search.Name) || p.Name.Contains(search.Name)) &&
(!search.PId.HasValue || p.ExCatId == search.PId.Value) &&
p.Status != (int)DataStatus.Deleted);
var linq2 = linq.GroupJoin(Context.Set<CategoryMapEntity>().Where(u => u.Status != (int)DataStatus.Deleted),
o => o.ExCatId,
i => i.CatId,
(o, i) => new { O = o, C = i })
;
totalCount = linq2.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
var linq3 = skipCount == 0 ? linq2.Take(request.PageSize) : linq2.Skip(skipCount).Take(request.PageSize);
var vo = from l in linq3.ToList()
select new CategoryViewModel().FromEntity<CategoryViewModel>(l.O, p =>
{
p.ShowCategories = l.C.Select(c => new ShowCategoryViewModel() {
ShowChannel = c.ShowChannel
}).ToList() ;
});
var v = new Pager<CategoryViewModel>(request, totalCount) { Data = vo.ToList() };
return Json(v);
}
private FavoriteCollectionResponse Get(float version, int userId, PagerRequest pagerRequest, CoordinateInfo coordinate, FavoriteSortOrder sortOrder, SourceType sourceType)
{
FavoriteCollectionResponse response;
int totalCount;
if (version >= 2.1)
{
var entitys = _favoriteRepository.Get(userId, pagerRequest, out totalCount, sortOrder, sourceType);
var list = MappingManager.FavoriteCollectionResponseMapping(entitys, coordinate);
response = new FavoriteCollectionResponse(pagerRequest, totalCount) { Favorites = list };
}
else
{
var entitys = _favoriteRepository.GetPagedList(userId, pagerRequest, out totalCount, sortOrder, sourceType);
response = MappingManager.FavoriteCollectionResponseMapping(entitys, coordinate);
response.Index = pagerRequest.PageIndex;
response.Size = pagerRequest.PageSize;
response.TotalCount = totalCount;
}
return response;
}
public List <PromotionEntity> GetPagedList(PagerRequest pagerRequest, out int totalCount, PromotionSortOrder sortOrder,
DateTimeRangeInfo dateTimeRangeInfo, CoordinateInfo coordinateInfo, Timestamp timestamp, int?recommendUser, PromotionFilterMode filterMode)
{
if (filterMode == PromotionFilterMode.New)
{
return(GetPagedListByNew(pagerRequest, out totalCount, sortOrder, dateTimeRangeInfo, coordinateInfo,
timestamp, recommendUser));
}
if (filterMode == PromotionFilterMode.BeginStart)
{
return(GetPagedListByBeStart(null, pagerRequest, out totalCount, sortOrder, dateTimeRangeInfo, coordinateInfo,
timestamp, recommendUser));
}
if (coordinateInfo != null)
{
//存储
return(GetPagedList(pagerRequest.PageIndex, pagerRequest.PageSize, out totalCount, (int)sortOrder,
coordinateInfo.Longitude, coordinateInfo.Latitude, timestamp));
}
return
(base.Get(Filter(DataStatus.Normal, dateTimeRangeInfo, timestamp, recommendUser), out totalCount, pagerRequest.PageIndex,
pagerRequest.PageSize, OrderBy(sortOrder)).ToList());
}
public ActionResult List(PagerRequest request,SectionSearchOption search)
{
int totalCount;
var linq = _sectionRepo.Get(s => (!search.SId.HasValue || search.SId.Value == s.Id) &&
(string.IsNullOrEmpty(search.Name) || s.Name.StartsWith(search.Name)) &&
(!search.BrandId.HasValue || search.BrandId.Value == s.BrandId) &&
(!search.StoreId.HasValue || search.StoreId.Value == s.StoreId) &&
s.Status!=(int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e => e.OrderByDescending(o => o.CreateDate));
var data = linq.Join(_storeRepo.GetAll(), o => o.StoreId, i => i.Id, (o, i) => new { S = o, Store = i })
.Join(_brandRepo.GetAll(), o => o.S.BrandId, i => i.Id, (o, i) => new { S = o.S, Store = o.Store, B = i })
.ToList()
.Select(l => new SectionViewModel().FromEntity<SectionViewModel>(l.S, p=>{
p.Store = new StoreViewModel().FromEntity<StoreViewModel>(l.Store);
p.Brand = new BrandViewModel().FromEntity<BrandViewModel>(l.B);
}));
var v = new Pager<SectionViewModel>(request, totalCount) { Data = data.ToList() };
return View("List", v);
}
/// <summary>
///
/// </summary>
/// <param name="skipCount"></param>
/// <param name="pagerRequest"></param>
/// <param name="totalCount"></param>
/// <param name="sortOrder"></param>
/// <param name="dateTimeRangeInfo"></param>
/// <param name="coordinateInfo"></param>
/// <param name="timestamp"></param>
/// <param name="recommendUser"></param>
/// <returns></returns>
private List <PromotionEntity> GetPagedListByBeStart(int?skipCount, PagerRequest pagerRequest, out int totalCount, PromotionSortOrder sortOrder,
DateTimeRangeInfo dateTimeRangeInfo, CoordinateInfo coordinateInfo, Timestamp timestamp, int?recommendUser)
{
/*查询逻辑
* 1.今天开始的活动
* 2.以前开始，今天还自进行的活动
* 3.即将开始的活动，时间升序 24小时内的
*
* logic 例 size40
*/
var f3 = Filter3(DataStatus.Normal, new DateTimeRangeInfo()
{
EndDateTime = DateTime.Now
}, timestamp, recommendUser);
if (skipCount == null)
{
return
(base.Get(f3, out totalCount, pagerRequest.PageIndex, pagerRequest.PageSize,
OrderBy(PromotionSortOrder.StartAsc)).ToList());
}
else
{
return
(base.Get(f3, out totalCount, pagerRequest.PageIndex, pagerRequest.PageSize,
OrderBy(PromotionSortOrder.StartAsc), skipCount.Value).ToList());
}
}
public ActionResult List(PagerRequest request,SpecialTopicListSearchOption search)
{
int totalCount;
var data = _specialTopicRepository.Get(e =>(!search.PId.HasValue || e.Id== search.PId.Value)
&& (string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower()))
&& (!search.Status.HasValue || e.Status == (int)search.Status.Value)
&& e.Status!=(int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e => {
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o=>o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o=>o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o=>o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o=>o.CreatedDate);
}
}
});
var vo = MappingManager.SpecialTopicViewMapping(data.ToList());
var v = new SpecialTopicCollectionViewModel(request, totalCount) { SpecialTopics = vo.ToList() };
ViewBag.SearchOptions = search;
return View("List", v);
}
public PagedCashierList(PagerRequest pagerRequest, int totalCount, IEnumerable <WebSiteCashierSearchDto> datas)
{
this.PageIndex = pagerRequest.PageIndex;
this.PageSize = pagerRequest.PageSize;
this.TotalCount = totalCount;
this.AddRange(datas);
}
public ActionResult List(PagerRequest request, SectionSearchOption search)
{
int totalCount;
var linq = _sectionRepo.Get(s => (!search.SId.HasValue || search.SId.Value == s.Id) &&
(string.IsNullOrEmpty(search.Name) || s.Name.StartsWith(search.Name)) &&
(!search.BrandId.HasValue || search.BrandId.Value == s.BrandId) &&
(!search.StoreId.HasValue || search.StoreId.Value == s.StoreId) &&
s.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e => e.OrderByDescending(o => o.CreateDate));
var data = linq.Join(_storeRepo.GetAll(), o => o.StoreId, i => i.Id, (o, i) => new { S = o, Store = i })
.Join(_brandRepo.GetAll(), o => o.S.BrandId, i => i.Id, (o, i) => new { S = o.S, Store = o.Store, B = i })
.ToList()
.Select(l => new SectionViewModel().FromEntity <SectionViewModel>(l.S, p => {
p.Store = new StoreViewModel().FromEntity <StoreViewModel>(l.Store);
p.Brand = new BrandViewModel().FromEntity <BrandViewModel>(l.B);
}));
var v = new Pager <SectionViewModel>(request, totalCount)
{
Data = data.ToList()
};
return(View("List", v));
}
private IHttpActionResult GetSectionList(SectionFilter filter, int userId, UserProfile userProfile)
{
if (filter == null)
{
filter = new SectionFilter();
}
var result = CheckRole4Store(userProfile, null);
if (!result.Result)
{
return(BadRequest(result.Error));
}
filter.AuthUserId = userId;
filter.DataRoleStores = userProfile.StoreIds.ToList();
filter.ArrangeParams();
int total;
var pagerRequest = new PagerRequest(filter.Page ?? 1, filter.PageSize ?? 0);
var model = _sectionRepository.GetPagedList(pagerRequest, out total, filter,
filter.SortOrder ?? SectionSortOrder.Default);
var dto = Mapper.Map <List <Section>, List <SectionDto> >(model);
var pagerdto = new PagerInfo <SectionDto>(pagerRequest, total);
pagerdto.Datas = dto;
return(RetrunHttpActionResult(pagerdto));
}
public PagedReturnGoodsStatListDto(PagerRequest pagerRequest, int totalCount, IEnumerable <ReturnGoodsStatDto> datas)
{
this.PageIndex = pagerRequest.PageIndex;
this.PageSize = pagerRequest.PageSize;
this.TotalCount = totalCount;
this.AddRange(datas);
}
public IQueryable <ProductEntity> Get(PagerRequest pagerRequest, out int totalCount, ProductSortOrder sortOrder, ProductFilter productFilter)
{
var linq = base.Get(Filter(productFilter));
//var linq = base.Get(Filter(productFilter), out totalCount, pagerRequest.PageIndex, pagerRequest.PageSize,
// GetOrder(sortOrder));
if (productFilter.TopicId != null)
{
linq = linq.Join(GetTopicRelationIds4Linq(productFilter.TopicId.Value), r => r.Id, v => v.Product_Id,
(r, v) => r);
}
if (productFilter.PromotionId != null)
{
linq = linq.Join(GetListByPromotion4Linq(productFilter.PromotionId.Value), r => r.Id, v => v.ProdId,
(r, v) => r);
}
var resetSet = linq;
var orderBy = GetOrder(sortOrder);
resetSet = orderBy != null?orderBy(resetSet).AsQueryable() : resetSet.AsQueryable();
totalCount = resetSet.Count();
var skipCount = (pagerRequest.PageIndex - 1) * pagerRequest.PageSize;
resetSet = skipCount == 0 ? resetSet.Take(pagerRequest.PageSize) : resetSet.Skip(skipCount).Take(pagerRequest.PageSize);
return(resetSet);
}
public IQueryable <ProductEntity> Search(PagerRequest pagerRequest, out int totalCount, ProductSortOrder sortOrder, Timestamp timestamp,
string productName, string brandName, int?recommendUser, List <int> tagids, int?brandId, DataStatus?dataStatus)
{
var filter = Filter(dataStatus, timestamp, tagids, recommendUser, brandId);
if (!String.IsNullOrWhiteSpace(productName))
{
filter = filter.And(v => v.Name.Contains(productName));
}
totalCount = 0;
var p1 = base.Get(filter).Take(pagerRequest.PageSize);
if (!String.IsNullOrEmpty(brandName))
{
var p2 = base.Get(Filter(dataStatus, timestamp, tagids, recommendUser, brandId));
var b = (ServiceLocator.Current.Resolve <IBrandRepository>().Get(DataStatus.Normal) as IQueryable <BrandEntity>).Where(v => v.Name.Contains(brandName) || v.EnglishName.Contains(brandName));
var r = p2.Join(b, v => v.Brand_Id, j => j.Id, (v, j) => v).Take(pagerRequest.PageSize);
return(r.Union(p1).Take(pagerRequest.PageSize));
}
return(p1);
}
/// <summary>
///
/// </summary>
/// <param name="pagerRequest"></param>
/// <param name="totalCount"></param>
/// <param name="sortOrder"></param>
/// <param name="dateTimeRangeInfo"></param>
/// <param name="coordinateInfo"></param>
/// <param name="timestamp"></param>
/// <param name="recommendUser"></param>
/// <returns></returns>
private List <PromotionEntity> GetPagedListByNew(PagerRequest pagerRequest, out int totalCount, PromotionSortOrder sortOrder,
DateTimeRangeInfo dateTimeRangeInfo, CoordinateInfo coordinateInfo, Timestamp timestamp, int?recommendUser)
{
/*查询逻辑
* 1.今天开始的活动
* 2.以前开始，今天还自进行的活动
* 3.即将开始的活动，时间升序 24小时内的
*
* logic 例 size40
*/
var r = new DateTimeRangeInfo
{
EndDateTime = DateTime.Now
};
var f1 = Filter1(DataStatus.Normal, r, timestamp, recommendUser);
var f2 = Filter2(DataStatus.Normal, r, timestamp, recommendUser);
var skip = (pagerRequest.PageIndex - 1) * pagerRequest.PageSize;
var t = base.Get(f1)
.Union(
base.Get(f2));
totalCount = t.Count();
if (pagerRequest.PageSize == 1)
{
return(t.OrderByDescending(s => s.IsTop).ThenByDescending(v => v.StartDate).Take(pagerRequest.PageSize).ToList());
}
return(t.OrderByDescending(s => s.IsTop).ThenByDescending(v => v.StartDate).Skip(skip).Take(pagerRequest.PageSize).ToList());
}
public ActionResult List(PagerRequest request, PromotionListSearchOption search)
{
int totalCount;
var storeList = new List <int>();
if (!string.IsNullOrEmpty(search.Store))
{
storeList = _storeRepository.Get(s => s.Name.StartsWith(search.Store)).Select(s => s.Id).ToList();
}
var linq = _promotionRepository.Get(e => (!search.PId.HasValue || e.Id == search.PId.Value) &&
(string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower())) &&
(!search.Status.HasValue || e.Status == (int)search.Status.Value) &&
e.Status != (int)DataStatus.Deleted &&
(string.IsNullOrEmpty(search.Store) || storeList.Any(m => m == e.Store_Id)));
linq = _authRepo.AuthFilter(linq, CurrentUser.CustomerId, CurrentUser.Role) as IQueryable <PromotionEntity>;
Func <IQueryable <PromotionEntity>, IOrderedQueryable <PromotionEntity> > orderBy = (IQueryable <PromotionEntity> e) =>
{
if (!search.OrderBy.HasValue)
{
return(e.OrderByDescending(o => o.CreatedDate));
}
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return(e.OrderByDescending(o => o.CreatedUser));
case GenericOrder.OrderByName:
return(e.OrderByDescending(o => o.Name));
case GenericOrder.OrderByCreateDate:
default:
return(e.OrderByDescending(o => o.CreatedDate));
}
}
};
linq = orderBy(linq);
totalCount = linq.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
linq = skipCount == 0 ? linq.Take(request.PageSize) : linq.Skip(skipCount).Take(request.PageSize);
var vo = MappingManager.PromotionViewMapping(linq.ToList());
var v = new PromotionCollectionViewModel(request, totalCount)
{
Promotions = vo.ToList()
};
ViewBag.SearchOptions = search;
return(View("List", v));
}
public ActionResult List(ProductSearchOption search, PagerRequest request)
{
int totalCount;
var vo = internalSearch(search, request,out totalCount);
var v = new ProductCollectionViewModel(request, totalCount) { Products = vo.ToList() };
ViewBag.SearchOptions = search;
return View(v);
}
/// <summary>
/// 获取 OPC 后台用户
/// </summary>
/// <param name="pagerRequest">分页参数</param>
/// <param name="roleId">指定权限</param>
/// <param name="authdatastartsWith">AUTHDATA 前拽</param>
/// <param name="incloudeSystem">是否包含管理员帐号</param>
/// <returns></returns>
public PageResult <AuthUserDto> GetPagedList(PagerRequest pagerRequest, int?roleId, List <string> authdatastartsWith, bool?incloudeSystem, string name = null, string logonName = null)
{
var datas = _accountRepository.GetPagedList(pagerRequest, roleId, authdatastartsWith, incloudeSystem);
var rst = new PageResult <OPC_AuthUser>(datas.Datas, datas.TotalCount);
return(OpcResult2Result(rst));
}
public ActionResult List(PagerRequest request)
{
int totalCount;
var jobs = new ProUploadService(this).JobList(request.PageIndex,request.PageSize,out totalCount);
return View(new Pager<ProductUploadJob>(request,totalCount){
Data = jobs
});
}
public List <PromotionEntity> GetPagedList(PagerRequest pagerRequest, out int totalCount,
PromotionSortOrder sortOrder,
DateTimeRangeInfo dateTimeRangeInfo, CoordinateInfo coordinateInfo,
Timestamp timestamp, int?recommendUser)
{
return(GetPagedList(pagerRequest, out totalCount, sortOrder, dateTimeRangeInfo, coordinateInfo, timestamp,
recommendUser, PromotionFilterMode.Default));
}
public ActionResult List(PagerRequest request, BannerSearchOption search)
{
int totalCount;
var linq = _bannerRepo.Get(e => (!search.PromotionId.HasValue || (e.SourceId == search.PromotionId.Value && e.SourceType == (int)SourceType.Promotion)) &&
(!search.Status.HasValue || e.Status == (int)search.Status.Value) &&
e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
{
return(e.OrderByDescending(o => o.CreatedDate));
}
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return(e.OrderByDescending(o => o.CreatedUser));
case GenericOrder.OrderByCreateDate:
default:
return(e.OrderByDescending(o => o.CreatedDate));
}
}
});
var linq_All = linq.Join(_proRepo.GetAll(),
o => o.SourceId,
i => i.Id,
(o, i) => new { B = o, P = i })
.GroupJoin(_resourceRepo.Get(r => r.SourceType == (int)SourceType.BannerPromotion),
o => o.B.Id,
i => i.SourceId,
(o, i) => new { B = o.B, P = o.P, R = i.FirstOrDefault() });
var vo = from l in linq_All.ToList()
select new BannerViewModel()
{
Id = l.B.Id,
SourceId = l.B.SourceId,
SourceType = l.B.SourceType,
Resource = MappingManager.ResourceViewMapping(l.R),
Promotion = MappingManager.PromotionViewMapping(l.P),
SortOrder = l.B.SortOrder,
Status = l.B.Status
};
var v = new BannerCollectionViewModel(request, totalCount)
{
Banners = vo.ToList()
};
ViewBag.SearchOptions = search;
return(View("List", v));
}
public ActionResult List(PagerRequest request, StorePromotionSearchOption search)
{
int totalCount;
var dbContext = _storepromotionRepo.Context;
var linq = from e in dbContext.Set <StorePromotionEntity>()
let scope = from es in dbContext.Set <StorePromotionScopeEntity>()
where es.StorePromotionId == e.Id && es.StoreId == search.StoreId.Value
select es
where (!search.SId.HasValue || e.Id == search.SId.Value) &&
(string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower())) &&
(!search.Status.HasValue || e.Status == (int)search.Status.Value) &&
(!search.ActiveStartDate.HasValue || e.ActiveStartDate >= search.ActiveStartDate.Value) &&
(!search.ActiveEndDate.HasValue || e.ActiveEndDate >= search.ActiveEndDate.Value) &&
e.Status != (int)DataStatus.Deleted &&
(!search.StoreId.HasValue || scope.Any())
select e;
linq = linq.WhereWithPageSort <StorePromotionEntity>(
out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.SortBy.HasValue)
{
return(e.OrderByDescending(o => o.CreateDate));
}
else
{
switch (search.SortBy.Value)
{
case GenericOrder.OrderByCreateUser:
return(e.OrderByDescending(o => o.CreateUser));
case GenericOrder.OrderByName:
return(e.OrderByDescending(o => o.Name));
case GenericOrder.OrderByCreateDate:
default:
return(e.OrderByDescending(o => o.CreateDate));
}
}
});
var vo = from l in linq.ToList()
select new StorePromotionViewModel().FromEntity <StorePromotionViewModel>(l);
var v = new Pager <StorePromotionViewModel>(request, totalCount)
{
Data = vo.ToList()
};
ViewBag.SearchOptions = search;
return(View("List", v));
}
public ActionResult List(PagerRequest request)
{
int totalCount;
var jobs = new ProUploadService(this).JobList(request.PageIndex, request.PageSize, out totalCount);
return(View(new Pager <ProductUploadJob>(request, totalCount)
{
Data = jobs
}));
}
public IQueryable <PromotionEntity> Get(PagerRequest pagerRequest, out int totalCount, PromotionSortOrder sortOrder, Timestamp timestamp, PromotionFilterMode?filterMode, DataStatus?dataStatus, bool?hasBanner)
{
return(Get(pagerRequest, out totalCount, sortOrder, new PromotionFilter
{
DataStatus = dataStatus,
FilterMode = filterMode,
HasBanner = hasBanner,
Timestamp = timestamp
}));
}
public ActionResult List(PagerRequest request, UserAuthSearchOption search)
{
int totalCount;
var data = _authRepo.Get(e => (!search.Type.HasValue || e.Type == search.Type.Value) &&
(!search.BrandId.HasValue || e.BrandId == search.BrandId.Value) &&
(!search.StoreId.HasValue || e.StoreId == search.StoreId.Value) &&
(!search.UserId.HasValue || e.UserId == search.UserId.Value) &&
e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
{
return(e.OrderByDescending(o => o.CreatedDate));
}
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return(e.OrderByDescending(o => o.CreatedUser));
case GenericOrder.OrderByName:
case GenericOrder.OrderByCreateDate:
default:
return(e.OrderByDescending(o => o.CreatedDate));
}
}
});
var models = data.Join(_customerRepo.GetAll(), o => o.UserId, i => i.Id, (o, i) => new { UA = o, U = i })
.GroupJoin(_storeRepo.GetAll(), o => o.UA.StoreId, i => i.Id, (o, i) => new { UA = o.UA, U = o.U, S = i.FirstOrDefault() })
.GroupJoin(_brandRep.GetAll(), o => o.UA.BrandId, i => i.Id, (o, i) => new { UA = o.UA, U = o.U, S = o.S, B = i.FirstOrDefault() })
.ToList()
.Select(o => new UserAuthViewModel()
{
Id = o.UA.Id
, BrandId = o.UA.BrandId
, StoreId = o.UA.StoreId
, Type = o.UA.Type
, BrandName = o.B == null?"所有":o.B.Name
, UserId = o.UA.UserId
, UserNick = o.U.Nickname
, StoreName = o.S == null ? "所有" : o.S.Name
, Status = o.UA.Status.Value
});
return(View("List", new Pager <UserAuthViewModel>(request, totalCount)
{
Data = models.ToList()
}));
}
private IEnumerable <BillEntity> GetList(PagerRequest pagerRequest, out int totalCount, BillFilterOptions filterOptions, BillSortOptions sortOptions)
{
var count = 0;
var t = ServiceInvoke(v => v.BillRepository.Get(Filler(filterOptions), out count, pagerRequest.PageIndex,
pagerRequest.PageSize, OrderBy(sortOptions)));
totalCount = count;
return(t);
}
public ActionResult List(PagerRequest request, int? sort)
{
int totalCount;
var sortOrder = (FeedbackSortOrder)(sort ?? 0);
var data = _feedbackRepository.GetPagedList(request, out totalCount, sortOrder);
var vo = MappingManager.FeedbackViewMapping(data);
var v = new FeedbackCollectionViewModel(request, totalCount) { Feedbacks = vo.ToList() };
return View("List", v);
}
private IEnumerable<BillEntity> GetList(PagerRequest pagerRequest, out int totalCount, BillFilterOptions filterOptions, BillSortOptions sortOptions)
{
var count = 0;
var t = ServiceInvoke(v => v.BillRepository.Get(Filler(filterOptions), out count, pagerRequest.PageIndex,
pagerRequest.PageSize, OrderBy(sortOptions)));
totalCount = count;
return t;
}
/// <summary>
/// TO PAGE
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="source"></param>
/// <param name="pagerRequest"></param>
/// <returns></returns>
public static PagerInfo <T> ToPagerInfo <T>(this IQueryable <T> source, PagerRequest pagerRequest)
{
var count = source.Count();
var data = source.Skip(pagerRequest.SkipCount).Take(pagerRequest.PageSize).ToList();
return(new PagerInfo <T>(pagerRequest, count)
{
Datas = data,
});
}
public ActionResult StoreCouponUsage(PagerRequest request, StoreCouponUsageOption search)
{
if (!ModelState.IsValid)
{
ViewBag.SearchOptions = search;
return View();
}
var prods = searchCouponLog(search);
var v = new Pager<StoreCouponUsageViewModel>(request, prods.Count()) { Data = prods.ToList() };
ViewBag.SearchOptions = search;
return View(v);
}
public PagerInfo <AssociateDto> GetPagedList(AssociateQueryRequest request, PagerRequest pagerRequest)
{
var associateFilter = Filter(request);
var sectionFilter = SectionFilter(request);
var userFilter = UserFilter(request);
using (var db = GetYintaiHZhouContext())
{
var associates = db.IMS_Associate;
var sections = db.Sections;
var stores = db.Stores;
var users = db.Users;
var deptments = db.Departments;
var q = from associate in associates.AsExpandable().Where(associateFilter)
join section in sections.AsExpandable().Where(sectionFilter) on associate.SectionId equals section.Id
join store in stores on associate.StoreId equals store.Id
join user in users.AsExpandable().Where(userFilter) on associate.UserId equals user.Id
join deptment in deptments on section.DepartmentId equals deptment.Id into tmp1
from deptment in tmp1.DefaultIfEmpty()
select new AssociateDto
{
StoreId = store.Id,
StoreName = store.Name,
SectionCode = section.SectionCode,
SectionId = section.Id,
SectionName = section.Name,
OperateRight = associate.OperateRight,
OperatorCode = associate.OperatorCode,
CreateDate = associate.CreateDate,
CreateUser = associate.CreateUser,
Id = associate.Id,
Status = associate.Status,
TemplateId = associate.TemplateId,
UserId = associate.UserId,
UserNickName = user.Nickname,
Mobile = user.Mobile,
Email = user.EMail,
UserName = user.Name,
UserLevel = user.UserLevel,
DepartmentId = deptment == null ? 0 : deptment.Id,
DepartmentName = deptment == null ? null : deptment.Name
};
var totalCount = q.Count();
var datas = q.OrderByDescending(v => v.Id).Skip(pagerRequest.SkipCount).Take(pagerRequest.PageSize).ToList();
return(new PagerInfo <AssociateDto>(pagerRequest, totalCount)
{
Datas = datas
});
}
}
public ActionResult List(PagerRequest request, int? sort)
{
int totalCount;
var sortOrder = (TagSortOrder)(sort ?? 0);
var data = _tagRepository.GetPagedList(request, out totalCount, sortOrder);
var vo = MappingManager.TagViewMapping(data);
var v = new TagCollectionViewModel(request, totalCount) { Tags = vo.ToList() };
return View("List", v);
}
public List <UserEntity> GetPagedListForNickName(PagerRequest pagerRequest, out int totalCount, CustomerSortOrder sortOrder, string nickName,
string mobile)
{
var f = Filter(DataStatus.Normal, null, null, mobile);
if (!String.IsNullOrWhiteSpace(nickName))
{
f = f.And(v => v.Nickname.StartsWith(nickName));
}
return(base.Get(f, out totalCount, pagerRequest.PageIndex, pagerRequest.PageSize, OrderBy(sortOrder)).ToList());
}
public ActionResult ProductByBrand(PagerRequest request, ReportByProductBrandOption search)
{
if (!ModelState.IsValid)
{
ViewBag.SearchOptions = search;
return View();
}
var prods = searchProduct(search);
var v = new Pager<ProductByBrandReportViewModel>(request, prods.Count()) { Data = prods.ToList() };
ViewBag.SearchOptions = search;
return View(v);
}
public ActionResult List(PagerRequest pagerRequest, BillFilterOptions filterOptions, BillSortOptions?sortOptions)
{
int totalCount;
var queryTable = GetList(pagerRequest, out totalCount, filterOptions, sortOptions ?? BillSortOptions.Default);
var dto = new ListDTO {
Bills = new PagerInfo <BillEntity>(pagerRequest, totalCount, queryTable)
};
return(View(dto));
}
public JsonResult ListP(OrderSearchOption search, PagerRequest request)
{
int totalCount;
search.CurrentUser = CurrentUser.CustomerId;
search.CurrentUserRole = CurrentUser.Role;
var dbContext = _orderRepo.Context;
var linq = dbContext.Set<OrderEntity>().Where(p => (string.IsNullOrEmpty(search.OrderNo) || p.OrderNo == search.OrderNo) &&
(!search.CustomerId.HasValue || p.CustomerId == search.CustomerId.Value) &&
(!search.Status.HasValue || p.Status == (int)search.Status.Value) &&
(!search.Store.HasValue || p.StoreId == search.Store.Value) &&
(!search.Brand.HasValue || p.BrandId == search.Brand.Value) &&
(!search.FromDate.HasValue || p.CreateDate >= search.FromDate.Value) &&
(!search.ToDate.HasValue || p.CreateDate <= search.ToDate.Value) &&
p.Status != (int)DataStatus.Deleted);
linq = _userAuthRepo.AuthFilter(linq, search.CurrentUser, search.CurrentUserRole) as IQueryable<OrderEntity>;
var linq2 = linq.Join(dbContext.Set<UserEntity>().Where(u => u.Status != (int)DataStatus.Deleted),
o => o.CustomerId,
i => i.Id,
(o, i) => new { O = o, C = i })
.GroupJoin(dbContext.Set<RMAEntity>(),
o => o.O.OrderNo,
i => i.OrderNo,
(o, i) => new { O = o.O, C = o.C, RMA = i })
.GroupJoin(dbContext.Set<ShipViaEntity>().Where(s => s.Status != (int)DataStatus.Deleted),
o => o.O.ShippingVia,
i => i.Id,
(o, i) => new { O = o.O, C = o.C, RMA = o.RMA, S = i.FirstOrDefault() });
totalCount = linq2.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
var linq3 = skipCount == 0 ? linq2.OrderByDescending(l => l.O.CreateDate).Take(request.PageSize) : linq2.OrderByDescending(l => l.O.CreateDate).Skip(skipCount).Take(request.PageSize);
var vo = from l in linq3.ToList()
select new OrderViewModel().FromEntity<OrderViewModel>(l.O, p =>
{
p.ShippingViaMethod = l.S;
p.Customer = new CustomerViewModel().FromEntity<CustomerViewModel>(l.C);
p.ShippingViaMethod_Name = l.S==null?string.Empty:l.S.Name;
p.RMAs = l.RMA.ToList().OrderByDescending(r=>r.CreateDate).Select(r => new RMAViewModel().FromEntity<RMAViewModel>(r));
});
var v = new Pager<OrderViewModel>(request, totalCount) { Data = vo.ToList() };
return Json(v);
}
public static T CopyPagerRequest <T>(PagerRequest request, PagerSupport criteria)
{
criteria.Limit = DataHelper.ConvertInputNumber(request.Limit);
criteria.Offset = DataHelper.ConvertInputNumber(request.Offset);
criteria.SortBy = DataHelper.ConvertInputString(request.SortBy);
if (!DataCheckHelper.IsNull(criteria.SortBy))
{
criteria.IsAsc = DataHelper.ConvertInputBoolean(request.IsAsc);
}
return(DataHelper.AutoCast <T>(criteria));
}
private PromotionCollectionResponse GetList(PagerRequest pagerRequest, Timestamp timestamp, PromotionSortOrder sortOrder, CoordinateInfo coordinateInfo)
{
int totalCount;
var entitys = Get(pagerRequest, timestamp, sortOrder, coordinateInfo, out totalCount);
var response = new PromotionCollectionResponse(pagerRequest, totalCount)
{
Promotions = MappingManager.PromotionResponseMapping(entitys, coordinateInfo)
};
return(response);
}
public ActionResult List(PagerRequest request,ProductPropertyValueSearchOption search)
{
int totalCount;
var prodLinq = _userauthRepo.AuthFilter(_prodRepo.GetAll(), CurrentUser.CustomerId, CurrentUser.Role) as IQueryable<ProductEntity>;
var linq = _prodpropertyvalRepo.Get(pv => pv.Status != (int)DataStatus.Deleted)
.Join(_prodpropertyRepo.Get(p => p.Status != (int)DataStatus.Deleted), o => o.PropertyId, i => i.Id, (o, i) => new { PV = o, P = i })
.Join(prodLinq, o => o.P.ProductId, i => i.Id, (o, i) => new { PV = o.PV, P = o.P, T = i })
.Where(l => (string.IsNullOrEmpty(search.PropertyDesc) || l.P.PropertyDesc.StartsWith(search.PropertyDesc)) &&
(string.IsNullOrEmpty(search.ValueDesc) || l.PV.ValueDesc.StartsWith(search.ValueDesc)) &&
(!search.ProductId.HasValue || l.P.ProductId == search.ProductId.Value));
linq = linq.WhereWithPageSort(
out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
return e.OrderByDescending(l => l.P.ProductId).ThenByDescending(l => l.P.UpdateDate);
});
var vo = new List<ProductPropertyViewModel>();
foreach (var l in linq)
{
var existProperty = vo.Find(t => t.ProductId == l.P.ProductId);
var newValue = new TagPropertyValueViewModel().FromEntity<TagPropertyValueViewModel>(l.PV, p =>
{
p.PropertyDesc = l.P.PropertyDesc;
p.SortOrder = l.P.SortOrder??0;
p.PropertyId = l.P.Id;
p.ValueId = l.PV.Id;
});
if (existProperty != null)
{
existProperty.Values.Add(newValue);
} else
{
vo.Add(new ProductPropertyViewModel().FromEntity<ProductPropertyViewModel>(l.P, p =>
{
p.ProductName = l.T.Name;
p.Values = new List<TagPropertyValueViewModel>();
p.Values.Add(newValue);
}));
}
}
var v = new Pager<ProductPropertyViewModel>(request, totalCount) { Data =vo };
return View("List", v);
}
public ActionResult List(PagerRequest request, UserAuthSearchOption search)
{
int totalCount;
var data = _authRepo.Get(e => (!search.Type.HasValue || e.Type == search.Type.Value)
&& (!search.BrandId.HasValue || e.BrandId == search.BrandId.Value)
&& (!search.StoreId.HasValue || e.StoreId == search.StoreId.Value)
&& (!search.UserId.HasValue || e.UserId == search.UserId.Value)
&& e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var models = data.Join(_customerRepo.GetAll(),o=>o.UserId,i=>i.Id,(o,i)=>new {UA=o,U=i})
.GroupJoin(_storeRepo.GetAll(),o=>o.UA.StoreId,i=>i.Id,(o,i)=>new {UA=o.UA,U=o.U,S=i.FirstOrDefault()})
.GroupJoin(_brandRep.GetAll(),o=>o.UA.BrandId,i=>i.Id,(o,i)=>new {UA=o.UA,U=o.U,S=o.S,B=i.FirstOrDefault()})
.ToList()
.Select(o=>new UserAuthViewModel(){
Id = o.UA.Id
, BrandId = o.UA.BrandId
, StoreId = o.UA.StoreId
, Type = o.UA.Type
, BrandName = o.B==null?"所有":o.B.Name
, UserId = o.UA.UserId
,UserNick = o.U.Nickname
, StoreName = o.S == null ? "所有" : o.S.Name
,Status = o.UA.Status.Value
});
return View("List", new Pager<UserAuthViewModel>(request, totalCount) { Data=models.ToList()});
}
public ActionResult List(PagerRequest request, BannerSearchOption search)
{
int totalCount;
var linq = _bannerRepo.Get(e => (!search.PromotionId.HasValue || (e.SourceId == search.PromotionId.Value && e.SourceType == (int)SourceType.Promotion))
&& (!search.Status.HasValue || e.Status == (int)search.Status.Value)
&& e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var linq_All = linq.Join(_proRepo.GetAll(),
o => o.SourceId,
i => i.Id,
(o, i) => new { B = o, P = i })
.GroupJoin(_resourceRepo.Get(r => r.SourceType == (int)SourceType.BannerPromotion),
o => o.B.Id,
i => i.SourceId,
(o, i) => new { B = o.B, P = o.P, R = i.FirstOrDefault() });
var vo = from l in linq_All.ToList()
select new BannerViewModel() {
Id = l.B.Id,
SourceId = l.B.SourceId,
SourceType = l.B.SourceType,
Resource = MappingManager.ResourceViewMapping(l.R),
Promotion = MappingManager.PromotionViewMapping(l.P),
SortOrder = l.B.SortOrder,
Status = l.B.Status
};
var v = new BannerCollectionViewModel(request, totalCount) { Banners = vo.ToList() };
ViewBag.SearchOptions = search;
return View("List", v);
}
public ActionResult List(PagerRequest request,PromotionListSearchOption search)
{
int totalCount;
var storeList = new List<int>();
if (!string.IsNullOrEmpty(search.Store))
storeList = _storeRepository.Get(s => s.Name.StartsWith(search.Store)).Select(s=>s.Id).ToList();
var linq= _promotionRepository.Get(e => (!search.PId.HasValue || e.Id== search.PId.Value)
&& (string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower()))
&& (!search.Status.HasValue || e.Status == (int)search.Status.Value)
&& e.Status != (int)DataStatus.Deleted
&& (string.IsNullOrEmpty(search.Store) || storeList.Any(m=>m==e.Store_Id)));
linq = _authRepo.AuthFilter(linq, CurrentUser.CustomerId, CurrentUser.Role) as IQueryable<PromotionEntity>;
Func<IQueryable<PromotionEntity>, IOrderedQueryable<PromotionEntity>> orderBy = (IQueryable<PromotionEntity> e) =>
{
if (!search.OrderBy.HasValue)
{
return e.OrderByDescending(o => o.CreatedDate);
}
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
};
linq = orderBy(linq);
totalCount = linq.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
linq = skipCount == 0 ? linq.Take(request.PageSize) : linq.Skip(skipCount).Take(request.PageSize);
var vo = MappingManager.PromotionViewMapping(linq.ToList());
var v = new PromotionCollectionViewModel(request, totalCount) { Promotions = vo.ToList() };
ViewBag.SearchOptions = search;
return View("List", v);
}
public ActionResult List(PagerRequest request,TagPropertyValueSearchOption search)
{
int totalCount;
var linq = _tagpropertyvalueRepo.Get(pv => pv.Status != (int)DataStatus.Deleted)
.Join(_tagpropertyRepo.Get(p => p.Status != (int)DataStatus.Deleted), o => o.PropertyId, i => i.Id, (o, i) => new { PV = o, P = i })
.Join(_tagRepo.GetAll(), o => o.P.CategoryId, i => i.Id, (o, i) => new { PV = o.PV, P = o.P, T = i })
.Where(l => (!search.PId.HasValue || l.PV.Id == search.PId.Value) &&
(string.IsNullOrEmpty(search.PropertyDesc) || l.P.PropertyDesc.StartsWith(search.PropertyDesc)) &&
(string.IsNullOrEmpty(search.ValueDesc) || l.PV.ValueDesc.StartsWith(search.ValueDesc)) &&
(!search.CategoryId.HasValue || l.P.CategoryId == search.CategoryId.Value));
linq = linq.WhereWithPageSort(
out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
return e.OrderByDescending(l => l.P.CategoryId).ThenByDescending(l => l.P.CreatedDate);
});
var vo = new List<TagPropertyViewModel>();
foreach (var l in linq)
{
var existProperty = vo.Find(t=>t.CategoryId == l.P.CategoryId);
var newValue = new TagPropertyValueViewModel().FromEntity<TagPropertyValueViewModel>(l.PV,p=>{
p.PropertyDesc = l.P.PropertyDesc;
p.SortOrder = l.P.SortOrder;
p.PropertyId = l.P.Id;
p.ValueId = l.PV.Id;
});
if (existProperty != null)
{
existProperty.Values.Add(newValue);
} else
{
vo.Add(new TagPropertyViewModel().FromEntity<TagPropertyViewModel>(l.P,p=>{
p.CategoryName = l.T.Name;
p.Values = new List<TagPropertyValueViewModel>();
p.Values.Add(newValue);
}));
}
}
var v = new Pager<TagPropertyViewModel>(request, totalCount) { Data =vo };
return View("List", v);
}
public ActionResult List(PagerRequest request)
{
int totalCount;
var data = _wxRepo.Get(w=>w.Status!=(int)DataStatus.Deleted,
out totalCount,
request.PageIndex,
request.PageSize,
w=>w.OrderByDescending(wi=>wi.UpdateDate));
var vo = data.ToList().Select(d => new WXReplyViewModel().FromEntity<WXReplyViewModel>(d));
var v = new Pager<WXReplyViewModel>(request, totalCount) { Data = vo.ToList() };
return View("List", v);
}
/// <summary>
/// 获取收藏列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
private ExecuteResult<FavoriteCollectionResponse> GetFavoriteList(FavoriteListRequest request)
{
var pagerRequest = new PagerRequest(request.Page, request.PageSize);
CoordinateInfo coordinate = null;
if (request.Lng > 0 || request.Lng < 0)
{
coordinate = new CoordinateInfo(request.Lng, request.Lat);
}
var response = Get(request.Version, request.UserModel.Id, pagerRequest, coordinate,
request.SortOrder, request.SType);
return new ExecuteResult<FavoriteCollectionResponse>(response);
}
public ActionResult List(PagerRequest request, StorePromotionSearchOption search)
{
int totalCount;
var dbContext = _storepromotionRepo.Context;
var linq = from e in dbContext.Set<StorePromotionEntity>()
let scope = from es in dbContext.Set<StorePromotionScopeEntity>()
where es.StorePromotionId == e.Id && es.StoreId == search.StoreId.Value
select es
where (!search.SId.HasValue || e.Id == search.SId.Value)
&& (string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower()))
&& (!search.Status.HasValue || e.Status == (int)search.Status.Value)
&& (!search.ActiveStartDate.HasValue || e.ActiveStartDate >= search.ActiveStartDate.Value)
&& (!search.ActiveEndDate.HasValue || e.ActiveEndDate >= search.ActiveEndDate.Value)
&& e.Status != (int)DataStatus.Deleted
&& (!search.StoreId.HasValue || scope.Any())
select e;
linq = linq.WhereWithPageSort<StorePromotionEntity>(
out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.SortBy.HasValue)
return e.OrderByDescending(o => o.CreateDate);
else
{
switch (search.SortBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreateUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreateDate);
}
}
});
var vo = from l in linq.ToList()
select new StorePromotionViewModel().FromEntity<StorePromotionViewModel>(l);
var v = new Pager<StorePromotionViewModel>(request, totalCount) { Data = vo.ToList() };
ViewBag.SearchOptions = search;
return View("List", v);
}
private PagerInfo<CategoryEntity> GetList(PagerRequest pagerRequest, CategoryFilterOptions filterOptions, CategorySortOptions sortOptions)
{
var paged = PagedListGetter(pagerRequest, filterOptions, sortOptions,
(INGnono_FMNoteContextEFUnitOfWork unitOfWork,
Expression<Func<CategoryEntity, bool>> filter,
Func<IQueryable<CategoryEntity>, IOrderedQueryable<CategoryEntity>> @orderby, PagerRequest pRequest,
out int totalCount) => unitOfWork.CategoryRepository
.Get(filter,
out totalCount,
pagerRequest
.PageIndex,
pagerRequest
.PageSize,
@orderby), Filler, OrderBy);
return paged;
}
public ExecuteResult<PromotionCollectionResponse> GetPromotionForBanner(GetPromotionBannerListRequest request)
{
var page = new PagerRequest(request.Page, request.Pagesize, 40);
int totalCount;
var entities = _promotionRepository.Get(page, out totalCount, request.SortOrder, null, PromotionFilterMode.NotTheEnd,
DataStatus.Normal, true);
var response = new PromotionCollectionResponse(page, totalCount)
{
Promotions = MappingManager.PromotionResponseMapping(entities, request.CoordinateInfo, true)
};
var result = new ExecuteResult<PromotionCollectionResponse> { Data = response };
return result;
}
public ActionResult SectionListP(SectionSearchViewModel search, PagerRequest request)
{
int totalCount;
var linq = Context.Set<SectionEntity>().Where(s=>s.StoreId ==search.StoreId && s.Status !=(int)DataStatus.Deleted && s.ChannelSectionId.HasValue)
;
totalCount = linq.Count();
var skipCount = (request.PageIndex - 1) * request.PageSize;
linq = skipCount == 0 ? linq.OrderBy(l => l.Id).Take(request.PageSize) : linq.OrderBy(l => l.Id).Skip(skipCount).Take(request.PageSize);
var vo = linq.ToList().Select(l=>new SectionViewModel().FromEntity<SectionViewModel>(l));
var v = new Pager<SectionViewModel>(request, totalCount) { Data = vo.ToList() };
return Json(v);
}
public ActionResult List(PagerRequest request,BrandListSearchOption search, int? sort)
{
int totalCount;
var linq = _brandRepository.Get(e => (!search.PId.HasValue || e.Id == search.PId.Value)
&& (string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower()))
&& e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var data = linq.GroupJoin(_resourceRepository.Get(r => r.SourceType == (int)SourceType.BrandLogo),
o => o.Id,
i => i.SourceId,
(o, i) => new { S = o,R = i});
var brands = from s in data.ToList()
select new BrandViewModel().FromEntity<BrandViewModel>(s.S,
b => (b as BrandViewModel).Resource= new ResourceViewModel().FromEntity<ResourceViewModel>(s.R.FirstOrDefault()));
var v = new BrandCollectionViewModel(request, totalCount) { Brands = brands.ToList() };
return View("List", v);
}
public ActionResult List(PagerRequest request, CustomerListSearchOption search)
{
int totalCount;
var data = _customerRepository.Get(e => (!search.PId.HasValue || e.Id == search.PId.Value)
&& (string.IsNullOrEmpty(search.Name) || e.Name.ToLower().StartsWith(search.Name.ToLower()) ||
e.Nickname.ToLower().StartsWith(search.Name.ToLower()))
&& e.Status != (int)DataStatus.Deleted
&& (string.IsNullOrEmpty(search.Mobile) || e.Mobile == search.Mobile)
&& (string.IsNullOrEmpty(search.Email) || e.EMail.ToLower().StartsWith(search.Email.ToLower()))
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var vo = MappingManager.CustomerViewMapping(MappingManager.UserModelMapping(data.ToList()).ToList());
var v = new CustomerCollectionViewModel(request, totalCount) { Customers = vo.ToList() };
return View("List", v);
}
private ExecuteResult<SpecialTopicCollectionResponse> Get(PagerRequest pagerRequest, SpecialTopicSortOrder sortOrder, Timestamp timestamp)
{
int totalCount;
var data = _specialTopicRepository.GetPagedList(pagerRequest, out totalCount, sortOrder,
timestamp);
var response = new SpecialTopicCollectionResponse(pagerRequest, totalCount)
{
SpecialTopics = MappingManager.SpecialTopicInfoResponseMapping(data).ToList()
};
var result = new ExecuteResult<SpecialTopicCollectionResponse> { Data = response };
return result;
}
public ActionResult List(PagerRequest request, PointListSearchOption search)
{
int totalCount;
var data = _pointRepository.Get(e => (!search.UId.HasValue || e.User_Id == search.UId.Value)
&& e.Status != (int)DataStatus.Deleted
&& (!search.PSourceType.HasValue || e.PointSourceType == (int)search.PSourceType.Value)
&& (!search.PSourceId.HasValue || e.PointSourceId == (int)search.PSourceId.Value)
&& (!search.PType.HasValue || e.Type == (int)search.PType.Value)
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
return e.OrderByDescending(o => o.Name);
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var vo = MappingManager.PointViewMapping(data.ToList());
var v = new PointCollectionViewModel(request, totalCount) { Points = vo.ToList() };
return View("List", v);
}
