/// <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);
