public List <DataTable> LoadDayOfWeekData(DayOfWeekConfiguration dowConf) { List <DataTable> dataList = new List <DataTable>(); foreach (var bandpass in dowConf.Channel.BandpassArr.Where(x => x.DisplayName != null)) { if (bandpass.Active) { string query = "SELECT WEEK_NAME, " + dowConf.ValueMeasureType + "([" + bandpass.BandpassName + "]) " + "FROM(SELECT CASE " + "WHEN DATEPART(dw, [DateTime]) = 1 THEN 'Sun' " + "WHEN DATEPART(dw, [DateTime]) = 2 THEN 'Mon' " + "WHEN DATEPART(dw, [DateTime]) = 3 THEN 'Tue' " + "WHEN DATEPART(dw, [DateTime]) = 4 THEN 'Wed' " + "WHEN DATEPART(dw, [DateTime]) = 5 THEN 'Thu' " + "WHEN DATEPART(dw, [DateTime]) = 6 THEN 'Fri' " + "WHEN DATEPART(dw, [DateTime]) = 7 THEN 'Sat' " + "END WEEK_NAME,[" + bandpass.BandpassName + "]" + "FROM [" + DataConnection.Database + "].[dbo].[VectorData_Day_" + dowConf.ValueMeasureType + "] " + "WHERE [ChannelId]=" + dowConf.Channel.Id + " AND [DateTime] BETWEEN '" + dowConf.StartDateStr + "' AND '" + dowConf.EndDateStr + "' " + "GROUP BY DATEPART(dw, [DateTime]),[" + bandpass.BandpassName + "])AS t1 " + "WHERE WEEK_NAME != 'Sun' AND WEEK_NAME != 'Sat' " + "GROUP BY WEEK_NAME " + "ORDER BY CASE " + "WHEN WEEK_NAME = 'Sun' THEN 7 " + "WHEN WEEK_NAME = 'Mon' THEN 6 " + "WHEN WEEK_NAME = 'Tue' THEN 5 " + "WHEN WEEK_NAME = 'Wed' THEN 4 " + "WHEN WEEK_NAME = 'Thu' THEN 3 " + "WHEN WEEK_NAME = 'Fri' THEN 2 " + "WHEN WEEK_NAME = 'Sat' THEN 1 " + "END"; DataTable dt = GetResultByQuery(query, DataConnection); dt.TableName = bandpass.OverrideInfo.OverrideName; dataList.Add(dt); } } 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 }; }