/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-08-20 朱家宏 创建</remarks> public override Pager <GsGroupShopping> Query(ParaGroupShoppingFilter filter) { const string sql = @"(select * from gsgroupshopping a where (@0 is null or charindex(a.title,@0)>0) and (@1 is null or exists (select 1 from splitstr(@1,',') tmp where tmp.col = a.status)) and -- (@2 is null or a.StartTime>=@2) and --日期(起) (@3 is null or a.EndTime<@3) --日期(止) ) tb"; var statuses = (filter.Statuses != null && filter.Statuses.Count > 0) ? string.Join(",", filter.Statuses) : null; var paras = new object[] { filter.Title, statuses, filter.BeginDate, filter.EndDate }; var dataList = Context.Select <GsGroupShopping>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <GsGroupShopping> { PageSize = filter.PageSize, CurrentPage = filter.Id, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.Id, filter.PageSize).QueryMany() }; return(pager); }
/// <summary> /// 团购分页列表 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-08-20 朱家宏 创建</remarks> public Pager <GsGroupShopping> GetPagerList(ParaGroupShoppingFilter filter) { return(IGsGroupShoppingDao.Instance.Query(filter)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-08-20 朱家宏 创建</remarks> public abstract Pager <GsGroupShopping> Query(ParaGroupShoppingFilter filter);