MVC经典后台管理系统

--收件 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 , CASE DATEDIFF(day, SendDate, GETDATE()) WHEN 0 THEN 0 WHEN 1 THEN 1 ELSE 2 END AS sort , 1 AS IsReaded FROM Base_Email e INNER JOIN dbo.Base_EmailAddressee a ON e.EmailId = a.EmailId WHERE 1 = 1 AND a.AddresseeId = @UserId AND e.DeleteMark = 0 ) Gorup GROUP BY DateArea , sort -- 已发送 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 WHERE 1 = 1 AND e.CreateUserId = @UserId AND