查询并计算时间 预计时间 到期时间

  SELECT [GluegunNumber],MAX([a].[CreateDate]) CreateDate INTO #AA  FROM LB_GluegunWash a GROUP BY  [a].[GluegunNumber]  

      SELECT   [t2].*  INTO #BB FROM #AA  t1
      INNER JOIN LB_GluegunWash t2 ON [t2].[GluegunNumber] = [t1].[GluegunNumber] AND [t2].[CreateDate] = [t1].[CreateDate]
 
        --SELECT  DISTINCT [#BB].[GluegunNumber] FROM  #BB
        select b.ProductId '物料编码',b.GluegunName '胶枪名称',b.GluegunModelSpecs '型号规格',
        a.GluegunNumber AS '胶枪条码',c.UserDescription '清洗操作员',
        convert(nvarchar(19),a.CreateDate,120) '时间',  [UC].[UserCodeDescription] AS '周期',
        CONVERT(nvarchar(19),DATEADD(DAY,CAST([UC].[UserCodeDescription]AS INT),a.CreateDate),120)AS '[预]时间',
        --DATEDIFF(DAY,DATEADD(DAY,CAST([UC].[UserCodeDescription]AS INT),a.CreateDate),GETDATE()) 相差天数,
        a.GluegunPJZ_ISOK,a.GluegunZZZ_ISOK,a.GluegunCJ_ISOK,a.[Gluegun7﹡1_ISOK],a.[Gluegun4﹡1_ISOK],a.GluegunFS_ISOK,a.GluegunBigU_ISOK,a.GluegunDT_ISOK,a.GluegunSmallU_ISOK,
        a.GluegunZJLG_ISOK,a.ISCheck,a.ISWash,a.ISRepair,
        CASE  WHEN DATEDIFF(DAY,DATEADD(DAY,CAST([UC].[UserCodeDescription]AS INT),a.CreateDate),GETDATE())>=-3
        AND DATEDIFF(DAY,DATEADD(DAY,CAST([UC].[UserCodeDescription]AS INT),a.CreateDate),GETDATE())<=0  THEN '[RowColor:X4Y0]'
        WHEN DATEDIFF(DAY,DATEADD(DAY,CAST([UC].[UserCodeDescription]AS INT),a.CreateDate),GETDATE())>0 THEN '[RowColor:XFY0]'
        ELSE '' END AS 'ColorControlId'

        from dbo.#BB a
        left join dbo.LB_GluegunReceive b on a.GluegunNumber=b.GluegunNumber
        LEFT JOIN [dbo].[UserCode] AS [UC] ON LEFT([UC]. [UserCodeName],1)=LEFT(a.[GluegunNumber],1)  AND [UC].[ParentUserCodeId]='URC10000030U'
        left join SysUser c on a.Operator=c.UserName
        where 1=1
        AND (CONVERT(date,a.CreateDate)>=@DateS  or ISNULL(@DateS,'')='')
        AND (convert(date,a.CreateDate)<=@DateE  or ISNULL(@DateE,'')='')
        and (a.GluegunNumber=@LotSN or @LotSN='')
        order by a.CreateDate DESC