/// <summary>
/// 后台首页
/// </summary>
/// <returns>后台首页</returns>
/// <remarks>2013-09-16 苟治国 创建</remarks>
public ActionResult Default()
{
//统计信息
var filter = new ParaIsDealerFilter {
};
//当前用户对应分销商，2015-12-19 王耀发 创建
if (CurrentUser.IsBindDealer)
{
filter.DealerSysNo = CurrentUser.Dealer.SysNo;
filter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
filter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
filter.DealerCreatedBy = CurrentUser.Base.SysNo;
ViewBag.TotalInfo = BLL.Order.SoOrderBo.Instance.GetOrderTotalInfo(filter);
return(View());
}
/// <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);
}
/// <summary>
/// 根据条件获取会员列表
/// </summary>
/// <param name="pageIndex">分页索引</param>
/// <param name="status">会员状态</param>
/// <param name="levelSysNo">级别</param>
/// <param name="emailStatus">邮箱状态</param>
/// <param name="mobilePhoneStatus">手机状态</param>
/// <param name="isReceiveEmail">是否接收邮</param>
/// <param name="isReceiveShortMessage">是否接收短信</param>
/// <param name="isPublicAccount">是否是公共账户</param>
/// <param name="isLevelFixed">等级是否固定</param>
/// <param name="isExperiencePointFixed">经验积分是否固定</param>
/// <param name="isExperienceCoinFixed">惠源币是否固定</param>
/// <param name="account">会员手机号</param>
/// <param name="filte">会员经销商 王耀发 2016-2-17 创建</param>
/// <returns>会员列表</returns>
/// <remarks>2013－07-15 苟治国 创建</remarks>
public PagedList <CBCrCustomer> Seach(int pageIndex, int?status, int?levelSysNo, int?emailStatus, int?mobilePhoneStatus, int?isReceiveEmail, int?isReceiveShortMessage, int?isPublicAccount, int?isLevelFixed, int?isExperiencePointFixed, int?isExperienceCoinFixed, string account = null, ParaIsDealerFilter filte = null, int SellBusinessGradeId = -1)
{
#region 赋初值
if (status == null)
{
status = -1;
}
if (levelSysNo == null)
{
levelSysNo = -1;
}
if (emailStatus == null)
{
emailStatus = -1;
}
if (mobilePhoneStatus == null)
{
mobilePhoneStatus = -1;
}
if (isReceiveEmail == null)
{
isReceiveEmail = -1;
}
if (isReceiveShortMessage == null)
{
isReceiveShortMessage = -1;
}
if (isPublicAccount == null)
{
isPublicAccount = -1;
}
if (isLevelFixed == null)
{
isLevelFixed = -1;
}
if (isExperiencePointFixed == null)
{
isExperiencePointFixed = -1;
}
if (isExperienceCoinFixed == null)
{
isExperienceCoinFixed = -1;
}
#endregion
var list = new PagedList <CBCrCustomer>();
var pager = new Pager <CBCrCustomer>();
pager.CurrentPage = pageIndex;
pager.PageFilter = new CBCrCustomer
{
Status = (int)status,
LevelSysNo = (int)levelSysNo,
EmailStatus = (int)emailStatus,
MobilePhoneStatus = (int)mobilePhoneStatus,
IsReceiveEmail = (int)isReceiveEmail,
IsReceiveShortMessage = (int)isReceiveShortMessage,
IsPublicAccount = (int)isPublicAccount,
IsLevelFixed = (int)isLevelFixed,
IsExperiencePointFixed = (int)isExperiencePointFixed,
IsExperienceCoinFixed = (int)isExperienceCoinFixed,
Account = account,
IsBindDealer = filte.IsBindAllDealer,
IsBindAllDealer = filte.IsBindAllDealer,
DealerCreatedBy = filte.DealerCreatedBy,
DealerSysNo = filte.DealerSysNo,
SelectedAgentSysNo = filte.SelectedAgentSysNo,
SelectedDealerSysNo = filte.SelectedDealerSysNo,
SellBusinessGradeId = SellBusinessGradeId
};
pager.PageSize = list.PageSize;
pager = Hyt.DataAccess.CRM.ICrCustomerDao.Instance.Seach(pager);
return(pager.Map());
}
