menu.cs

很不错的公文流转系统

/* ***************************************************
 * 类名：创建QQ菜单
 * 描述：创建一个类似QQ的菜单
 * 设计人：赖德兵
 * 时间：2004/02/18
 * 备注：
 ************************************************* */
using System;
using System.Data;
using System.Data.SqlClient;
using OI.Modules;
using OI.DatabaseOper;
namespace OI
{
	/// <summary>
	/// menu 的摘要说明。
	/// </summary>
	public class menu
	{
		OI.DatabaseOper.DatabaseConnect dbo=new DatabaseConnect();  
		private string userid;
		public string UserID
		{
			get
			{
				return this.userid;
			}
			set
			{
				this.userid=OI.Modules.String.GenSafeChars(value);
			}
		}
		public menu()
		{
			
			
		}
		private string genSqlFilter()
		{
			string gensql="";
			gensql=" from  models , accounts_userroles ,account_rolepermission  ";
			gensql +=" where  models.showmenu=1 ";
			gensql +=" and  models.moduleid=account_rolepermission.moduleid ";
			gensql +=" and  account_rolepermission.roleid=accounts_userroles.roleid ";
			if(this.userid!=null||this.userid!="")
			{				
				gensql +=" and  accounts_userroles.userid="+this.userid;
			}
			return gensql;
		}
		//得到一级节点
		public DataSet GetFirNodeTab()
		{
			string strSql=@"select distinct models.ID,models.ModuleID,models.ModuleName,models.ShowMenu,models.MenuPath,models.ParentModuleID,models.Description  "+this.genSqlFilter()+" and ParentModuleID='0' ";
			DataSet ds=new DataSet();
			ds=dbo.getBinding(strSql,"FirNodeTab");
			return ds;
		}
		/// <summary>
		/// 得到子级节点
		/// </summary>
		/// <param name="PID"></param>
		/// <returns></returns>
		public DataSet GetSecondNodeTab(string PID)
		{
			PID=OI.Modules.String.GenSafeChars(PID);
			string strSql=@"select distinct models.ID,models.ModuleID,models.ModuleName,models.ShowMenu,models.MenuPath,models.ParentModuleID,models.Description "+this.genSqlFilter()+" and  ParentModuleID='"+PID+"' ";			
			DataSet ds=dbo.getBinding(strSql,"SecNodeTab");
			return ds;
		}
		/// <summary>
		/// 判断是否有叶子节点
		/// </summary>
		/// <param name="ModuleID">ModuleID</param>
		/// <returns></returns>
		public bool HaveChild(string ModuleID)
		{
			ModuleID=OI.Modules.String.GenSafeChars(ModuleID);
			string sql="select count([ID]) from models where ParentModuleID='"+ModuleID+"' and ShowMenu='1'";
			string c=dbo.GetValueBySql(sql);
			if(System.Int32.Parse(c)>0)
				return true;
			return false;
		}
		/// <summary>
		/// 获得当前节点
		/// </summary>
		/// <param name="ModuleID"></param>
		/// <returns></returns>
		public DataRow GetCurrentNode(string ModuleID)
		{
			ModuleID=OI.Modules.String.GenSafeChars(ModuleID);
			string sql="select ID,ModuleID,ModuleName,ShowMenu,MenuPath,ParentModuleID,Description from models where ModuleID='"+ModuleID+"'";
			DataSet ds=dbo.getBinding(sql,"table");
			if(ds.Tables[0].Rows.Count>0)
				return ds.Tables[0].Rows[0];
			return null;
		}
	}
}