public List <DataTable> LoadPeriodData(PeriodConfiguration periodConf) { List <DataTable> dataList = new List <DataTable>(); foreach (var channel in periodConf.SelectedChannelList) { string query = "SELECT DATEPART(yy, [DateTime]),Year_Quarter, " + periodConf.ValueMeasureType + "([" + periodConf.SelectedBandpass.BandpassName + "]) " + "FROM(SELECT CASE " + "WHEN DATEPART(mm, [DateTime]) = 1 THEN '1th' WHEN DATEPART(mm, [DateTime]) = 2 THEN '1th' WHEN DATEPART(mm, [DateTime]) = 3 THEN '1th' " + "WHEN DATEPART(mm, [DateTime]) = 4 THEN '2nd' WHEN DATEPART(mm, [DateTime]) = 5 THEN '2nd' WHEN DATEPART(mm, [DateTime]) = 6 THEN '2nd' " + "WHEN DATEPART(mm, [DateTime]) = 7 THEN '3rd' WHEN DATEPART(mm, [DateTime]) = 8 THEN '3rd' WHEN DATEPART(mm, [DateTime]) = 9 THEN '3rd' " + "WHEN DATEPART(mm, [DateTime]) = 10 THEN '4th' WHEN DATEPART(mm, [DateTime]) = 11 THEN '4th' WHEN DATEPART(mm, [DateTime]) = 12 THEN '4th' " + "END Year_Quarter,[" + periodConf.SelectedBandpass.BandpassName + "],[DateTime] " + "FROM " + DataConnection.Database + ".[dbo].[VectorData_month_" + periodConf.ValueMeasureType + "] " + "WHERE [ChannelId]=" + channel.Id + " AND [DateTime] >= '" + periodConf.StartDateStr + "' AND [DateTime] < '" + periodConf.StartDate.AddYears(1).ToString("yyyy-MM-dd") + "')AS T " + "GROUP BY DATEPART(yy, [DateTime]),Year_Quarter " + "ORDER BY DATEPART(yy, [DateTime]),Year_Quarter "; DataTable table = GetResultByQuery(query, DataConnection); table.TableName = channel.PointName; dataList.Add(table); } return(dataList); }
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 }; }