/// <summary> /// 查询可退换货升舱订单 /// </summary> /// <param name="param">订单查询参数</param> /// <returns>第三方订单实体分页数据</returns> /// <remarks>2014-1-8 黄志勇 代码规范</remarks> public Result <PagedList <UpGradeOrder> > GetCanRmaOrderList(MallOrderParameters param) { Pager <CBDsOrder> dsOrders; var filter = new ParaDsOrderFilter { 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 }; dsOrders = Hyt.BLL.MallSeller.DsOrderBo.Instance.QueryForRma(filter); var list = new List <UpGradeOrder>(); foreach (var order in dsOrders.Rows) { var mallOrderInfo = new UpGradeOrder { HytOrderDealer = new HytOrderDealerInfo { HytOrderTime = order.UpgradeTime, LogisticsTime = order.DeliveryTime, DsOrderSysNo = order.SysNo, HytPayStatus = order.PayStatus, DeliveryStatus = order.Status.ToString(), HytPayTime = order.PayTime }, MallOrderBuyer = new MallOrderBuyerInfo { MallOrderId = order.MallOrderId, BuyerNick = order.BuyerNick }, MallOrderPayment = new MallOrderPaymentInfo(), MallOrderReceive = new MallOrderReceiveInfo() }; list.Add(mallOrderInfo); } var result = new Result <PagedList <UpGradeOrder> > { Data = new PagedList <UpGradeOrder> { TotalItemCount = dsOrders.TotalRows, CurrentPageIndex = dsOrders.CurrentPage, TData = list }, Status = true }; return(result); }
/// <summary> /// 获取经销商升舱订单 /// </summary> /// <returns>2017-8-21 罗熙 创建</returns> public override void GetDealerOrder(ref Pager <DsOrder> pager, ParaDsOrderFilter dsDetail) { using (var _context = Context.UseSharedConnection(true)) { var sqlWhere = " 1=1 "; if (dsDetail.status != 0) { sqlWhere += " and Status=@Status"; } if (dsDetail.MallOrderId != "") { sqlWhere += " and MallOrderId=@MallOrderId"; } //select dm.ShopName,dso.* from DsDealerMall dm,DsOrder dso where dm.SysNo=dso.DealerMallSysNo and dso.[Status] = 10 pager.Rows = _context.Select <DsOrder>("*").From("DsOrder").Where(sqlWhere).Parameter("Status", dsDetail.status).Parameter("MallOrderId", dsDetail.MallOrderId).OrderBy("SysNo desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany(); pager.TotalRows = _context.Select <int>("count(1)").From("DsOrder").Where(sqlWhere).Parameter("Status", dsDetail.status).Parameter("MallOrderId", dsDetail.MallOrderId).QuerySingle(); pager.IdRows = _context.Select <int>("SysNo").From("DsOrder").Where(sqlWhere).Parameter("Status", dsDetail.status).Parameter("MallOrderId", dsDetail.MallOrderId).QueryMany(); } }
/// <summary> /// 查询可退换货升舱订单 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-26 朱成果 创建</remarks> public Pager <CBDsOrder> QueryForRma(ParaDsOrderFilter filter) { return(IDsOrderDao.Instance.QueryForRma(filter)); }
public Pager <CBDsOrder> GetPagerSuccessedList(ParaDsOrderFilter filter) { filter.HytOrderStatus = (int)Model.WorkflowStatus.OrderStatus.销售单状态.已完成; return(IDsOrderDao.Instance.Query(filter)); }
/// <summary> /// 升舱订单分页 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-03 朱家宏 创建</remarks> public Pager <CBDsOrder> GetPagerList(ParaDsOrderFilter filter) { return(IDsOrderDao.Instance.Query(filter)); }
/// <summary> /// 获取经销商升舱信息 /// </summary> /// <param name="pager">升舱信息查询列表</param> /// <param name="dsDetail">动态条件</param> /// <remarks>2017-8-23 罗熙 创建</remarks> public void GetDealerOrder(ref Pager <DsOrder> pager, ParaDsOrderFilter dsDetail) { IDsSpecialPriceDao.Instance.GetDealerOrder(ref pager, dsDetail); }
/// <summary> /// 查询可退换货升舱订单 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-26 朱成果 创建</remarks> public abstract Pager <CBDsOrder> QueryForRma(ParaDsOrderFilter filter);
/// <summary> /// 经销商升舱订单 /// </summary> /// <returns>2017-8-21 罗熙 创建</returns> public abstract void GetDealerOrder(ref Pager <DsOrder> pager, ParaDsOrderFilter dsDetail);
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-03 朱家宏 创建</remarks> /// <remarks>2013-10-15 黄志勇 修改</remarks> public override Pager <CBDsOrder> Query(ParaDsOrderFilter filter) { string sql = @"DsOrder a left join soOrder b on a.OrderTransactionSysNo = b.transactionsysno left join SoReceiveAddress c on b.receiveaddresssysno=c.sysno where {0} "; #region 构造sql var paras = new ArrayList(); var where = "1=1 "; int i = 0; if (filter.DealerMallSysNo != null) { where += " and a.DealerMallSysNo=@p0p" + i; paras.Add(filter.DealerMallSysNo); i++; } if (!string.IsNullOrWhiteSpace(filter.BuyerNick)) { where += " and charindex(a.buyernick,@p0p" + i + ")>0"; paras.Add(filter.BuyerNick); i++; } if (!string.IsNullOrWhiteSpace(filter.MallOrderId)) { where += " and a.MallOrderID=@p0p" + i; paras.Add(filter.MallOrderId); i++; } if (filter.BeginDate.HasValue) { where += " and a.UpgradeTime>=@p0p" + i; paras.Add(filter.BeginDate); i++; } if (filter.EndDate.HasValue) { where += " and a.UpgradeTime<@p0p" + i; paras.Add(filter.EndDate); i++; } if (!string.IsNullOrWhiteSpace(filter.MallProductName)) { //商品名称 where += @" and exists ( select 1 from DsOrderItem tmp where tmp.DsOrderSysNo=a.sysNo and charindex(tmp.MallProductName,:MallProductName)>0 union all select 1 from DsOrderItem t1 inner join DsOrderItemAssociation t2 on t1.SysNo = t2.DsOrderItemSysNo inner join SoOrderItem t3 on t2.SoOrderItemSysNo = t3.SysNo where t1.DsOrderSysNo=a.sysNo and charindex(t3.ProductName,@p0p" + i + @")>0 )"; paras.Add(filter.MallProductName); i++; } if (!string.IsNullOrWhiteSpace(filter.MallProductId)) { where += " and exists (select 1 from DsOrderItem tmp where tmp.DsOrderSysNo=a.sysNo and tmp.MallProductId=@p0p" + i + ")"; paras.Add(filter.MallProductId); i++; } if (filter.HytOrderStatus != null) { where += " and a.Status=@p0p" + i; paras.Add(filter.HytOrderStatus); i++; } if (filter.OrderSysNo != null) { where += " and b.Sysno=@p0p" + i; paras.Add(filter.OrderSysNo); i++; } if (!string.IsNullOrWhiteSpace(filter.ReceiveName)) { where += " and c.Name like @p0p" + i; paras.Add("%" + filter.ReceiveName + "%"); i++; } if (!string.IsNullOrWhiteSpace(filter.MobilePhoneNumber)) { where += " and c.MobilePhoneNumber= @p0p" + i; paras.Add(filter.MobilePhoneNumber); i++; } sql = string.Format(sql, where); #endregion var dataList = Context.Select <CBDsOrder>("a.*,b.PayStatus,b.Sysno as OrderSysNo").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsOrder> { PageSize = filter.PageSize, CurrentPage = filter.PageIndex, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("a.sysNo desc").Paging(filter.PageIndex, filter.PageSize).QueryMany() }; return(pager); }
/// <summary> /// 查询可退换货升舱订单 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2013-09-26 朱成果 创建</remarks> public override Pager <CBDsOrder> QueryForRma(ParaDsOrderFilter filter) { const string sql = @"( select a.*,b.PayStatus from DsOrder a inner join soOrder b on a.OrderTransactionSysNo = b.transactionsysno inner join ( select distinct m.ordersysno from WhStockOutItem m inner join WhStockOut p on p.sysno=m.stockoutsysno left outer join ( select n.stockoutitemsysno,n.rmaquantity from RcReturn k inner join RcReturnItem n on n.returnsysno=k.sysno where k.status<>-10 ) r on m.sysno=r.stockoutitemsysno where p.Status=60 group by m.ordersysno,m.sysno,m.productquantity having m.productquantity-isnull(sum(r.rmaquantity),0)>0 ) rtb on rtb.ordersysno=b.sysno where 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.UpgradeTime>=@3) and --日期(起) (@4 is null or a.UpgradeTime<@4) and --日期(止) (@5 is null or exists (select 1 from DsOrderItem tmp where tmp.DsOrderSysNo=a.sysNo and charindex(tmp.MallProductName,@5)>0 union all select 1 from DsOrderItem t1 inner join DsOrderItemAssociation t2 on t1.SysNo = t2.DsOrderItemSysNo inner join SoOrderItem t3 on t2.SoOrderItemSysNo = t3.SysNo where t1.DsOrderSysNo=a.sysNo and charindex(t3.ProductName,@5)>0 )) and --商品名称 (@6 is null or exists (select 1 from DsOrderItem tmp where tmp.DsOrderSysNo=a.sysNo and tmp.MallProductId=@6)) and --商品编号 (@7 is null or b.Status=@7) ) tb"; var paras = new object[] { filter.DealerMallSysNo, filter.BuyerNick, filter.MallOrderId, filter.BeginDate, filter.EndDate, filter.MallProductName, filter.MallProductId, filter.HytOrderStatus }; var dataList = Context.Select <CBDsOrder>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsOrder> { PageSize = filter.PageSize, CurrentPage = filter.PageIndex, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.PageIndex, filter.PageSize).QueryMany() }; return(pager); }