C# (CSharp) Hyt.Model.WorkflowStatus.DistributionStatus.升舱订单状态 примеры использования

Пример #1

Файл: IDsOrderDao.cs Проект: KqSMea8/HS.Admin

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

Пример #2

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

Пример #3

Файл: DsOrderDaoImpl.cs Проект: KqSMea8/HS.Admin

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