コード例 #1
0
 public void LoadTargetObjects(TargetObjects targetObjects)
 {
     _devicesWorksheet.AddDevices(targetObjects.Devices);
     _facilitiesWorksheet.AddFacilities(targetObjects.Facilities);
     foreach (var facility in targetObjects.Facilities)
     {
         _facilitiesScheduleWorksheet.AddSchedule(facility.Schedule);
     }
 }
コード例 #2
0
        public void Run()
        {
            var ts               = DateTime.Now;
            var baseFileName     = String.Format("{0}-{1:00}{2:00}-{3:00}{4:00}{5:00}", ts.Year, ts.Month, ts.Day, ts.Hour, ts.Minute, ts.Second);
            var fileName         = baseFileName;
            var cwd              = Directory.GetCurrentDirectory();
            var templateFilePath = $"{cwd}/Template.xlsx";

            int numDevices    = 0;
            int numFacilities = 0;

            Console.WriteLine($"Generating import document:");
            if (_options.FacilityGroupSpecifiers != null)
            {
                Console.WriteLine($" Facility Groups:");
                foreach (var facilityGroupSpec in _options.FacilityGroupSpecifiers)
                {
                    numFacilities += facilityGroupSpec.NumFacilities;
                    numDevices    += facilityGroupSpec.NumDevices * facilityGroupSpec.NumFacilities;
                    Console.WriteLine($"   {facilityGroupSpec.NumFacilities} @ {facilityGroupSpec.NumDevices}");
                    fileName += $"-{facilityGroupSpec.NumFacilities}@{facilityGroupSpec.NumDevices}";
                }
            }
            else
            {
                fileName     += $"-F{_options.NumFacilities}-D{_options.NumDevices}-R{_options.Duration}";
                numDevices    = _options.NumDevices;
                numFacilities = _options.NumFacilities;
            }

            if (_options.OutputFileName != null)
            {
                fileName = _options.OutputFileName;
            }

            var filePath = $"{cwd}/{fileName}.xlsx";

            Console.WriteLine($" Devices:    {numDevices}");
            Console.WriteLine($" Facilities: {numFacilities}");
            Console.WriteLine($" S/N Prefix: {_options.SerialPrefix}");
            Console.WriteLine($" Duration:   {_options.Duration}");
            Console.WriteLine($" Output:     {filePath}");

            var targetObjects = new TargetObjects(_options);
            var document      = new OutputDocument(templateFilePath);

            document.LoadTargetObjects(targetObjects);
            document.SaveAndClose(filePath);
        }