FETCH NEXT FROM AddDateList INTO @Partnum , @Revision  

      WHILE @@FETCH_STATUS = 0                                                                         

        BEGIN                                  

                Select @Count = Count(WeekDate) From #WeekConfig

                    Where Partnum = @Partnum  and Revision = @Revision  and WeekDate >= @BDateTime and WeekDate <= @EDateTime

      Select @DateCount = 0

                IF @Count < 7

        Begin

                    While @DateCount < 7  

         Begin

             Select @WeekDate =  convert(datetime, Convert(varchar ,  (@BDateTime + @DateCount), 101))

                   IF Not Exists( Select *  From #WeekConfig

                                                 Where Partnum = @Partnum and Revision = @Revision

                           and  convert(datetime, Convert

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>