protected List<Domain.Entity.PushContents> GetAutoPushContentTrueState(
            Infrastructure.Data.Uow.EfRepository<Domain.Entity.AutoPush> autoPushRepository,
            Infrastructure.Data.Uow.EfRepository<Domain.Entity.AutoPushDetail> autoPushdetailRepository,
            Infrastructure.Data.Uow.EfRepository<Domain.Entity.AutoPushTimer> autoPushTimerRepository,
            Infrastructure.Data.Uow.EfRepository<Domain.Entity.PushContents> contentRepository)
        {
            var now = System.DateTime.Now;
            var hour = now.Hour;
            var minute = now.Minute;
            var data = (from auto in autoPushRepository.GetList()
                        join detail in autoPushdetailRepository.GetList() on auto.Id equals detail.AutoPushId
                        join timer in autoPushTimerRepository.GetList() on detail.TimerId equals timer.Id
                        join content in contentRepository.GetList() on auto.ContentId equals content.Id
                        where auto.State == true
                        && (
                            (
                            auto.ExpiredDateTime >= now &&
                            (
                            //9.30-12.30 9.40(在),9.12(不在)
                                (hour == timer.BeginHour && minute >= timer.BeninMinute) ||
                            //9.30-12.30 10.20(在),11.20(在)
                                (hour > timer.BeginHour && hour < timer.EndHour) ||
                            //9.30-12.30 12.30(在),12.40(不在)
                                (hour == timer.EndHour && minute <= timer.EndMinute))
                            ) || (
                            //精确到分就行了，
                            //auto.IntervalTime <= 0 && timer.BeginHour == hour && timer.BeninMinute == minute
                            auto.IntervalTime <= 0 &&
                            //年
                            auto.ExpiredDateTime.Year == now.Year &&
                            //月
                            auto.ExpiredDateTime.Month == now.Month &&
                            //日
                            auto.ExpiredDateTime.Day == now.Day &&
                            //时
                            auto.ExpiredDateTime.Hour == now.Hour &&
                            //分
                            auto.ExpiredDateTime.Minute == now.Minute
                            )
                        )
                        select content).Distinct();

            return data.ToList();
        }

{SELECT 
[Distinct1].[Id] AS [Id], 
[Distinct1].[Content] AS [Content], 
[Distinct1].[ExpiredDateTime] AS [ExpiredDateTime], 
[Distinct1].[AddTime] AS [AddTime], 
[Distinct1].[IpAddress] AS [IpAddress], 
[Distinct1].[State] AS [State], 
[Distinct1].[SortNum] AS [SortNum]
FROM ( SELECT DISTINCT 
    [Extent4].[Id] AS [Id], 
    [Extent4].[Content] AS [Content], 
    [Extent4].[ExpiredDateTime] AS [ExpiredDateTime], 
    [Extent4].[AddTime] AS [AddTime], 
    [Extent4].[IpAddress] AS [IpAddress], 
    [Extent4].[State] AS [State], 
    [Extent4].[SortNum] AS [SortNum]
    FROM   (SELECT [Extent1].[ContentId] AS [ContentId], [Extent1].[IntervalTime] AS [IntervalTime], [Extent1].[ExpiredDateTime] AS [ExpiredDateTime], [Extent3].[BeginHour] AS [BeginHour], [Extent3].[EndHour] AS [EndHour], [Extent3].[BeninMinute] AS [BeninMinute], [Extent3].[EndMinute] AS [EndMinute]
        FROM   [dbo].[AutoPush] AS [Extent1]
        INNER JOIN [dbo].[AutoPushDetail] AS [Extent2] ON [Extent1].[Id] = [Extent2].[AutoPushId]
        INNER JOIN [dbo].[AutoPushTimer] AS [Extent3] ON [Extent2].[TimerId] = [Extent3].[Id]
        WHERE 1 = [Extent1].[State] ) AS [Filter1]
    INNER JOIN [dbo].[PushContents] AS [Extent4] ON [Filter1].[ContentId] = [Extent4].[Id]
    WHERE (([Filter1].[ExpiredDateTime] >= @p__linq__0) AND (((@p__linq__1 = [Filter1].[BeginHour]) AND (@p__linq__2 >= [Filter1].[BeninMinute])) OR ((@p__linq__3 > [Filter1].[BeginHour]) AND (@p__linq__4 < [Filter1].[EndHour])) OR ((@p__linq__5 = [Filter1].[EndHour]) AND (@p__linq__6 <= [Filter1].[EndMinute])))) OR (([Filter1].[IntervalTime] <= 0) AND ((DATEPART (year, [Filter1].[ExpiredDateTime])) = (DATEPART (year, @p__linq__7))) AND ((DATEPART (month, [Filter1].[ExpiredDateTime])) = (DATEPART (month, @p__linq__8))) AND ((DATEPART (day, [Filter1].[ExpiredDateTime])) = (DATEPART (day, @p__linq__9))) AND ((DATEPART (hour, [Filter1].[ExpiredDateTime])) = (DATEPART (hour, @p__linq__10))) AND ((DATEPART (minute, [Filter1].[ExpiredDateTime])) = (DATEPART (minute, @p__linq__11))))
)  AS [Distinct1]}