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 BasarAndProdovecForm_Load(object sender, EventArgs e) { /*General.CheckForExitsFile(DataFilePath);*/ General.LoadData(DataFilePath, humanEditorData); General.ChangeWidth(humanEditorData); General.SetGridStyle(humanEditorData, Color.MediumTurquoise); }
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); }
private void reloadDataToolStripMenuItem_Click(object sender, EventArgs e) { try { if (t_Type == "RawResidue") { 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 nodeLists = xRoot.SelectNodes("RawResidue"); string nameToDelete = string.Empty; if (nodeLists != null) { foreach (XmlNode item in nodeLists) { XmlNode parentN = null; XmlNode countN = item.SelectSingleNode("Количество"); if (countN != null) { float N = float.Parse(countN.InnerText.Replace(".", ",")); if (N == 0) { parentN = countN.ParentNode; nameToDelete = parentN.SelectSingleNode("Имя").InnerText; xRoot.RemoveChild(parentN); try { General.DeleteFromSQLDataBase("RawMaterialsResidue", "Имя", nameToDelete); } catch (Exception) { } } } } } StreamWriter SWriter = new StreamWriter(Application.StartupPath + "//Raw.Residue.Data.xml", false, Encoding.UTF8); xDoc.Save(SWriter); SWriter.Flush(); SWriter.Close(); if (DataControl.Columns != null && DataControl.Rows != null) { DataControl.DataMember = null; DataControl.DataSource = null; DataControl.Rows.Clear(); DataControl.Columns.Clear(); } General.LoadData(Application.StartupPath + "//Raw.Residue.Data.xml", DataControl); } } if (t_Type == "ShopResidue") { 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 nodeLists = xRoot.SelectNodes("ShopResidue"); string nameToDelete = string.Empty; if (nodeLists != null) { foreach (XmlNode item in nodeLists) { XmlNode parentN = null; XmlNode countN = item.SelectSingleNode("Количество"); if (countN != null) { float N = float.Parse(countN.InnerText.Replace(".", ",")); if (N == 0) { parentN = countN.ParentNode; nameToDelete = parentN.SelectSingleNode("Имя").InnerText; xRoot.RemoveChild(parentN); try { General.DeleteFromSQLDataBase("RawMaterialsResidue", "Имя", nameToDelete); } catch (Exception) { } } } } } StreamWriter SWriter = new StreamWriter(Application.StartupPath + "//Shop.Residue.Data.xml", false, Encoding.UTF8); xDoc.Save(SWriter); SWriter.Flush(); SWriter.Close(); if (DataControl.Columns != null && DataControl.Rows != null) { DataControl.DataMember = null; DataControl.DataSource = null; DataControl.Rows.Clear(); DataControl.Columns.Clear(); } General.LoadData(Application.StartupPath + "//Shop.Residue.Data.xml", DataControl); } } } catch (Exception) { throw; } /* * try * { * if (t_Type == "RawResidue") * { * if (DataControl.Columns.Count > 0 && DataControl.Rows.Count > 0) * { * DataControl.Rows.Clear(); * DataControl.Columns.Clear(); * } * General.LoadData("Raw.Residue.Data.xml", DataControl); * } * else if (t_Type == "ShopResidue") * { * if (DataControl.Columns.Count > 0 && DataControl.Rows.Count > 0) * { * DataControl.Rows.Clear(); * DataControl.Columns.Clear(); * } * General.LoadData("Shop.Residue.Data.xml", DataControl); * } * } * catch (Exception) { throw; } */ }