popedommake.cs

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

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// PopedomMake 的摘要说明。
	/// </summary>
	public class PopedomMake
	{
		/// <summary>
		/// 添加权限
		/// </summary>
		/// <param name="pd"></param>
		/// <returns></returns>
		public bool Insert(Entity.Popedom pd)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pdName",pd.PdName),
				new SqlParameter("@pdPath",pd.PdPath),
			};

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

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

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

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

		/// <summary>
		/// 修改权限
		/// </summary>
		/// <param name="pd"></param>
		/// <param name="pdId"></param>
		/// <returns></returns>
		public bool Update(Entity.Popedom pd,int pdId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pdName",pd.PdName),
				new SqlParameter("@pdPath",pd.PdPath),
				new SqlParameter("@pdId",pdId),
			};

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

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

		/// <summary>
		/// 查询权限 
		/// </summary>
		/// <returns></returns>
		public DataTable Find()
		{
			DataTable dt=new DataTable();

			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_POPEDOM_SELECT,dt);

			return dt;
		}

		/// <summary>
		/// 查询页面具有的权限
		/// </summary>
		/// <param name="pageName"></param>
		/// <returns></returns>
		public Entity.Popedom FindByPage(string pageName)
		{
			SqlDataReader reader=SqlBasic.ExecuteReader(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_POPEDOM_SELECTBYPAGE,
				new SqlParameter("@pdPath","%" + pageName + "%")
				);

			Entity.Popedom pd=new Com.SMS.Entity.Popedom();
			while(reader.Read())
			{
				pd.PdId=reader.GetInt32(0);
				pd.PdName=reader.GetString(1);
				pd.PdPath=reader.GetString(2);
			}

			return pd;
		}
	}
}