/// <summary> /// 月点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Month_Checked(object sender, RoutedEventArgs e) { //按钮颜色 HourBackcolor = Color; DayBackcolor = Color; MonthBackcolor = Click; string monthsql = $"SELECT 1 FROM FaultData"; DataTable MonthData = SQLiteHelp.ExecuteQuery(monthsql); if (MonthData.Rows.Count > 0) { UserPieCharts = new BreakDownPieChart("Month", "Bottom"); } else { UserPieCharts = new NoData(); } }
/// <summary> /// 天点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Day_Checked(object sender, RoutedEventArgs e) { //按钮颜色 HourBackcolor = Color; DayBackcolor = Click; MonthBackcolor = Color; var DayTime = DateTime.Today.Date.ToShortDateString(); string daysql = $"SELECT FaultID,Content FROM FaultData WHERE Day = '{DayTime}'"; DataTable DayData = SQLiteHelp.ExecuteQuery(daysql); if (DayData.Rows.Count > 0) { // 默认显示小时数据 UserPieCharts = new BreakDownPieChart("Day", "Bottom"); } else { UserPieCharts = new NoData(); } }