/// <summary> /// 分页查询分销商预存款往来账明细 /// </summary> /// <param name="param">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-9-6 黄志勇 创建</remarks> public Result <PagedList <DsPrePaymentItem> > GetDsPrePaymentItemList(MallAccountParameters param) { var filter = new ParaDsPrePaymentItemFilter() { PageIndex = param.PageIndex <= 0 ? 1 : param.PageIndex, PageSize = param.PageSize, DealerSysNo = param.HytDealerSysNo, BeginDate = param.BeginDate, EndDate = param.EndDate }; var dsItems = DsOrderBo.Instance.QueryPrePaymentItem(filter); var list = new List <DsPrePaymentItem>(); foreach (var order in dsItems.Rows) { var mallOrderInfo = new DsPrePaymentItem(); Hyt.Util.Reflection.ReflectionUtils.Transform(order, mallOrderInfo); list.Add(mallOrderInfo); } var result = new Result <PagedList <DsPrePaymentItem> > { Data = new PagedList <DsPrePaymentItem> { TotalItemCount = dsItems.TotalRows, CurrentPageIndex = dsItems.CurrentPage, TData = list }, Status = true }; return(result); }
/// <summary> /// 分页查询分销商预存款往来账明细 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-06 黄志勇 创建</remarks> public override Pager <DsPrePaymentItem> QueryPrePaymentItem(ParaDsPrePaymentItemFilter filter) { const string sql = @"(select a.* from DsPrePaymentItem a inner join DsPrePayment b on a.PrePaymentSysNo = b.SysNo where (@DealerSysNo is null or b.DealerSysNo=@DealerSysNo) and (@BeginDate is null or a.CreatedDate>=@BeginDate) and --日期(起) (@EndDate is null or a.CreatedDate<@EndDate) --日期(止) ) tb"; var paras = new object[] { filter.DealerSysNo, filter.BeginDate, filter.EndDate }; var dataList = Context.Select <DsPrePaymentItem>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <DsPrePaymentItem> { PageSize = filter.PageSize, CurrentPage = filter.PageIndex, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("tb.CreatedDate desc").Paging(filter.PageIndex, filter.PageSize).QueryMany() }; return(pager); }
/// <summary> /// 分页查询分销商预存款往来账明细 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-06 黄志勇 创建</remarks> public Pager <DsPrePaymentItem> QueryPrePaymentItem(ParaDsPrePaymentItemFilter filter) { return(IDsOrderDao.Instance.QueryPrePaymentItem(filter)); }
/// <summary> /// 分页查询分销商预存款往来账明细 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-06 黄志勇 创建</remarks> public abstract Pager <DsPrePaymentItem> QueryPrePaymentItem(ParaDsPrePaymentItemFilter filter);