private void button1_Click(object sender, EventArgs e)
{
if (NameTextBox.Text == "" || NameTextBox.Text == " ")
{
return;
}
else
{
General.CheckForExitsFile(Application.StartupPath + "//ReList//" + NameTextBox.Text);
if (!Directory.Exists(Application.StartupPath + "//ReList"))
{
Directory.CreateDirectory(Application.StartupPath + "//ReList");
}
DirectoryInfo Dinfo = new DirectoryInfo(Application.StartupPath + "//ReList");
FileInfo[] info = Dinfo.GetFiles("*.");
List.Items.Clear();
if (info != null)
{
foreach (FileInfo finf in info)
{
List.Items.Add(finf.Name);
}
}
}
}
void LoadFile()
{
General.CheckForExitsFile(Application.StartupPath + "//" + FirmsP);
General.CheckForExitsFile(Application.StartupPath + "//" + StocksP);
General.CheckForExitsFile(Application.StartupPath + "//" + BState);
General.CheckForExitsFile(Application.StartupPath + "//" + EState);
General.CheckForExitsFile(Application.StartupPath + "//" + CState);
General.CheckForExitsFile(Application.StartupPath + "//" + CPState);
if (General.CheckIsFileNull(BState))
{
General.WriteToFileValue(BState, 0, false);
}
if (General.CheckIsFileNull(EState))
{
General.WriteToFileValue(EState, 0, false);
}
if (General.CheckIsFileNull(CState))
{
General.WriteToFileValue(CState, 0, false);
}
if (General.CheckIsFileNull(CPState))
{
General.WriteToFileValue(CPState, 0, false);
}
General.CheckForExitsDirectory(Application.StartupPath + "//CounterpartyAgentsList//");
General.CheckForExitsDirectory(Application.StartupPath + "//Report//");
/*General.CheckForExitsFile(WorkersSalaryDataFilePath);
* General.CheckForExitsFile(FoodDataFilePath);
* General.CheckForExitsFile(FirmDataFilePath);
* General.CheckForExitsFile(FuelDataFilePath);
* General.CheckForExitsFile(ResultsDataFilePath);
* General.CheckForExitsFile(CashDataFilePath);
* General.CheckForExitsFile(RelDataFilePath);
* General.CheckForExitsFile(Shop0DataFilePath);
* General.CheckForExitsFile(Shop1DataFilePath);
* General.CheckForExitsFile(CounterpartyDataFilePath);
* General.CheckForExitsFile(RawMatDataFilePath);
* General.CheckForExitsFile(RawMat0DataFilePath);
* General.CheckForExitsFile(CounterpartySPASDataFilePath);
* General.CheckForExitsFile(CounterpartyEndOfDataFilePath);
* General.CheckForExitsFile(TransportDataFilePath);
*/
}
public void Clear()
{
try
{
General.CheckForExitsFile(FilePath);
StreamWriter StreamW = new StreamWriter(FilePath, false, Encoding.UTF8);
StreamW.Write(String.Empty);
StreamW.Flush();
StreamW.Close();
}
catch (Exception ex)
{
General.ShowErrorBox(ex);
}
}
public void Save()
{
try
{
General.CheckForExitsFile(FilePath);
StreamWriter StreamW = new StreamWriter(FilePath, true, Encoding.UTF8);
StreamW.WriteLine(StateTextBox.Text);
StreamW.Flush();
StreamW.Close();
}
catch (Exception ex)
{
General.ShowErrorBox(ex);
}
}
public void LoadRecords()
{
try
{
General.CheckForExitsFile(f_FileName);
string[] Names = File.ReadAllLines(f_FileName);
AccountTableList.Rows.Clear();
if (Names != null)
{
foreach (string finf in Names)
{
AccountTableList.Rows.Add(finf);
}
}
}
catch (Exception) { }
}
private void button1_Click(object sender, EventArgs e)
{
DataPicker D = new DataPicker();
D.OpenT = DataPicker.ReportType.ExpenseReport;
D.button2.Enabled = false;
D.ShowDialog(this);
string Date = D.MonthComboBox.SelectedItem.ToString();
if (Date != null)
{
string FileName = Application.StartupPath + "//Report//" + Date + "//EState.data";
float ESumm = General.ReadFromFileValue(FileName, 0);
float BSumm = General.ReadFromFileValue(Application.StartupPath + "//BState.data", 0);
A += (BSumm / ESumm);
General.CheckForExitsDirectory(Application.StartupPath + "//Report//" + Date + "//CalcProductsData");
General.CheckForExitsFile(Application.StartupPath + "//Report//" + Date + "//CalcProductsData//" + ProductName + ".data");
SumLabel.Text = "Общая Сумма:" + A.ToString().Replace(",", ".") + " Сомони";
General.WriteToFileValue(Application.StartupPath + "//Report//" + Date + "//CalcProductsData//" + ProductName + ".data", A.ToString().Replace(".", ","), false);
}
}
void AddRawData(string Name)
{
if (Name == null)
{
return;
}
else
{
General.CheckForExitsFile(FolderPath + "\\" + Name);
DirectoryInfo Dinfo = new DirectoryInfo(FolderPath);
FileInfo[] info = Dinfo.GetFiles("*.");
RawMaterialListBox.Items.Clear();
if (info != null)
{
foreach (FileInfo finf in info)
{
RawMaterialListBox.Items.Add(finf.Name);
}
}
//try
//{
//General.UpdateCellData("RawMaterials", "Масса", MassDataTextBox.Text, Convert.ToInt32(ID));
//}
//catch (Exception) { }
//try
//{
// General.DeleteFromSQLDataBase("RawMaterials", "Имя", RawDataTextBox.Text);
//}
//catch (Exception)
//{
// //Empty
//}
}
}
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
}
