createdefaultpower.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

using System;

namespace RWSB.cs
{
	/// <summary>
	/// createDefaultPower 的摘要说明。
	/// </summary>
	public class createDefaultPower
	{
		protected RWSB.DatabaseOper .DatabaseConnect Dbc=new RWSB.DatabaseOper.DatabaseConnect ();
		public createDefaultPower()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 创建默认角色：
		/// </summary>
		
		public void createUserRole(string userid,string RoleName)
		{
			try
			{
				string sql= " select roleID from accounts_Roles where rolename='"+RoleName+"' ";
				object o= Dbc.GetObjectBySql (sql);
				if (o ==null)
				{
					return ; //没有此角色不自动创建.
				}
				else
				{
					sql ="select count(*) from accounts_userRoles where userid="+userid +" and roleid="+o.ToString ();
					int number=int.Parse (Dbc.GetValueBySql(sql));
					if (number <1) //用户没有此角色权限
					{
						sql=" insert into accounts_userRoles (userid,roleid) values("+userid +","+o.ToString ()+")";
						Dbc.ExecuteSQL (sql); 
					}
				}
			}
			catch
			{
			}
			
		}
		/// <summary>
		/// 创建角色权限.
		/// </summary>
		public void createRolePower()
		{
//			string sql= "select moduleid from models "+
//                   " where ( parentmoduleID  in(  select moduleid from models where modulename='收文办理')"+
//                   "  or moduleid =( select moduleid from models where modulename='收文办理'))" + 
//                   "  and modulename !='已阅办' and   modulename !='未阅办' order by id ";

		}
	}
}