/// <summary>
/// 获取经销商退换货订单
/// </summary>
/// <param name="pager"></param>
/// <param name="dsDetail">2017-8-29 罗熙 创建</param>
public override void GetDsRMAorder(ref Pager <DsReturn> pager, ParaDsReturnFilter dsRMADetail)
{
using (var _context = Context.UseSharedConnection(true))
{
var sqlWhere = " 1=1 ";
pager.Rows = _context.Select <DsReturn>("*").From("DsReturn").Where(sqlWhere).Parameter("RmaType", dsRMADetail.RmaType).Parameter("MallOrderId", dsRMADetail.MallOrderId).OrderBy("SysNo desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = _context.Select <int>("count(1)").From("DsReturn").Where(sqlWhere).Parameter("RmaType", dsRMADetail.RmaType).Parameter("MallOrderId", dsRMADetail.MallOrderId).QuerySingle();
pager.IdRows = _context.Select <int>("SysNo").From("DsReturn").Where(sqlWhere).Parameter("RmaType", dsRMADetail.RmaType).Parameter("MallOrderId", dsRMADetail.MallOrderId).QueryMany();
}
}
/// <summary>
/// /// <summary>
/// 获取分销商所有已申请退货订单
/// </summary>
/// <param name="param">查询参数</param>
/// <returns>已申请退货列表</returns>
/// <remarks>2013-8-28 陶辉 创建</remarks>
/// <remarks>2013-09-10 余勇 实现</remarks>
public Result <PagedList <UpGradeRma> > GetMallRmaList(MallRmaParameters param)
{
var filter = new ParaDsReturnFilter
{
PageIndex = param.PageIndex <= 0 ? 1 : param.PageIndex,
PageSize = param.PageSize,
MallProductName = param.ProductName,
MallProductId = param.ProductCode,
MallOrderId = param.OrderId,
BuyerNick = param.BuyerName,
BeginDate = param.StartDate,
EndDate = param.EndDate,
DealerMallSysNo = param.DealerMallSysNo
};
var dsOrders = BLL.MallSeller.DsReturnBo.Instance.GetPagerList(filter);
var list = new List <UpGradeRma>();
foreach (var order in dsOrders.Rows)
{
var mallRmaInfo = new UpGradeRma
{
MallOrderId = order.MallOrderId,
ApplyTime = order.ApplicationTime,
BuyerRmaMessage = order.BuyerRemark,
BuyerRmaReason = order.RmaRemark,
HytRmaStatus = Hyt.Util.EnumUtil.GetDescription(typeof(Hyt.Model.WorkflowStatus.RmaStatus.退换货状态), order.Status),
MallBuyerName = order.BuyerNick,
MallRefundFee = order.MallReturnAmount,
MallRmaId = order.MallReturnId,
MallRmaMessage = "",
MallType = 1,
HytRmaId = order.RcReturnSysNo
};
list.Add(mallRmaInfo);
}
var result = new Result <PagedList <UpGradeRma> >
{
Data = new PagedList <UpGradeRma>
{
TotalItemCount = dsOrders.TotalRows,
CurrentPageIndex = dsOrders.CurrentPage,
TData = list
},
Status = true
};
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2013-09-10 余勇 创建</remarks>
public override Pager <CBDsReturn> Query(ParaDsReturnFilter filter)
{
const string sql = @"(select a.*,b.Status from DsReturn a left join RcReturn b on a.ReturnTransactionSysNo = b.TransactionSysNo
left join soOrder c on b.OrderSysNo = c.SysNo
where a.DealerMallSysNo=@0 and
(@1 is null or charindex(a.buyernick,@1)>0) and
(@2 is null or a.MallOrderID=@2) and
(@3 is null or a.ApplicationTime>=@3) and --日期(起)
(@4 is null or a.ApplicationTime<@4) and --日期(止)
(@5 is null or exists (select 1 from DsReturnItem tmp where tmp.DsReturnSysNo=a.sysNo and charindex(tmp.MallProductName,@5)>0)) and --商品名称
(@6 is null or exists (select 1 from DsReturnItem tmp where tmp.DsReturnSysNo=a.sysNo and tmp.MallProductId=@6)) --商品编号
) tb";
var paras = new object[]
{
filter.DealerMallSysNo,
filter.BuyerNick,
filter.MallOrderId,
filter.BeginDate,
filter.EndDate,
filter.MallProductName,
filter.MallProductId
};
var dataList = Context.Select <CBDsReturn>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBDsReturn>
{
PageSize = filter.PageSize,
CurrentPage = filter.PageIndex,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.PageIndex, filter.PageSize).QueryMany()
};
return(pager);
}
/// <summary>
/// 获取经销商退换货订单
/// </summary>
/// <param name="pager"></param>
/// <param name="dsRMADetail">2017-8-29 罗熙 创建</param>
public void GetDsRMAorder(ref Pager <DsReturn> pager, ParaDsReturnFilter dsRMADetail)
{
IDsSpecialPriceDao.Instance.GetDsRMAorder(ref pager, dsRMADetail);
}
/// <summary>
/// 退货订单分页
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2013-09-10 余勇 创建</remarks>
public Pager <CBDsReturn> GetPagerList(ParaDsReturnFilter filter)
{
return(IDsReturnDao.Instance.Query(filter));
}
/// <summary> /// 经销商退换货订单 /// </summary> /// <param name="pager"></param> /// <param name="dsRMADetail">2017-8-29 罗熙 创建</param> public abstract void GetDsRMAorder(ref Pager <DsReturn> pager, ParaDsReturnFilter dsRMADetail);
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-10 余勇 创建</remarks> public abstract Pager <CBDsReturn> Query(ParaDsReturnFilter filter);
