当前文件路径：TicketOnline/SystemCfg.aspx.cs

		            
  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 SystemCfg : System.Web.UI.Page
 14...{
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        if (!IsPostBack)
 18        ...{
 19            this.Panel1.Visible = true;
 20            this.Panel2.Visible = false;
 21            if (Session["Apw"].ToString()== "普通管理员")
 22            ...{
 23                Response.Write("<script language='javascript'>alert('对不起你没有该项的操作权限');location.href='Index.aspx'</script>");
 24            
 25            }
 26            else
 27                if (Session["Apw"].ToString() == "超级管理员")
 28                ...{
 29                  
 30 
 31                
 32                }
 33        
 34        }
 35
 36    }
 37    protected void linkconfig_Click(object sender, EventArgs e)
 38    ...{
 39        this.Panel2.Visible = false;
 40        this.Panel1.Visible = true;
 41    }
 42    protected void dayin_Click(object sender, EventArgs e)
 43    ...{
 44        Response.Write("<script language='javascript'>alert('该功能正在制作中！')</script>");
 45    }
 46    protected void linkclear_Click(object sender, EventArgs e)
 47    ...{
 48        this.txtname.Text = "";
 49        txtpwd.Text = "";
 50        txtpwd2.Text = "";
 51    }
 52    protected void lingadd_Click(object sender, EventArgs e)
 53    ...{
 54        try
 55        ...{
 56
 57            SqlConnection con = db.ceratcon();
 58            con.Open();
 59            SqlCommand cmd = new SqlCommand();
 60            cmd.Connection = (SqlConnection)con;//对象实例化
 61            cmd.CommandText = "insert into Admin (Apwd,Aname,Apw)values(@Apwd,@Aname,@Apw)";
 62
 63
 64            cmd.Parameters.Add("@Apwd", SqlDbType.VarChar);
 65            cmd.Parameters.Add("@Aname", SqlDbType.VarChar);
 66            cmd.Parameters.Add("@Apw",SqlDbType.VarChar);
 67
 68            cmd.Parameters["@Apwd"].Value = this.txtpwd.Text;
 69            cmd.Parameters["@Aname"].Value = this.txtname.Text;
 70            cmd.Parameters["@Apw"].Value = this.DropDownList1.SelectedItem.Text;
 71            cmd.ExecuteNonQuery();
 72            con.Close();
 73            Response.Write("<script language='javascript'>alert('注册成功请登陆');location.href='Index.aspx'</script>");
 74        }
 75        catch
 76        ...{
 77            Response.Write("<script language='javascript'>alert('注册失败请重新注册');location.href='SystemCfg.aspx'</script>");
 78        }
 79    }
 80    protected void linkUpdata_Click(object sender, EventArgs e)
 81    ...{
 82        Panel1.Visible = false;
 83        Panel2.Visible = true;
 84    }
 85    protected void txtpwd3_TextChanged(object sender, EventArgs e)
 86    ...{
 87
 88    }
 89    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
 90    ...{
 91        SqlConnection con = db.ceratcon();
 92        con.Open();
 93        SqlCommand cmd = new SqlCommand("select  * from Admin", con);//从数据库中选择数据
 94        cmd.Parameters.Add("@Aname", SqlDbType.VarChar);
 95        cmd.Parameters["@Aname"].Value = this.DropDownList1.SelectedItem.Text;
 96
 97        SqlDataReader sdr = cmd.ExecuteReader();//读数据
 98        if (sdr.Read())
 99        ...{
100            this.txtname2.Text = this.DropDownList3.SelectedItem.Text;
101            this.txtpwd3.Text = Convert.ToString(sdr["Apwd"]);
102            this.DropDownList2.SelectedItem.Text = Convert.ToString(sdr["Apw"]);
103
104
105
106        }
107        con.Close();
108
109    }
110    protected void LinkButton1_Click(object sender, EventArgs e)
111    ...{
112        string name = this.DropDownList3.SelectedItem.Text;
113        SqlConnection con = db.ceratcon();
114        con.Open();
115        SqlCommand cmd = new SqlCommand();
116        cmd.Connection = (SqlConnection)con;
117        cmd.CommandText = "update   Admin set Apwd=@Apwd,Aname=@Aname,Apw=@Apw where Aname=@Aname";
118        cmd.Parameters.Add("@Apwd", SqlDbType.VarChar);
119        cmd.Parameters.Add("@Aname", SqlDbType.VarChar);
120        cmd.Parameters.Add("@Apw", SqlDbType.VarChar);
121
122        cmd.Parameters["@Apwd"].Value =this.txtpwd3.Text;
123        cmd.Parameters["@Aname"].Value = this.txtname2.Text;
124        cmd.Parameters["@Apw"].Value = this.DropDownList2.SelectedItem.Text;
125        cmd.ExecuteNonQuery();
126         con.Close();
127         Response.Write("<script language='javascript'>alert('修改成功');location.href='SystemCfg.aspx'</script>");
128
129    }
130}
131