(Ddl_content.SelectedItem.Text=="优秀人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_department='"+Tbx_area.Text+"'andStudent_grade>=85";
}
elseif(Ddl_content.SelectedItem.Text=="不及格人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_department='"+Tbx_area.Text+"'andStudent_grade<60";
}
else
{
strsql="selectAVG(Student_grade),MAX(Student_grade)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_department='"+Tbx_area.Text+"'";
}
}
elseif(Ddl_stat.SelectedItem.Value=="学院")
{
if(Ddl_content.SelectedItem.Text=="总人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_college='"+Tbx_area.Text+"'";
}
elseif(Ddl_content.SelectedItem.Text=="优秀人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_college='"+Tbx_area.Text+"'andStudent_grade>=85";
}
elseif(Ddl_content.SelectedItem.Text=="不及格人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_college='"+Tbx_area.Text+"'andStudent_grade<60";
}
else
{
strsql="selectAVG(Student_grade),MAX(Student_grade)fromstudent_course,student,classwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid=class.Class_idandclass.Class_college='"+Tbx_area.Text+"'";
}
}
elseif(Ddl_stat.SelectedItem.Value=="班级")
{
if(Ddl_content.SelectedItem.Text=="总人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,studentwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid='"+Tbx_area.Text+"'";
}
elseif(Ddl_content.SelectedItem.Text=="优秀人数")
{
strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,studentwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid='"+Tbx_area.Text+"'andStudent_grade>=85";
}
elseif(Ddl_content.SelectedItem.Text=="不及格人数")
{strsql="selectAVG(Student_grade),MAX(Student_grade),COUNT(*)fromstudent_course,studentwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid='"+Tbx_area.Text+"'andStudent_grade<60";
}
else
{
strsql="selectAVG(Student_grade),MAX(Student_grade)fromstudent_course,studentwhereCourse_id='"+Tbx_classid.Text+"'andstudent_course.Course_year='"+Tbx_year.Text+"'andstudent_course.Student_id=student.Student_idandstudent.Student_classid='"+Tbx_area.Text+"'";
}
}
SqlCommandcm=newSqlCommand(strsql,cn);
cn.Open();
SqlDataReaderdr=cm.ExecuteReader();
if(dr.Read())
{
if(Ddl_content.SelectedItem.Text=="均分")
{
Lbl_average.Visible=true;
Lbl_average.Text="平均分为:"+dr[0].ToString();
}
elseif(Ddl_content.SelectedItem.Text=="最高分")
{
Lbl_high.Visible=true;
Lbl_high.Text="最高分为:"+dr[1].ToString();
}
elseif(Ddl_content.SelectedItem.Text=="总人数")
{
Lbl_all.Visible=true;
Lbl_all.Text="总人数为:"+dr[2].ToString();
}
elseif(Ddl_content.SelectedItem.Text=="优秀人数")
{
Lbl_a.Visible=true;
Lbl_a.Text="优秀人数为:"+dr[2].ToString();
}
elseif(Ddl_content.SelectedItem.Text=="不及格人数")
{
Lbl_unpass.Visible=true;
Lbl_unpass.Text="不及格人数为:"+dr[2].ToString();
}
else
{Lbl_note.Text="无此信息";
}
cn.Close();
}
}
}
}
8.8学生选课管理页面
学生选课管理页面窗体所示,学生选课后需要管理员进一步确认管理,来确定最终选课信息。
主要相关代码如下:
usingSystem;
usingSystem.Collections;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Drawing;
usingSystem.Web;
usingSystem.Web.SessionState;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.HtmlControls;
usingSystem.Configuration;
namespacesms
{
///
///student_course的摘要说明。
///
publicclassstudent_course:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.ButtonBtn_student;
protectedSystem.Web.UI.WebControls.DataGridDgd_sort;
protectedSystem.Web.UI.WebControls.LabelLbl_all;
protectedSystem.Web.UI.WebControls.TextBoxTbx_year;
protectedSystem.Web.UI.WebControls.LabelLbl_note;
protectedSystem.Web.UI.WebControls.ButtonBtn_exit;
protectedSystem.Web.UI.WebControls.DropDownListDdl_course;
protectedSystem.Web.UI.WebControls.DropDownListDdl_teacher;
SqlConnectioncn;
privatevoidPage_Load(objectsender,System.EventArgse)
{//教师名称下拉列表框绑定
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
//连接本地计算机的sms数据库
SqlConnectioncn0=newSqlConnection(strconn);
if(!IsPostBack)
{
cn0.Open();
stringmysql="select*fromteacher";
SqlCommandcm0=newSqlCommand(mysql,cn0);
SqlDataReaderdr0=cm0.ExecuteReader();
while(dr0.Read())
{
Ddl_teacher.Items.Add(newListItem(dr0["Teacher_name"].ToString(),dr0["Teacher_id"].ToString()));
}
cn0.Close();
//课程名称下拉列表框绑定
cn0.Open();
stringmysql1="select*fromcourse";
SqlCommandcm1=newSqlCommand(mysql1,cn0);
SqlDataReaderdr1=cm1.ExecuteReader();
while(dr1.Read())
{
Ddl_course.Items.Add(newListItem(dr1["Course_name"].ToString(),dr1["Course_id"].ToString()));
}
cn0.Close();
}
//在此处放置用户代码以初始化页面
cn=newSqlConnection(strconn);
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
///
///设计器支持所需的方法-不要使用代码编辑器修改
///此方法的内容。
///
privatevoidInitializeComponent()
{
this.Btn_student.Click+=newSystem.EventHandler(this.Btn_student_Click);
this.Btn_exit.Click+=newSystem.EventHandler(this.Btn_exit_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
privatevoidBtn_student_Click(objectsender,System.EventArgse)
{Bindgrid();
}
publicvoidDataGrid_delete(objectsender,DataGridCommandEventArgse)
{
stringstrsql="deletefromstudent_coursewhereID=@id";
SqlCommandcm=newSqlCommand(strsql,cn);
cm.Parameters.Add(newSqlParameter("@ID",SqlDbType.BigInt,8));
cm.Parameters["@id"].Value=Dgd_sort.DataKeys[(int)e.Item.ItemIndex];
cm.Connection.Open();
try
{
cm.ExecuteNonQuery();
Lbl_note.Text="删除成功";
}
catch(SqlException)
{
Lbl_note.Text="删除失败";
Lbl_note.Style["color"]="red";
}
cm.Connection.Close();
Bindgrid();
}
publicvoidBindgrid()
{
stringstrsql="selectstudent_course.ID,student.Student_id,student.Student_classidfromstudent_course,student,teacher_coursewherestudent_course.Course_id='"+Ddl_course.SelectedItem.Value+"'andstudent_course.Course_year=teacher_course.Course_yearandstudent_course.Course_year='"+Tbx_year.Text+"'andteacher_course.Teacher_id='"+Ddl_teacher.SelectedItem.Value+"'andstudent_course.Course_id=teacher_course.Course_idandstudent.Student_id=student_course.Student_id";
SqlDataAdapterda=newSqlDataAdapter(strsql,cn);
DataSetds=newDataSet();
da.Fill(ds);
Dgd_sort.DataSource=ds;
Dgd_sort.DataBind();
stringstrsq="selectCOUNT(*)fromstudent_course,student,teacher_coursewherestudent_course.Course_id='"+Ddl_course.SelectedItem.Value+"'andstudent_course.Course_year=teacher_course.Course_yearandstudent_course.Course_year='"+Tbx_year.Text+"'andteacher_course.Teacher_id='"+Ddl_teacher.SelectedItem.Value+"'andstudent_course.Course_id=teacher_course.Course_idandstudent.Student_id=student_course.Student_id";
SqlCommandcm1=newSqlCommand(strsq,cn);
cn.Open();
SqlDataReaderdr=cm1.ExecuteReader();
if(dr.Read())
{
Lbl_all.Text="选课总人数为:"+dr[0].ToString();
}
else
{
Lbl_all.Text="无人选此课";
}
cn.Close();
}
privatevoidBtn_exit_Click(objectsender,System.EventArgse)
{
Response.Redirect("default.aspx");
}
}
}
8.9学生选课页面
学生可进入学生选课页面浏览本学期待选课程的信息,可以设定查询条件,可以根据选此课的人数,教师等情况来确定是否选择此课。
主要相关代码
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
金融危机下的新贸易保护主