public void CheckSerial() { if (CheckConnection(0) != 0) { if (Execute("select * from robots where serial='" + App.hddSerialNumber + "'").Tables[0].Rows.Count == 0) { AppJournal.Write("DataBaseManager", "Record about SN not exist in DB"); MessageBox.Show("Подключение не легально.\nДанного ключа программы нет в базе.", "Предупреждение правообладателя", MessageBoxButton.OK, MessageBoxImage.Warning); Environment.Exit(0); } } }
// Добавление режимов public void MakeModes() { AppJournal.Write("DataManager", "Make modes"); modeData = new ObservableCollection <Mode>(); modeData.Add(new Mode { type = "Конкурирующий" }); modeData.Add(new Mode { type = "Поточный" }); modeData.Add(new Mode { type = "Разовый" }); }
protected int FirmsOpen() { AppJournal.Write("DataManager", "Trying open firm table"); tableFirms = new DSSERVERLib.Online(); firmData = new ObservableCollection <Firm>(); tableFirms.AddRow += TableFirmsAddRows; try { connectionType = tableFirms.Open(DSSERVERLib.ConnectionType.RTSONL_DYNAMIC, "Firm", "id, name", "name", null, null, DSSERVERLib.Sort.RTSONL_FORWARD); } catch (Exception ex) { AppJournal.Write("DataManager", "Opening table err: " + ex.ToString()); MessageBox.Show("Ошибка доступа к таблице клиентов!"); } return(connectionType); }
public void FillQuotesData() { AppJournal.Write("Order", "Trying open quotes table"); DSSERVERLib.Online tableQuotes; tableQuotes = new DSSERVERLib.Online(); tableQuotes.AddRow += TableQuotesAddRow; try { tableQuotes.Open(DSSERVERLib.ConnectionType.RTSONL_DYNAMIC, "Quote", "issue_name, price, moment, firm_name", "id", null, null, DSSERVERLib.Sort.RTSONL_SORT_EMPTY); } catch (Exception ex) { AppJournal.Write("Order", "Opening table err: " + ex.ToString()); MessageBox.Show("Ошибка доступа к таблице котировок!"); } }
public int IssuesOpen() { AppJournal.Write("DataManager", "Trying open issue table"); tableIssues = new DSSERVERLib.Online(); issueData = new ObservableCollection <Issue>(); tableIssues.AddRow += TableIssuesAddRow; try { connectionType = tableIssues.Open(DSSERVERLib.ConnectionType.RTSONL_DYNAMIC, "Issue", "id, name, nominal", "id", null, null, DSSERVERLib.Sort.RTSONL_BACKWARD); } catch (Exception ex) { AppJournal.Write("DataManager", "Open table err: " + ex.ToString()); MessageBox.Show("Ошибка доступа к таблице инструментов!"); } return(connectionType); }
private DataSet Execute(String queryStr) { if (mySqlConn.State != ConnectionState.Open) { connectionStatus = CheckConnection(1); } if (connectionStatus != 0) { sqlAdapter.SelectCommand = new MySqlCommand(queryStr, mySqlConn); try { sqlAdapter.Fill(dataSet); return(dataSet); } catch (Exception ex) { MessageBox.Show(ex.Message); AppJournal.Write("DataBaseManager", "Get data from db query err: " + ex.ToString()); } } return(null); }
private int CheckConnection(int trying) { mySqlConn = new MySqlConnection(connectionStr); try { mySqlConn.Open(); } catch (Exception ex) { AppJournal.Write("DataBaseManager", "Connect to DB err: " + ex.ToString()); MessageBox.Show("Нет доступа к базе", "Предупреждение правообладателя", MessageBoxButton.OK, MessageBoxImage.Warning); if (trying == 0) { Environment.Exit(0); } else { return(0); } } connectionStatus = 1; return(connectionStatus); }