// Клиенты public Boolean FillClientData() { AppJournal.Write("DataManager", "Trying open client table"); tableSettlPair = new DSSERVERLib.Online(); clientData = new ObservableCollection <SettlPair>(); tableSettlPair.AddRow += TableClientsAddRow; lastAddRowTime = DateTime.Now.AddDays(1); try { connectionType = tableSettlPair.Open(DSSERVERLib.ConnectionType.RTSONL_DYNAMIC, "SettlPair", "id, firm_name, settl_pair", "id", null, null, DSSERVERLib.Sort.RTSONL_SORT_EMPTY); } catch (Exception ex) { AppJournal.Write("DataManager", "Opening table err: " + ex.ToString()); MessageBox.Show("Ошибка доступа к таблице Workstation!"); } if (connectionType == 0) { return(false); } else { LoadTimeManagement(); return(true); } }
void TableQuotesAddRow(int IDConnect, int IDRecord, object Fields) { IList collection = (IList)Fields; decimal rez; decimal.TryParse(collection[1].ToString(), NumberStyles.Any, new CultureInfo("en-US"), out rez); AppJournal.WriteServerLogs("ServerResponse", string.Format("Firm: {0}, price: {1}, lot: {2}, serverTime: {3}, curTime: {4}", collection[3].ToString(), rez.ToString(), collection[0].ToString(), collection[2].ToString(), DateTime.Now.ToString("dd.MM.yyyy hh:mm:ss:fff"))); }
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); }