TXT LeaRun.WebApp/Resource/Document/Email/20141016/281df26a-cf92-4929-8a73-66d4ec6ad46a.txt

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

                                              
                                              --收件
                                              SELECT    CASE DATEDIFF(day,
                                                              SendDate,
                                                              GETDATE())
                                                          WHEN 0 THEN '今天'
                                                          WHEN 1 THEN '昨天'
                                                          ELSE '更早'
                                                        END AS DateArea ,
                                                        CASE DATEDIFF(day,
                                                              SendDate,
                                                              GETDATE())
                                                          WHEN 0 THEN 0
                                                          WHEN 1 THEN 1
                                                          ELSE 2
                                                        END AS sort ,
                                                        e.EmailId ,
                                                        '2' AS datatype ,
                                                        e.Theme ,
                                                        e.ThemeColour ,
                                                        e.Addresser ,
                                                        e.SendDate ,
                                                        ISNULL(e.IsAccessory,
                                                              0) AS IsAccessory ,
                                                        1 AS IsRead ,
                                                        0 AS EmailCnt ,
                                                        0 AS UnRead ,
                                                        e.Priority ,
                                                        e.State
                                              FROM      Base_Email e
                                                        INNER JOIN dbo.Base_EmailAddressee a ON e.EmailId = a.EmailId
                                              WHERE     1 = 1
                                                        AND a.AddresseeId = @UserId
                                                        AND a.DeleteMark = 0
                                              UNION
                                              SELECT    DateArea ,
                                                        sort ,
                                                        '' AS EmailId ,
                                                        '1' AS datatype ,
                                                        '' AS Theme ,
                                                        '' AS ThemeColour ,
                                                        '' AS Addresser ,
                                                        '' AS SendDate ,
                                                        0 AS IsAccessory ,
                                                        0 AS IsRead ,
                                                        COUNT(1) AS EmailCnt ,
                                                        SUM(1
                                                            - ISNULL(IsReaded,
                                                              0)) AS UnRead ,
                                                        0 AS Priority ,
                                                        0 AS State
                                              FROM      ( SELECT
                                                              CASE DATEDIFF(day,
                                                              SendDate,
                                                              GETDATE())
                                                              WHEN 0 THEN '今天'
                                                              WHEN 1 THEN '昨天'
                                                              ELSE '更早'
                                                              END AS DateArea ,