project.cs

全自动办公软件

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;

namespace OASelfManage.Components
{
	/// <summary>
	/// Project 的摘要说明。
	/// </summary>
	public class ProjectClass
	{
		public ProjectClass()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		#region 检测是否有权限访问
		/// <summary>
		/// 检测是否有权限访问
		/// </summary>
		public bool GetAccessPermission(int classID,string UserName,int actID)
		{
			int flag = 0;
			// 定义数据库操作类及DataReader
			Database data = new Database();
				
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Class_ID" , SqlDbType.Int, 20, classID),
									   data.MakeInParam("@UserName" , SqlDbType.NVarChar, 20, UserName),
									   data.MakeInParam("@Act_ID" , SqlDbType.Int, 20, actID),
									   // data.MakeInParam("@Inheit" , SqlDbType.Bit, 1, 1),	
									   data.MakeOutParam("@ReturnValue",SqlDbType.Int,20)
								   };
			
			try 
			{
				data.RunProc("sp_GetAccessPermission",prams);
				flag = Int32.Parse(prams[3].Value.ToString());
				return (flag==1)?true:false;
			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获取访问权出错",ex);
			}
			finally
			{
				data	   = null;
			}
			
		}
		#endregion
	}
}