当前文件： OlympicBook20/RoleByAccess/adminpara.aspx.cs[3K，2009-6-12 11:51:24]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.OleDb;
12public partial class RoleByAccess_adminpara : System.Web.UI.Page
13...{
14    OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if(!this.Page.IsPostBack)
18        ...{
19            this.ShowInfoSys();
20        }
21    }
22    protected void Button2_Click(object sender, EventArgs e)
23    ...{
24        if(this.username.Text==String.Empty)
25        ...{
26            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script language=javascript>alert('用户名不能为空！');</script>");  
27           
28            return;
29        }
30        if (this.userpwd.Text == String.Empty)
31        ...{
32            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert2", "<script language=javascript>alert('原密码不能为空！');</script>");  
33           
34            return;
35        }
36        if (this.newpwd.Text == String.Empty)
37        ...{
38            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert3", "<script language=javascript>alert('新密码不能为空！');</script>");  
39            
40            return;
41        }
42        if (this.newreaptpwd.Text == String.Empty)
43        ...{
44            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert4", "<script language=javascript>alert('重复密码不能为空！');</script>");  
45          
46            return;
47        }
48        if (this.newpwd.Text !=this.newreaptpwd.Text)
49        ...{
50            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert5", "<script language=javascript>alert('两次输入的密码不一致！');</script>");  
51            
52            return;
53        }
54        string sql = "update  admin  set userpwd='" + this.newpwd.Text.Trim() + "' where username=" + Session["user"].ToString(); ;
55        OleDbCommand comm = new OleDbCommand(sql, conn);
56        conn.Open();
57        comm.ExecuteNonQuery();
58        conn.Close();
59        comm.Dispose();
60    }
61    protected void Button1_Click(object sender, EventArgs e)
62    ...{
63        string sql = "update  sysconfig  set maxletter='"+this.letters.Text.Trim()+"',zanghua='"+this.zanghua.Text.Trim()+"'" ;
64        OleDbCommand comm = new OleDbCommand(sql,conn);
65        conn.Open();
66        comm.ExecuteNonQuery();
67        conn.Close();
68        comm.Dispose();
69        Page.ClientScript.RegisterStartupScript(this.GetType(), "alert6", "<script language=javascript>alert('保存成功！');</script>");  
70        //this.Label2.Text = "保存成功！";
71    }
72    private void ShowInfoSys() 
73    ...{
74        string str = "select * from sysconfig ";
75        OleDbDataAdapter da = new OleDbDataAdapter(str, conn);
76        DataSet ds = new DataSet();
77        da.Fill(ds, "m");
78        this.zanghua.Text = ds.Tables["m"].Rows[0]["zanghua"].ToString();
79    }
80}
81