时间段报表

  switch (timeQuantum)
            {
                case "year":
                    str = "SELECT  CONVERT(char(4),YEAR(lo.CREATEDATE),21) AS 'CREATEDATE',lo.SYS_NAME, lo.TYPE_NAME,count(*) as 'COUNT' FROM LOG_ELOG lo  ";
                    strGroupBy = " GROUP BY lo.SYS_NAME,lo.TYPE_NAME,CONVERT(char(4),YEAR(lo.CREATEDATE),21) Order By lo.SYS_NAME,Lo.TYPE_NAME,CONVERT(char(4),YEAR(lo.CREATEDATE),21)  ";
                    break;
                case "quarter":
                    str = " SELECT convert(char(4),datepart(year,lo.CREATEDATE),21)+' '+ case datepart(month,DATEADD(qq, DATEDIFF(qq,0,lo.CREATEDATE), 0)) when 1 then '一季度' when 4 then '二季度' when 7 then '三季度' when 10 then '四季度' end AS 'CREATEDATE',lo.SYS_NAME,lo.TYPE_NAME,COUNT(*) AS 'COUNT' FROM LOG_ELOG lo ";
                    strGroupBy = "  GROUP BY lo.SYS_NAME,lo.TYPE_NAME,convert(char(4),datepart(year,lo.CREATEDATE),21)+' '+case datepart(month,DATEADD(qq, DATEDIFF(qq,0,lo.CREATEDATE), 0)) when 1 then '一季度' when 4 then '二季度' when 7 then '三季度' when 10 then '四季度'end  ";
                    break;
                case "month":
                    str = "SELECT  CONVERT(char(4),YEAR(lo.CREATEDATE),21)+'-'+CONVERT(char(2),month(lo.CREATEDATE),21) AS 'CREATEDATE',lo.SYS_NAME, lo.TYPE_NAME,count(*) as 'COUNT' FROM LOG_ELOG lo  ";
                    strGroupBy = " GROUP BY lo.SYS_NAME,lo.TYPE_NAME,CONVERT(char(4),YEAR(lo.CREATEDATE),21)+'-'+CONVERT(char(2),month(lo.CREATEDATE),21)  Order By lo.SYS_NAME,Lo.TYPE_NAME, CONVERT(char(4),YEAR(lo.CREATEDATE),21)+'-'+CONVERT(char(2),MONTH(lo.CREATEDATE),21) ";
                    break;
                case "week":
                    str = " SELECT convert(char(4),datepart(year,lo.CREATEDATE),21)+' '+convert(varchar(2),DATEPART(wk, lo.CREATEDATE))+'周' AS 'CREATEDATE',lo.SYS_NAME, lo.TYPE_NAME,count(*) as 'COUNT' from LOG_ELOG lo ";
                    strGroupBy = " group BY lo.SYS_NAME, lo.TYPE_NAME,convert(char(4),datepart(year,lo.CREATEDATE),21)+' '+convert(varchar(2),DATEPART(wk, lo.CREATEDATE))+'周' ";
                    break;
                case "onlyday":
                    str = " SELECT CONVERT(char(10), lo.CREATEDATE, 21) AS 'CREATEDATE',lo.SYS_NAME,lo.TYPE_NAME,COUNT(*) AS 'COUNT' FROM LOG_ELOG lo ";
                    strGroupBy = " GROUP BY lo.SYS_NAME,lo.TYPE_NAME,CONVERT(char(10), lo.CREATEDATE, 21) ORDER BY lo.SYS_NAME,Lo.TYPE_NAME,CONVERT(char(10), lo.CREATEDATE, 21) ";
                    break;
                case "hour":
                    str = " SELECT CONVERT(char(13), lo.CREATEDATE, 21)+'时' AS 'CREATEDATE',lo.SYS_NAME,lo.TYPE_NAME,COUNT(*) AS 'COUNT' FROM LOG_ELOG lo ";
                    strGroupBy = " GROUP BY lo.SYS_NAME,lo.TYPE_NAME,CONVERT(char(13), lo.CREATEDATE, 21)+'时' ORDER BY lo.SYS_NAME,Lo.TYPE_NAME,CONVERT(char(13), lo.CREATEDATE, 21)+'时' ";
                    break;
            }