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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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

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

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


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

            return(queryable);
        }