studentinfo.aspx.cs.svn-base

大学英语学习系统

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 SystemManage_StudentInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["USERSTYLE"] == "STUDENT")
        {
            
        }
        else
        {
            Dialog("对不起，你没有权限访问这个页面！");
            Response.Write(@"<script type='text/JavaScript'>");
            Response.Write(@"window.location='./Login.aspx';");
            Response.Write(@"</script>");
        }

    }
    private void Dialog(String Str)
    {
        Response.Write(@"<script type='text/JavaScript'>");
        Response.Write(@"alert('" + Str + "');");
        //Response.Write(@"window.location='./list_logingroup.aspx';");
        Response.Write(@"</script>");
    }
    protected void BtnChangeInfo_Click(object sender, EventArgs e)
    {
        SqlData sql = new SqlData();
        String[] StrAll ={"成功修改","修改失败" };
        String StrSName = TxtSname.Text.ToString();
        //TxtSClass.
        String StrClass = TxtSClass.Text.ToString();
        String StrSno = Session["USERID"].ToString();
        String TableName = "TAB_STUDENT";
        String WhereCloumn="SNO";
        String[] UpdateCloumn={"SNAME","SCLASS"};
        String[] UpdateStr={StrSName,StrClass};
        if (sql.updateRow(TableName, UpdateCloumn, UpdateStr, UpdateStr.Length, WhereCloumn, StrSno) == true)
        {
            Dialog(StrAll[0]);
        }
        else
        {
            Dialog(StrAll[1]);
        }
        sql.SqlDataClose();
    }
    protected void BtnChangePassword_Click(object sender, EventArgs e)
    {
        SqlData sql = new SqlData();
        String[] StrAll ={ "成功修改", "修改失败","你输入的密码错误或者验证密码不一致！"};
        String StrSno = Session["USERID"].ToString();
        String StrSPassword = TxtSPassword.Text.ToString();
        String StrNewPassword = TxtNewPassword.Text.ToString();
        String StrConfirm = TxtConfirm.Text.ToString();
        String TableName = "TAB_STUDENT";
        String CloumnName = "SNO";
        String WhereCloumn = "SNO";
        String ReturnCloumn = "SPASSWORD";
        String[] UpdateCloumn ={ "SPASSWORD"};
        String[] UpdateStr ={ StrNewPassword };
        if ((sql.FindString(TableName, CloumnName, ReturnCloumn, StrSno) == StrSPassword) && (StrNewPassword == StrConfirm))
        {
            if (sql.updateRow(TableName, UpdateCloumn, UpdateStr, UpdateStr.Length, WhereCloumn, StrSno) == true)
            {
                Dialog(StrAll[0]);
            }
            else
            {
                Dialog(StrAll[1]);
            }
        }
        else
        {
            Dialog(StrAll[2]);
        }
        sql.SqlDataClose();
    }
    protected void LnkReturn_Click(object sender, EventArgs e)
    {
        Response.Write(@"<script type='text/JavaScript'>");
        Response.Write(@"window.location='./Main.aspx';");
        Response.Write(@"</script>");
    }
    protected void BtnRead_Click(object sender, EventArgs e)
    {
        SqlData sql = new SqlData();
        String StrSno = Session["USERID"].ToString();
        String TableName = "TAB_STUDENT";
        String CloumnName = "SNO";
        String ReturnCloumn = "SNAME";
        TxtSname.Text = sql.FindString(TableName, CloumnName, ReturnCloumn, StrSno);
        ReturnCloumn = "SCLASS";
        TxtSClass.Text = sql.FindString(TableName, CloumnName, ReturnCloumn, StrSno);
        sql.SqlDataClose();
    }
}