提交

username@email.com

3 天以前 e4ee60ed94d24e394a7895daa9fb98df813e5953

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs

@@ -1530,6 +1530,20 @@
        }



        /// <summary>
        /// 根据类型查询 订单
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        public IEnumerable<EC_OrderBasic> GetOrderByPrintTypeId(int PrintTypeId)
        {
            
            IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" PrintTypeId = {0} and OrderState = 4 ", PrintTypeId));
            return result;
        }


        /// <summary>
        /// 根据客户ID和订单支付状态获取订单列表 
        /// </summary>
@@ -1743,6 +1757,46 @@
            }

            return null == result || result.Count == 0 ? null : result[0];
        }


        /// <summary>
        /// 根据编号获取订单信息
        /// </summary>
        /// <param name="orderId">订单唯一编号</param>
        /// <returns></returns>
        public EC_OrderBasic SelectModelByxiadanId(int orderId)
        {
            if (0 >= orderId)
            {
                return null;
            }
            else
            {
            }
            string condition = "  ";
            if (orderId > 0)
            {
                condition = " b.[XiadanKeyid]=" + orderId + "";
            }
            else
            {
                return null;
            }


            try
            {
                IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>("a.*", " EC_OrderBasic a inner join   [EC_OrderExtend] b on a.[Keyid] = b.[Keyid] ", condition) as IList<EC_OrderBasic>;//执行查询

                return (null == result || result.Count == 0) ? null : result[0];//返回结果

            }
            catch (Exception ex)
            {
                throw ex;
            }

        }


@@ -3094,7 +3148,7 @@
                    condition += " and  a.CreateTime >= '" + StartCreatTime.Value + "' ";

                if (EndCreatTime != null)
                    condition += " and  a.CreateTime =< '" + EndCreatTime.Value.AddDays(1) + "' ";
                    condition += " and  a.CreateTime <= '" + EndCreatTime.Value.AddDays(1) + "' ";

                if (StartReturnTime != null)
                    condition += " and  d.DeliverTime >= '" + StartReturnTime.Value + "' ";