private void ShopMaterialsStep2_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
if (!hasSaved)
{
if (MessageBox.Show("Сохранить данные?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
General.SaveData(DataFilePath, ShopMatResultsDaa);
General.SaveData(DataFilePath2, ShopMatResultsDaa);
this.Close();
}
else
{
this.Close();
}
}
else
{
this.Close();
}
}
General.FormBlock(e, this);
}
public static void SaveBiSyTable(DataGridView DataControl)
{
SaveFileDialog sfg = new SaveFileDialog();
sfg.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
sfg.Filter = "BiSyTable (*.bisytable)|*.bisytable";
if (sfg.ShowDialog() == DialogResult.OK)
{
General.SaveData(sfg.FileName, DataControl);
}
}
private void RawMaterials_FormClosed(object sender, FormClosedEventArgs e)
{
if (!hasSaved)
{
if (MessageBox.Show("Сохранить данные?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
General.SaveData(DataFilePath, RawMatData);
this.Close();
}
else
{
this.Close();
}
}
else
{
this.Close();
}
}
void SaveExpenseReport()
{
string DateData = DatePicker.Text;
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + DateData);
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//EState.data", MoneySumResults, false);
try
{
General.Command = new SqlCommand("select sum(Общий) from ExpenseWorker", General.Connection);
General.Connection.Open();
float ExpenseWorkerSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseWorker.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseWorker.data", ExpenseWorkerSumm, false);
string ExpenseWorkerData = Application.StartupPath + "//Report//" + DateData + "//ExpenseWorkerData.data";
General.LoadSQLData("ExpenseWorker", DView);
General.SaveData(ExpenseWorkerData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFood", General.Connection);
General.Connection.Open();
float ExpenseFooodSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFood.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFood.data", ExpenseFooodSumm, false);
string ExpenseFoodData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFoodData.data";
General.LoadSQLData("ExpenseFood", DView);
General.SaveData(ExpenseFoodData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFuel", General.Connection);
General.Connection.Open();
float ExpenseFuel = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFuel.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFuel.data", ExpenseFuel, false);
string ExpenseFuelData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFuelData.data";
General.LoadSQLData("ExpenseFuel", DView);
General.SaveData(ExpenseFuelData, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from ExpenseFirm", General.Connection);
General.Connection.Open();
float ExpenseFirmSumm = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ExpenseFirm.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ExpenseFirm.data", ExpenseFirmSumm, false);
string ExpenseFirmData = Application.StartupPath + "//Report//" + DateData + "//ExpenseFirmData.data";
General.LoadSQLData("ExpenseFirm", DView);
General.SaveData(ExpenseFirmData, DView);
}
catch (Exception) { }
}
void SaveCollectionReport()
{
string DateData = DatePicker.Text;
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + DateData);
#region Raws
try
{
General.Command = new SqlCommand("select sum(Сумма) from RawMaterials", General.Connection);
General.Connection.Open();
float ImportedRawSum = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsImported.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsImported.data", ImportedRawSum, false);
string ReportRawMaterialsDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsImportedReportData.data";
General.LoadSQLData("RawMaterials", DView);
General.SaveData(ReportRawMaterialsDataFileDATA, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from RemovedRawMaterials", General.Connection);
General.Connection.Open();
float RemovedRawsSummData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsRemoved.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsRemoved.data", RemovedRawsSummData, false);
string ReportRawMaterialsRemovedDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsRemovedReportData.data";
General.LoadSQLData("RemovedRawMaterials", DView);
General.SaveData(ReportRawMaterialsRemovedDataFileDATA, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Сумма) from RawMaterialsResidue", General.Connection);
General.Connection.Open();
float ResidueRawsMaterials = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//RawsResidue.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//RawsResidue.data", ResidueRawsMaterials, false);
string ReportRawMaterialsResidueDataFileDATA = Application.StartupPath + "//Report//" + DateData + "//RawsResidueReportData.data";
General.LoadSQLData("RawMaterialsResidue", DView);
General.SaveData(ReportRawMaterialsResidueDataFileDATA, DView);
}
catch (Exception) { }
#endregion
#region Shop
try
{
General.Command = new SqlCommand("select sum(КоличествоКаробок) from ShopMaterials", General.Connection);
General.Connection.Open();
float CrateCount = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//BState.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//BState.data", CrateCount, false);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from ShopMaterials", General.Connection);
General.Connection.Open();
float ImportedShopMAterialsData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopMaterials.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopMaterials.data", ImportedShopMAterialsData, false);
string ImportedShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//ImportedShopData.data";
General.LoadSQLData("ShopMaterials", DView);
General.SaveData(ImportedShopMAterialsDataFile, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from SaledShopMaterials", General.Connection);
General.Connection.Open();
float SaledShopMaterials = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopSaled.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopSaled.data", SaledShopMaterials, false);
string SaledShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//SaledShopMaterialsData.data";
General.LoadSQLData("SaledShopMaterials", DView);
General.SaveData(SaledShopMAterialsDataFile, DView);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Цена) from ResidueShopMaterials", General.Connection);
General.Connection.Open();
float ResidueShopMaterialsData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//ShopResidue.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//ShopResidue.data", ResidueShopMaterialsData, false);
string ResidueShopMAterialsDataFile = Application.StartupPath + "//Report//" + DateData + "//ResidueShopMaterialsData.data";
General.LoadSQLData("ResidueShopMaterials", DView);
General.SaveData(ResidueShopMAterialsDataFile, DView);
}
catch (Exception) { }
#endregion
#region Cash
try
{
General.Command = new SqlCommand("select sum(Оплаченно) from CashData", General.Connection);
General.Connection.Open();
float CounterPartyResults = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//CPState.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//CPState.data", CounterPartyResults, false);
}
catch (Exception) { }
try
{
General.Command = new SqlCommand("select sum(Должен) from CashData", General.Connection);
General.Connection.Open();
float DebtData = float.Parse(General.Command.ExecuteScalar().ToString().Replace(".", ","));
General.Connection.Close();
General.CheckForExitsFile(Application.StartupPath + "//Report//" + DateData + "//Debt.data");
General.WriteToFileValue(Application.StartupPath + "//Report//" + DateData + "//Debt.data", DebtData, false);
}
catch (Exception) { }
try
{
string CashData = Application.StartupPath + "//Report//" + DateData + "//CashRecordsData.data";
General.LoadSQLData("CashData", DView);
General.SaveData(CashData, DView);
}
catch (Exception) { }
#endregion
}
private void сохрантьToolStripMenuItem_Click(object sender, EventArgs e)
{
General.SaveData(DataFilePath, RawMatResultsDaa);
}
private void сохрантьToolStripMenuItem_Click(object sender, EventArgs e)
{
General.SaveData(DataFilePath, ShopMaterialsData);
}
private void сохрантьToolStripMenuItem_Click(object sender, EventArgs e)
{
General.SaveData(DataFilePath, humanEditorData);
}