tree_contrl.cs

工资管理系统

using System;
using System.Data;
using System.Web;
using Datamodel;

namespace Data_Contrl
{

	/* ****************************************************	
				   重庆杰诺软件开发工作室

	QQ:83898700
	EMAIL:[e-mail]
	url:www.gisii.com
	***************************************************** */
	/// <summary>
	/// Tree_Contrl 的摘要说明。
	/// </summary>
	public class Tree_Contrl
	{
		public Tree_Contrl()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 根据权限显示左面的树状菜单
		/// </summary>
		/// <param name="qx"></param>
		/// <param name="cg"></param>
		/// <returns></returns>
		public string TreeLoad(string qx,string cg)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL=String.Empty;
			if(cg=="1")
			{
                 strSQL="select * from H_system_tree order by id asc";
			}
			else
			{
				if (qx=="1,0")
				{
					strSQL="select * from H_system_tree where bz<>'3' order by id asc";
				}
				if(qx=="1")
				{
					strSQL="select * from H_system_tree where bz='1' or bz='2'";
				}
				if(qx=="0")
				{
					strSQL="select * from H_system_tree where bz='0' or bz='2'";
				}
			}
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree="<DIV class=deeptree>";
			arr_tree+="<script lanage=javascript>";
			arr_tree+="var a=new TreeView(\'a\',\'main\');";
			while(Rs.Read()==true)
			{
				arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\""+Rs["Url_Add"]+"\");";
			}
			arr_tree+="document.write(a);";
			arr_tree+="a.expandAll();";
			arr_tree+="</script>";
			arr_tree+="</DIV>";
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 树形菜单显示
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string Treeinit(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from h_bm where id="+Parentid+" order by id desc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree=string.Empty;
			while(Rs.Read()==true)
			{
					arr_tree+=Rs["id"]+",";
					arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
			}
			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
		/// <summary>
		/// 树形菜单显示
		/// </summary>
		/// <param name="Parentid"></param>
		/// <returns></returns>
		public string GetSub(int Parentid)
		{
			CreateDb mydb = new CreateDb();
			IDataReader Rs=null;
			DBManager my = mydb.Createdb();
			my.OpenConn();
			string strSQL="select * from h_bm where parentid="+Parentid+" order by id asc";
			Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
			string arr_tree=string.Empty;
			while(Rs.Read()==true)
			{
				arr_tree+=Rs["id"]+",";
				arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
			}

			Rs.Close();
			my.CloseConn();
			return arr_tree;
		}
	}
}