/// <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-08-21 苟治国 创建</remarks> public PagedList <Model.CrExperienceCoinLog> SeachPager(int pageIndex, int customersysno, int type, DateTime beginTime, DateTime endTime) { var list = new PagedList <CrExperienceCoinLog>(); var pager = new Pager <CrExperienceCoinLog>(); var exp = new ParaCrExperienceCoinLogFilter(); exp.CustomerSysNo = customersysno; exp.BeginDate = beginTime; exp.EndDate = endTime; exp.Type = type; pager.CurrentPage = pageIndex; pager.PageSize = list.PageSize; pager = ICrExperienceCoinLogDao.Instance.SeachPager(pager, exp); list = new PagedList <CrExperienceCoinLog> { 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-08-21 苟治国 创建</remarks> public override Pager <Model.CrExperienceCoinLog> SeachPager(Pager <CrExperienceCoinLog> pager, ParaCrExperienceCoinLogFilter exp) { #region 测试SQL /*增加惠源币*/ //select * from CrExperienceCoinLog ce where customersysno=1004 and Increased > 0 /*减少惠源币*/ //select * from CrExperienceCoinLog ce where customersysno=1004 and Decreased > 0 #endregion #region sql条件 string sqlWhere = ""; if (exp.Type == 0) { sqlWhere = @"(@CustomerSysNo=-1 or ce.CustomerSysNo =@CustomerSysNo) and (@beginTime is null or ce.CreatedDate>=@beginTime) and (@endTime is null or ce.CreatedDate<=@endTime)"; } else if (exp.Type == 10) { sqlWhere = @"(@CustomerSysNo=-1 or ce.CustomerSysNo =@CustomerSysNo) and (@beginTime is null or ce.CreatedDate>=@beginTime) and (@endTime is null or ce.CreatedDate<=@endTime) and ce.Increased > 0"; } else if (exp.Type == 20) { sqlWhere = @"(@CustomerSysNo=-1 or ce.CustomerSysNo =@CustomerSysNo) and (@beginTime is null or ce.CreatedDate>=@beginTime) and (@endTime is null or ce.CreatedDate<=@endTime) and ce.Decreased <> 0"; } #endregion using (var _context = Context.UseSharedConnection(true)) { pager.Rows = _context.Select <CrExperienceCoinLog>("ce.*") .From("CrExperienceCoinLog ce") .Where(sqlWhere) .Parameter("customersysno", exp.CustomerSysNo) .Parameter("beginTime", exp.BeginDate) .Parameter("endTime", exp.EndDate) .Paging(pager.CurrentPage, pager.PageSize).OrderBy("ce.CreatedDate desc").QueryMany(); pager.TotalRows = _context.Select <int>("count(1)") .From("CrExperienceCoinLog ce") .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-08-21 苟治国 创建</remarks> public abstract Pager <Model.CrExperienceCoinLog> SeachPager(Pager <CrExperienceCoinLog> pager, ParaCrExperienceCoinLogFilter exp);