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 = "更新時間";
}
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;
}
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();
}
}
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";
}
}
