/// <summary> /// 根据开始日期获取指定状态的升舱订单 /// </summary> /// <param name="startDate">开始时间</param> /// <param name="endDate">结束时间</param> /// <param name="dearerMallSysNo">商城系统编号</param> /// <param name="status">订单状态</param> /// <returns>订单列表</returns> /// <reamrks>2014-04-08 黄波 创建</reamrks> public abstract List <CBDsOrder> GetSuccessedOrder(DateTime startDate, DateTime endDate, int dearerMallSysNo, Hyt.Model.WorkflowStatus.DistributionStatus.升舱订单状态 status);
/// <summary> /// 锁定对象用户预存款表 /// </summary> //private static object obj = new object(); #region 根据开始日期获取指定状态的升舱订单 /// <summary> /// 根据开始日期获取指定状态的升舱订单 /// </summary> /// <param name="startDate">开始时间</param> /// <param name="endDate">结束时间</param> /// <param name="dearerMallSysNo">商城系统编号</param> /// <param name="status">订单状态</param> /// <returns>订单列表</returns> /// <reamrks>2014-04-08 黄波 创建</reamrks> public List <CBDsOrder> GetSuccessedOrder(DateTime startDate, DateTime endDate, int dearerMallSysNo, Hyt.Model.WorkflowStatus.DistributionStatus.升舱订单状态 status) { return(IDsOrderDao.Instance.GetSuccessedOrder(startDate, endDate, dearerMallSysNo, status)); }
/// <summary> /// 根据开始日期获取指定状态的升舱订单 /// </summary> /// <param name="startDate">开始时间</param> /// <param name="endDate">结束时间</param> /// <param name="dearerMallSysNo">商城系统编号</param> /// <param name="status">订单状态</param> /// <returns>订单列表</returns> /// <reamrks>2014-04-08 黄波 创建</reamrks> public override List <CBDsOrder> GetSuccessedOrder(DateTime startDate, DateTime endDate, int dearerMallSysNo, Hyt.Model.WorkflowStatus.DistributionStatus.升舱订单状态 status) { string sql = @"select t1.*,t6.DeliveryTypeName,t4.ExpressNo from dsorder t1 inner join SoOrder t2 on t1.ordertransactionsysno=t2.transactionsysno left join WhStockOut t3 on t3.ordersysno=t2.sysno and t3.Status<>-10 left join LgDeliveryItem t4 on t4.notetype=10 and t4.notesysno=t3.sysno and t4.Status<>-10 left join LgDelivery t5 on t5.sysno=t4.deliverysysno left join LgDeliveryType t6 on t6.sysno=t5.deliverytypesysno where t1.dealerMallSysNo=@dealerMallSysNo and t1.status=@status and t1.upgradetime>=@startDate and t1.upgradetime<@endDate"; return(Context.Sql(sql) .Parameter("dealerMallSysNo", dearerMallSysNo) .Parameter("status", (int)status) .Parameter("startDate", startDate) .Parameter("endDate", endDate) .QueryMany <CBDsOrder>()); }