private void btnOpen_Click(object sender, EventArgs e)
{
if (rbSrez.Checked)
{
dataTable = new DataTable("SrezTable");
SrezAdapter sa = new SrezAdapter();
sa.FileName = txtFileName.Text;
sa.Fill(dataTable);
}
else if (rbEvent.Checked)
{
dataTable = new DataTable("EventTable");
EventAdapter ea = new EventAdapter();
ea.FileName = txtFileName.Text;
ea.Fill(dataTable);
}
else // rbBase.Checked
{
dataTable = new DataTable("BaseTable");
BaseAdapter ba = new BaseAdapter();
ba.FileName = txtFileName.Text;
ba.Fill(dataTable, true);
}
dataGridView.DataSource = dataTable;
}
/// <summary>
/// Экспортировать события, загрузив их из файла
/// </summary>
private void ExportEventsFromFile(Exporter exporter, DateTime date)
{
// загрузка таблицы событий из файла
EventTableLight eventTable = new EventTableLight();
EventAdapter eventAdapter = new EventAdapter();
eventAdapter.FileName = ServerUtils.BuildEvFileName(Settings.ArcDir, date);
try
{
eventAdapter.Fill(eventTable);
}
catch (Exception ex)
{
log.WriteAction(string.Format(Localization.UseRussian ?
"Ошибка при загрузке таблицы событий из файла {0}: {1}" :
"Error loading event table from file {0}: {1}", eventAdapter.FileName, ex.Message));
}
// добавление событий в очередь экспорта
if (eventTable.AllEvents.Count > 0)
{
foreach (EventTableLight.Event ev in eventTable.AllEvents)
{
exporter.EnqueueEvent(ev);
}
log.WriteAction(Localization.UseRussian ? "События добавлены в очередь экспорта" :
"Events added to export queue");
}
else
{
log.WriteAction(Localization.UseRussian ? "Отсутствуют события для экспорта" :
"No events to export");
}
}
/// <summary>
/// Loads the event table.
/// </summary>
private bool LoadEventTable(DataTable table)
{
try
{
eventAdapter.FileName = FileName;
eventAdapter.Fill(table);
return(true);
}
catch (Exception ex)
{
errLog.WriteException(ex, ServerShellPhrases.LoadEventTableError);
ScadaUiUtils.ShowError(ServerShellPhrases.LoadEventTableError + ": " + ex.Message);
return(false);
}
}
/// <summary>
/// Download event table
/// </summary>
private static bool LoadDataTable(EventAdapter eventAdapter, Log errLog, ref DataTable dataTable)
{
try {
eventAdapter.Fill(dataTable);
return(true);
} catch (Exception ex) {
string errMsg = AppPhrases.LoadEventTableError + ":\r\n" + ex.Message;
if (errLog != null)
{
errLog.WriteAction(errMsg, Log.ActTypes.Exception);
}
ScadaUiUtils.ShowError(errMsg);
return(false);
}
}
private void btnOpen_Click(object sender, EventArgs e)
{
try
{
if (rbSnapshot.Checked)
{
dataTable = new DataTable("SrezTable");
srezTable = new SrezTable();
SrezAdapter sa = new SrezAdapter();
sa.FileName = txtFileName.Text;
sa.Fill(dataTable);
sa.Fill(srezTable);
dataTable.RowChanged += DataTable_RowChanged;
dataTable.Columns["DateTime"].ReadOnly = true;
dataTable.Columns["CnlNum"].ReadOnly = true;
}
else if (rbEvent.Checked)
{
dataTable = new DataTable("EventTable");
srezTable = null;
EventAdapter ea = new EventAdapter();
ea.FileName = txtFileName.Text;
ea.Fill(dataTable);
}
else // rbBase.Checked
{
dataTable = new DataTable("BaseTable");
srezTable = null;
BaseAdapter ba = new BaseAdapter();
ba.FileName = txtFileName.Text;
ba.Fill(dataTable, true);
}
dataTable.DefaultView.AllowNew = !rbSnapshot.Checked;
dataTable.DefaultView.AllowEdit = true;
dataGridView.DataSource = dataTable;
}
catch (Exception ex)
{
dataTable = null;
ScadaUiUtils.ShowError(ex.Message);
}
finally
{
ShowRecordCount();
}
}
/// <summary>
/// Loads events from file and adds to the queue.
/// </summary>
private void ExportEventsFromFile(DateTime minDT, DateTime maxDT)
{
if (minDT.Date != maxDT.Date)
{
log.WriteError(Localization.UseRussian ?
"Временной диапазон событий должен быть в пределах одних суток" :
"The time range of events must be within one day");
return;
}
string fileName = ServerUtils.BuildEvFileName(arcDir, minDT.Date);
if (!File.Exists(fileName))
{
log.WriteError(string.Format(CommonPhrases.NamedFileNotFound, fileName));
return;
}
try
{
EventTableLight eventTable = new EventTableLight();
EventAdapter eventAdapter = new EventAdapter {
FileName = fileName
};
eventAdapter.Fill(eventTable);
foreach (EventTableLight.Event ev in eventTable.AllEvents)
{
if (minDT <= ev.DateTime && ev.DateTime <= maxDT)
{
EnqueueEvent(ev);
}
}
}
catch (Exception ex)
{
log.WriteException(ex, Localization.UseRussian ?
"Ошибка при загрузке событий из файла {0}" :
"Error loading events from file {0}", fileName);
}
}
