private void OKButton_Click(object sender, EventArgs e)
{
try
{
float Price = float.Parse(textBox1.Text.ToString().Replace(".", ","));
float Count = float.Parse(textBox2.Text.ToString().Replace(".", ","));
float Summ = Price * Count;
ProductTableLoadder ProdTable = new ProductTableLoadder();
ShopMaterialsNamesList MatNames = new ShopMaterialsNamesList("ShopProductsList.data", "Shop");
ShopMaterialsStep2 ShopTable = new ShopMaterialsStep2();
ResidueShopMaterials ResidShopTable = new ResidueShopMaterials();
//RemovedRawMaterialsForm RemRawShopTable = new RemovedRawMaterialsForm();
ProdTable.TableName = LoadString;
ProdTable.LoadRecords();
//RemRawShopTable.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox4.Text, Summ.ToString().Replace(",", "."), Date, textBoxPost.Text, textBoxPoluch.Text);
ResidShopTable.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox4.Text, Date, textBoxPost.Text, textBoxPoluch.Text);
General.DeleteFromSQLDataBase("RawMaterialsResidue", "Имя", titlebox.Text);
ShopTable.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox4.Text, Date, textBoxPost.Text, textBoxPoluch.Text);
ProdTable.InsertRecordsShop(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox4.Text, Date, textBoxPost.Text, textBoxPoluch.Text);
//RemRawShopTable.Close();
ShopTable.Close();
ResidShopTable.Close();
MatNames.LoadRecords();
MatNames.ShowDialog(this);
ProdTable.Close();
}
catch (Exception ex)
{
General.ShowErrorBox(ex);
General.Connection.Close();
}
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowID != null)
{
General.DeleteFromSQLDataBase("CounterpartyData", "Имя", RowID);
General.LoadSQLData("CounterpartyData", HumanEditorDataResults);
}
RowID = null;
General.SetRowIndex(HumanEditorDataResults);
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowID != null)
{
General.DeleteFromSQLDataBase("RawMaterialsResidue", "ID", RowID);
General.LoadSQLData("RawMaterialsResidue", RawMatResultsDaa);
}
RowID = null;
General.SetRowIndex(RawMatResultsDaa);
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowID != null)
{
General.DeleteFromSQLDataBase("SaledShopMaterials", "ID", RowID);
General.LoadSQLData("SaledShopMaterials", ShopMatData);
}
RowID = null;
General.SetRowIndex(ShopMatData);
}
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 deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
General.DeleteFromSQLDataBase(tableName, "ID", rowID);
LoadData(tableName);
}
catch (Exception)
{
General.Connection.Close();
}
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowID != null)
{
General.DeleteFromSQLDataBase("ConculationData", "ID", RowID);
General.LoadSQLData("ConculationData", ConculationDataEditor);
if (pName != null)
{
General.DeleteDirectory("RawList//" + pName);
}
}
RowID = null;
pName = String.Empty;
General.SetRowIndex(ConculationDataEditor);
}
private void OKButton_Click(object sender, EventArgs e)
{
General.CreateCounterpartyAccount(Counterparty);
SaledShopMaterials SaledMaterials = new SaledShopMaterials();
SaledMaterials.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox5.Text, DateTime.Today.ToString(), "Vella", Counterparty);
SaledMaterials.Close();
General.DeleteFromSQLDataBase("ResidueShopMaterials", "Имя", titlebox.Text);
CounterpartyAccount CpAcc = new CounterpartyAccount();
CpAcc.LoadString = Counterparty;
CpAcc.ProductName = titlebox.Text;
CpAcc.PriceString = textBox1.Text;
CpAcc.CountString = textBox2.Text;
CpAcc.SumString = textBox4.Text;
CpAcc.InsertRecordsBoolean = true;
CpAcc.Date = dateTimePicker1.Text;
CpAcc.ShowDialog(this);
}
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; }
*/
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (RowID != null && IDName != null)
{
General.DeleteFromSQLDataBase(TableName, "ID", RowID);
if (this.Text == "RawTable")
{
try
{
string IDStr = null;
General.Command = new SqlCommand("select ID from RawMaterials where Имя=@name and Дата=@date", General.Connection);
General.Connection.Open();
General.Command.Parameters.AddWithValue("@name", IDName.Trim());
General.Command.Parameters.AddWithValue("@date", IDDate.Trim());
SqlDataReader sqlReader = General.Command.ExecuteReader();
while (sqlReader.Read())
{
IDStr = sqlReader["ID"].ToString();
}
sqlReader.Close();
General.Connection.Close();
General.DeleteFromSQLDataBase("RawMaterials", "ID", int.Parse(IDStr));
}
catch (Exception)
{
General.Connection.Close();
}
}
else if (this.Text == "ShopTable")
{
try
{
string IDStr = null;
General.Command = new SqlCommand("select ID from ShopMaterials where Имя=@name and Дата=@date", General.Connection);
General.Connection.Open();
General.Command.Parameters.AddWithValue("@name", IDName.Trim());
General.Command.Parameters.AddWithValue("@date", IDDate.Trim());
SqlDataReader sqlReader = General.Command.ExecuteReader();
while (sqlReader.Read())
{
IDStr = sqlReader["ID"].ToString();
}
sqlReader.Close();
General.Connection.Close();
General.DeleteFromSQLDataBase("ShopMaterials", "ID", int.Parse(IDStr));
}
catch (Exception)
{
General.Connection.Close();
}
}
General.LoadSQLData(TableName, RawMatResultsDaa);
}
RowID = null;
IDDate = null;
IDName = null;
General.SetRowIndex(RawMatResultsDaa);
}
