/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2016-1-15 王耀发 创建</remarks> public override Pager <CBSpCombo> Query(ParaSpComboFilter filter) { const string sql = @"(select a.*,b.Name from spcombo a left join sppromotion b on a.promotionsysno = b.sysno 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 <CBSpCombo>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBSpCombo> { 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>2016-1-15 王耀发 创建</remarks> public Pager <CBSpCombo> GetPagerList(ParaSpComboFilter filter) { return(ISpComboDao.Instance.Query(filter)); }
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2016-1-15 王耀发 创建</remarks> public abstract Pager <CBSpCombo> Query(ParaSpComboFilter filter);