public void savedMoney(NormalConsume normalConsume) { double surplus; var KwM = Kwh_up_Month; if (normalConsume.consumeMonth != 0) { for (double i = normalConsume.rankElectricWorkList.Count; i >= 1; i--) { var E = normalConsume.rankElectricWorkList[i]; E.UsedWork = E.usedPrice / E.Price; surplus = KwM - E.UsedWork; E.SavedWork = surplus >= 0 ? E.UsedWork : KwM; KwM = surplus; rankElectricWorkPrivate.Add(i, E); } } else { var keyList = new string[3] { "Cao điểm", "Bình thường", "Thấp điểm" }; foreach (var key in keyList) { var E = normalConsume.rankElectricWorkList[key]; surplus = KwM - E.UsedWork; E.SavedWork = surplus >= 0 ? E.UsedWork : KwM; KwM = surplus; rankElectricWorkPrivate.Add(key, E); } } SurplusWork = KwM >= 0 ? KwM : 0; SurplusPrice = SurplusWork * sellforEVN; }
private void ReadDataExcel(int index) { try { rankE = null; soGioNangHashtable.Clear(); rankE = new SortedList <object, rankElectricWork>(); string path = @Properties.Settings.Default.pathDataExcel; using (ExcelPackage MaNS = new ExcelPackage(new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))) { ExcelWorksheet workSheet = MaNS.Workbook.Worksheets[0]; for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++) { soGioNangHashtable.Add(workSheet.Cells[i, 2].Value, workSheet.Cells[i, 3].Value); } workSheet = MaNS.Workbook.Worksheets[index]; switch (index) { case 1: { for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++) { rankElectricWork E = new rankElectricWork(); E.Price = (double)workSheet.Cells[i, 2].Value; E.quantityAllowed = (double)workSheet.Cells[i, 3].Value; rankE.Add(workSheet.Cells[i, 1].Value, E); // rankElectricWorkPrice.Add(, ); // rankElectricWorkCount.Add(workSheet.Cells[i, 1].Value, ); normalConsume = new NormalConsume() { rankElectricWorkList = rankE }; } break; } default: for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++) { rankElectricWork E = new rankElectricWork(); E.Price = (double)workSheet.Cells[i, 2].Value; rankE.Add(workSheet.Cells[i, 1].Value, E); // rankElectricWorkPrice.Add(, ); // rankElectricWorkCount.Add(workSheet.Cells[i, 1].Value, ); normalConsume = new NormalConsume() { rankElectricWorkList = rankE }; } break; } // normalConsume = new NormalConsume(700, 3100, 1000) // normalConsume = new NormalConsume(5000000) // { // rankElectricWorkList = rankE // }; } khuvucComboBox.ItemsSource = soGioNangHashtable.Keys; } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); throw; } }