void WriteSettings(Datashit recviz, Bank bank) { if (shemes) { Properties.Settings.Default.name = recviz.name; Properties.Settings.Default.platNumber = recviz.platNumber; Properties.Settings.Default.mfo = recviz.mfo; Properties.Settings.Default.rahunok = recviz.rahunok; Properties.Settings.Default.datePayment = recviz.datePayment; Properties.Settings.Default.clientBankCode = recviz.cliBankCode; Properties.Settings.Default.recivePayNum = recviz.recivPayNum; Properties.Settings.Default.state1 = recviz.state; Properties.Settings.Default.Save(); //Xml.editXml(xmlConfig, bank); } else { Properties.Settings.Default.name2 = recviz.name2; Properties.Settings.Default.platNumber2 = recviz.platNumber2; Properties.Settings.Default.rahunok2 = recviz.rahunok2; Properties.Settings.Default.edrpou = recviz.edrpou; Properties.Settings.Default.state1 = recviz.state; //Xml.CreteConfig(xmlConfig, bank); Properties.Settings.Default.Save(); } }
void WriteIni(Datashit recviz, Bank bank) { if (shemes) { bank.name = recviz.name; bank.platNumber = recviz.platNumber; bank.mfo = recviz.mfo; bank.rahunok = recviz.rahunok; bank.datePayment = recviz.datePayment; bank.cliBankCode = recviz.cliBankCode; bank.recivPayNum = recviz.recivPayNum; bank.state = recviz.state; } else { bank.name = recviz.name2; bank.platNumber = recviz.platNumber2; bank.rahunok = recviz.rahunok2; bank.edrpou = recviz.edrpou; bank.state = recviz.state; } ////Bank //myIni.Write("Bank", recviz.name); //myIni.Write("PlatNumber", recviz.platNumber.ToString()); //myIni.Write("Mfo", recviz.mfo); //myIni.Write("Rahunok", recviz.rahunok); //myIni.Write("Paydate", recviz.datePayment.ToString()); //myIni.Write("Bankclentnum", recviz.cliBankCode); //myIni.Write("PlatReciver", recviz.recivPayNum); ////Bank2 //myIni.Write("Bank2", recviz.name2); //myIni.Write("Platnumber2", recviz.platNumber2.ToString()); //myIni.Write("Edrpou", recviz.edrpou); //myIni.Write("Rahunok2", recviz.rahunok2); //myIni.Write("State", recviz.state.ToString()); }
public static Datashit IniRead(Datashit recviz, IniFile myIni) { string[] recvizs = { }; string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"config.ini"); try { // config.Text = myIni.Read("bank Aval"); recviz.name = myIni.Read("Bank"); recviz.platNumber = Int64.Parse(myIni.Read("PlatNumber")); recviz.mfo = myIni.Read("Mfo"); recviz.rahunok = myIni.Read("Rahunok"); recviz.datePayment = Convert.ToInt32(myIni.Read("Paydate")); recviz.recivPayNum = myIni.Read("PlatReciver"); recviz.cliBankCode = myIni.Read("bankclentnum"); // config.Text = myIni.Read("bank2 UkrGaz"); recviz.name2 = myIni.Read("Bank2"); recviz.platNumber2 = Int64.Parse(myIni.Read("PlatNumber2")); recviz.edrpou = myIni.Read("Edrpou"); recviz.rahunok2 = myIni.Read("Rahunok2"); //recviz.state = Int32.Parse(myIni.Read("State")); recvizs = File.ReadAllLines(path, Encoding.Default); } catch (Exception e) { Console.WriteLine(e); } // try // { // if (recvizs.Length >= 5) // { // recviz.name = string.IsNullOrEmpty(recvizs[0]) ? "" : recvizs[0]; // recviz.platNumber = string.IsNullOrEmpty(recvizs[1]) ? 0 : Convert.ToInt32(recvizs[1]); // recviz.mfo = string.IsNullOrEmpty(recvizs[2]) ? 0 : Convert.ToInt32(recvizs[2]); // recviz.rahunok = string.IsNullOrEmpty(recvizs[3]) ? "0" : (recvizs[3]); // recviz.datePayment = string.IsNullOrEmpty(recvizs[4]) ? 0 : Convert.ToInt32(recvizs[4]); // } // } // catch (Exception e) // { // // } // try // { // if (recvizs.Length >= 9) // { // recviz.name2 = myIni.Read("Bank2"); // recviz.platNumber2 = Int32.Parse(myIni.Read("PlatNumber2")); // recviz.edrpou = myIni.Read("Edrpou"); // recviz.rahunok2 = recviz.rahunok = myIni.Read("Rahunok2"); // } // } // catch (Exception e) // { // // } return(recviz); }
public static void saveExcel(SaveFileDialog saveDialog, DataGridView dataGridView1, Datashit recviz) { long numDoc = recviz.platNumber2; string senderRah = recviz.rahunok2; string edrpou = recviz.ToString(); // Creating a Excel object. Microsoft.Office.Interop.Excel._Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = excel.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; //worksheet.Cells.Style; try { worksheet = workbook.ActiveSheet; worksheet.Name = "ExportedFromDatGrid"; int cellRowIndex = 1; int cellColumnIndex = 1; //Loop through each row and read value from each column. // worksheet.Cells["D:D"].NumberFormat = "@"; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { for (int j = 0; j < dataGridView1.Columns.Count; j++) { // Excel index starts from 1,1. As first Row would have the Column headers, adding a condition check. switch (cellColumnIndex) { case 6: if (cellRowIndex == 1) { worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Columns[j + 1].HeaderText; } else { worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j + 1].Value.ToString(); } break; case 7: if (cellRowIndex == 1) { worksheet.Cells[cellRowIndex, cellColumnIndex] = "Номер платежу"; } else { worksheet.Cells[cellRowIndex, cellColumnIndex] = numDoc++; } break; case 8: if (cellRowIndex == 1) { worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@"; worksheet.Cells[cellRowIndex, cellColumnIndex] = "ЄРДПО платника"; } else { worksheet.Cells[cellRowIndex, cellColumnIndex] = recviz.edrpou; } break; case 9: if (cellRowIndex == 1) { worksheet.Cells[cellRowIndex, cellColumnIndex] = "Рахунок платника"; worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@"; } else { worksheet.Cells[cellRowIndex, cellColumnIndex] = recviz.rahunok2; } break; case 10: case 11: break; default: if (cellRowIndex == 1) { worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Columns[j].HeaderText; } else { worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@"; worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } break; } cellColumnIndex++; } cellColumnIndex = 1; cellRowIndex++; } // SaveFileDialog saveDialog = new SaveFileDialog(); // saveDialog.Filter = "Excel files(2003)| *.xls|Excel Files(2007+)|*.xlsx"; ; // saveDialog.FilterIndex = 2; //if (saveDialog.ShowDialog() == DialogResult.OK) { workbook.SaveAs(saveDialog.FileName); MessageBox.Show("Експорт завершено"); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } finally { excel.Quit(); workbook = null; excel = null; } }