course.aspx.cs

基于asp.net的网上选课系统

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 Course : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //设置分页控件的数据源
        Pg1.datalist1 = DataList1;
        Pg1.CmdStr = "SELECT CourseID, CourseName, CourseHours, CourseScore, UpperLimitStudentNumber, SelectedStudentNumber FROM Courses WHERE TeacherID ="+ "'" + Session["userid"] + "'";
    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        string CourseID, CourseName, TeacherID;
        int CourseHours, CourseScore, UpperLimitStudentNumber;
        bool aff;
        TeaSQL tea = new TeaSQL();
        tea.Open();
        if (e.CommandName == "insert")
        {
            CourseID = ((TextBox)e.Item.FindControl("id")).Text.ToString();
            CourseName = ((TextBox)e.Item.FindControl("name")).Text.ToString();
            CourseHours = Convert.ToInt32(((TextBox)e.Item.FindControl("hour")).Text.ToString());
            CourseScore = Convert.ToInt32(((TextBox)e.Item.FindControl("score")).Text.ToString());
            TeacherID =(string)Session["userid"];  
            UpperLimitStudentNumber =
                Convert.ToInt32(((TextBox)e.Item.FindControl("num")).Text.ToString());
            if (CourseID!= "" && CourseName!= "" && CourseHours!=0 &&CourseScore!=0 &&UpperLimitStudentNumber!=0)
           {
               //得到CourseID的前三位字符
               string str = CourseID.Substring(0, 3);
               int a = Convert.ToInt32(Session["userid"] + "001");
               if (str != (string)Session["userid"] || Convert.ToInt32(str) < a)
               {
                   Response.Write("<script>javascript:alert('若要开设课程，课程号需为自己的工号开头且附上从001开始的数字！');</script>");
               }
               else
               {
                   aff = tea.AddCourse(CourseID, CourseName, CourseHours, CourseScore, TeacherID, UpperLimitStudentNumber);
                   if (aff)
                   {

                       Response.Write("<script>javascript:alert('添加课程成功！');</script>");
                   }
                   else
                   {
                       Response.Write("<script>javascript:alert('添加课程失败，课程号已存在或其它错误！');</script>");
                   }
               }
           }
             else
           {
               Response.Write("<script>javascript:alert('添加课程失败，请输入完整的课程信息！');</script>");
           }
           ((TextBox)e.Item.FindControl("id")).Text = "";
           ((TextBox)e.Item.FindControl("name")).Text = "";
           ((TextBox)e.Item.FindControl("hour")).Text = "";
           ((TextBox)e.Item.FindControl("score")).Text = "";
           ((TextBox)e.Item.FindControl("num")).Text = "";
       }
       Pg1.recordchanged();
       tea.Close();
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;
        Pg1.BindData();
    }

    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = -1;
        Pg1.BindData();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        string CourseID, CourseName;
        int CourseHours, CourseScore, UpperLimitStudentNumber;
        bool aff;

        TeaSQL tea = new TeaSQL();
        tea.Open();
        CourseID = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        CourseName = ((TextBox)e.Item.FindControl("txtCourseName")).Text.Trim(); ;
        CourseHours = Convert.ToInt32(((TextBox)e.Item.FindControl("txtCourseHours")).Text.Trim());
        CourseScore = Convert.ToInt32(((TextBox)e.Item.FindControl("txtCourseScore")).Text.Trim());
        UpperLimitStudentNumber =
            Convert.ToInt32(((TextBox)e.Item.FindControl("txtUpperLimitStudentNumber")).Text.Trim());
        aff = tea.ModifyCourse(CourseID, CourseName, CourseHours, CourseScore,UpperLimitStudentNumber);
        if (aff)
        {
            Response.Write("<script>javascript:alert('修改课程成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('修改课程失败！');</script>");
        }
        Pg1.recordchanged();
        tea.Close();
    }
    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
         if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
         {
             LinkButton btnDel = (LinkButton)e.Item.FindControl("btdelete");
             btnDel.Attributes.Add("onclick", "return confirm('确定要删除这条记录吗？')");

             e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='#cccc00'");
             e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='white'");
         }
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string CourseID;
        bool aff;
        TeaSQL tea = new TeaSQL();
        tea.Open();
      
        CourseID = DataList1.DataKeys[e.Item.ItemIndex].ToString().Trim();
        aff = tea.RemoveCourse(CourseID);
        if (aff)
        {
            Response.Write("<script>javascript:alert('删除课程成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('删除课程失败！');</script>");
        }
        Pg1.recordchanged();
        tea.Close();
    }
}