/// <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);