private void LoadSchoolRecord()
{
//그리드속성
SchoolGrid.AutoGenerateColumns = false;
SchoolGrid.AllowUserToAddRows = false;
SchoolGrid.MultiSelect = true;
SchoolGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
SchoolGrid.RowHeadersWidth = 15;
SchoolGrid.ColumnHeadersHeight = 20;
SchoolGrid.ColumnHeadersDefaultCellStyle.Font = new Font("Segoe UI", 9.5F);
SchoolGrid.RowsDefaultCellStyle.Font = new Font("Segoe UI", 9.5F);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "학년", "grade", true, 60);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "국어", "sch_korean", true, 60);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "영어", "sch_english", true, 60);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "수학", "sch_math", true, 60);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "평균", "total_avg", true, 60);
UtilityClass.AddNewColumnToDataGridView(SchoolGrid, "등급컷", "cut", true, 70);
SchoolRecordInfoDAC DAC = new SchoolRecordInfoDAC();
DataSet ds = DAC.GetSchoolRecordAvg(lblStudentID.Text);
SchoolGrid.DataSource = ds.Tables[0];
SchoolGrid.ClearSelection();
DAC.Dispose();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindGrid()
{
string sortField = SchoolGrid.Columns[SchoolGrid.SortColumnIndex].SortField;
string sortDirection = SchoolGrid.SortDirection;
DataTable table = GetSchoolInfoDateTable();
DataView TableView = table.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
SchoolGrid.DataSource = TableView;
SchoolGrid.DataBind();
}
/// <summary>
/// 行绑定事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SchoolGrid_OnPreRowDataBound(object sender, FineUI.GridPreRowEventArgs e)
{
LinkButtonField lbf = SchoolGrid.FindColumn("Schooledit") as LinkButtonField;
DataRowView row = e.DataItem as DataRowView;
string schoolno = row[0].ToString();
lbf.OnClientClick = WindowEdit.GetShowReference("SchoolEdit.aspx?flag=edit&id=" + schoolno + "", "校区编辑");
LinkButtonField lbfx = SchoolGrid.FindColumn("Schooldelete") as LinkButtonField;
DataRowView rowx = e.DataItem as DataRowView;
string schoolnox = rowx[0].ToString();
lbfx.OnClientClick = WindowDelete.GetShowReference("../SystemSet/DeletePassword.aspx?Type=School&id=" + schoolnox + "", "校区删除");
}
