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

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

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

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

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

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

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

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

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

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

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

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

            queryable = queryable.WhereIf(input.PureFlow !=null, t => t.PureFlow == input.PureFlow).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 <Wsgas> CreateQueryable(GetWsgasPageInput input)
        {
            IQueryable <Wsgas> queryable = base.CreateQueryable(input);

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


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


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


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


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


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


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


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


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


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


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


            queryable = queryable.WhereIf(input.PureFlow != null, t => t.PureFlow == input.PureFlow).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);
        }