当前文件： QiYeKeHuGuanLi/adduser.aspx.cs[2K，2009-6-12 11:52:45]，打开代码结构图

		            
 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.SqlClient;
12
13public partial class adduser : System.Web.UI.Page
14...{
15    SqlConnection cn;
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (Session["branch"].ToString() == "0")
19        ...{
20            
21        }
22        else
23        ...{
24            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
25            Page.Response.End();
26        }
27        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
28        cn = new SqlConnection(strconn);
29    }
30    private void Cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
31    ...{//对系统用户编号进行判断
32        cn.Open();
33        SqlCommand cm = new SqlCommand("select * from sysuser where Login=@user_id", cn);
34        cm.Parameters.Add("@user_id", SqlDbType.VarChar, 20);
35        cm.Parameters["@user_id"].Value = userid.Text;
36        SqlDataReader dr = cm.ExecuteReader();
37        if (dr.Read())
38        ...{
39            args.IsValid = false;
40        }
41        else
42        ...{
43            args.IsValid = true;
44        }
45        cn.Close();
46    }
47    protected void Btn_ok_Click(object sender, EventArgs e)
48    ...{
49        if (Page.IsValid)
50        ...{
51            SqlCommand cm = new SqlCommand("Addsysuser", cn);
52            cm.CommandType = CommandType.StoredProcedure;
53            cm.Parameters.Add(new SqlParameter("@Login", SqlDbType.VarChar, 20));
54            cm.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar, 50));
55            cm.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50));
56            cm.Parameters.Add(new SqlParameter("@branch", SqlDbType.Int, 4));
57          
58
59            cm.Parameters["@Login"].Value = userid.Text;
60            cm.Parameters["@password"].Value = userid.Text;
61            cm.Parameters["@name"].Value = name.Text;
62            cm.Parameters["@branch"].Value = Ddl_kind.SelectedItem.Value;
63         
64            cm.Connection.Open();
65            try
66            ...{
67                cm.ExecuteNonQuery();
68                Response.Redirect("edituser.aspx");
69
70            }
71            catch (SqlException)
72            ...{
73                Lbl_note.Text = "添加失败";
74                Lbl_note.Style["color"] = "red";
75            }
76            cm.Connection.Close();
77        }
78    }
79    protected void Btn_cancel_Click(object sender, EventArgs e)
80    ...{
81        Page.Response.Redirect("adduser.aspx");
82    }
83}
84