/// <summary>
/// 单击课程名时显示课程详细信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lb1_SelectedIndexChanged(object sender, EventArgs e)
{
DALcourse dal = new DALcourse();
courseEntity course = dal.Getcourse(int.Parse(lb1.SelectedValue));
Literal1.Text = "课程名称：" + course.CourseName + "；<br/>授课教师：" + course.CourseTeacher + "；<br/>课程简介：" + course.CourseInfo + "；<br/>限选人数：" + course.CourseStudentNum;
}
/// <summary>
/// 当行数据绑定的时候，进行必要的翻译处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//翻译课程
DALcourse dalc = new DALcourse();
courseEntity c = dalc.Getcourse(int.Parse(e.Row.Cells[1].Text));
if (c != null) //判断是否有值
{
e.Row.Cells[1].Text = c.CourseName; //有值才能使用
}
//else
//{
// Response.Write("<script>alert('kongde');</script>");
//}
//翻译学生
DALstudent_info dals = new DALstudent_info();
IList <student_infoEntity> ss = dals.Getstudent_infosbyCondition("studentId='" + e.Row.Cells[0].Text + "'");
if (ss.Count > 0)
{
e.Row.Cells[0].Text = ss[0].StudentId;
}
}
}
/// <summary>
/// 加载已选课程
/// </summary>
public void BindSelectCourese()
{
DALstudent_course dal = new DALstudent_course();
IList <student_courseEntity> scs = dal.Getstudent_coursesbyCondition("StudentId='" + Session["name"].ToString() + "'");
if (scs.Count > 0)
{
Button1.Enabled = false;
Button2.Enabled = false;
Button3.Enabled = false;
Button3.ToolTip = "您已经选过课程了，只能查看！";
lb2.Items.Clear();//先清空，再绑定已选择的课程
DALcourse dalc = new DALcourse();
courseEntity c = new courseEntity();
foreach (student_courseEntity sc in scs)
{
c = dalc.Getcourse(int.Parse(sc.CourseId));//通过选课存储的课程号，到课程表中取出该课程的课程名称等信息
ListItem li = new ListItem(c.CourseName, c.Id.ToString());
lb2.Items.Add(li);
}
}
else
{
Button1.Enabled = true;
Button2.Enabled = true;
Button3.Enabled = true;
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//翻译课程号->名称
DALcourse dalc = new DALcourse();
courseEntity c = dalc.Getcourse(int.Parse(e.Row.Cells[0].Text));
if (c != null)
{
e.Row.Cells[0].Text = c.CourseName;
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DALcourse dal = new DALcourse(); //定义针对admin_user表的操作对象
string Id = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取操作行数据的主键Id
courseEntity course = dal.Getcourse(int.Parse(Id));
course.CourseName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
course.CourseTeacher = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
course.CourseInfo = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
course.CourseStudentNum = int.Parse(((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim());
dal.Modcourse(course);
GridView1.EditIndex = -1;
LoadData();//重新加载数据，验证是否重置
}
/// <summary>
/// 当行数据绑定的时候，进行必要的翻译处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//翻译课程编号->名称
DALcourse dalc = new DALcourse();
courseEntity c = dalc.Getcourse(int.Parse(e.Row.Cells[1].Text));
if (c != null)
{
e.Row.Cells[1].Text = c.CourseName;
}
//翻译学生编号->姓名
DALstudent_info dals = new DALstudent_info();
IList <student_infoEntity> ss = dals.Getstudent_infosbyCondition("Id='" + e.Row.Cells[0].Text + "'");
if (ss.Count > 0)
{
e.Row.Cells[0].Text = ss[0].StudentName;
}
}
}
