Beispiel #1
0
        /// <summary>
        /// 查询积分订单
        /// </summary>
        /// <param name="entity">参数:实体</param>
        /// <param name="pageIndex">参数:当前页</param>
        /// <param name="pageSize">参数:分页个数</param>
        /// <param name="rowCount">参数:数据集的总数</param>
        /// <returns></returns>
        public OrderIntegralEntity[] GetList(OrderIntegralEntity entity, int pageIndex, int pageSize, out int rowCount)
        {
            List <IWhereCondition> wheres = new List <IWhereCondition>();

            if (entity != null && !string.IsNullOrEmpty(entity.item_code))
            {
                wheres.Add(new LikeCondition()
                {
                    FieldName = "ti.item_code", HasLeftFuzzMatching = true, HasRightFuzzMathing = true, Value = entity.item_code
                });
            }
            if (entity != null && !string.IsNullOrEmpty(entity.item_name))
            {
                wheres.Add(new LikeCondition()
                {
                    FieldName = "ti.item_name", HasLeftFuzzMatching = true, HasRightFuzzMathing = true, Value = entity.item_name
                });
            }
            if (entity != null && !string.IsNullOrEmpty(entity.VipName))
            {
                wheres.Add(new LikeCondition()
                {
                    FieldName = "vp.VipName", HasLeftFuzzMatching = true, HasRightFuzzMathing = true, Value = entity.VipName
                });
            }

            List <OrderBy> orderbys = new List <OrderBy>();

            orderbys.Add(new OrderBy()
            {
                FieldName = "[CreateTime]", Direction = OrderByDirections.Desc
            });

            PagedQueryResult <OrderIntegralEntity> pEntity = new OrderIntegralDAO(this.CurrentUserInfo).GetList(wheres.ToArray(), orderbys.ToArray(), pageIndex, pageSize);

            rowCount = pEntity.RowCount;
            return(pEntity.Entities);
        }
 /// <summary>
 /// 构造函数
 /// </summary>
 public OrderIntegralBLL(LoggingSessionInfo pUserInfo)
 {
     this.CurrentUserInfo = pUserInfo;
     this._currentDAO     = new OrderIntegralDAO(pUserInfo);
 }