public MainWindow() { InitializeComponent(); objSQL = new DB_MySQL("sql7.freesqldatabase.com", 3306, "sql7338923", "sql7338923", "bc9vSYmu5u"); objSQL.openSessionMySQL(); }
/* * Метод для публикации данных в бд */ public void pushDB() { string strCellData = ""; double douCellData; DB_MySQL objSQL = new DB_MySQL("sql7.freesqldatabase.com", 3306, "sql7338923", "sql7338923", "bc9vSYmu5u"); objSQL.openSessionMySQL(); int rowCnt = 0; //строка int colCnt = 0; //столбец int[] mass = new int[10]; DataTable dt = new DataTable(); string FlightDate = ""; // new DateTime(); string ScheduledTime = "", FlightNumber = ""; //= new TimeSpan(); int AirlineCode = 0; string CodeA = "", FlagArrivalDeparture = "", TypeAircraft = "", AParking = "", ParkingSector = "", NameAirline = ""; for (rowCnt = 1; rowCnt <= excelRange.Rows.Count; rowCnt++) { string strData = ""; for (colCnt = 1; colCnt <= excelRange.Columns.Count; colCnt++) { switch (colCnt) { case 1: douCellData = (excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; FlightDate = DateTime.FromOADate(douCellData).ToString("yyyy-MM-dd"); break; case 2: douCellData = (excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; ScheduledTime = DateTime.FromOADate(douCellData).ToLongTimeString().ToString(); break; case 3: CodeA = (string)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; break; case 4: AirlineCode = (int)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; break; case 5: FlightNumber = (string)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; break; case 6: FlagArrivalDeparture = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2); break; case 7: TypeAircraft = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2); break; case 8: AParking = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2); break; case 9: ParkingSector = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2); break; } } objSQL.CreatingNewRowTimetable(FlightDate, ScheduledTime, CodeA, AirlineCode, FlightNumber, FlagArrivalDeparture, TypeAircraft, AParking, ParkingSector, NameAirline); } objSQL.closeSessionMySQL(); excelBook.Close(true, null, null); excelApp.Quit(); }