albumtypemake.cs

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

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// AlbumType 的摘要说明。
	/// </summary>
	public class AlbumTypeMake
	{
		/// <summary>
		/// 添加相册分类
		/// </summary>
		/// <param name="at"></param>
		/// <returns></returns>
		public bool Insert(Entity.AlbumType at)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.StoredProcedure,SqlCollections.SQL_ALBUMTYPE_INSERT,new SqlParameter("@typeName",at.ToString()));

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

		/// <summary>
		/// 删除相册分类
		/// </summary>
		/// <param name="abtId"></param>
		/// <returns></returns>
		public bool Delete(int abtId)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_ALBUMTYPE_DELETE,new SqlParameter("@abtId",abtId));

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

		/// <summary>
		/// 修改相册分类
		/// </summary>
		/// <param name="at"></param>
		/// <param name="abtId"></param>
		/// <returns></returns>
		public bool Update(Entity.AlbumType at,int abtId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@abtId",abtId),
				new SqlParameter("@typeName",at.TypeName),
			};

			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.StoredProcedure,SqlCollections.SQL_ALBUMTYPE_UPDATE,parms);

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

		/// <summary>
		/// 条件分页查询相册分类
		/// </summary>
		/// <param name="currentPage"></param>
		/// <param name="pageSize"></param>
		/// <param name="pageCount"></param>
		/// <param name="typeName"></param>
		/// <returns></returns>
		public DataTable FindWhere(int currentPage,int pageSize,out int pageCount,string typeName)
		{
			SqlParameter p=new SqlParameter("@count",SqlDbType.Int);
			p.Direction=ParameterDirection.Output;

			DataTable dt=new DataTable();
			SqlParameter[] parms=
			{
				new SqlParameter("@currentPage",currentPage),
				new SqlParameter("@pageSize",pageSize),
				p,
				new SqlParameter("@btName",typeName),
			};
			
			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.StoredProcedure,SqlCollections.SQL_ALBUMTYPE_SELECTWHERE,dt,parms);

			int recordCount = Convert.ToInt32(p.Value);
			pageCount =  recordCount / pageSize;
			if (recordCount % pageSize != 0)
				pageCount++;

			return dt;
		}

		/// <summary>
		/// 不分页查询所有相册分类
		/// </summary>
		/// <returns></returns>
		public DataTable FindAll()
		{
			DataTable dt=new DataTable();

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

			return dt;
		}

		/// <summary>
		/// 按编号查询相册分类
		/// </summary>
		/// <param name="Id"></param>
		/// <returns></returns>
		public Entity.AlbumType FindById(int Id)
		{
			SqlDataReader reader=SqlBasic.ExecuteReader(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_ALBUMTYPE_SELECTBYID,new SqlParameter("@abtId",Id));

			Entity.AlbumType at=new Com.SMS.Entity.AlbumType();
			while(reader.Read())
			{
				at.AbtId=reader.GetInt32(0);
				at.TypeName=reader.GetString(1);
			}

			return at;
		}
	}
}