protected void Data_Bind() { string stu_id = Session["account_user_id"].ToString(); string dept_id = ClassDBUtil.GetDeptID(StudentUserDBUtil.GetClassID(stu_id)); string sql1 = "SELECT course_schedule.course_schedule_id AS `课程编号`, course.course_name AS `课程名称`, course_schedule.course_schedule_type AS `课程类型`, course.course_credit AS `课程学分`, course_select.course_select_score AS `课程成绩` FROM (course_schedule INNER JOIN course ON course_schedule.course_id = course.course_id) INNER JOIN course_select ON course_select.course_schedule_id = course_schedule.course_schedule_id WHERE course_select.stu_id = '" + stu_id + "' AND course_select.course_select_score <> 0"; GeneralUtil.GridViewInit(GridView1, sql1); }
protected void Data_Bind() { string stu_id = Session["account_user_id"].ToString(); string dept_id = ClassDBUtil.GetDeptID(StudentUserDBUtil.GetClassID(stu_id)); string sql1 = "SELECT course_schedule.course_schedule_id AS `课程编号`, course.course_name AS `课程名称`, course_schedule.course_schedule_type AS `课程类型`, course_credit AS `课程学分`, course_schedule.course_schedule_capacity AS `容量`, course_schedule.course_schedule_capacity - course_selected_count.selected_count AS `余量` FROM (course_schedule INNER JOIN course ON course_schedule.course_id = course.course_id) LEFT JOIN course_selected_count ON course_schedule.course_schedule_id = course_selected_count.course_schedule_id WHERE course_schedule.dept_id = '" + dept_id + "' AND course_schedule.course_schedule_id NOT IN (SELECT course_schedule_id FROM course_select WHERE stu_id = '" + stu_id + "')"; GeneralUtil.GridViewInit(GridView1, sql1); string sql2 = "SELECT course_schedule.course_schedule_id AS `课程编号`, course.course_name AS `课程名称`, course_schedule.course_schedule_type AS `课程类型`, course_credit AS `课程学分` FROM (course_schedule INNER JOIN course ON course_schedule.course_id = course.course_id) INNER JOIN course_select ON course_select.course_schedule_id = course_schedule.course_schedule_id WHERE course_select.stu_id = '" + stu_id + "' AND course_select.course_select_score = 0"; GeneralUtil.GridViewInit(GridView2, sql2); }