teacherinfo.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_TeacherInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["USERSTYLE"] == "TEACHER")
        {
           
        }
        else
        {
            Dialog("对不起，你没有权限访问这个页面！");
        }
    }
    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 BtnRead_Click(object sender, EventArgs e)
    {
        SqlData sql = new SqlData();
        String StrTno = Session["USERID"].ToString();
        String TableName = "TAB_TEACHER";
        String CloumnName = "TNO";
        String ReturnCloumn = "TNAME";
        TxtTname.Text = sql.FindString(TableName, CloumnName, ReturnCloumn, StrTno);
        sql.SqlDataClose();
    }
    protected void BtnChangeInfo_Click(object sender, EventArgs e)
    {
        SqlData sql = new SqlData();
        String[] StrAll ={ "成功修改", "修改失败" };
        String StrTName = TxtTname.Text.ToString();
        String StrTno = Session["USERID"].ToString();
        String TableName = "TAB_TEACHER";
        String WhereCloumn = "TNO";
        String[] UpdateCloumn ={ "TNAME" };
        String[] UpdateStr ={ StrTName };
        if (sql.updateRow(TableName, UpdateCloumn, UpdateStr, UpdateStr.Length, WhereCloumn, StrTno) == 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 StrTno = Session["USERID"].ToString();
        String StrTPassword = TxtTPassword.Text.ToString();
        String StrNewPassword = TxtNewPassword.Text.ToString();
        String StrConfirm = TxtConfirm.Text.ToString();
        String TableName = "TAB_TEACHER";
        String CloumnName = "TNO";
        String WhereCloumn = "TNO";
        String ReturnCloumn = "TPASSWORD";
        String[] UpdateCloumn ={ "TPASSWORD" };
        String[] UpdateStr ={ StrNewPassword };
        if ((sql.FindString(TableName, CloumnName, ReturnCloumn, StrTno) == StrTPassword) && (StrNewPassword == StrConfirm))
        {
            if (sql.updateRow(TableName, UpdateCloumn, UpdateStr, UpdateStr.Length, WhereCloumn, StrTno) == 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='./TeacherMain.aspx';");
           Response.Write(@"</script>");
        
    }
}