public DataTable LoadDailyData(DailyConfiguration dailyConf)
{
string query = string.Empty;
string[] bandpassStringArr = Enum.GetNames(typeof(VectorOverrideOrder));
for (int i = 0; i < bandpassStringArr.Length; i++)
{
query +=
"SELECT DISTINCT point.[ChannelId], machine.[Name] as Machine, point.[Name] as Point, " +
"Bandpass = '******', " +
"data_min.[" + bandpassStringArr[i] + "] as 'MIN', data_max.[" + bandpassStringArr[i] + "] as 'MAX', data_avg.[" + bandpassStringArr[i] + "] as 'AVG', " +
"Ch.ExtraJson " +
"FROM [" + ConfigConnection.Database + "].[dbo].[MimicNode] as point " +
"JOIN [" + ConfigConnection.Database + "].[dbo].[MimicNode] as machine " +
"ON point.[ParentId] = machine.[Id] " +
"JOIN [" + DataConnection.Database + "].[dbo].[VectorData_day_min] as data_min ON point.[ChannelId] = data_min.[ChannelId] " +
"JOIN [" + DataConnection.Database + "].[dbo].[VectorData_day_max] as data_max ON point.[ChannelId] = data_max.[ChannelId] " +
"JOIN [" + DataConnection.Database + "].[dbo].[VectorData_day_avg] as data_avg ON point.[ChannelId] = data_avg.[ChannelId] " +
"JOIN [" + ConfigConnection.Database + "].[dbo].[SensorChannel] as Ch ON point.[ChannelId] = Ch.[Id] " +
"WHERE point.[NodeType]=300 AND point.[Name] != 'spare' AND point.[Name] NOT LIKE 'Trigger%' AND data_min.[DateTime] = '" + dailyConf.StartDateStr + "' AND data_max.[DateTime] = '" + dailyConf.StartDateStr + "' AND data_avg.[DateTime] = '" + dailyConf.StartDateStr + "' ";
if (i < bandpassStringArr.Length - 1)
{
query += " UNION ";
}
}
return(GetResultByQuery(query, DataConnection));
}
public DataTable LoadShiftData(DailyConfiguration dailyConf)
{
string query = string.Empty;
string[] bandpassStringArr = Enum.GetNames(typeof(VectorOverrideOrder));
for (int i = 0; i < bandpassStringArr.Length; i++)
{
query += string.Format(
"SELECT DISTINCT point.[ChannelId], machine.[Name] as Machine, point.[Name] as Point, " +
"Bandpass = '******', " +
"data_min.[{0}] as 'MIN', data_max.[{0}] as 'MAX', data_avg.[{0}] as 'AVG', " +
"Ch.ExtraJson " +
"FROM [{1}].[dbo].[MimicNode] as point " +
"JOIN [{1}].[dbo].[MimicNode] as machine " +
"ON point.[ParentId] = machine.[Id] " +
"JOIN [{2}].[dbo].[VectorData_hour_min] as data_min ON point.[ChannelId] = data_min.[ChannelId] " +
"JOIN [{2}].[dbo].[VectorData_hour_max] as data_max ON point.[ChannelId] = data_max.[ChannelId] " +
"JOIN [{2}].[dbo].[VectorData_hour_avg] as data_avg ON point.[ChannelId] = data_avg.[ChannelId] " +
"JOIN [{1}].[dbo].[SensorChannel] as Ch ON point.[ChannelId] = Ch.[Id] " +
"WHERE point.[NodeType]=300 AND point.[Name] != 'spare' AND point.[Name] NOT LIKE 'Trigger%' " +
"AND data_min.[DateTime] >= '{3} {4}' AND data_min.[DateTime] <= '{3} {5}'" +
"AND data_max.[DateTime] >= '{3} {4}' AND data_max.[DateTime] <= '{3} {5}'" +
"AND data_avg.[DateTime] >= '{3} {4}' AND data_avg.[DateTime] <= '{3} {5}'"
, bandpassStringArr[i], ConfigConnection.Database, DataConnection.Database, dailyConf.StartDateStr, dailyConf.SelectedItem.TimeStrFrom, dailyConf.SelectedItem.TimeStrTo);
if (i < bandpassStringArr.Length - 1)
{
query += " UNION ";
}
}
return(GetResultByQuery(query, DataConnection));
}
public MainForm()
{
InitializeComponent();
#region MultiLang
BtnReport_BandpassTrend.Text = MultiLang.TrendOfMeasurements;
BtnReport_PointTrend.Text = MultiLang.TrendOfPoint;
BtnReport_DayOfWeek.Text = MultiLang.WeeklyComparison;
BtnReport_Period.Text = MultiLang.PeriodicComparison;
BtnReport_Daily.Text = MultiLang.Daily;
BtnReport_Repair.Text = MultiLang.MaintenanceTask;
BtnReport_PeriodDays.Text = MultiLang.PeriodDays;
BtnReport_GeneralTrend.Text = MultiLang.GenaralTrend;
BtnConfig_BandpassTrend.Text = MultiLang.Configuration;
BtnConfig_PointTrend.Text = MultiLang.Configuration;
BtnConfig_DayOfWeek.Text = MultiLang.Configuration;
BtnConfig_Period.Text = MultiLang.Configuration;
BtnConfig_Daily.Text = MultiLang.Configuration;
BtnConfig_Repair.Text = MultiLang.Configuration;
BtnConfig_PeriodDays.Text = MultiLang.Configuration;
BtnConfig_GeneralTrend.Text = MultiLang.Configuration;
BtnPreview_BandpassTrend.Text = MultiLang.Preview;
BtnPreview_PointTrend.Text = MultiLang.Preview;
BtnPreview_DayOfWeek.Text = MultiLang.Preview;
BtnPreview_Period.Text = MultiLang.Preview;
BtnPreview_Daily.Text = MultiLang.Preview;
BtnPreview_Repair.Text = MultiLang.Preview;
BtnPreview_PeriodDays.Text = MultiLang.Preview;
BtnPreview_GeneralTrend.Text = MultiLang.Preview;
#endregion
SQLRepository.Init();
LogGenerator.CreateLogFile();
CreatePreviewSample();
DBConn = new DBConnector();
ExcelManager = new ExcelIOManager();
MultiBandConf = new MultiMeasureConfiguration();
MultiPointConf = new MultiPointConfiguration();
DayOfWeekConf = new DayOfWeekConfiguration();
PeriodConf = new PeriodConfiguration();
DailyConf = new DailyConfiguration();
RepairConf = new RepairConfiguration();
PeriodDaysConf = new PeriodDaysConfiguration();
GeneralTrendConf = new GeneralTrendConfiguration();
PeriodDaysConfigDlg = new PeriodDaysDlg(PeriodDaysConf)
{
Owner = this
};
DailyConfDlg = new DailyConfigDlg(DailyConf)
{
Owner = this
};
MultiBandConfigDlg = new MultiMeasureConfigDlg(MultiBandConf)
{
Owner = this
};
MultiPointConfigDlg = new MultiPointConfigDlg(MultiPointConf)
{
Owner = this
};
DayOfWeekConfigDlg = new DayOfWeekConfigDlg(DayOfWeekConf)
{
Owner = this
};
PeriodConfigDlg = new PeriodConfigDlg(PeriodConf)
{
Owner = this
};
RepairConfigDlg = new RepairConfigDlg(RepairConf)
{
Owner = this
};
GeneralTrendConfigDlg = new GeneralConfigDlg(GeneralTrendConf)
{
Owner = this
};
}
