/// <summary>
/// 会员可用积分日志
/// </summary>
/// <param name="pageIndex">索引</param>
/// <param name="customerSysNo">会员编号</param>
/// <returns>可用积分日志列表</returns>
/// <remarks>2013-12-01 苟治国 创建</remarks>
public PagedList <Model.CrAvailablePointLog> GetPager(int pageIndex, int customerSysNo, DateTime beginTime, DateTime endTime)
{
var list = new PagedList <CrAvailablePointLog>();
var pager = new Pager <CrAvailablePointLog>();
var apl = new ParaCrAvailablePointLogFilter();
apl.CustomerSysNo = customerSysNo;
apl.BeginDate = beginTime;
apl.EndDate = endTime;
pager.CurrentPage = pageIndex;
pager.PageFilter = new CrAvailablePointLog
{
CustomerSysNo = customerSysNo
};
pager.PageSize = list.PageSize;
pager = ICrAvailablePointLogDao.Instance.GetPager(pager, apl);
list = new PagedList <CrAvailablePointLog>
{
Data = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows,
IsLoading = false,
Style = PagedList.StyleEnum.WebSmall
};
return(list);
}
/// <summary> /// 会员可用积分日志 /// </summary> /// <param name="pager">条件</param> /// <returns>可用积分日志列表</returns> /// <remarks>2013-12-01 苟治国 创建</remarks> public abstract Pager <Model.CrAvailablePointLog> GetPager(Pager <CrAvailablePointLog> pager, ParaCrAvailablePointLogFilter apl);
/// <summary>
/// 会员可用积分日志
/// </summary>
/// <param name="pager">条件</param>
/// <returns>可用积分日志列表</returns>
/// <remarks>2013-12-01 苟治国 创建</remarks>
public override Pager <Model.CrAvailablePointLog> GetPager(Pager <CrAvailablePointLog> pager, ParaCrAvailablePointLogFilter apl)
{
#region sql条件
string sqlWhere = @"(@customersysnos=-1 or cap.customersysno =@customersysno) and (@beginTime is null or cap.CreatedDate>=@beginTime) and (@endTime is null or cap.CreatedDate<=@endTime) and cap.Decreased <> 0";
#endregion
using (var context = Context.UseSharedConnection(true))
{
pager.Rows = context.Select <CrAvailablePointLog>("cap.*")
.From("CrAvailablePointLog cap")
.Where(sqlWhere)
.Parameter("customersysno", pager.PageFilter.CustomerSysNo)
.Parameter("beginTime", apl.BeginDate)
.Parameter("endTime", apl.EndDate)
.Paging(pager.CurrentPage, pager.PageSize).OrderBy("cap.ChangeDate desc").QueryMany();
pager.TotalRows = context.Select <int>("count(1)")
.From("CrAvailablePointLog cap")
.Where(sqlWhere)
.Parameter("customersysno", pager.PageFilter.CustomerSysNo)
.Parameter("beginTime", apl.BeginDate)
.Parameter("endTime", apl.EndDate)
.QuerySingle();
}
return(pager);
}
