private void toolStripMenuItem2_Click(object sender, EventArgs e) { DatabaseRecordsConfiguration DC = new DatabaseRecordsConfiguration(); DC.dateTimePicker.Enabled = false; DC.TextBox1.Enabled = true; DC.TextBox0.Enabled = false; DC.TextBox2.Enabled = false; DC.TextBox3.Enabled = false; DC.TextBox4.Enabled = false; DC.dateTimePicker.Text = String.Empty; DC.TextBox0.Text = String.Empty; DC.TextBox2.Text = String.Empty; DC.TextBox3.Text = String.Empty; DC.TextBox4.Text = String.Empty; DC.TextBox1.Text = "Название"; DC.ShowDialog(this); if (DC.TextBox1.Text == null || DC.TextBox1.Text == " " || DC.TextBox1.Text == "Название") { return; } else { InsertRecords(DC.TextBox1.Text); } General.SetGridStyle(ConculationDataEditor, Color.Coral); }
private void RawMatFormStep2_Load(object sender, EventArgs e) { LoadRecords(); General.SetRowIndex(ShopMatData); General.SetGridStyle(ShopMatData, Color.CornflowerBlue); General.ChangeWidth(ShopMatData); }
private void HumanEditorStep2_Load(object sender, EventArgs e) { LoadRecords(); General.SetRowIndex(AccountTableList); General.ChangeWidth(AccountTableList); General.SetGridStyle(AccountTableList, Color.MediumTurquoise); }
private void RawMaterials_Load(object sender, EventArgs e) { /*General.CheckForExitsFile(DataFilePath);*/ General.LoadData(DataFilePath, RawMatData); General.ChangeWidth(RawMatData); General.SetGridStyle(RawMatData, Color.MediumTurquoise); }
private void StorageViewer_Load(object sender, EventArgs e) { if (LoadDataType == "Raw") { General.LoadSQLData("RawMaterials", ImportedMaterials); General.LoadSQLData("RemovedRawMaterials", RemovedMaterials); General.LoadSQLData("RawMaterialsResidue", ResidueMaterials); } else if (LoadDataType == "Shop") { General.LoadSQLData("ShopMaterials", ImportedMaterials); General.LoadSQLData("SaledShopMaterials", RemovedMaterials); General.LoadSQLData("ResidueShopMaterials", ResidueMaterials); } General.ChangeWidth(ImportedMaterials); General.ChangeWidth(RemovedMaterials); General.ChangeWidth(ResidueMaterials); General.SetRowIndex(ImportedMaterials); General.SetRowIndex(RemovedMaterials); General.SetRowIndex(ResidueMaterials); General.SetGridStyle(ImportedMaterials, Color.Aqua); General.SetGridStyle(RemovedMaterials, Color.LightBlue); General.SetGridStyle(ResidueMaterials, Color.LightSalmon); }
private void CashFormViewer_Load(object sender, EventArgs e) { LoadRecords(); General.ChangeWidth(CashEditor); General.SetRowIndex(CashEditor); General.SetGridStyle(CashEditor, Color.LightSeaGreen); }
private void BasarAndProdovecForm_Load(object sender, EventArgs e) { /*General.CheckForExitsFile(DataFilePath);*/ General.LoadData(DataFilePath, humanEditorData); General.ChangeWidth(humanEditorData); General.SetGridStyle(humanEditorData, Color.MediumTurquoise); }
private void HumanEditorStep2_Load(object sender, EventArgs e) { LoadRecords(); /*General.CheckForExitsFile(DataFilePath);*/ General.SetRowIndex(HumanEditorDataResults); General.ChangeWidth(HumanEditorDataResults); General.SetGridStyle(HumanEditorDataResults, Color.MediumTurquoise); }
private void RawMatFormStep2_Load(object sender, EventArgs e) { LoadRecords(); /*General.CheckForExitsFile(DataFilePath);*/ General.SetRowIndex(RawMatResultsDaa); General.SetGridStyle(RawMatResultsDaa, Color.CornflowerBlue); General.ChangeWidth(RawMatResultsDaa); }
private void ProductConculationStep1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'mineDataDataSet3.ConculationData' table. You can move, or remove it, as needed. this.conculationDataTableAdapter.Fill(this.mineDataDataSet3.ConculationData); LoadRecords(); General.SetGridStyle(ConculationDataEditor, Color.Aqua); General.ChangeWidth(ConculationDataEditor); }
private void ShopMaterialsStep2_Load(object sender, EventArgs e) { LoadRecords(); General.SetRowIndex(ShopMatResultsDaa); /*General.CheckForExitsFile(DataFilePath);*/ General.ChangeWidth(ShopMatResultsDaa); General.SetGridStyle(ShopMatResultsDaa, Color.MediumTurquoise); }
private void HumanEditorStep2_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'mineDataDataSet3.CounterpartyData' table. You can move, or remove it, as needed. //this.counterpartyDataTableAdapter.Fill(this.mineDataDataSet3.CounterpartyData); LoadRecords(); /*General.CheckForExitsFile(DataFilePath);*/ General.SetRowIndex(AccountTable); General.ChangeWidth(AccountTable); General.SetGridStyle(AccountTable, Color.MediumTurquoise); }
private void toolStripMenuItem28_Click(object sender, EventArgs e) { if (RowID != null) { General.DeleteFromSQLDataBase("CashData", "ID", RowID); General.LoadSQLData("CashData", CashEditor); } RowID = null; General.SetRowIndex(CashEditor); General.SetGridStyle(CashEditor, Color.LightSeaGreen); }
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e) { if (RowID != null) { General.DeleteFromSQLDataBase(LoadString, "ID", RowID); General.LoadSQLData(LoadString, AccountTable); } RowID = null; General.SetRowIndex(AccountTable); General.SetGridStyle(AccountTable, Color.LightSeaGreen); General.SetRowIndex(AccountTable); }
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e) { if (RowID != null) { General.DeleteFromSQLDataBase("CounterpartyData", "ID", RowID); General.LoadSQLData("CounterpartyData", HumanEditorDataResults); } RowID = null; General.SetRowIndex(HumanEditorDataResults); General.SetGridStyle(HumanEditorDataResults, Color.LightSeaGreen); General.SetRowIndex(HumanEditorDataResults); }
private void RawMatFormStep2_Load(object sender, EventArgs e) { if (DataControl.Columns.Count > 0) { DataControl.DataMember = null; DataControl.DataSource = null; DataControl.Rows.Clear(); DataControl.Columns.Clear(); } try { if (t_Type == "RawResidue") { if (DataControl.Columns.Count > 0) { DataControl.DataMember = null; DataControl.DataSource = null; DataControl.Rows.Clear(); DataControl.Columns.Clear(); } if (!File.Exists(Application.StartupPath + "//Raw.Residue.Data.xml")) { General.ShowErrorBox("Список продуктов сырья отсутствует!\nВозможно была потеря данных, обратитесь к администрации программы!"); } else { XmlDocument xDoc = new XmlDocument(); xDoc.Load(Application.StartupPath + "//Raw.Residue.Data.xml"); XmlElement xRoot = xDoc.DocumentElement; XmlNodeList RowsCountElement = xRoot.SelectNodes("RawResidue"); if (RowsCountElement != null) { foreach (XmlNode xNode in RowsCountElement) { XmlNode nameChildNode = xNode.SelectSingleNode("Имя"); string elemNameStr = "NONE"; if (nameChildNode != null) { elemNameStr = nameChildNode.InnerText; XmlNode massElem = xNode.SelectSingleNode("Масса"); XmlNode countElem = xNode.SelectSingleNode("Количество"); XmlNode cratesElem = xNode.SelectSingleNode("КоличествоКаробок"); XmlNode pricesElem = xNode.SelectSingleNode("Цена"); XmlNode summElem = xNode.SelectSingleNode("Сумма"); if (massElem != null && countElem != null && cratesElem != null && pricesElem != null && summElem != null) { if (massElem.InnerText == "NONE" && countElem.InnerText == "NONE" && cratesElem.InnerText == "NONE" && pricesElem.InnerText == "NONE" && summElem.InnerText == "NONE") { massElem.InnerText = General.SumColumnDataSQL("Масса", elemNameStr).ToString(); countElem.InnerText = General.SumColumnDataSQL("Количество", elemNameStr).ToString(); cratesElem.InnerText = General.SumColumnDataSQL("КоличествоКаробок", elemNameStr).ToString(); pricesElem.InnerText = General.SumColumnDataSQL("Цена", elemNameStr).ToString(); summElem.InnerText = General.SumColumnDataSQL("Сумма", elemNameStr).ToString(); } } } } } StreamWriter SWriter = new StreamWriter(Application.StartupPath + "//Raw.Residue.Data.xml", false, Encoding.UTF8); xDoc.Save(SWriter); SWriter.Flush(); SWriter.Close(); try { General.LoadData(Application.StartupPath + "//Raw.Residue.Data.xml", DataControl); } catch (Exception) { } } } else if (t_Type == "ShopResidue") { if (DataControl.Columns.Count > 0) { DataControl.DataMember = null; DataControl.DataSource = null; DataControl.Rows.Clear(); DataControl.Columns.Clear(); } if (!File.Exists(Application.StartupPath + "//Shop.Residue.Data.xml")) { General.ShowErrorBox("Список продуктов цеха отсутствует!\nВозможно была потеря данных, обратитесь к администрации программы!"); } else { XmlDocument xDoc = new XmlDocument(); xDoc.Load(Application.StartupPath + "//Shop.Residue.Data.xml"); XmlElement xRoot = xDoc.DocumentElement; XmlNodeList RowsCountElement = xRoot.SelectNodes("ShopResidue"); if (RowsCountElement != null) { foreach (XmlNode xNode in RowsCountElement) { XmlNode nameChildNode = xNode.SelectSingleNode("Имя"); string elemNameStr = "NONE"; if (nameChildNode != null) { elemNameStr = nameChildNode.InnerText; XmlNode massElem = xNode.SelectSingleNode("Масса"); XmlNode countElem = xNode.SelectSingleNode("Количество"); XmlNode cratesElem = xNode.SelectSingleNode("КоличествоКаробок"); XmlNode pricesElem = xNode.SelectSingleNode("Цена"); XmlNode summElem = xNode.SelectSingleNode("Сумма"); if (massElem != null && countElem != null && cratesElem != null && pricesElem != null && summElem != null) { if (massElem.InnerText == "NONE" && countElem.InnerText == "NONE" && cratesElem.InnerText == "NONE" && pricesElem.InnerText == "NONE" && summElem.InnerText == "NONE") { massElem.InnerText = General.SumColumnDataSQL("Масса", elemNameStr).ToString(); countElem.InnerText = General.SumColumnDataSQL("Количество", elemNameStr).ToString(); cratesElem.InnerText = General.SumColumnDataSQL("КоличествоКаробок", elemNameStr).ToString(); pricesElem.InnerText = General.SumColumnDataSQL("Цена", elemNameStr).ToString(); summElem.InnerText = General.SumColumnDataSQL("Сумма", elemNameStr).ToString(); } } } } } StreamWriter SWriter = new StreamWriter(Application.StartupPath + "//Shop.Residue.Data.xml", false, Encoding.UTF8); xDoc.Save(SWriter); SWriter.Flush(); SWriter.Close(); try { General.LoadData(Application.StartupPath + "//Shop.Residue.Data.xml", DataControl); } catch (Exception) { } } } else { LoadData(); } } catch (Exception) { } General.SetRowIndex(DataControl); General.SetGridStyle(DataControl, Color.CornflowerBlue); General.ChangeWidth(DataControl); }