[原创]使用Microsoft.Web.UI.WebControls的iewc轻松解决权限树问题（无限级权限管理）2

TreeControl.cs ：对树的操作

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.Data.SqlClient;

using System.Text.RegularExpressions;

using System.IO;

using System.Text;

using System.Xml;

using Microsoft.Web.UI.WebControls;

namespace YljWeb.Classes

{

/// <summary>

/// TreeControl 的摘要说明。

/// </summary>

public class TreeControl

{

public DataTable dt;

public TreeControl()

{

//

// TODO: 在此处添加构造函数逻辑

//

}

public void BindTreeView1(string f_key,string f_parentkey,string location,string f_text,string str_Sql,string Frame,string Url,Label lbl_Curnodeid,TreeView TreeView1)

{

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

dt = ds.Tables[0];

TreeView1.Nodes.Clear(); // 清空树

TreeNode rootnode=new TreeNode();

rootnode.Text=dt.Rows[0][f_text].ToString(); // 给节点绑定显示值

rootnode.NodeData=dt.Rows[0][f_key].ToString(); // 给节点绑定key值

lbl_Curnodeid.Text=dt.Rows[0][f_key].ToString(); //保存选中key值

rootnode.Expanded=true; //默认根结点为展开

rootnode.Target = Frame;

rootnode.NavigateUrl = Url+"?"+location+"=" + dt.Rows[0][location].ToString();

TreeView1.Nodes.Add(rootnode);

string parentid=dt.Rows[0][f_parentkey].ToString()+dt.Rows[0][f_key].ToString()+"_"; //他子节点的parentid字段值

CreateNode1(f_key,f_parentkey,location,f_text,Frame,Url,parentid,rootnode);//加入所有根结点以下的结点

}

public void BindTreeView2(string f_key,string f_parentkey,string location,string f_text,string str_Sql,string Frame,string Url,Label lbl_Curnodeid,TreeView TreeView1)

{

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

dt = ds.Tables[0];

TreeView1.Nodes.Clear(); // 清空树

TreeNode rootnode=new TreeNode();

rootnode.Text=dt.Rows[0][f_text].ToString(); // 给节点绑定显示值

rootnode.NodeData=dt.Rows[0][f_key].ToString(); // 给节点绑定key值

lbl_Curnodeid.Text=dt.Rows[0][f_key].ToString(); //保存选中key值

rootnode.Expanded=true; //默认根结点为展开

rootnode.Target = Frame;

rootnode.NavigateUrl = Url+"?location2=" + dt.Rows[0][location].ToString();

TreeView1.Nodes.Add(rootnode);

string parentid=dt.Rows[0][f_parentkey].ToString()+dt.Rows[0][f_key].ToString()+"_"; //他子节点的parentid字段值

CreateNode2(f_key,f_parentkey,location,f_text,Frame,Url,parentid,rootnode);//加入所有根结点以下的结点

}

public void CreateNode1(string f_key,string f_parentkey,string location,string f_text,string Frame,string Url,string parentid,TreeNode parentnode)

{

DataRow [] drs = dt.Select(f_parentkey +"= '" + parentid + "'");//选出所有子节点

//遍历所有子节点

foreach( DataRow r in drs )

{

TreeNode tempnode = new TreeNode();

tempnode.Text = r[f_text].ToString();

tempnode.NodeData = r[f_key].ToString();

parentnode.Nodes.Add(tempnode);

tempnode.Expanded=true;

tempnode.Target = Frame;

tempnode.NavigateUrl = Url+"?"+location+"=" + r[location].ToString();

parentid=r[f_parentkey].ToString()+r[f_key].ToString()+"_";

CreateNode1(f_key,f_parentkey,location,f_text,Frame,Url,parentid,tempnode);

}

}

public void CreateNode2(string f_key,string f_parentkey,string location,string f_text,string Frame,string Url,string parentid,TreeNode parentnode)

{

DataRow [] drs = dt.Select(f_parentkey +"= '" + parentid + "'");//选出所有子节点

//遍历所有子节点

foreach( DataRow r in drs )

{

TreeNode tempnode = new TreeNode();

tempnode.Text = r[f_text].ToString();

tempnode.NodeData = r[f_key].ToString();

parentnode.Nodes.Add(tempnode);

tempnode.Expanded=true;

tempnode.Target = Frame;

tempnode.NavigateUrl = Url+"?location2=" + r[location].ToString();

parentid=r[f_parentkey].ToString()+r[f_key].ToString()+"_";

CreateNode2(f_key,f_parentkey,location,f_text,Frame,Url,parentid,tempnode);

}

}

public void BindTreeViewShow(string f_key,string f_parentkey,string location,string f_text,string str_Sql,Label lbl_Curnodeid,TreeView TreeView1)

{

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

dt = ds.Tables[0];

TreeView1.Nodes.Clear(); // 清空树

TreeNode rootnode = new TreeNode();

rootnode.Text = dt.Rows[0][f_text].ToString(); // 给节点绑定显示值

rootnode.NodeData = dt.Rows[0][f_key].ToString(); // 给节点绑定key值

// lbl_Curnodeid.Text = dt.Rows[0][f_key].ToString(); //保存选中key值

rootnode.Expanded = true; //默认根结点为展开

rootnode.NavigateUrl = "?"+location+"=" + dt.Rows[0][f_text].ToString();

TreeView1.Nodes.Add(rootnode);

string parentid=dt.Rows[0][f_parentkey].ToString()+dt.Rows[0][f_key].ToString()+"_"; //他子节点的parentid字段值

CreateNodeShow(f_key,f_parentkey,location,f_text,parentid,rootnode);//加入所有根结点以下的结点

}

public void CreateNodeShow(string f_key,string f_parentkey,string location,string f_text,string parentid,TreeNode parentnode)

{

DataRow [] drs = dt.Select(f_parentkey +"= '" + parentid + "'");//选出所有子节点

//遍历所有子节点

foreach( DataRow r in drs )

{

TreeNode tempnode = new TreeNode();

tempnode.Text = r[f_text].ToString();

tempnode.NodeData = r[f_key].ToString();

parentnode.Nodes.Add(tempnode);

tempnode.Expanded=true;

tempnode.NavigateUrl = "?"+location+"=" + r[f_text].ToString();

parentid=r[f_parentkey].ToString()+r[f_key].ToString()+"_";

CreateNodeShow(f_key,f_parentkey,location,f_text,parentid,tempnode);

}

}

public string GetFirstStr(string strOriginal,string strSymbol)

{

int strPlace=strOriginal.IndexOf(strSymbol);

if (strPlace!=-1)

strOriginal=strOriginal.Substring(0,strPlace);

return strOriginal;

}

/// <summary>

/// 获得某个字符串在另个字符串最后一次出现时后面所有字符

/// </summary>

/// <param name="strOriginal">要处理的字符</param>

/// <param name="strSymbol">符号</param>

/// <returns>返回值</returns>

public string GetLastStr(string strOriginal,string strSymbol)

{

int strPlace=strOriginal.LastIndexOf(strSymbol)+strSymbol.Length;

strOriginal=strOriginal.Substring(strPlace);

return strOriginal;

}

/// <summary>

/// 获得两个字符之间最后一次出现时的所有字符

/// </summary>

/// <param name="strOriginal">要处理的字符</param>

/// <param name="strFirst">最前哪个字符</param>

/// <param name="strLast">最后哪个字符</param>

/// <returns>返回值</returns>

public string GetTwoMiddleLastStr(string strOriginal,string strFirst,string strLast)

{

strOriginal=GetLastStr(strOriginal,strFirst);

strOriginal=GetFirstStr(strOriginal,strLast);

return strOriginal;

}

public void AddRootNode(string nodeid,string order_id,string parentid,string location,string text,string tablename,string MyText)

{

if( MyText !="" )

{

string str_Sql = "INSERT INTO "+ tablename +"("+ nodeid +","+ parentid +","+ location +","+ text +","+ order_id +") VALUES ('1','0_','0_1_','"+ MyText +"','0')";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

}

public void AddChildNode(string nodeid,string order_id,string parentid,string location,string text,string tablename,int Curnodeid,string MyText)

{

if( MyText !="" )

{

string str_MaxId =(int.Parse(YljWeb.Classes.SqlConn.GetMaxId("nodeid",tablename).ToString())+1).ToString();

int NewNodeId = int.Parse(str_MaxId);

string str_Sql="select * from "+tablename+" where "+ nodeid +"="+ Curnodeid;

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

DataRow dr = ds.Tables[0].Rows[0];

string str_ = dr[parentid]+ Curnodeid.ToString() +"_";

string str_Location = str_+str_MaxId+"_";

string str_Sql1 = "INSERT INTO "+ tablename +"("+ nodeid +","+ parentid +","+ location +","+ text +","+ order_id +") VALUES ("+ NewNodeId +",'"+ str_ +"','"+ str_Location +"','"+ MyText +"',"+ NewNodeId +")";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql1);

}

}

public void AddChildNode2(string nodeid,string order_id,string parentid,string location,string text,string text2,string tablename,int Curnodeid,string MyText,string MyText2)

{

if( MyText !="" )

{

string str_MaxId =(int.Parse(YljWeb.Classes.SqlConn.GetMaxId("nodeid",tablename).ToString())+1).ToString();

int NewNodeId = int.Parse(str_MaxId);

string str_Sql="select * from "+tablename+" where "+ nodeid +"="+ Curnodeid;

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

DataRow dr = ds.Tables[0].Rows[0];

string str_ = dr[parentid]+ Curnodeid.ToString() +"_";

string str_Location = str_+str_MaxId+"_";

string str_Sql1 = "INSERT INTO "+ tablename +"("+ nodeid +","+ parentid +","+ location +","+ text +","+ text2 +","+ order_id +") VALUES ("+ NewNodeId +",'"+ str_ +"','"+ str_Location +"','"+ MyText +"','"+ MyText2 +"',"+ NewNodeId +")";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql1);

}

}

public void AddBrotherNode(string nodeid,string order_id,string parentid,string location,string text,string tablename,int Curnodeid,string MyText)

{

if( MyText !="" )

{

string str_MaxId =(int.Parse(YljWeb.Classes.SqlConn.GetMaxId("nodeid",tablename).ToString())+1).ToString();

int NewNodeId = int.Parse(str_MaxId);

string str_Sql="select * from "+ tablename +" where "+ nodeid +"="+ Curnodeid;

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

DataRow dr = ds.Tables[0].Rows[0];

string str_ = dr[parentid].ToString();

string str_Location = str_+str_MaxId+"_";

str_Sql = "INSERT INTO "+tablename+"("+ nodeid +","+ parentid +","+ location +","+ text +","+ order_id +") VALUES ("+ NewNodeId +",'"+ str_ +"','"+ str_Location +"','"+ MyText +"',"+ NewNodeId +")";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

}

public void AddBrotherNode2(string nodeid,string order_id,string parentid,string location,string text,string text2,string tablename,int Curnodeid,string MyText,string MyText2)

{

if( MyText !="" )

{

string str_MaxId =(int.Parse(YljWeb.Classes.SqlConn.GetMaxId("nodeid",tablename).ToString())+1).ToString();

int NewNodeId = int.Parse(str_MaxId);

string str_Sql="select * from "+ tablename +" where "+ nodeid +"="+ Curnodeid;

DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

DataRow dr = ds.Tables[0].Rows[0];

string str_ = dr[parentid].ToString();

string str_Location = str_+str_MaxId+"_";

str_Sql = "INSERT INTO "+tablename+"("+ nodeid +","+ parentid +","+ location +","+ text +","+ text2 +","+ order_id +") VALUES ("+ NewNodeId +",'"+ str_ +"','"+ str_Location +"','"+ MyText +"','"+ MyText2 +"',"+ NewNodeId +")";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

}

public void DelTreeViewNode(string nodeid,string parentid,string tablename,int Curnodeid)

{

string str_Sql="delete from "+tablename+" where "+nodeid+"="+ Curnodeid +" or "+ parentid +" like '%"+ Curnodeid +"%'";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

}

}

Purview_All_Left.aspx.cs：权限树的显示

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 Microsoft.Web.UI.WebControls;

namespace YljWeb._Admin.Purview_Manage

{

/// <summary>

/// Tree_Left 的摘要说明。

/// </summary>

public class Purview_All_Left : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label lbl_Curnodeid;

protected Microsoft.Web.UI.WebControls.TreeView TreeView1;

protected Microsoft.Web.UI.WebControls.TreeView Treeview1;

protected YljWeb.Classes.TreeControl tree=new YljWeb.Classes.TreeControl();

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

string str_Sql="select * from Purview_All order by order_id";

if (YljWeb.Classes.SqlConn.IsExist(str_Sql)) // 遍历树

{

tree.BindTreeView1("nodeid","parentid","location","mytext",str_Sql,"mainFrame","Purview_All_Operate.aspx",lbl_Curnodeid,TreeView1);

}

}

#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void TreeView_Selected(object sender, Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs e)

{

lbl_Curnodeid.Text = ((TreeNode)TreeView1.GetNodeFromIndex(e.NewNode)).NodeData;

}

}

}

Purview_All_Operate.aspx.cs：系统功能的管理（填加、修改、删除等操作）

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 Microsoft.Web.UI.WebControls;

namespace YljWeb._Admin.Purview_Manage

{

/// <summary>

/// Tree_Operate 的摘要说明。

/// </summary>

public class Purview_All_Operate : System.Web.UI.Page

{

protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;

protected System.Web.UI.WebControls.Button btn_AddChildNode;

protected System.Web.UI.WebControls.Button btn_AddBrotherNode;

protected System.Web.UI.WebControls.Button btn_DelNode;

protected System.Web.UI.WebControls.Button btn_AddRootNode;

protected System.Web.UI.WebControls.TextBox txt_Mytext;

protected System.Web.UI.WebControls.Label lbl_Error;

protected YljWeb.Classes.TreeControl tree=new YljWeb.Classes.TreeControl();

public static DataView dv1;//数据视图

public string str_Sql;

public string str_Location;

public string cru_location;

public int Curnodeid;

protected System.Web.UI.WebControls.TextBox Txt_Command;

protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;

public string MyText;

protected System.Web.UI.WebControls.Label lbl_name;

protected System.Web.UI.WebControls.Label lbl_command;

protected System.Web.UI.WebControls.Button btn_CruNode_Modify;

public string MyText2;

public string cru_user;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

btn_DelNode.Attributes.Add("onClick","javascript:return confirm('你确定要删除此结点及其子结点吗？')");

if (Request["location"]!=null)

{

str_Location=Request["location"].ToString().Substring(0,Request["location"].ToString().Length-1);

Curnodeid = int.Parse(tree.GetTwoMiddleLastStr(str_Location,"_","_"));

MyText = this.txt_Mytext.Text.Replace(" ","");

MyText2 = this.Txt_Command.Text.Replace(" ","");

//////////////// 通过用户的权限来控制按扭的属性 ////////////////////////////////////////////////

if ( Session["AdminName"] != null )

{

cru_user = Session["AdminName"].ToString();

}

else

{

cru_user = "------";/////// 只要该值在用户数据库中不存在就可以

}

if ( YljWeb.Classes.Purview.Purview_Verify(cru_user,"Purview_All_node_Del") )

{

this.btn_DelNode.Visible = true;

}

// else

// {

// this.ShowErrMsg("您没有权限删除！");

// }

/////////////////////////////////////////////////////////////////////////////////////////////////

this.btn_CruNode_Modify.Visible = true;

Get_CruNode_Info();

// BindGrid();

}

str_Sql="select * from Purview_All";

if (YljWeb.Classes.SqlConn.GetRowCount(str_Sql)>0) // 树表存在记录,做遍历操作

{

btn_AddRootNode.Visible=false;

}

else // 数表不存在记录,不做遍历操作

{

btn_DelNode.Visible=false;

btn_AddBrotherNode.Visible=false;

btn_AddChildNode.Visible=false;

}

}

#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.btn_AddRootNode.Click += new System.EventHandler(this.btn_AddRootNode_Click);

this.btn_AddChildNode.Click += new System.EventHandler(this.btn_AddChildNode_Click);

this.btn_AddBrotherNode.Click += new System.EventHandler(this.btn_AddBrotherNode_Click);

this.btn_DelNode.Click += new System.EventHandler(this.btn_DelNode_Click);

this.btn_CruNode_Modify.Click += new System.EventHandler(this.btn_CruNode_Modify_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void Get_CruNode_Info()

{

cru_location = Request["location"].ToString();

string str_Sql = "Select * from Purview_All where location = '"+ cru_location +"' ";

DataSet ds1= new DataSet();

ds1 = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);

this.lbl_name.Text = ds1.Tables[0].Rows[0]["mytext"].ToString();

this.lbl_command.Text = ds1.Tables[0].Rows[0]["command_name"].ToString();

ds1.Dispose();

}

/// <summary>

/// /////////

/// </summary>

// public void BindGrid()

// {

// str_Location = Request["location"].ToString();

// str_Sql="select * from Purview_All where parentid='"+ str_Location +"' order by order_id";

// ViewState["Sort"]="";

// DataSet myds1 = new DataSet();

// myds1 = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);//调用YljWeb.Classes.SqlConn.ExecuteSqlForDataSet

// dv1=myds1.Tables[0].DefaultView;

// dv1.Table.AcceptChanges();

// ////////////// dv1.Sort /////////////////////////////////////////////////////////////////////////

// if(!object.Equals(ViewState["Sort"],null))

// {

// dv1.Sort =ViewState["Sort"].ToString() ;

// }

//

// ViewState["PageDataCount"]=dv1.Count;//记录每页的数据条数

// if(dv1.Count==0)//判断所查询出来的数据中是否有记录

// {

// dv1.Dispose();

// }

// show_all.DataSource = dv1;//指定数据源

// show_all.DataBind();//控件绑定

// }

/// <summary>

/// //////////

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

private void btn_AddChildNode_Click(object sender, System.EventArgs e)

{

if (Request["location"]==null) // 判断是否选择左边导航树导航

{

// this.ShowErrMsg("请选择左边导航树节点,再做添加操作!");

// string Str_Show = YljWeb.Classes.MyMethod.ShowErrMsg("请选择左边导航树节点,再做添加操作!");

this.Response.Write( YljWeb.Classes.MyMethod.ShowErrMsg("请选择左边导航树节点,再做添加操作!") );

return;

}

str_Sql="select * from Purview_All where command_name='"+ MyText2 +"'";

if ( YljWeb.Classes.SqlConn.IsExist(str_Sql) )

{

this.ShowErrMsg("对不起，已经存在此命令，请重新输入!");

return;

}

// 下面是增加子节点

tree.AddChildNode2("nodeid","order_id","parentid","location","mytext","command_name","Purview_All",Curnodeid,MyText,MyText2);

// 将最新加入的权限填加到Purview_User_Have预定义

Add_To_Purview_User_Have();

// 刷新左边树导航

lbl_Error.Text="<script language=\"javascript\">parent.frames(\"leftFrame\").document.location.reload();</"+"script>";

}

/// <summary>

/// /////////

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

private void btn_AddBrotherNode_Click(object sender, System.EventArgs e)

{

if (Request["location"]==null) // 判断是否选择左边导航树导航

{

this.ShowErrMsg("请选择左边导航树节点,再做添加操作!");

return;

}

string str_Sql="select * from Purview_All where nodeid="+ Curnodeid +"and parentid='0_' ";

int count=int.Parse(YljWeb.Classes.SqlConn.GetRowCount(str_Sql).ToString());

if ( count != 0 )

{

this.ShowErrMsg("不能给根节点增加兄弟节点,请增加子节点!"); // 判断不能给跟节点增加兄弟节点

return;

}

str_Sql="select * from Purview_All where command_name='"+ MyText2 +"'";

if ( YljWeb.Classes.SqlConn.IsExist(str_Sql) )

{

this.ShowErrMsg("对不起，已经存在此命令，请重新输入!");

return;

}

// 下面是增加兄弟节点

tree.AddBrotherNode2("nodeid","order_id","parentid","location","mytext","command_name","Purview_All",Curnodeid,MyText,MyText2); // 增加兄弟节点

// 将最新加入的权限填加到Purview_User_Have预定义

Add_To_Purview_User_Have();

// 刷新左边树导航

lbl_Error.Text="<script language=\"javascript\">parent.frames(\"leftFrame\").document.location.reload();</"+"script>";

}

public void Add_To_Purview_User_Have()

{

////// 查出所有用户

string strSql_User = "Select * from AdminUser ";

DataSet ds_user= new DataSet();

ds_user = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(strSql_User);

if ( ds_user.Tables[0].Rows.Count > 0 )

{

for ( int i = 0 ; i < ds_user.Tables[0].Rows.Count ; i ++ )

{

string strSql_Purview = "Select top 1 * from Purview_All order by nodeid desc";

DataSet ds_purview= new DataSet();

ds_purview = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(strSql_Purview);

/////// 组合用户权限列表的项 /////////////////////

if ( ds_purview.Tables[0].Rows.Count > 0 )

{

for ( int j = 0 ; j < ds_purview.Tables[0].Rows.Count ; j ++ )

{

string username = ds_user.Tables[0].Rows[i]["username"].ToString().Trim();

string nodeid = ds_purview.Tables[0].Rows[j]["nodeid"].ToString().Trim();

string parentid = ds_purview.Tables[0].Rows[j]["parentid"].ToString().Trim();

string mytext = ds_purview.Tables[0].Rows[j]["mytext"].ToString().Trim();

string location = ds_purview.Tables[0].Rows[j]["location"].ToString().Trim();

string command_name = ds_purview.Tables[0].Rows[j]["command_name"].ToString().Trim();

string order_id = ds_purview.Tables[0].Rows[j]["order_id"].ToString().Trim();

try

{

//////// 写入用户权限数据库 ///////////////////////////

string strSql_Insert = "Insert into Purview_User_Have (username,nodeid,parentid,mytext,location,command_name,order_id,state) values('"+ username +"','"+ nodeid +"','"+ parentid +"','"+ mytext +"','"+ location +"','"+ command_name +"','"+ order_id +"',0)";

YljWeb.Classes.SqlConn.ExecuteSql(strSql_Insert);

}

catch(Exception er)

{

this.ShowErrMsg(" Sorry! 用户权限初始化失败！原因是："+ er.Message);

}

}

}

else

{

this.ShowErrMsg("对不起，系统功能列表为空，请先设置功能列表！2秒自动转到功能设置页面");

}

}

////// 在这里是调用这个方法，所以最好不要出现以下提示

// this.ShowErrMsg(" 提示：用户权限初始化成功！");

}

else

{

this.ShowErrMsg("对不起，暂时没有用户，请先填加用户！2秒自动转到填加用户页面");

}

}

/// <summary>

/// /

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

private void btn_DelNode_Click(object sender, System.EventArgs e)

{

if (Request["location"]==null) // 判断是否选择左边导航树节点

{

this.ShowErrMsg("请选择左边导航树节点,再做添加操作!");

return;

}

tree.DelTreeViewNode("nodeid","parentid","Purview_All",Curnodeid); // 递归删除节点

////// 删除Purview_User_Have中的相应记录

Delete_Purview_User_Have();

string str_Sql="select * from Purview_All";

if (YljWeb.Classes.SqlConn.GetRowCount(str_Sql)>0) // 如果树表中存在记录，就做遍历树等操作

{

btn_DelNode.Visible=true;

btn_AddBrotherNode.Visible=true;

btn_AddChildNode.Visible=true;

btn_AddRootNode.Visible=false;

}

else // 如果数表中不存在记录,就清空数

{

btn_DelNode.Visible=false;

btn_AddBrotherNode.Visible=false;

btn_AddChildNode.Visible=false;

btn_AddRootNode.Visible=true;

}

// 刷新左边树导航

lbl_Error.Text="<script language=\"javascript\">parent.frames(\"leftFrame\").document.location.reload();</"+"script>";

}

public void Delete_Purview_User_Have()

{

str_Sql = "Delete from Purview_User_Have where location like '"+ str_Location +"%'";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

/// <summary>

/// /

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

private void btn_AddRootNode_Click(object sender, System.EventArgs e)

{

// 下面增加根节点

string str_Sql="select * from Purview_All where parentid='0_'";

int count=int.Parse(YljWeb.Classes.SqlConn.GetRowCount(str_Sql).ToString());

if ( count != 0 )

{

this.ShowErrMsg("已经存在根结点，只能有一个根结点，填加失败!"); // 判断不能给跟节点增加兄弟节点

return;

}

string MyText = this.txt_Mytext.Text.ToString();

tree.AddRootNode("nodeid","order_id","parentid","location","mytext","Purview_All",MyText);

// 将最新加入的权限填加到Purview_User_Have预定义

Add_To_Purview_User_Have();

btn_DelNode.Visible=true;

btn_AddBrotherNode.Visible=true;

btn_AddChildNode.Visible=true;

btn_AddRootNode.Visible=false;

// 刷新左边树导航

lbl_Error.Text="<script language=\"javascript\">parent.frames(\"leftFrame\").document.location.reload();</"+"script>";

}

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

// public void node_Delete(Object sender, DataGridCommandEventArgs e)

// {

// string nodeid=e.Item.Cells[0].Text.ToString();

// this.ShowErrMsg("对不起，删除失败！原因："+ nodeid);

// try

// {

// string deleteCmd = "Delete from Purview_All where nodeid ='"+ nodeid +"'";

// YljWeb.Classes.SqlConn.ExecuteSql(deleteCmd);

// BindGrid();

// }

// catch(Exception er)

// {

// this.ShowErrMsg("对不起，删除失败！原因："+ er.Message);

// }

// /////////////// 在 1秒后自动刷新 //////////////////////////////////////////

// Response.Write("<meta http-equiv=refresh content=0>");

// }

/// <summary>

///

/// </summary>

/// <param name="source"></param>

/// <param name="e"></param>

// private void show_all_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)

// {

// if(e.SortExpression==ViewState["Sort"].ToString() )

// {

// ViewState["Sort"]=ViewState["Sort"]+" desc";

// }

// else

// {

// ViewState["Sort"]=e.SortExpression;

// }

// BindGrid();

// }

/// <summary>

/// /

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

// private void show_all_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

// {

// System.Web.UI.WebControls.Button TempBtn;

// TempBtn=(System.Web.UI.WebControls.Button)e.Item.FindControl("node_delete") ;

// if(object.Equals(TempBtn,null)==false)

// {

// TempBtn.Attributes.Add("onClick","javascript:return confirm('你确定要删除此结点及其子结点吗？')");

// }

// }

/// <summary>

/// ////////////////////////////// 弹出消息框 ////////////////////////////////////////

/// </summary>

/// <param name="MsgStr"></param>

private void ShowErrMsg(string MsgStr)

{

this.Response.Write("<script language='javascript'>");

this.Response.Write("alert('" +MsgStr + "');");

this.Response.Write("</script>");

}

private void btn_CruNode_Modify_Click(object sender, System.EventArgs e)

{

string str_Sql = "Update Purview_All set mytext ='"+ MyText +"',command_name = '"+ MyText2 +"' where location = '"+ cru_location +"' ";

try

{

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

/////// 修改Purview_User_Have，使之同步

Update_Purview_User_Have();

this.ShowErrMsg("修改成功");

Response.Write("<meta http-equiv=refresh content=0>");

lbl_Error.Text="<script language=\"javascript\">parent.frames(\"leftFrame\").document.location.reload();</"+"script>";

}

catch(Exception er)

{

this.ShowErrMsg("对不起，修改失败！原因："+ er.Message);

}

}

public void Update_Purview_User_Have()

{

str_Sql = "Update Purview_User_Have set mytext ='"+ MyText +"',command_name = '"+ MyText2 +"' where location = '"+ cru_location +"' ";

YljWeb.Classes.SqlConn.ExecuteSql(str_Sql);

}

}

}

• ·SAS spawner 使用
• ·越冷越燃脂的冬天减肥法 减肥_美丽顾问
• ·[原创]使用Microsoft.Web.UI.
• ·[原创]使用Microsoft.Web.UI.
• ·实现Web页面上的右键快捷菜单
• ·关于如何使用struts标签输出值为map的l
• ·在VB.NET中进行抓屏
• ·[原创]使用Microsoft.Web.UI.
• ·饭后喝汤 甩不掉小肚腩 减肥_美丽顾问
• ·《成长》：微软捕获中国黑客刘蝶雨的故事