/// <summary>
/// 通过过滤条件获取分销商列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>分销商列表</returns>
///<remarks>2013-09-03 周唐炬 创建</remarks>
public override Pager <CBDsDealer> GetDealerList(ParaDealerFilter filter)
{
string sqlWhere = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and A.SysNo = @3";
}
else
{
sqlWhere += " and A.CreatedBy = @4";
}
}
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and A.SysNo = @5";
}
string sql = @"(SELECT A.*
,B.SysNo As PrePaymentSysNo
,B.TOTALPRESTOREAMOUNT
,B.AVAILABLEAMOUNT
,B.FROZENAMOUNT
FROM DsDealer A
LEFT JOIN DsPrePayment B ON A.Sysno = B.dealersysno
WHERE (@0 IS NULL OR A.AREASYSNO = @0)
AND (@1 IS NULL OR A.STATUS = @1)
AND (@2 IS NULL OR charindex(A.DEALERNAME, @2) > 0)
AND " + sqlWhere + ") tb";
var dataList = Context.Select <CBDsDealer>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.AddressSysNo,
filter.Status,
filter.DealerName,
filter.DealerSysNo,
filter.DealerCreatedBy,
filter.SelectedDealerSysNo
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBDsDealer>()
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
/// <summary>
/// 创建分销商预存款往来账明细
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>分销商预存款往来账明细列表</returns>
/// <remarks>2013-09-11 周唐炬 创建</remarks>
public PagedList <CBDsPrePaymentItem> GetDsPrePaymentItemList(ParaDealerFilter filter)
{
if (filter != null)
{
var model = new PagedList <CBDsPrePaymentItem>();
filter.PageSize = model.PageSize;
var pager = IDsPrePaymentItemDao.Instance.GetDsPrePaymentItemList(filter);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = filter.CurrentPage;
}
return(model);
}
return(null);
}
/// <summary> /// 通过过滤条件获取分销商列表 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商列表</returns> ///<remarks>2013-09-03 周唐炬 创建</remarks> public abstract Pager <CBDsDealer> GetDealerList(ParaDealerFilter filter);
/// <summary> /// 创建分销商预存款往来账明细 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>分销商预存款往来账明细列表</returns> /// <remarks>2013-09-11 周唐炬 创建</remarks> public abstract Pager <CBDsPrePaymentItem> GetDsPrePaymentItemList(ParaDealerFilter filter);
