当前文件： ProjectManager/userControl/ucModifyPassword.ascx.cs[1K，2009-6-12 11:52:29]，打开代码结构图

		            
 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.Common;
12using projmanager;
13
14public partial class ucModifyPassword : System.Web.UI.UserControl
15...{
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18
19    }
20    protected void btnModifyPwd_Click(object sender, EventArgs e)
21    ...{
22        string employeeid = Session["LoginEmployeeID"].ToString();
23        string sql = "select password from employee where employeeid=" + employeeid;
24        string oldpassword = this.tbOldPwd.Text;
25
26     
27        DbDataReader reader = DataAccess.ExecuteDataReader(sql);
28        if (reader.Read())
29        ...{
30            oldpassword = reader["password"].ToString();
31        }
32        reader.Close();
33
34        if (this.tbOldPwd.Text.Trim() != oldpassword)
35        ...{
36            lbMsg1.Text = "原密码错误";
37            return;
38        }
39
40        string newpassword1 = this.tbNewPwd1.Text.Trim();
41        string newpassword2 = this.tbNewPwd2.Text.Trim();
42        if (newpassword1 != newpassword2)
43        ...{
44            lbMsg2.Text = "两次密码输入不一致";
45            return;
46        }
47        sql = "update employee set password='" + newpassword1 + "' where employeeid = " + employeeid;
48        if (DataAccess.ExecuteNonQuery(sql) == 1)
49        ...{
50            this.lbMsg.Text = "密码修改成功";
51        }
52        else
53        ...{
54            this.lbMsg.Text = "密码修改失败";
55        }
56    }
57}
58