/// <summary>
/// 退换货单统计
/// </summary>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="filter">分销商权限信息</param>
/// <param name="infomation">信息对象</param>
/// <returns>统计数据</returns>
/// <remarks>2013-09-26 邵斌 创建</remarks>
public abstract CBDefaultPageCountInfo GetTodayRMATotalInformation(System.DateTime startTime,
System.DateTime endTime,
ParaIsDealerFilter filter,
ref CBDefaultPageCountInfo infomation);
/// <summary>
/// 退换货单统计
/// </summary>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="filter">分销商权限信息</param>
/// <param name="infomation">信息对象</param>
/// <returns>统计数据</returns>
/// <remarks>2013-09-26 邵斌 创建</remarks>
public override CBDefaultPageCountInfo GetTodayRMATotalInformation(System.DateTime startTime, System.DateTime endTime, ParaIsDealerFilter filter, ref CBDefaultPageCountInfo infomation)
{
//待审核退换货单
//var where = "where a.status<>@status and a.createdate between @startTime and @endTime";
var where = "where r.status=@status";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
where += " and dea.SysNo = " + filter.DealerSysNo;
}
else
{
where += " and dea.CreatedBy = " + filter.DealerCreatedBy;
}
}
var sql = @"select count(r.sysno) as RequiredAuidtRMAOrderCount from RcReturn r left join SoOrder a on r.OrderSysNo = a.SysNo
left join DsDealer dea on a.DealerSysNo = dea.SysNo " + where;
infomation.RequiredAuidtRMAOrderCount = Context.Sql(sql)
.Parameter("status", (int)OrderStatus.销售单状态.待审核)
//.Parameter("startTime", startTime)
//.Parameter("endTime", endTime)
.QuerySingle <int>();
return(infomation);
}
