/// <summary>
/// 初始化统计grid
/// </summary>
private void dataSource_reports()
{
List <Reports> list = DbUtil.queryReports("select level, count(1), FORMAT(sum(weight),2), FORMAT(sum(weight)/count(1),2) from t_weights where life_cycle=1 and DATE(create_time) = '" + this.input_date.Value.ToString("yyyy-MM-dd") + "' group by level; ");
Reports reports = new Reports();
reports.report_level = "累计";
reports.report_count = list.Sum(t => t.report_count);
reports.report_weight = double.Parse(list.Sum(t => t.report_weight).ToString("0.00"));
reports.report_average = double.Parse((reports.report_weight / reports.report_count).ToString("0.00"));
list.Add(reports);
this.grid_reports.DataSource = list;
this.grid_reports.ClearSelection();
}
