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

public partial class user : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {   
       
        if (!IsPostBack)
        {
            //设置分页控件的数据源
            Pg1.datalist1 = DataList1;
            Pg1.CmdStr = "SELECT TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword, '老师' AS UserIdent FROM Teachers UNION SELECT StudentID, StudentName, StudentPwd, '学生' AS Expr1 FROM Students";
            ViewState["str"] = Pg1.CmdStr;
        }
        Pg1.CmdStr = (string)ViewState["str"];
        Pg1.datalist1 = DataList1;
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string userid,userident;
        bool aff;
        //打开数据库连接
        AdminSQL admin = new AdminSQL();
        admin.Open();

        userid= DataList1.DataKeys[e.Item.ItemIndex].ToString().Trim();
        userident = ((Label)e.Item.FindControl("UserIdentLabel")).Text.Trim();
        //根据用户身份调用AdminSQL类的DeleteStudent或DeleteTeacher删除用户记录
        if (userident=="学生")
        {
            aff = admin.DeleteStudent(userid);
        }
        else
        {
            aff = admin.DeleteTeacher(userid);
        }
        if (aff)
        {
            Response.Write("<script>javascript:alert('删除用户记录成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('删除用户记录失败！');</script>");
        }
        Pg1.recordchanged();
        //关闭数据库连接
        admin.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_CancelCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = -1;
        Pg1.BindData();
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;
        Pg1.BindData();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        string userid, username, userpwd,userident;
        bool aff;
        //打开数据库连接
        AdminSQL admin = new AdminSQL();
        admin.Open();
        userid  = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        username = ((TextBox)e.Item.FindControl("txtUserName")).Text.Trim(); 
        userpwd = ((TextBox)e.Item.FindControl("txtUserPassword")).Text.Trim();
        userident = ((Label)e.Item.FindControl("lblUserIdent")).Text.Trim();
        //根据用户身份调用AdminSQL类的ModifyStudent或ModifyTeacher修改用户记录
        if (userident =="学生")
        {
            aff = admin.ModifyStudent(userid, username, userpwd);
        }
        else
        {
            aff = admin.ModifyTeacher(userid, username, userpwd);
        }
        if (aff)
        {
            Response.Write("<script>javascript:alert('修改用户记录成功！');</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('修改用户记录失败！');</script>");
        }
        Pg1.BindData();
        //关闭数据库连接
        admin.Close();
    }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        string userid, username, userpwd, userident;
        int id;
        //打开数据库连接
        AdminSQL admin = new AdminSQL();
        admin.Open();
       
        if (e.CommandName == "insert")
        {
            userid = ((TextBox)e.Item.FindControl("id")).Text.Trim();
            username = ((TextBox)e.Item.FindControl("name")).Text.Trim();
            userpwd = ((TextBox)e.Item.FindControl("pwd")).Text.Trim();
            userident = ((DropDownList)e.Item.FindControl("drpIdent")).SelectedValue.ToString().Trim();
          
            if (userid != "" && username != "" && userpwd!="")
            {
                 //根据用户身份调用AdminSQL类的AddStudent或AddTeacher添加用户记录
                if (userident=="学生")
                {
                    id = admin.AddStudent(userid, username, userpwd);
                }
                else
                {
                    id = admin.AddTeacher(userid, username, userpwd);
                }
                if (id>0)
                {

                    Response.Write("<script>javascript:alert('添加用户记录成功！');</script>");
                }
                else
                {
                    Response.Write("<script>javascript:alert('添加用户记录失败，ID号已存在或其它错误！');</script>");
                }
            }
            else
            {
                Response.Write("<script>javascript:alert('添加用户记录失败，请输入完整的用户信息！');</script>");
            }
            ((TextBox)e.Item.FindControl("id")).Text = "";
            ((TextBox)e.Item.FindControl("name")).Text = "";
            ((TextBox)e.Item.FindControl("pwd")).Text = "";
        }
        Pg1.recordchanged();
        //关闭数据库连接
        admin.Close();
    }
    protected void btFind_Click(object sender, EventArgs e)
    {
        string str, userid,username;
        //打开数据库连接
        AdminSQL admin = new AdminSQL();
        admin.Open();
            if (txtid.Text != "" || txtname.Text != "")
            {
                userid = txtid.Text.Trim();
                username = txtname.Text.Trim();
                if (userid == "")
                {
                    if (drpident.SelectedValue == "Students")
                    {
                        str = "select StudentID AS UserID, StudentName AS UserName, StudentPwd AS UserPassword,'学生' as UserIdent from Students where StudentName=" + "'" + username + "'";
                    }
                    else if (drpident.SelectedValue == "Teachers")
                    {
                        str = "select TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword,'教师' as UserIdent from Teachers where TeacherName=" + "'" + username + "'";
                    }
                    else
                    {
                        str = "select TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword,'教师' as UserIdent from Teachers where TeacherName=" + "'" + username + "'";
                        str = str + "union ";
                        str=str+"select StudentID, StudentName, StudentPwd ,'学生' from Students where StudentName=" + "'" + username + "'";
                    }
                    Pg1.CmdStr = str;
                    ViewState["str"] = Pg1.CmdStr;
                    Pg1.recordchanged();
                }
                else
                {

                    if (drpident.SelectedValue == "Students")
                    {
                        str = "select StudentID AS UserID, StudentName AS UserName, StudentPwd AS UserPassword,'学生' as UserIdent from Students where StudentID=" + "'" + userid + "'";
                    }
                    else if (drpident.SelectedValue == "Teachers")
                    {
                        str = "select  TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword,'教师' as UserIdent from Teachers where TeacherID=" + "'" + userid + "'";
                    }
                    else
                    {
                        str = "select TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword,'教师' as UserIdent from Teachers where TeacherID=" + "'" + userid+ "'";
                        str = str + "union ";
                        str = str + "select StudentID, StudentName, StudentPwd ,'学生' from Students where StudentID=" + "'" + userid + "'";
                    }
                    Pg1.CmdStr = str;
                    ViewState["str"] = Pg1.CmdStr;
                    Pg1.recordchanged();
                }
            }
            else if (drpident.SelectedValue != "choose")
            {
                if (drpident.SelectedValue == "Students")
                {
                    str = "select StudentID AS UserID, StudentName AS UserName, StudentPwd AS UserPassword,'学生' as UserIdent from Students";
                }
                else  
                {
                    str = "select  TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword,'教师' as UserIdent from Teachers";
                }
                Pg1.CmdStr = str;
                ViewState["str"] = Pg1.CmdStr;
                Pg1.recordchanged();
            }
            else
           {
                Response.Write("<script>javascript:alert('请输入查询条件！');</script>");
                str = "SELECT TeacherID AS UserID, TeacherName AS UserName, TeacherPwd AS UserPassword, '老师' AS UserIdent FROM Teachers UNION SELECT StudentID, StudentName, StudentPwd, '学生' AS Expr1 FROM Students";
                Pg1.CmdStr = str;
                ViewState["str"] = Pg1.CmdStr;
                Pg1.recordchanged();
           }
        txtid.Text = "";
        txtname.Text = "";
        //关闭数据库连接
        admin.Close();
    }
}