Пример #1
0
 public ProcessLoader(ProcessSim sim)
 {
     Simulator       = sim;
     _db             = DbHelper.CreateDb();
     _sessionAdapter = DbHelper.CreateAdapter <Session>();
     _wqiAdapter     = DbHelper.CreateAdapter <WorkQueueItem>();
 }
Пример #2
0
        public IEnumerable <ProcessSim> GetSims(string filename)
        {
            var res = new List <ProcessSim>();

            using (var package = new ExcelPackage(new FileInfo(filename)))
            {
                using (var workbook = package.Workbook)
                {
                    using (var sheet = workbook.Worksheets[1])
                    {
                        var row = 2;
                        while (true)
                        {
                            if (string.IsNullOrWhiteSpace(Convert.ToString(sheet.Cells[row, 1].Value)))
                            {
                                return(res);
                            }
                            var item = new ProcessSim()
                            {
                                Region            = Convert.ToString(sheet.Cells[row, 1].Value),
                                ServiceLine       = Convert.ToString(sheet.Cells[row, 2].Value),
                                BusinessUnit      = Convert.ToString(sheet.Cells[row, 3].Value),
                                Id                = Convert.ToInt32(sheet.Cells[row, 4].Value),
                                Name              = Convert.ToString(sheet.Cells[row, 5].Value),
                                StartDate         = Convert.ToDateTime(sheet.Cells[row, 6].Value),
                                StartMinDate      = Convert.ToInt32(sheet.Cells[row, 7].Value),
                                EndMinDate        = Convert.ToInt32(sheet.Cells[row, 8].Value),
                                Interval          = Convert.ToInt32(sheet.Cells[row, 9].Value),
                                MinTransaction    = Convert.ToInt32(sheet.Cells[row, 10].Value),
                                MaxTransaction    = Convert.ToInt32(sheet.Cells[row, 11].Value),
                                FPY               = Convert.ToDouble(sheet.Cells[row, 12].Value),
                                BusinessException = Convert.ToDouble(sheet.Cells[row, 13].Value),
                                SystemException   = Convert.ToDouble(sheet.Cells[row, 14].Value),
                            };
                            res.Add(item);
                            row++;
                        }
                    }
                }
            }
        }