private DataTable GetDataTable()
{
try
{
DataTable dt = SchoolBusiness.GetAllData();
string sex = ddl_sex.SelectedValue;
string startYear = input_start.Value;
string endYear = input_end.Value;
DataTable dt_student = StudentBusiness.GetAllData("", "", sex, startYear, endYear);
if (dt != null)
{
dt.Columns["SchoolName"].ColumnName = "ItemName";
dt.Columns.Add("Count"); // 总人数
dt.Columns.Add("Percent"); //百分比
int itemCount = dt.Rows.Count; //总项数
int totals = dt_student.Rows.Count; //总人数
foreach (DataRow dr in dt.Rows)
{
int count = dt_student.Select("School = '" + dr["ItemName"] + "'").Length;
double percent = totals == 0 ? 0.0000 : Math.Round(count * 1.0 / totals, 4);
dr["Percent"] = percent * 100 + "%";
dr["Count"] = count.ToString();
}
DataRow dr_total = dt.NewRow();//添加一条 总计
dr_total["ItemName"] = "总计";
dr_total["Count"] = totals;
dr_total["Percent"] = totals == 0 ? "0.00%" : "100%";
dt.Rows.Add(dr_total);
return(dt);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "layer.alert('数据加载错误！')", true);
return(new DataTable());
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "layer.alert('数据加载错误！')", true);
return(new DataTable());
}
}
private void Bind_statistic()
{
try
{
DataTable dt = SchoolBusiness.GetAllData();
string sex = ddl_sex.SelectedValue;
string startYear = input_start.Value;
string endYear = input_end.Value;
string label = "";
if (!startYear.IsNullOrEmpty())
{
label += "【出生年份>=" + startYear + "年】";
}
if (!endYear.IsNullOrEmpty())
{
label += "【出生年份<=" + endYear + "年】";
}
if (!sex.Equals("99"))
{
label += "【" + ddl_sex.SelectedItem.Text + "性】";
}
if (label == "")
{
label = "【全体】";
}
label += "在校本科生学院分布统计";
label_head.Text = label;
DataTable dt_student = StudentBusiness.GetAllData("", "", sex, startYear, endYear);
if (dt != null)
{
dt.Columns["SchoolName"].ColumnName = "ItemName";
dt.Columns.Add("Count"); // 总人数
dt.Columns.Add("Percent"); //百分比
int itemCount = dt.Rows.Count; //总项数
int totals = dt_student.Rows.Count; //总人数
foreach (DataRow dr in dt.Rows)
{
int count = dt_student.Select("School = '" + dr["ItemName"] + "'").Length;
double percent = totals == 0 ? 0.0000 : Math.Round(count * 1.0 / totals, 4);
dr["Percent"] = percent * 100 + "%";
dr["Count"] = count.ToString();
if (PercentString.Equals(""))
{
PercentString = "['" + dr["ItemName"] + "'," + percent + "]";
}
else
{
PercentString += ",['" + dr["ItemName"] + "'," + percent + "]";
}
}
DataRow dr_total = dt.NewRow();//添加一条 总计
dr_total["ItemName"] = "总计";
dr_total["Count"] = totals;
dr_total["Percent"] = totals == 0 ? "0.00%" : "100%";
dt.Rows.Add(dr_total);
gv_result.DataSource = dt;
gv_result.DataBind();
Label_Result.Text = itemCount.ToString();
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "layer.alert('数据加载错误！')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alter", "layer.alert('数据加载错误！')", true);
}
}