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 }