/// <summary> /// 根据条件获取经验积分的列表 /// </summary> /// <param name="pageIndex">分页索引</param> /// <param name="customersysno">客户编号</param> /// <param name="type">类型</param> /// <param name="beginTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <returns>经验积分列表</returns> /// <remarks>2013-11-1 苟治国 创建</remarks> public PagedList <Model.CrExperiencePointLog> SeachPager(int pageIndex, int customersysno, int type, DateTime beginTime, DateTime endTime) { var list = new PagedList <CrExperiencePointLog>(); var pager = new Pager <CrExperiencePointLog>(); var exp = new ParaCrExperiencePointLogFilter(); exp.CustomerSysNo = customersysno; exp.BeginDate = beginTime; exp.EndDate = endTime; exp.Type = type; pager.CurrentPage = pageIndex; pager.PageSize = list.PageSize; pager = ICrExperiencePointLogDao.Instance.SeachPager(pager, exp); list = new PagedList <CrExperiencePointLog> { Data = pager.Rows, CurrentPageIndex = pager.CurrentPage, TotalItemCount = pager.TotalRows, IsLoading = false, Style = PagedList.StyleEnum.WebSmall }; return(list); }
/// <summary> /// 根据条件获取经验积分的列表 /// </summary> /// <param name="pager">分页属性</param> /// <param name="exp">经验积分查询条件</param> /// <returns>经验积分列表</returns> /// <remarks>2013-11-1 苟治国 创建</remarks> public override Pager <Model.CrExperiencePointLog> SeachPager(Pager <CrExperiencePointLog> pager, ParaCrExperiencePointLogFilter exp) { #region 测试SQL /*增加惠源币*/ //select * from CrExperiencePointLog ce where customersysno=1004 and Increased > 0 /*减少惠源币*/ //select * from CrExperiencePointLog ce where customersysno=1004 and Decreased > 0 #endregion #region sql条件 string sqlWhere = ""; if (exp.Type == 0) { sqlWhere = @"(@CustomerSysNo=-1 or cep.CustomerSysNo =@CustomerSysNo) and (@beginTime is null or cep.CreatedDate>=@beginTime) and (@endTime is null or cep.CreatedDate<=@endTime) and cep.Increased > 0"; } else if (exp.Type == 10) { sqlWhere = @"(@CustomerSysNo=-1 or cep.CustomerSysNo =@CustomerSysNo) and (@beginTime is null or cep.CreatedDate>=@beginTime) and (@endTime is null or cep.CreatedDate<=@endTime) and cep.Decreased <> 0"; } #endregion using (var context = Context.UseSharedConnection(true)) { pager.Rows = context.Select <CrExperiencePointLog>("cep.*") .From("CrExperiencePointLog cep") .Where(sqlWhere) .Parameter("customersysno", exp.CustomerSysNo) .Parameter("beginTime", exp.BeginDate) .Parameter("endTime", exp.EndDate) .Paging(pager.CurrentPage, pager.PageSize).OrderBy("cep.CreatedDate desc").QueryMany(); pager.TotalRows = context.Select <int>("count(1)") .From("CrExperiencePointLog cep") .Where(sqlWhere) .Parameter("customersysno", exp.CustomerSysNo) .Parameter("beginTime", exp.BeginDate) .Parameter("endTime", exp.EndDate) .QuerySingle(); } return(pager); }
/// <summary> /// 根据条件获取经验积分的列表 /// </summary> /// <param name="pager">分页属性</param> /// <param name="exp">经验积分查询条件</param> /// <returns>经验积分列表</returns> /// <remarks>2013-11-1 苟治国 创建</remarks> public abstract Pager <Model.CrExperiencePointLog> SeachPager(Pager <CrExperiencePointLog> pager, ParaCrExperiencePointLogFilter exp);