/// <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);
