public IEnumerable <ProtocolRow> GetProtocolData(string storageName, int startRow, int maxRows, string filter, DateTime?FromDate, DateTime?ToDate) { var datasetConfig = ProtokollerConfiguration.ActualConfigInstance.Datasets.FirstOrDefault(s => s.Name == storageName); IDBInterface dbInterface = StorageHelper.GetStorage(datasetConfig, null); dbInterface.Connect_To_Database(datasetConfig.Storage); IDBViewable dbViewable = dbInterface as IDBViewable; List <ProtocolRow> list = new List <ProtocolRow>(); DataTable table = dbViewable.ReadData(datasetConfig, filter, startRow, maxRows, FromDate, ToDate); foreach (DataRow row in table.Rows) { ProtocolRow storageLine = new ProtocolRow(); var date = row["datetime"]; if (date is DateTime) { storageLine.Timestamp = (DateTime)date; } else { storageLine.Timestamp = DateTime.ParseExact(row["datetime"].ToString(), "yyyy.MM.dd - HH:mm:ss.fff", null); } storageLine.Telegram = Convert.ToString(row["data"]); list.Add(storageLine); } return(list); }
private void cmdBeginn_Click(object sender, RoutedEventArgs e) { if (dbView != null) { CurrentNumber = 0; txtFromDataset.Text = CurrentNumber.ToString(); lblToDataset.Content = (CurrentNumber + 1000).ToString(); DataTable tbl = dbView.ReadData(datasetConfig, null, CurrentNumber, 1000, null, null); if (tbl != null) { grdDatasetFields.ItemsSource = tbl.DefaultView; } lblDataCount.Content = dbView.ReadCount(datasetConfig); } }
private void cmbStorage_SelectionChanged(object sender, SelectionChangedEventArgs e) { lblError.Content = null; if (dbIf != null) dbIf.Dispose(); dbIf = null; dbView = null; lblDataCount.Content = null; grdDatasetFields.ItemsSource = null; datasetConfig = cmbStorage.SelectedItem as DatasetConfig; dbIf = StorageHelper.GetStorage(ProtokollerConfiguration.ActualConfigInstance, datasetConfig.Storage, null); dbIf.Connect_To_Database(datasetConfig.Storage); dbView = dbIf as IDBViewable; dbViewSQL = dbIf as IDBViewableSQL; txtSQL.IsEnabled = false; cmdSQL.IsEnabled = false; txtSearch.IsEnabled = false; cmdSearch.IsEnabled = false; try { if (dbView != null) { txtSQL.Text = ""; CurrentNumber = 0; DataTable tbl = dbView.ReadData(datasetConfig, null, CurrentNumber, 1000, null, null); if (tbl != null) grdDatasetFields.ItemsSource = tbl.DefaultView; lblDataCount.Content = dbView.ReadCount(datasetConfig); } if (!string.IsNullOrEmpty(datasetConfig.DateTimeDatabaseField)) { /*dbFieldNames = datasetConfig.DateTimeDatabaseField; foreach (var datasetConfigRow in datasetConfig.DatasetConfigRows) { if (datasetConfigRow.DatabaseField.ToLower().Trim() != datasetConfig.DateTimeDatabaseField.ToLower().Trim()) dbFieldNames += ", " + datasetConfigRow.DatabaseField; }*/ dbFieldNames = datasetConfig.DateTimeDatabaseField + ",*"; } if (dbViewSQL != null) { string table; if (datasetConfig.DatasetTableName != "") table = datasetConfig.DatasetTableName; else table = datasetConfig.Name; txtSQL.Text = "SELECT " + dbFieldNames + " FROM " + table + " ORDER BY id DESC LIMIT " + 1000.ToString(); txtSQL.IsEnabled = true; cmdSQL.IsEnabled = true; txtSearch.IsEnabled = true; cmdSearch.IsEnabled = true; } } catch (Exception ex) { lblError.Content = ex.Message; } }
private void cmbStorage_SelectionChanged(object sender, SelectionChangedEventArgs e) { lblError.Content = null; if (dbIf != null) { dbIf.Dispose(); } dbIf = null; dbView = null; lblDataCount.Content = null; grdDatasetFields.ItemsSource = null; datasetConfig = cmbStorage.SelectedItem as DatasetConfig; dbIf = StorageHelper.GetStorage(datasetConfig, null); dbIf.Connect_To_Database(datasetConfig.Storage); dbView = dbIf as IDBViewable; dbViewSQL = dbIf as IDBViewableSQL; txtSQL.IsEnabled = false; cmdSQL.IsEnabled = false; txtSearch.IsEnabled = false; cmdSearch.IsEnabled = false; try { if (dbView != null) { txtSQL.Text = ""; CurrentNumber = 0; DataTable tbl = dbView.ReadData(datasetConfig, null, CurrentNumber, 1000, null, null); if (tbl != null) { grdDatasetFields.ItemsSource = tbl.DefaultView; } lblDataCount.Content = dbView.ReadCount(datasetConfig); } if (!string.IsNullOrEmpty(datasetConfig.DateTimeDatabaseField)) { /*dbFieldNames = datasetConfig.DateTimeDatabaseField; * foreach (var datasetConfigRow in datasetConfig.DatasetConfigRows) * { * if (datasetConfigRow.DatabaseField.ToLower().Trim() != datasetConfig.DateTimeDatabaseField.ToLower().Trim()) * dbFieldNames += ", " + datasetConfigRow.DatabaseField; * }*/ dbFieldNames = datasetConfig.DateTimeDatabaseField + ",*"; } if (dbViewSQL != null) { txtSQL.Text = "SELECT " + dbFieldNames + " FROM " + datasetConfig.Name + " ORDER BY id DESC LIMIT " + 1000.ToString(); txtSQL.IsEnabled = true; cmdSQL.IsEnabled = true; txtSearch.IsEnabled = true; cmdSearch.IsEnabled = true; } } catch (Exception ex) { lblError.Content = ex.Message; } }