private void ValueRefreshData() { DataTable Value = new DataTable(); DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_ValueYear", true).First()).Value; TextBox tb_AdminECCC = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminECCC", true).First(); TextBox tb_AdminEuro = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminEuro", true).First(); TextBox tb_AdminDolars = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminDolars", true).First(); TextBox tb_AdminSEK = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminSEK", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Value, "Kurs"); FoundRow = Value.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { MessageBox.Show("Brak danych do wybranego roku, wprowadź je !"); return; } else { tb_AdminECCC.Text = FoundRow["ECCC"].ToString(); tb_AdminEuro.Text = FoundRow["EURO"].ToString(); tb_AdminDolars.Text = FoundRow["USD"].ToString(); tb_AdminSEK.Text = FoundRow["SEK"].ToString(); } }
private void AddRowForHistory(string What, decimal Year) { DataTable Action = new DataTable(); DataTable Historia = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref Historia, "History"); Data_Import.Singleton().Load_TxtToDataTable2(ref Action, "Action"); DataColumn Col = Action.Columns.Add("History"); Col.SetOrdinal(0); foreach (DataRow ActionRow in Action.Rows) { if (ActionRow["StartYear"].ToString() == Year.ToString() || ActionRow["StartYear"].ToString() == (Year - 1).ToString() || ActionRow["StartYear"].ToString() == ("BU/" + Year).ToString() || ActionRow["StartYear"].ToString() == ("SA/" + Year).ToString()) { ActionRow["History"] = What + "/" + Year.ToString(); DataRow HistoriaNewRow = Historia.NewRow(); HistoriaNewRow.ItemArray = ActionRow.ItemArray; Historia.Rows.Add(HistoriaNewRow); } } Data_Import.Singleton().Save_DataTableToTXT2(ref Historia, "History"); }
private void ManulaUpadte(decimal Year) { DataTable STKTable = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (STKTable.Columns.Contains(Year.ToString())) { DialogResult Results = MessageBox.Show("Dane STK na rok " + Year.ToString() + " istnieją!. Czy zamienić je ?", "Uwaga", MessageBoxButtons.YesNo); if (Results == DialogResult.Yes) { STKTable.Columns.Remove(Year.ToString()); STKTable.Columns.Remove("STK/" + Year.ToString()); } else { return; } } STKTable.Columns.Add(Year.ToString()); STKTable.Columns.Add("STK/" + Year.ToString()); Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); _ = new AddData("Sprowadz dane dla STK", Year); //Data.Show(); }
private void ValueSaveData() { DataTable Value = new DataTable(); DataRow NewRow; DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_ValueYear", true).First()).Value; TextBox tb_AdminECCC = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminECCC", true).First(); TextBox tb_AdminEuro = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminEuro", true).First(); TextBox tb_AdminDolars = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminDolars", true).First(); TextBox tb_AdminSEK = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminSEK", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Value, "Kurs"); NewRow = Value.NewRow(); NewRow["Year"] = Year.ToString(); NewRow["ECCC"] = tb_AdminECCC.Text; NewRow["EURO"] = tb_AdminEuro.Text; NewRow["USD"] = tb_AdminDolars.Text; NewRow["SEK"] = tb_AdminSEK.Text; FoundRow = Value.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { Value.Rows.Add(NewRow); } else { FoundRow.ItemArray = NewRow.ItemArray.Clone() as object[]; } Data_Import.Singleton().Save_DataTableToTXT2(ref Value, "Kurs"); }
//ładowanie tabeli z akcjami plus wyciągnięcie akcji która nas interesuje private DataRow ImportRowAction(string ActionName, decimal Year) { DataTable ActionList = new DataTable(); DataRow[] FoundArry; Data_Import.Singleton().Load_TxtToDataTable2(ref ActionList, "Action"); FoundArry = ActionList.Select(string.Format("Name LIKE '%{0}%'", ActionName)).ToArray(); foreach (DataRow Row in FoundArry.Take(FoundArry.Length)) { if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == Year.ToString()) { return(Row); } else if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == (Year - 1).ToString()) { return(Row); } else if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == "SA/" + Year.ToString()) { return(Row); } } return(null); }
//LoadAction Table private DataTable LoadActionTable() { DataTable ActionList = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref ActionList, "Action"); return(ActionList); }
private void SaveFromDataGridView(string Link) { DataTable Actiontable; DataGridView Dg_AdminActionGrid = (DataGridView)Tab_AdminAction.Controls.Find("Dg_AdminActionGrid", true).First(); Actiontable = (DataTable)(Dg_AdminActionGrid.DataSource); Data_Import.Singleton().Save_DataTableToTXT(ref Actiontable, Link); }
private void ClearYear(decimal Year) { DataTable STKTable = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (STKTable.Columns.Contains(Year.ToString())) { STKTable.Columns.Remove(Year.ToString()); STKTable.Columns.Remove("STK/" + Year.ToString()); Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); } }
public void STK_LoadFile() { if (File.Exists(link)) { DataTable Table = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref Table, "STK"); } else { MessageBox.Show("Brak Bazy danych, proszę skontaktować się z administratorem"); } //Dodać odrazu filtrowanie na bierzący rok, chyba przelicza wszystkie - sprawdzić }
public MainProgram() { try { data_Import = Data_Import.Singleton(); if (!data_Import.CheckConnectionToDataBase()) { Environment.Exit(0); } //Widocznoś Maina dla Wszystkich. Self = this; //Pobranie danych z bazy dla dostępów osób logujących się do programy Access = data_Import.Load_Access(); //Tworzenie Użytkowanika CreateUsers NewUsers = new CreateUsers(Access); //Inicjalizowanie programu InitializeComponent(); action = new Action(this, data_Import); admin = new Admin(); summaryDetails = new SummaryDetails(); //Budowanie Formsa w zależności od uprawnień buildForm.Tab_Control_Add(Access, this, action, summaryDetails, admin, data_Import); if (ApplicationDeployment.IsNetworkDeployed) { toolStripStatusLabel1.Text = ApplicationDeployment.CurrentDeployment.CurrentVersion.ToString() + " Beta Version"; } else { toolStripStatusLabel1.Text = "0.5.0.40 Beta Portable Version"; } if (Environment.UserName.ToString() == "BartkKon") { string Link = data_Import.CheckLink(); toolStripStatusLabel1.Text = toolStripStatusLabel1.Text + " " + Link; } } catch (Exception ex) { LogSingleton.Instance.SaveLog(ex.Message); } }
private void LoadToDataGridView(string Link) { DataTable ActionTable = new DataTable(); DataGridView Dg_AdminActionGrid = (DataGridView)Tab_AdminAction.Controls.Find("Dg_AdminActionGrid", true).First(); GroupBox Gb_AdminAction_NewColumn = (GroupBox)Tab_AdminAction.Controls.Find("Gb_AdminAction_NewColumn", true).First(); Label QuantityColumns = (Label)MainProgram.Self.TabControl.Controls.Find("Lab_ColumnQuantity", true).First(); Data_Import.Singleton().Load_TxtToDataTable(ref ActionTable, Link); Dg_AdminActionGrid.DataSource = ActionTable; foreach (DataGridViewColumn Column in Dg_AdminActionGrid.Columns) { Column.SortMode = DataGridViewColumnSortMode.NotSortable; } Dg_AdminActionGrid.Columns[0].Frozen = true; Gb_AdminAction_NewColumn.Enabled = true; Dg_AdminActionGrid.AutoSize = true; QuantityColumns.Text = (Dg_AdminActionGrid.Columns.Count - 1).ToString(); }
public void HistorySave() { DataTable Frozen = new DataTable(); DataRow FrozenRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_SummaryDetailYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First(); if (FrozenRow != null) { if (FrozenRow["BU"].ToString() == "Open") { DeleteRowFromHistory("BU", Year); AddRowForHistory("BU", Year); } if (FrozenRow["EA1"].ToString() == "Open") { DeleteRowFromHistory("EA1", Year); AddRowForHistory("EA1", Year); } if (FrozenRow["EA2"].ToString() == "Open") { DeleteRowFromHistory("EA2", Year); AddRowForHistory("RA2", Year); } if (FrozenRow["EA3"].ToString() == "Open") { DeleteRowFromHistory("EA3", Year); AddRowForHistory("EA3", Year); } for (int counter = 1; counter < 13; counter++) { if (FrozenRow[counter.ToString()].ToString() == "Open") { DeleteRowFromHistory(counter.ToString(), Year); AddRowForHistory(counter.ToString(), Year); } } } }
private void DeleteRowFromHistory(string what, decimal Year) { DataTable Historia = new DataTable(); DataRow[] ForDelete; Data_Import.Singleton().Load_TxtToDataTable2(ref Historia, "History"); ForDelete = Historia.Select(string.Format("History LIKE '%{0}%'", what + "/" + Year.ToString())).ToArray(); if (ForDelete != null) { foreach (DataRow Delete in ForDelete) { Historia.Rows.Remove(Delete); } } Data_Import.Singleton().Save_DataTableToTXT2(ref Historia, "History"); }
private void FrozenRefreshData() { DataTable Frozen = new DataTable(); DataRow FrozenRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_FrozenYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FrozenRow == null) { MessageBox.Show("Brak Danego roku w Bazie - dodaj go !!"); return; } else { foreach (DataColumn column in Frozen.Columns) { if (column.ColumnName != "Year") { if (FrozenRow[column.ColumnName].ToString() == "Close") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 0; } else if (FrozenRow[column.ColumnName].ToString() == "Open") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 1; } else if (FrozenRow[column.ColumnName].ToString() == "Approve") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 2; } else { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 0; } } } } }
private void Pb_AddData_STK_Close_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; string[] Row = tb_AddData_Data.Text.Split(new[] { Environment.NewLine }, StringSplitOptions.None); DataTable STK = new DataTable(); DataRow STKRow; Data_Import.Singleton().Load_TxtToDataTable2(ref STK, "STK"); foreach (string SingleRow in Row) { string[] Part = SingleRow.Split('\t'); if (Part.Length > 1) { Part[0] = Part[0].Replace(" ", ""); STKRow = STK.Select(string.Format("ANC LIKE '%{0}%'", Part[0])).FirstOrDefault(); if (STKRow != null) { STKRow[Year.ToString()] = "01/00/" + Year.ToString(); STKRow["STK/" + Year.ToString()] = Part[1]; } else { STKRow = STK.NewRow(); STKRow["ANC"] = Part[0].ToString(); STKRow[Year.ToString()] = "01/00/" + Year.ToString(); STKRow["STK/" + Year.ToString()] = Part[1]; STK.Rows.Add(STKRow); } } } Data_Import.Singleton().Save_DataTableToTXT2(ref STK, "STK"); this.Close(); Cursor.Current = Cursors.Default; }
private void FrozenSaveData() { DataTable Frozen = new DataTable(); DataRow NewRow; DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_FrozenYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); NewRow = Frozen.NewRow(); foreach (DataColumn column in Frozen.Columns) { if (column.ColumnName == "Year") { NewRow[column.ColumnName] = Year.ToString(); } else { ComboBox ComboBoxFrozen = (ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First(); NewRow[column.ColumnName] = ComboBoxFrozen.GetItemText(ComboBoxFrozen.SelectedItem); } } FoundRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { Frozen.Rows.Add(NewRow); } else { FoundRow.ItemArray = NewRow.ItemArray.Clone() as object[]; } Data_Import.Singleton().Save_DataTableToTXT2(ref Frozen, "Frozen"); }
private bool ActionSave(bool NewAction) { DataTable ActionList; DataRow[] TableRow; DataRow NewRow = null; string NameAction; string NameAction2; decimal Year; bool New_Year = false; ActionList = LoadActionTable(); Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Action_YearAction", true).First()).Value; if (NewAction) { NameAction = ((TextBox)MainProgram.Self.TabControl.Controls.Find("tb_Name", true).First()).Text; NameAction = NameAction.Replace(";", ","); bool NameExist = CheckIfActionNameExist(NameAction, ref ActionList); if (NameExist) { MessageBox.Show("Please change Action Name, current Name Exist in DataBase"); return(false); } else { NewRow = ActionList.NewRow(); } } else { NameAction = ((GroupBox)MainProgram.Self.TabControl.Controls.Find("gb_ActiveAction", true).First()).Text; NameAction = NameAction.Replace(";", ","); NameAction2 = ((TextBox)MainProgram.Self.TabControl.Controls.Find("tb_Name", true).First()).Text; NameAction2 = NameAction2.Replace(";", ","); TableRow = ActionList.Select(string.Format("Name LIKE '%{0}%'", NameAction)).ToArray(); foreach (DataRow Row in TableRow.Take(TableRow.Length)) { if (Row["StartYear"].ToString() == Year.ToString() && Row["Name"].ToString() == NameAction2) { NewRow = Row; } else if (Row["StartYear"].ToString() == (Year - 1).ToString() && Row["Name"].ToString() == NameAction2) { if (Year.ToString() != Row["StartYear"].ToString()) { if (GridCheck(decimal.Parse(Row["StartYear"].ToString()))) { Row["StartYear"] = "BU/" + Row["StartYear"].ToString(); NewRow = ActionList.NewRow(); New_Year = true; } else { NewRow = Row; } } else { NewRow = Row; } } else if (Row["StartYear"].ToString() == (Year + 1).ToString() && Row["Name"].ToString() == NameAction2) { NewRow = Row; } } if (NewRow == null) { if (NameAction != NameAction2) { DialogResult dialogResult = MessageBox.Show("Do you want change Action Name for this Action?", "Change Action Name", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { MessageBox.Show("Action will be save with Old Name"); } else if (dialogResult == DialogResult.Yes) { bool NameExist = CheckIfActionNameExist(NameAction2, ref ActionList); if (NameExist) { MessageBox.Show("Name Exist in Data Base, please change Action Name"); return(false); } else { MessageBox.Show("Action will be Save with New Name"); TableRow = ActionList.Select(string.Format("Name LIKE '%{0}%'", NameAction)).ToArray(); foreach (DataRow Row in TableRow.Take(TableRow.Length)) { if (Row["StartYear"].ToString() == Year.ToString() && Row["Name"].ToString() == NameAction) { NewRow = Row; } else if (Row["StartYear"].ToString() == (Year - 1).ToString() && Row["Name"].ToString() == NameAction) { NewRow = Row; } } NameAction = NameAction2; ((GroupBox)MainProgram.Self.TabControl.Controls.Find("gb_ActiveAction", true).First()).Text = NameAction2; } } } } } NewRow["Name"] = NameAction; NewRow["Description"] = ActionDescription(); NewRow["Group"] = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_Devision", true).First()).Text; NewRow["Leader"] = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_Leader", true).First()).Text; NewRow["Status"] = Active_Idea_Action(); NewRow["Factory"] = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_Factory", true).First()).Text; NewRow["StartYear"] = Year.ToString(); NewRow["StartMonth"] = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_Month", true).First()).Text; //ClearDataforUse(((ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_Month", true).First()).Text); NewRow["Platform"] = Platform(); NewRow["Installation"] = Installation(); if (((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcANC", true).First()).Checked) { NewRow["Calculate"] = "ANC"; ANCSave(ref NewRow); } else if (((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcANCby", true).First()).Checked) { NewRow["Calculate"] = "ANCSpec"; ANCSave(ref NewRow); NewRow["Calc"] = ANCCalcby(); NewRow["CalcMass"] = ANCCalcbyMass(); } else if (((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcPNC", true).First()).Checked) { NewRow["Calculate"] = "PNC"; ANCSave(ref NewRow); NewRow["PNC"] = PNCReader(); } else if (((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcPNCSpec", true).First()).Checked) { NewRow["Calculate"] = "PNCSpec"; ANCSave(ref NewRow); PNCSpecReader(ref NewRow); NewRow["PNCEstyma"] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("TB_EstymacjaPNC", true).First()).Text; } NewRow["PNCANCPersent"] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("TB_PercentANCPNC", true).First()).Text; NewRow["ECCC"] = ECCCReader(NewRow["ECCC"].ToString()); string[] GridValue; //Quantity DataGridView Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Quantity", true).First(); GridValue = GridReader(Grid); GridSave(ref NewRow, GridValue, "Quantity", Year); //Saving Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Saving", true).First(); GridValue = GridReader(Grid); GridSave(ref NewRow, GridValue, "Saving", Year); //ECCC Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_ECCC", true).First(); GridValue = GridReader(Grid); GridSave(ref NewRow, GridValue, "ECCC", Year); //Sprawdzenie czy to jest Akcja dodatnia czy ujemna PozitiveOrNegative(ref NewRow); //Sprawdzenie czy jakiś Calc jest nie wpisany - jak nie jest to ma zamienić na same "//////////////" IfEmptyCalc(ref NewRow); //Dodanie IDCO do pliku IDCOAdd(ref NewRow); //Zapis kalkulacji poszczególych ANC?PNC if (!New_Year) { PerANC_PNC(ref NewRow, Year); } //Jesli zmienił się rok to ma do gridów wpisać puste warości if (New_Year) { Calc_Clear(ref NewRow, "Quantity"); Calc_Clear(ref NewRow, "Saving"); Calc_Clear(ref NewRow, "ECCC"); Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Quantity", true).First(); Grid_Clear(Grid); Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Saving", true).First(); Grid_Clear(Grid); Grid = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_ECCC", true).First(); Grid_Clear(Grid); //NewRow["IDCO"] = ""; } //Jeśli to była nowa akcja to dodaje wiersz if (NewAction || New_Year) { ActionList.Rows.Add(NewRow); } //Zapis do pliku Data_Import.Singleton().Save_DataTableToTXT2(ref ActionList, "Action"); return(true); }
public STK() { link = Data_Import.Singleton().Load_Link("STK"); }
private void LoadNewSTKFile(string linkFile) { DataTable STKTable = new DataTable(); string line_help; string ANC; int Year; int Month; int Day; float STK; string Name; string day; string month; string IDCO; Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (linkFile == "0") { MessageBox.Show("Plik nie był generowany od ponad miesiąca!"); } else { string[] STKFileupdate = File.ReadAllLines(linkFile); foreach (string line in STKFileupdate) { line_help = line; line_help = line_help.Remove(0, 2); ANC = line_help.Remove(9); line_help = line_help.Remove(0, 11); Year = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); Month = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); Day = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); STK = float.Parse(line_help.Remove(9)) / 10000; line_help = line_help.Remove(0, 154); Name = line_help.Remove(30).Trim(); line_help = line_help.Remove(0, 31); IDCO = line_help.Remove(4); Year = 2000 + Year; DataRow FoundRow = STKTable.Select(string.Format("ANC LIKE '%{0}%'", ANC)).FirstOrDefault(); if (FoundRow == null) { DataRow NewRow = STKTable.NewRow(); NewRow["ANC"] = ANC; NewRow["Description"] = Name; NewRow["IDCO"] = IDCO; if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } if (!STKTable.Columns.Contains(Year.ToString())) { STKTable.Columns.Add(new DataColumn(Year.ToString())); STKTable.Columns.Add(new DataColumn("STK/" + Year)); } NewRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); NewRow["STK/" + Year] = STK.ToString(); STKTable.Rows.Add(NewRow); } else { if (STKTable.Columns.Contains(Year.ToString())) { if (FoundRow["STK/" + Year].ToString() != STK.ToString()) { //Co się stanie jak nie jest równy. FoundRow["STK/" + Year] = STK.ToString(); if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } FoundRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); } if (FoundRow["IDCO"].ToString() != IDCO) { FoundRow["IDCO"] = IDCO; } } else { //Dodać kolumne z nowym rokiem i dopisać wartość STKTable.Columns.Add(new DataColumn(Year.ToString())); STKTable.Columns.Add(new DataColumn("STK/" + Year)); if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } FoundRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); FoundRow["STK/" + Year] = STK.ToString(); } } } Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); } }
private void Pb_AddData_Close_Click(object sender, EventArgs e) { //Action action = new Action(); Cursor.Current = Cursors.WaitCursor; string[] row = tb_AddData_Data.Text.Split(new[] { Environment.NewLine }, StringSplitOptions.None); int DuplicateCount = 0; bool IFCalc = false; if (row[0] != "") { if (Jak == "PNC") { DataGridView dg_PNC = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_PNC", true).First(); if (dg_PNC.Rows.Count > 1) { DialogResult result = MessageBox.Show("Do you want replace all PNC in this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns["PNC"].Width = 63; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } else if (result == DialogResult.No) { DialogResult result2 = MessageBox.Show("Do you want add this PNC to exisitng PNC for this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result2 == DialogResult.Yes) { IFCalc = true; } else if (result2 == DialogResult.No) { IFCalc = false; } } } else { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns["PNC"].Width = 63; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } if (IFCalc) { foreach (string OneRow in row) { if (OneRow != "") { var Row = dg_PNC.Rows.Cast <DataGridViewRow>().Where(u => u.Cells["PNC"].Value.ToString().Equals(OneRow)).FirstOrDefault(); if (Row == null) { dg_PNC.Rows.Add(OneRow); } else { DuplicateCount++; } } } } this.Close(); Cursor.Current = Cursors.Default; if (DuplicateCount > 0) { MessageBox.Show($"Was remove {DuplicateCount} Duplicate Value", "Duplicate counter"); } return; } if (Jak == "PNCSpec") { DataGridView dg_PNC = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_PNC", true).First(); if (dg_PNC.Rows.Count > 1) { DialogResult result = MessageBox.Show("Do you want replace all PNC in this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns.Add("OLD ANC", "OLD ANC"); dg_PNC.Columns.Add("OLD Q", "Q"); dg_PNC.Columns.Add("NEW ANC", "NEW ANC"); dg_PNC.Columns.Add("NEW Q", "Q"); dg_PNC.Columns["PNC"].Width = 80; dg_PNC.Columns["OLD ANC"].Width = 65; dg_PNC.Columns["OLD ANC"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["OLD Q"].Width = 35; dg_PNC.Columns["OLD Q"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["NEW ANC"].Width = 65; dg_PNC.Columns["NEW ANC"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["NEW Q"].Width = 35; dg_PNC.Columns["NEW Q"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD Q"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW Q"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } else if (result == DialogResult.No) { DialogResult result2 = MessageBox.Show("Do you want add this PNC to exisitng PNC for this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result2 == DialogResult.Yes) { IFCalc = true; } else if (result2 == DialogResult.No) { IFCalc = false; } } } else { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns.Add("OLD ANC", "OLD ANC"); dg_PNC.Columns.Add("OLD Q", "Q"); dg_PNC.Columns.Add("NEW ANC", "NEW ANC"); dg_PNC.Columns.Add("NEW Q", "Q"); dg_PNC.Columns["PNC"].Width = 80; dg_PNC.Columns["OLD ANC"].Width = 65; dg_PNC.Columns["OLD ANC"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["OLD Q"].Width = 35; dg_PNC.Columns["OLD Q"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["NEW ANC"].Width = 65; dg_PNC.Columns["NEW ANC"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["NEW Q"].Width = 35; dg_PNC.Columns["NEW Q"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD Q"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW Q"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } if (IFCalc) { foreach (string SingleRow in row) { if (SingleRow == string.Empty) { continue; } string[] SelectedRow = SingleRow.Split(';'); string PNC = SelectedRow[0]; string ECCC = string.Empty; int Limit = ((SelectedRow.Length - 3) / 2); if (SelectedRow[1].ToString() != string.Empty) { ECCC = "ECCC(" + SelectedRow[1] + ")"; } dg_PNC.Rows.Add(PNC, ECCC, string.Empty); dg_PNC.Rows[dg_PNC.Rows.Count - 1].DefaultCellStyle.BackColor = Color.LightBlue; dg_PNC.Rows[dg_PNC.Rows.Count - 1].DefaultCellStyle.Font = new Font(dg_PNC.Font, FontStyle.Bold); dg_PNC.Rows[dg_PNC.Rows.Count - 1].Cells[1].Style.Font = new Font(dg_PNC.Font, FontStyle.Regular); dg_PNC.Rows[dg_PNC.Rows.Count - 1].Cells[1].Style.Font = new Font("Tahoma", 10F, GraphicsUnit.Pixel); for (int counter2 = 2; counter2 < Limit + 2; counter2++) { if (SelectedRow[counter2] != string.Empty || SelectedRow[counter2 + Limit + 1] != string.Empty) { dg_PNC.Rows.Add(string.Empty, SelectedRow[counter2], SelectedRow[counter2 + 1], SelectedRow[counter2 + Limit + 1], SelectedRow[counter2 + Limit + 2]); } counter2++; } } } this.Close(); Cursor.Current = Cursors.Default; return; } } else { this.Close(); Cursor.Current = Cursors.Default; return; } if (Jak == "BU" || Jak == "EA1" || Jak == "EA2" || Jak == "EA3") { NumericUpDown Admin_Year = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_YearQuantity", true).First(); CheckBox cb_AdminPNC = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminPNC", true).First(); CheckBox cb_AdminANC = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminANC", true).First(); DataTable Baza = new DataTable(); DataRow FoundRow; int ile; if (cb_AdminANC.Checked) { Data_Import.Singleton().Load_TxtToDataTable2(ref Baza, "ANC"); } if (cb_AdminPNC.Checked) { Data_Import.Singleton().Load_TxtToDataTable2(ref Baza, "PNC"); } switch (Jak) { case "BU": ile = 1; break; case "EA1": ile = 3; break; case "EA2": ile = 6; break; case "EA3": ile = 9; break; default: return; } if (Baza.Columns.Contains(Jak + "/12/" + Admin_Year.Text)) { for (int counter = ile; counter <= 12; counter++) { Baza.Columns.Remove(Jak + "/" + counter + "/" + Admin_Year.Text); } } for (int counter = ile; counter <= 12; counter++) { Baza.Columns.Add(new DataColumn(Jak + "/" + counter + "/" + Admin_Year.Text)); } foreach (string OneRow in row) { string[] row2 = OneRow.Split('\t'); if (row2[0] != "") { if (cb_AdminANC.Checked) { FoundRow = Baza.Select(string.Format("BUANC LIKE '%{0}%'", row2[0])).FirstOrDefault(); } else { FoundRow = Baza.Select(string.Format("BUPNC LIKE '%{0}%'", row2[0])).FirstOrDefault(); } int zmienna; if (FoundRow != null) { zmienna = ile; for (int counter = 1; counter <= (13 - ile); counter++) { FoundRow[Jak + "/" + zmienna + "/" + Admin_Year.Text] = row2[counter]; zmienna++; } } else { DataRow NewRow = Baza.NewRow(); NewRow[0] = row2[0]; zmienna = ile; for (int counter = 1; counter <= (13 - ile); counter++) { NewRow[Jak + "/" + zmienna + "/" + Admin_Year.Text] = row2[counter]; zmienna++; } Baza.Rows.Add(NewRow); } } } if (cb_AdminANC.Checked) { Data_Import.Singleton().Save_DataTableToTXT2(ref Baza, "ANC"); } if (cb_AdminPNC.Checked) { Data_Import.Singleton().Save_DataTableToTXT2(ref Baza, "PNC"); } this.Close(); Cursor.Current = Cursors.Default; return; } if (Jak == "AddMonthANC" || Jak == "AddMonthPNC") { NumericUpDown Admin_Year = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_YearMonth", true).First(); NumericUpDown Admin_Month = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_QuantityMonth", true).First(); DataTable Quantity = new DataTable(); DataRow FoundRow; string Miesiac = Admin_Month.Value.ToString() + "/" + Admin_Year.Value.ToString(); if (Jak == "AddMonthANC") { Data_Import.Singleton().Load_TxtToDataTable2(ref Quantity, "ANCMonth"); } if (Jak == "AddMonthPNC") { Data_Import.Singleton().Load_TxtToDataTable2(ref Quantity, "PNCMonth"); } if (Quantity.Columns.Contains(Miesiac)) { Quantity.Columns.Remove(Miesiac); } Quantity.Columns.Add(new DataColumn(Miesiac)); foreach (string OneRow in row) { string[] NewValue = OneRow.Split('\t'); if (NewValue[0] != "") { if (Jak == "AddMonthANC") { FoundRow = Quantity.Select(string.Format("ANC LIKE '%{0}%'", NewValue[0])).FirstOrDefault(); } else { FoundRow = Quantity.Select(string.Format("PNC LIKE '%{0}%'", NewValue[0])).FirstOrDefault(); } if (FoundRow != null) { FoundRow[Miesiac] = NewValue[1]; } else { DataRow NewRow = Quantity.NewRow(); NewRow[0] = NewValue[0]; NewRow[Miesiac] = NewValue[1]; Quantity.Rows.Add(NewRow); } } } if (Jak == "AddMonthANC") { Data_Import.Singleton().Save_DataTableToTXT2(ref Quantity, "ANCMonth"); } if (Jak == "AddMonthPNC") { Data_Import.Singleton().Save_DataTableToTXT2(ref Quantity, "PNCMonth"); } this.Close(); Cursor.Current = Cursors.Default; return; } }
public void Pb_AdminAction_SaveAccess_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; SaveFromDataGridView(Data_Import.Singleton().Load_Link("Access")); Cursor.Current = Cursors.Default; }
public void Pb_AdminAction_LoadFrozen_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; LoadToDataGridView(Data_Import.Singleton().Load_Link("Frozen")); Cursor.Current = Cursors.Default; }
//Sprawdzenie czy w Gridach jest coś zapisane już private bool GridCheck(decimal Year) { bool Grid = false; DataTable Frozen = new DataTable(); DataRow FrozenRow; DataGridView Table_Check = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Saving", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FrozenRow == null) { return(Grid); } for (int Row = 0; Row < 5; Row++) { for (int Column = 0; Column < 12; Column++) { if (Table_Check.Rows[Row].Cells[Column] != null && Table_Check.Rows[Row].Cells[Column].ToString() != "") { if (Row == 1) { if (FrozenRow["EA3"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 2) { if (FrozenRow["EA2"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 3) { if (FrozenRow["EA1"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 4) { if (FrozenRow["BU"].ToString() == "Approve") { Grid = true; return(Grid); } } else { if (FrozenRow[(Column + 1).ToString()].ToString() == "Approve") { Grid = true; return(Grid); } } } } } return(Grid); }