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;
}
}
