using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml;
using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;
namespace passworddemo
{
/// <summary>
/// **************************************************************
/// 文件功能:
/// 上级调用:
/// 下级调用:
/// 所用到表:
/// 参 数:
/// 设计思路:
/// 作 者: xuhu
/// 开发日期: 2005/05/01
/// 修改日期:
/// 其它信息:
/// **************************************************************
/// </summary>
public class WebForm5 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.TextBox role_name;
protected System.Web.UI.WebControls.TextBox comm;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected Microsoft.Web.UI.WebControls.TreeView TreeView1;
private void Page_Load(object sender, System.EventArgs e)
{
if(! this.Page.IsPostBack)
{
disAllTree(TreeView1);
}
}
public void disAllTree(TreeView tvXmlList)
{
tvXmlList.Nodes.Clear();
//添加根节点
TreeNode root=new TreeNode();
//root.ID="r10000";
root.ID="R00001";
root.Text="角色管理";
root.ImageUrl="/webctrl_client/1_0/images/root.gif";
tvXmlList.Nodes.AddAt(0,root);
DataTable tb = MyDB.gettable("SELECT * FROM sys_roletable ORDER BY sj_id");
for(int k=0;k<tb.Rows.Count;k++)
{
TreeNode tnCurrent=new TreeNode();
tnCurrent.ID= tb.Rows[k][0].ToString().Trim();
tnCurrent.Text= tb.Rows[k][1].ToString().Trim();
if(tb.Rows[k][3].ToString().Trim() == tvXmlList.Nodes[0].ID)
{
tvXmlList.Nodes[0].Nodes.Add(tnCurrent);
}
else
{
MyXml.addSubNode(tvXmlList.Nodes[0],tnCurrent,tb.Rows[k][3].ToString().Trim());
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TreeView1.SelectedIndexChange += new Microsoft.Web.UI.WebControls.SelectEventHandler(this.TreeView1_SelectedIndexChange);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{//添加
string fromindex = TreeView1.SelectedNodeIndex;
try
{
MyData.roletableAdd(TreeView1.GetNodeFromIndex(fromindex).ID,
role_name.Text,
comm.Text);
}
catch(System.Exception)
{
throw new System.Exception("添加失败!");
}
disAllTree(TreeView1);
TreeView1.SelectedNodeIndex = fromindex;
}
private void TreeView1_SelectedIndexChange(object sender, Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs e)
{//节点改变时
string sqlstring = "SELECT * FROM sys_roletable WHERE (role_id = '"+TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).ID+"')";
SqlDataReader rd = MyDB.DataReader(sqlstring);
if(rd.Read())
{
this.role_name.Text = (string)rd["role_name"];
this.comm.Text = (string)rd["comm"];
}
}
private void Button2_Click(object sender, System.EventArgs e)
{//删除
MyData.sys_roletableDelete(TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).ID);
TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).Remove();
}
private void Button3_Click(object sender, System.EventArgs e)
{ //修改
string fromindex = TreeView1.SelectedNodeIndex;
try
{
MyData.sys_roletableUpdate(
TreeView1.GetNodeFromIndex(fromindex).ID,
role_name.Text,
comm.Text);
this.Response.Write("<script>alert('数据处理成功!');</script>");
}
catch(System.Exception)
{
throw new System.Exception("edit失败!");
}
disAllTree(TreeView1);
TreeView1.SelectedNodeIndex = fromindex;
}
}
}