existposer.cs

很不错的公文流转系统

using System;
namespace OI.cs
{
	/// <summary>
	/// existPoser 的摘要说明。
	/// </summary>
	public class existPoser
	{  
		public existPoser()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 检验当前选择的用户有没有权限
		/// </summary>
		/// <param name="userid">选择的用户</param>
		/// <param name="Power">当前操作需要的权限</param>
		/// <returns></returns>
		public static bool ExistPower(string userid,string Power)
		{
			if  (userid=="" || Power =="") return true;
            string  powerStr  =  "select count(*) " ;
			        powerStr +=" from accounts_users a, accounts_userRoles aur, account_RolePermission arp ,models m ";
                    powerStr +=" where a.userid=aur.userid  and  arp.roleid=aur.roleid  and  arp.moduleid=m.moduleid ";
                    powerStr +=" and m.modulename='"+ Power+"'" ;
                    powerStr +=" and a.userid="+userid;
			try
			{
				OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect (); 
				int number=int.Parse ( Dbc.GetValueBySql(powerStr));
				if (number >0)
				{
					return true;
				}
				else
				{
					return false;
				}

			}
			catch(Exception er)
			{
				throw  new Exception(er.Message );
				
			}
			
		}
	}
}