,教师等情况来确定是否选择此课。
主要相关代码如下:
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
{
///
///sortcourse的摘要说明。
///
publicclasssortcourse:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.DataGridDgd_sort;
protectedSystem.Web.UI.WebControls.TextBoxTbx_courseid;
protectedSystem.Web.UI.WebControls.TextBoxTbx_year;
protectedSystem.Web.UI.WebControls.ButtonBtn_look;
protectedSystem.Web.UI.WebControls.TextBoxTbx_teacher;
protectedSystem.Web.UI.WebControls.TextBoxTbx_term;
protectedSystem.Web.UI.WebControls.ButtonBtn_sort;
protectedSystem.Web.UI.WebControls.LabelLbl_all;
protectedSystem.Web.UI.WebControls.LabelLbl_note;
protectedSystem.Web.UI.WebControls.ButtonBtn_yes;
protectedSystem.Web.UI.WebControls.ButtonBtn_no;
protectedSystem.Web.UI.WebControls.PanelPn_yes;
protectedSystem.Web.UI.WebControls.CustomValidatorCv_course;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_year;
SqlConnectioncn;
protectedSystem.Web.UI.WebControls.DropDownListDdl_course;stringstrsql;
privatevoidPage_Load(objectsender,System.EventArgse)
{ stringstrconn=ConfigurationSettings.AppSettings["dsn"];
cn=newSqlConnection(strconn);
if(!IsPostBack)
{
//课程名称下拉列表框绑定
SqlConnectioncn0=newSqlConnection(strconn);
cn0.Open();
stringmysql1="select*fromcoursewhereCourse_kind='2'";
SqlCommandcm1=newSqlCommand(mysql1,cn0);
SqlDataReaderdr1=cm1.ExecuteReader();
Ddl_course.Items.Add(newListItem("",""));
while(dr1.Read())
{
Ddl_course.Items.Add(newListItem(dr1["Course_name"].ToString(),dr1["Course_id"].ToString()));
}
cn0.Close();
}
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
} ///
///设计器支持所需的方法-不要使用代码编辑器修改
///此方法的内容。
///
privatevoidInitializeComponent()
{
this.Btn_sort.Click+=newSystem.EventHandler(this.Btn_sort_Click);
this.Cv_course.ServerValidate+=newSystem.Web.UI.WebControls.ServerValidateEventHandler(this.Cv_course_ServerValidate);
this.Btn_yes.Click+=newSystem.EventHandler(this.Btn_yes_Click);
this.Btn_no.Click+=newSystem.EventHandler(this.Btn_no_Click);
this.Btn_look.Click+=newSystem.EventHandler(this.Btn_look_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
privatevoidBtn_sort_Click(objectsender,System.EventArgse)
{
stringstrsq="selectCOUNT(Student_id)fromstudent_coursewhereCourse_id='"+Tbx_courseid.Text+"'andCourse_year='"+Tbx_year.Text+"'";
SqlCommandcm1=newSqlCommand(strsq,cn);
cn.Open();
SqlDataReaderdr=cm1.ExecuteReader();
if(dr.Read())
{
Lbl_all.Text="选此课总人数为:"+dr[0].ToString();
}
else
{
Lbl_all.Text="无人选此课";
}
Pn_yes.Visible=true;
cn.Close();
}
privatevoidBtn_yes_Click(objectsender,System.EventArgse)
{
strsql="insertintostudent_course(Student_id,Course_id,Course_year)values(@Student_id,@Course_id,@Course_year)";
SqlCommandcm=newSqlCommand(strsql,cn);
cm.Parameters.Add(newSqlParameter("@Student_id",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Course_id",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Course_year",SqlDbType.VarChar,50));
cm.Parameters["@Student_id"].Value=Session["User_id"].ToString();
cm.Parameters["@Course_id"].Value=Tbx_courseid.Text;
cm.Parameters["@Course_year"].Value=Tbx_year.Text;
cn.Open();
try
{
cm.ExecuteNonQuery();
}
catch(SqlException)
{
Lbl_note.Text="添加失败!";
}
cn.Close();
}
privatevoidBtn_no_Click(objectsender,System.EventArgse)
{
Lbl_all.Text="请重新选择";
}
privatevoidCv_course_ServerValidate(objectsource,System.Web.UI.WebControls.ServerValidateEventArgsargs)
{
cn.Open();
strsql="select*fromcoursewhereCourse_id='"+Tbx_courseid.Text+"'";
SqlCommandcm=newSqlCommand(strsql,cn);
SqlDataReaderdr=cm.ExecuteReader();
if(dr.Read())
{
args.IsValid=true;
}
else
{
args.IsValid=false;
}
cn.Close();
}
privatevoidBtn_look_Click(objectsender,System.EventArgse)
{
if(Ddl_course.SelectedItem.Text=="")
{
if(Tbx_teacher.Text=="")
{strsql="selectcourse.Course_name,course.Course_id,teacher.Teacher_name,course.Course_credit,course.Course_periodfromcourse,teacher,teacher_coursewhereteacher_course.Course_year='"+Tbx_term.Text+"'andteacher_course.Course_id=course.Course_idandteacher_course.Teacher_id=teacher.Teacher_id";
}
else
{
strsql="selectcourse.Course_name,course.Course_id,teacher.Teacher_name,course.Course_credit,course.Course_periodfromcourse,teacher,teacher_coursewhereteacher_course.Course_year='"+Tbx_term.Text+"'andteacher_course.Course_id=course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandteacher.Teacher_name='"+Tbx_teacher.Text+"'";
}
}
else
{
if(Tbx_teacher.Text=="")
{
strsql="selectcourse.Course_name,course.Course_id,teacher.Teacher_name,course.Course_credit,course.Course_periodfromcourse,teacher,teacher_coursewhereteacher_course.Course_year='"+Tbx_term.Text+"'andteacher_course.Course_id=course.Course_idandteacher_course.Teacher_id=teacher.Teacher_idandcourse.Course_name='"+Ddl_course.SelectedItem.Text+"'";
}
else
{
strsql="selectcourse.Course_name,cou
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
用遗传算法解决车辆优化调度问题