Example #1
0
        public Report(string reportid)
        {
            this.reportid = reportid;
            report        = (JObject)Client.reports[reportid];
            name          = report["name"].ToString();
            moduleid      = report["moduleid"].ToString();
            module        = new ExcelModule((JObject)Client.modules[moduleid]);
            string[] index;
            switch (report["ranges"].ToString())
            {
            case "0":
                ranges        = module.ranges;
                range_indexes = new string[ranges.Length];

                for (int i = 0; i < ranges.Length; i++)
                {
                    range_indexes[i] = (i + 1).ToString();
                }

                break;

            case "ALL":
                ranges        = module.ranges;
                range_indexes = new string[ranges.Length];

                for (int i = 0; i < ranges.Length; i++)
                {
                    range_indexes[i] = (i + 1).ToString();
                }

                break;

            default:
                index = report["ranges"].ToString().Split('|');
                index.CopyTo(range_indexes, 0);
                ranges = new JObject[index.Length];
                for (int i = 0; i < ranges.Length; i++)
                {
                    ranges[i] = module.ranges[Convert.ToInt32(index[i]) - 1];
                }
                break;
            }
            ranges_count = ranges.Length;
        }
Example #2
0
        public Boolean csvfinished    = false; //csv是否创建完成
        public Range(ExcelModule module, int id)
        {
            this.module     = module;
            rangename       = module.ranges[id]["name"].ToString();
            sheetname       = module.ranges[id]["sheetname"].ToString();
            startrow        = Convert.ToInt32(module.ranges[id]["startrow"].ToString());
            startcol        = Convert.ToInt32(module.ranges[id]["startcol"].ToString());
            dims            = module.ranges[id]["dims"].ToString().Split(',');
            fields          = module.ranges[id]["fields"].ToString().Split(',');
            sourcetype      = module.ranges[id]["sourcetype"].ToString();
            campaign_models = module.ranges[id]["campaign_models"].ToString();
            switch (sourcetype)
            {
            case "zuanshi":
                sourcetable = new Zuanshitable(this);
                break;

            case "subway":
                sourcetable = new Subwaytable(this);
                break;

            case "shop":
                sourcetable = new SYCMSHOPtable(this);
                break;

            case "item":
                sourcetable = new SYCMITEMtable(this);
                break;

            case "ordersinfo":
                sourcetable = new Orderstable(this);
                break;

            default:
                sourcetable = new Sourcetable(this);
                break;
            }
        }