Exemplo n.º 1
0
        /// <summary>
        /// 数据检索
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        protected override IQueryable<Cmaddress> CreateQueryable(GetCmaddressPageInput input)
        {
            IQueryable<Cmaddress> queryable = base.CreateQueryable(input);

            queryable = queryable.WhereIf(input.Id !=null, t => t.Id == input.Id).AsQueryable();

            queryable = queryable.WhereIf(input.AddressName !=null, t => t.AddressName == input.AddressName).AsQueryable();

            queryable = queryable.WhereIf(input.AddressCategory !=null, t => t.AddressCategory == input.AddressCategory).AsQueryable();

            queryable = queryable.WhereIf(input.IsActive !=null, t => t.IsActive == input.IsActive).AsQueryable();

            queryable = queryable.WhereIf(input.IsDeleted !=null, t => t.IsDeleted == input.IsDeleted).AsQueryable();

            queryable = queryable.WhereIf(input.IsPointClosedWall !=null, t => t.IsPointClosedWall == input.IsPointClosedWall).AsQueryable();

            queryable = queryable.WhereIf(input.IsChangeDrainage !=null, t => t.IsChangeDrainage == input.IsChangeDrainage).AsQueryable();

            queryable = queryable.WhereIf(input.IsChangeGas !=null, t => t.IsChangeGas == input.IsChangeGas).AsQueryable();

            queryable = queryable.WhereIf(input.DuctType !=null, t => t.DuctType == input.DuctType).AsQueryable();

            queryable = queryable.WhereIf(input.CreationTime.HasValue, t => t.CreationTime == input.CreationTime.Value).AsQueryable();

            queryable = queryable.WhereIf(input.CollectionTime.HasValue, t => t.CollectionTime == input.CollectionTime.Value).AsQueryable();

            return queryable;
        }
Exemplo n.º 2
0
        /// <summary>
        /// 数据检索
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        protected override IQueryable <Cmaddress> CreateQueryable(GetCmaddressPageInput input)
        {
            IQueryable <Cmaddress> queryable = base.CreateQueryable(input);

            queryable = queryable.WhereIf(input.Id != null, t => t.Id == input.Id).AsQueryable();


            queryable = queryable.WhereIf(input.AddressName != null, t => t.AddressName == input.AddressName).AsQueryable();


            queryable = queryable.WhereIf(input.AddressCategory != null, t => t.AddressCategory == input.AddressCategory).AsQueryable();


            queryable = queryable.WhereIf(input.IsActive != null, t => t.IsActive == input.IsActive).AsQueryable();


            queryable = queryable.WhereIf(input.IsDeleted != null, t => t.IsDeleted == input.IsDeleted).AsQueryable();


            queryable = queryable.WhereIf(input.IsPointClosedWall != null, t => t.IsPointClosedWall == input.IsPointClosedWall).AsQueryable();


            queryable = queryable.WhereIf(input.IsChangeDrainage != null, t => t.IsChangeDrainage == input.IsChangeDrainage).AsQueryable();


            queryable = queryable.WhereIf(input.IsChangeGas != null, t => t.IsChangeGas == input.IsChangeGas).AsQueryable();


            queryable = queryable.WhereIf(input.DuctType != null, t => t.DuctType == input.DuctType).AsQueryable();

            queryable = queryable.WhereIf(input.CreationTime.HasValue, t => t.CreationTime == input.CreationTime.Value).AsQueryable();

            queryable = queryable.WhereIf(input.CollectionTime.HasValue, t => t.CollectionTime == input.CollectionTime.Value).AsQueryable();

            return(queryable);
        }