/// <summary> /// 分销汇总明细 /// </summary> /// <param name="filter"></param> /// <remarks>2016-07-15 周 创建</remarks> public abstract Pager <CBCCustomerRebatesRecord> GetDealerInfoSummaryList(ParaCBCCustomerRebatesRecordFilter filter);
/// <summary>
/// 分销汇总明细
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public Pager <CBCCustomerRebatesRecord> GetDealerInfoSummaryList(ParaCBCCustomerRebatesRecordFilter filter)
{
return(IDsDealerRebatesRecordDao.Instance.GetDealerInfoSummaryList(filter));
}
/// <summary>
/// 分销汇总明细
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
/// <remarks>2016-07-15 周 创建</remarks>
public override Pager <CBCCustomerRebatesRecord> GetDealerInfoSummaryList(ParaCBCCustomerRebatesRecordFilter filter)
{
string sqlWhere = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and c.DealerSysNo = " + filter.DealerSysNo;
}
else
{
sqlWhere += " and de.CreatedBy = " + filter.DealerCreatedBy;
}
}
if (filter.SelectedAgentSysNo != -1)
{
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and c.DealerSysNo = " + filter.SelectedDealerSysNo;
}
else
{
sqlWhere += " and de.CreatedBy = " + filter.SelectedAgentSysNo;
}
}
if (filter.Account != "" || filter.Account != null)
{
sqlWhere += "and (c.Account like '%" + filter.Account + "%' or c.Name like '%" + filter.Account + "%' or c.NickName like '%" + filter.Account + "%' or substring(Convert(char(10),c.CreatedDate,112),1,8)='" + filter.Account + "' )";
}
string sql = @"(select [dbo].[func_GetCrCustomerOrderCount](c.sysno) as OrderNums,
[dbo].[func_GetRebagesOrderCount](c.sysno) as RebagesOrderCount,
[dbo].[func_GetDistributionGenreCount](c.sysno,1) as DirectCount,
[dbo].[func_GetDistributionGenreCount](c.sysno,2) as Indirect1Count,
[dbo].[func_GetDistributionGenreCount](c.sysno,3) as Indirect2Count,
le.LevelName,le.[Direct],le.[Indirect1],le.Indirect2,de.DealerName,de.CreatedBy as DealerCreatedBy,c.*
from [CrCustomer] c
left join DsDealer de on c.DealerSysNo=de.[SysNo]
left join DsDealerLevel le on le.[SysNo]=de.LevelSysNo
where c.IsSellBusiness=1 and " + sqlWhere + " ) tb";
var dataList = Context.Select <CBCCustomerRebatesRecord>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
//var paras = new object[]
// {
// //filter.Account,
// filter.Account
// };
//dataList.Parameters(paras);
//dataCount.Parameters(paras);
var pager = new Pager <CBCCustomerRebatesRecord>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("RebagesOrderCount desc,OrderNums desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
