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