student/ChkCourse.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Student_ChkCourse : System.Web.UI.Page
{
    data mydata = new data();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["xuehao"] == null)
            {
                Alert.AlertAndRedirect("请重新登陆账号", "CourseList.aspx");
                return;
            }
            string Cid = Request.QueryString["id"].ToString();
            SqlDataReader dr = mydata.GetDataReader("select * from SelectCourse where CourseId='" + Cid + "' and Stuid='" + Session["xuehao"].ToString() + "' ");
            if (dr.Read())
            {
                Alert.AlertAndRedirect("您已经选了该课程不能重复选课", "CourseList.aspx");
          
            }
            else
            {
                
              


                     dr = mydata.GetDataReader(@"select count(1) as totalnum from  SelectCourse where courseId='" + Cid + "'");
                     if (dr.Read())
                     {
                         if (Convert.ToInt32(dr["totalnum"]) > 50)
                         {
                             Alert.AlertAndRedirect("你选的课程已满员，请选择另外课程", "CourseList.aspx");
                         }
                         else
                         {
                             mydata.RunSql("insert into SelectCourse(CourseId,Stuid)values('" + Cid + "','" + Session["xuehao"].ToString() + "')");
                             Alert.AlertAndRedirect("选择该课程成功", "MyCourse.aspx");
                         }

                     }



              
            }
        }
    }
}