Student/selectcourse.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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.OleDb;

public partial class selectcourse : System.Web.UI.Page
{
    DataSet myds = new DataSet();
    string mysql;
    CommDB mydb = new CommDB();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            int i,j;
            string sn = "";
            mysql = "SELECT * FROM selcourse WHERE sno='" + Session["uno"] +"'";
            i = mydb.Rownum(mysql, "selcourse", ref sn);
            mysql = "SELECT * FROM score WHERE sno='" + Session["uno"] + "'";
            j = mydb.Rownum(mysql, "score", ref sn);
            if (i == 0 && j == 0)  //第一次选课:score和selcourse表中都没有该学号的记录
            {
                mysql = "INSERT INTO selcourse(sno,cno,cname,ctime,cplace,tno,tname,sel) SELECT '" +
                    Session["uno"] + "',cno,cname,ctime,cplace,tno,tname,'×' FROM course";
                mydb.ExecuteNonQuery(mysql);
                bind();
            }
            else if (i > 0)  //selcourse表中有该学号的记录
                bind();
            else
                Response.Redirect("~/dispinfo.aspx?info=" + "你选课已提交,不能再重新选课");
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)  
         //选定课程
    {
         mysql = "UPDATE selcourse SET sel='√' WHERE sno='" + Session["uno"] + "' AND cno='" + GridView1.DataKeys[e.NewEditIndex].Value.ToString() + "'";
         mydb.ExecuteNonQuery(mysql);
         bind();

     }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        //取消选课
    {
        mysql = "UPDATE selcourse SET sel='×' WHERE sno='" + Session["uno"] + "' AND cno='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        mydb.ExecuteNonQuery(mysql);
        bind();
    }
    // 下载于www.51aspx.com
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bind();