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; }
*/
}
