public void ShowWeightLogs() { bll = new WeightLogBLL(); if (!isSearch || cmbMembers.SelectedIndex == 0) { dto.WeightLogs = bll.GetWeightLogs(); } else { dto.WeightLogs = bll.GetWeightLogs(memberID); } dataGridView1.DataSource = dto.WeightLogs; dataGridView1.Columns["ID"].HeaderText = "編號"; dataGridView1.Columns["MemberID"].Visible = false; dataGridView1.Columns["MemberName"].HeaderText = "會員名稱"; dataGridView1.Columns["Weight"].HeaderText = "體重"; dataGridView1.Columns["UpdatedDate"].HeaderText = "更新時間"; isSearch = false; }
public void ShowWeightLogs() { bll = new WeightLogBLL(); dto.WeightLogs = bll.GetWeightLogs(UserStatic.UserID); dataGridView1.DataSource = dto.WeightLogs; dataGridView1.Columns["ID"].Visible = false; dataGridView1.Columns["MemberID"].Visible = false; dataGridView1.Columns["MemberName"].HeaderText = "會員名稱"; dataGridView1.Columns["Weight"].HeaderText = "體重"; dataGridView1.Columns["UpdatedDate"].HeaderText = "更新時間"; }
private void ShowWeightLogChart() { weightLogBLL = new WeightLogBLL(); DateTime startDate = dpStart.Value; DateTime endDate = dpEnd.Value; if (selectedMember != 0) { weightLogDTO.WeightLogs = weightLogBLL.GetWeightLogs(selectedMember, startDate, endDate); if (weightLogDTO.WeightLogs.Count != 0) { chart1.Series.Clear(); chart1.Series.Add("體重"); chart1.DataSource = weightLogDTO.WeightLogs; chart1.Series["體重"].XValueMember = "UpdatedDate"; chart1.Series["體重"].YValueMembers = "Weight"; } else { chart1.Series.Clear(); } } else { weightLogDTO.WeightLogs = weightLogBLL.GetWeightLogs(startDate, endDate); var list = from wl in weightLogDTO.WeightLogs group wl by wl.MemberName into g select new { MemberName = g.Key, MemberCount = g.Count() }; chart1.Series.Clear(); chart1.Series.Add("體重登入次數"); chart1.DataSource = list.ToList(); chart1.Series["體重登入次數"].XValueMember = "MemberName"; chart1.Series["體重登入次數"].YValueMembers = "MemberCount"; } }
private void ShowWeightLogChart() { weightLogBLL = new WeightLogBLL(); DateTime startDate = dpStart.Value; DateTime endDate = dpEnd.Value; weightLogDTO.WeightLogs = weightLogBLL.GetWeightLogs(UserStatic.UserID, startDate, endDate); if (weightLogDTO.WeightLogs.Count != 0) { chart1.Series.Clear(); chart1.Series.Add("體重"); chart1.DataSource = weightLogDTO.WeightLogs.OrderBy(x => x.UpdatedDate); chart1.Series["體重"].XValueMember = "UpdatedDate"; chart1.Series["體重"].YValueMembers = "Weight"; chart1.Series["體重"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; chart1.Series["體重"].BorderWidth = 5; } else { chart1.Series.Clear(); } }