/// <summary>
/// 返利记录信息
/// </summary>
/// <param name="filter">返利记录信息</param>
/// <returns>返回返利记录信息</returns>
/// <remarks>2015-09-15 王耀发 创建</remarks>
public override IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter)
{
string sqlWhere = "1=1";
if (filter.OrderSysNo > 0)
{
sqlWhere += " and a.OrderSysNo = @OrderSysNo";
}
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and rd.SysNo = @DealerSysNo";
}
else
{
sqlWhere += " and rd.CreatedBy = @DealerCreatedBy";
}
}
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and rd.SysNo = @SelectedDealerSysNo";
}
string sql = @"select a.*, b.Account as RecommendAccount,b.Name as RecommendName,c.Account as ComplyAccount,c.Name as ComplyName,rd.DealerName as RDealerName
from CrCustomerRebatesRecord a left join CrCustomer b on a.RecommendSysNo = b.SysNo
left join CrCustomer c on a.ComplySysNo = c.SysNo
left join DsDealer rd on b.DealerSysNo = rd.SysNo
where " + sqlWhere;
var items = Context.Sql(sql)
.Parameter("OrderSysNo", filter.OrderSysNo)
.Parameter("DealerSysNo", filter.DealerSysNo)
.Parameter("DealerCreatedBy", filter.DealerCreatedBy)
.Parameter("SelectedDealerSysNo", filter.SelectedDealerSysNo)
.QueryMany <CBDsDealerRebatesRecord>();
return(items);
}
/// <summary>
/// 返利记录信息
/// </summary>
/// <param name="filter">返利记录信息</param>
/// <returns>返回返利记录信息</returns>
/// <remarks>2015-09-15 王耀发 创建</remarks>
public IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter)
{
return(IDsDealerRebatesRecordDao.Instance.GetDsDealerRebatesRecordView(filter));
}
/// <summary>
/// 分页获取返利记录
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>分页列表</returns>
/// <remarks>2015-08-06 王耀发 创建</remarks>
public Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter)
{
return(IDsDealerRebatesRecordDao.Instance.GetDsDealerRebatesRecordList(filter));
}
/// <summary> /// 返利记录信息 /// </summary> /// <param name="filter">返利记录信息</param> /// <returns>返回返利记录信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public abstract IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter);
/// <summary> /// 获取返利记录列表 /// </summary> /// <param name="sysNo">返利记录系统编号</param> /// <returns>返利记录列表</returns> /// <remarks>2015-08-30 王耀发 创建</remarks> public abstract Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter);
/// <summary>
/// 返利记录信息
/// </summary>
/// <param name="filter">返利记录信息</param>
/// <returns>返回返利记录信息</returns>
/// <remarks>2015-09-15 王耀发 创建</remarks>
public override Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter)
{
string sqlWhere = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and rd.SysNo = " + filter.DealerSysNo;
}
else
{
sqlWhere += " and rd.CreatedBy = " + filter.DealerCreatedBy;
}
}
if (filter.SelectedAgentSysNo != -1)
{
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and rd.SysNo = " + filter.SelectedDealerSysNo;
}
else
{
sqlWhere += " and rd.CreatedBy = " + filter.SelectedAgentSysNo;
}
}
///订单数据不为空的时候
if (!string.IsNullOrEmpty(filter.Condition))
{
sqlWhere += " and (c.Name like '%" + filter.Condition.Replace("\'", "") + "%' or b.Name like '%" + filter.Condition.Replace("\'", "") + "%' or Convert(varchar(50), a.OrderSysNo) = '" + filter.Condition.Replace("\'", "")
+ "' or c.Account like '%" + filter.Condition.Replace("\'", "") + "%' or b.Account like '%" + filter.Condition.Replace("\'", "") + "%' ) ";
}
if (!string.IsNullOrEmpty(filter.RebatesType))
{
sqlWhere += " and ( a.Genre = '" + filter.RebatesType + "' ) ";
}
string sql = @"(select a.*, b.Account as RecommendAccount,b.Name as RecommendName,c.Account as ComplyAccount,c.Name as ComplyName,rd.DealerName as RDealerName
from CrCustomerRebatesRecord a left join CrCustomer b on a.RecommendSysNo = b.SysNo
left join CrCustomer c on a.ComplySysNo = c.SysNo
left join SoOrder so on a.OrderSysNo=so.SysNo
left join DsDealer rd on so.DealerSysNo = rd.SysNo
where
" + sqlWhere + " ) tb";
var dataList = Context.Select <CBDsDealerRebatesRecord>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
//var paras = new object[]
// {
// filter.OrderSysNo,
// filter.OrderSysNo
// };
//dataList.Parameters(paras);
//dataCount.Parameters(paras);
var pager = new Pager <CBDsDealerRebatesRecord>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.OrderSysNo desc,tb.RebatesTime desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
