コード例 #1
0
        public List <object[]> getAxisLabel(List <dropdown_list> skus, Helpers.Helpers.AxisType axisType)
        {
            List <object[]> listData = new List <object[]>();

            foreach (dropdown_list s in skus)
            {
                object[] values = new object[2];
                values[0] = s.description;
                values[1] = 0;
                listData.Add(values);
            }
            return(listData);
        }
コード例 #2
0
ファイル: ReportController.cs プロジェクト: hongyangus/test
        public List <object[]> getAxisLabel(string drillDownLevelID, DateTime start_date, DateTime end_date, DateTime startOfWeek, Helpers.Helpers.AxisType axisType)
        {
            List <object[]> listData = new List <object[]>();

            switch (drillDownLevelID)
            {
            //group by daily
            case "1":
                while (start_date <= end_date)
                {
                    object[] values = new object[2];
                    values[0] = getLabelName(drillDownLevelID, start_date, 0, 0, 0, 0);
                    values[1] = 0;
                    listData.Add(values);
                    start_date = start_date.AddDays(1);
                }
                break;

            //group by weekly
            case "2":
                int startWeek = 1;
                while (startOfWeek <= end_date)
                {
                    object[] values = new object[2];
                    // pull out week
                    values[0] = getLabelName(drillDownLevelID, start_date, startWeek, 0, 0, 0);
                    values[1] = 0;
                    listData.Add(values);

                    startOfWeek = startOfWeek.AddDays(7);
                    startWeek  += 1;
                }
                break;

            //group by monthly
            case "3":
                start_date = new DateTime(start_date.Year, start_date.Month, 1);
                while (start_date <= end_date)
                {
                    object[] values = new object[2];
                    // pull out month and year
                    values[0] = getLabelName(drillDownLevelID, start_date, 0, start_date.Month, 0, start_date.Year);
                    values[1] = 0;
                    listData.Add(values);
                    start_date = start_date.AddMonths(1);
                }
                break;

            //group by quarterly
            case "4":
                start_date = new DateTime(start_date.Year, start_date.Month, 1).AddMonths(6);
                end_date   = end_date.AddMonths(6);
                while (start_date <= end_date)
                {
                    object[] values = new object[2];
                    // pull out month and year
                    values[0] = getLabelName(drillDownLevelID, start_date, 0, 0, (int)Math.Ceiling(start_date.Month / 3.0), start_date.Year);
                    values[1] = 0;
                    listData.Add(values);
                    start_date = start_date.AddMonths(3);
                }
                break;

            default:
                break;
            }
            return(listData);
        }