Пример #1
0
        public static IEnumerable <TimeSeries> GetTimeSeries(IRange DateTimes, IRange Values, string Apart, string Bpart, string Cpart, string Dpart, string Epart, string Fpart)
        {
            var l = new List <TimeSeries>();
            var c = Values.ColumnCount;

            for (int i = 0; i < c; i++)
            {
                var ts = new TimeSeries();
                ts.Times  = RangeToDateTimes(DateTimes);
                ts.Values = RangeToTimeSeriesValues(Values, i);
                if (CheckTimeSeriesType(ts.Times) == RecordType.RegularTimeSeries)
                {
                    ts.Path = new DssPath(Apart, Bpart, Cpart, "", "",
                                          "r" + (i + 1).ToString() + Fpart, RecordType.RegularTimeSeries, "type", "units");
                    ts.Path.Epart = TimeWindow.GetInterval(ts);
                }
                else
                {
                    ts.Path = new DssPath(Apart, Bpart, Cpart, "", "IR-Year",
                                          "r" + (i + 1).ToString() + Fpart, RecordType.IrregularTimeSeries, "type", "units");
                }
                l.Add(ts);
            }

            return(l);
        }
Пример #2
0
        private void GetPath(TimeSeries ts, string worksheet, int column, PathLayout pathLayout)
        {
            ts.Path = new DssPath();
            if (pathLayout == PathLayout.StandardPath)
            {
                ts.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
                ts.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
                ts.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
                ts.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[5, column]);
            }
            else if (pathLayout == PathLayout.PathWithoutDPart)
            {
                ts.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
                ts.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
                ts.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
                ts.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[4, column]);
            }

            if (IsRegular(ts.Times.ToList()))
            {
                ts.Path.Epart = TimeWindow.GetInterval(ts);
            }
            else
            {
                ts.Path.Epart = "IR-Year";
            }
        }
Пример #3
0
        public void TimeIntervalMethodTest()
        {
            DssPath path = new DssPath("/MISSISSIPPI/ST. LOUIS/FLOW//1Day/OBS/");

            using (DssReader r = new DssReader(TestUtility.BasePath + "sample7.dss"))
            {
                var s = TimeWindow.GetInterval(r.GetTimeSeries(path));
                Debug.WriteLine(s);
            }
        }
Пример #4
0
        private void ImportRegularTimeSeries(string destination, string worksheet)
        {
            string fileName = destination;

            File.Delete(fileName);
            TimeSeries ts = GetTimeSeries(worksheet);

            ts.Path       = new DssPath("excel", "import", "plugin", "", "", "regularTimeSeries" + RandomString(3));
            ts.Path.Epart = TimeWindow.GetInterval(ts);
            using (DssWriter w = new DssWriter(fileName))
            {
                w.Write(ts);
            }
        }
Пример #5
0
 private DssPath GetRandomTimeSeriesPath(TimeSeries ts, string worksheet)
 {
     if (IsRegular(ts.Times.ToList()))
     {
         var temp = ts;
         temp.Path = new DssPath("import", Path.GetFileNameWithoutExtension(workbook.FullName), worksheet,
                                 "", "", "regularTimeSeries" + ExcelTools.RandomString(3));
         temp.Path.Epart = TimeWindow.GetInterval(temp);
         return(temp.Path);
     }
     else
     {
         return(new DssPath("import", Path.GetFileNameWithoutExtension(workbook.FullName), worksheet,
                            "", "IR-Year", "irregularTimeSeries" + ExcelTools.RandomString(3)));
     }
 }