userandpopedommake.cs

企业内部的短信交流管理平台。 设计详细

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// UserAndPopedomMake 的摘要说明。
	/// </summary>
	public class UserAndPopedomMake
	{
		/// <summary>
		/// 添加用户权限关系
		/// </summary>
		/// <param name="uap"></param>
		/// <returns></returns>
		public bool Insert(Entity.UserAndPopedom uap)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@userId",uap.UserId),
				new SqlParameter("@pdId",uap.PdId),
			};

			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_USERANDPOPEDOM_INSERT,parms);

			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 删除用户权限关系
		/// </summary>
		/// <param name="uapId"></param>
		/// <returns></returns>
		public bool Delete(int uapId)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_USERANDPOPEDOM_DELETE,new SqlParameter("@uapId",uapId));

			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 修改用户权限关系
		/// </summary>
		/// <param name="upd"></param>
		/// <param name="updId"></param>
		/// <returns></returns>
		public bool Update(Entity.UserAndPopedom upd,int updId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@userId",upd.UserId),
				new SqlParameter("@pdId",upd.PdId),
				new SqlParameter("@uapId",updId),
			};

			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_USERANDPOPEDOM_UPDATE,parms);

			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 查询某个用户的权限
		/// </summary>
		/// <param name="userId"></param>
		/// <returns></returns>
		public DataTable FindByUser(int userId)
		{
			DataTable dt=new DataTable();

			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_USERANDPOPEDOM_SELECTMY,dt,new SqlParameter("@userId",userId));

			return dt;
		}
	}
}