photosmake.cs

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

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// PhotosMake 的摘要说明。
	/// </summary>
	public class PhotosMake
	{
		/// <summary>
		/// 添加照片
		/// </summary>
		/// <param name="pi"></param>
		/// <returns></returns>
		public bool Insert(Entity.Photo pi)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pPath",pi.PPath),
				new SqlParameter("@pDesc",pi.PDesc),
				new SqlParameter("@abId",pi.AbId),
				new SqlParameter("@isPublic",pi.IsPublic),
			};

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

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

		/// <summary>
		/// 删除照片
		/// </summary>
		/// <param name="pId"></param>
		/// <returns></returns>
		public bool Delete(int pId)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_PHOTOS_DELETE,new SqlParameter("@pId",pId));

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

		/// <summary>
		/// 修改照片信息
		/// </summary>
		/// <param name="pi"></param>
		/// <param name="pId"></param>
		/// <returns></returns>
		public bool Update(Entity.Photo pi,int pId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pId",pId),
				new SqlParameter("@pPath",pi.PPath),
				new SqlParameter("@pDesc",pi.PDesc),
				new SqlParameter("@abId",pi.AbId),
				new SqlParameter("@isPublic",pi.IsPublic),
			};

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

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

		public bool UpdatePubic(int pId,int isPublic)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@isPublic",isPublic),
				new SqlParameter("@pId",pId),
			};

			int i=SqlBasic.ExecuteNonQuery(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_PHOTOS_UPDATEPUBLIC,
				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="pDesc"></param>
		/// <param name="alId"></param>
		/// <param name="isPublic"></param>
		/// <returns></returns>
		public DataTable FindWhere(int currentPage,int pageSize,out int pageCount,string pDesc,int alId,int isPublic,int typeId)
		{
			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("@pDesc",pDesc),
				new SqlParameter("@abId",alId),
				new SqlParameter("@isPublic",isPublic),
				new SqlParameter("@typeId",typeId),
			};
	
			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.StoredProcedure,SqlCollections.SQL_PHOTOS_SELECTWHERE,dt,parms);

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

			return dt;
		}

		/// <summary>
		/// 按编号查询照片
		/// </summary>
		/// <param name="pId"></param>
		/// <returns></returns>
		public Entity.Photo FindById(int pId)
		{
			SqlDataReader reader=SqlBasic.ExecuteReader(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_PHOTOS_SELECTBYID,new SqlParameter("@pId",pId));

			Entity.Photo pi=new Com.SMS.Entity.Photo();

			while(reader.Read())
			{
				pi.PId=reader.GetInt32(0);
				pi.PPath=reader.GetString(1);
				pi.PDesc=reader.GetString(2);
				pi.AbId=reader.GetInt32(3);
				pi.IsPublic=reader.GetBoolean(4);
			}

			return pi;
		}

		/// <summary>
		/// 查询某个相册下的照片
		/// </summary>
		/// <param name="abId"></param>
		/// <returns></returns>
		public DataTable FindByALbum(int abId)
		{
			DataTable dt=new DataTable();
			SqlBasic.FillDatatable(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_PHOTOS_SELECTBYALBUM,
				dt,
				new SqlParameter("@abId",abId)
				);

			return dt;
		}

		/// <summary>
		/// 查询某张照片的上一张照片
		/// </summary>
		/// <param name="pId"></param>
		/// <param name="abId"></param>
		/// <returns></returns>
		public Entity.Photo FindByIdUp(int pId,int abId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pId",pId),
				new SqlParameter("@abId",abId),
			};

			SqlDataReader reader=SqlBasic.ExecuteReader(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_PHOTOS_SELECTBYIDUP,
				parms
				);

			Entity.Photo pt=new Com.SMS.Entity.Photo();
			while(reader.Read())
			{
				pt.PId=reader.GetInt32(0);
				pt.PPath=reader.GetString(1);
				pt.PDesc=reader.GetString(2);
				pt.AbId=reader.GetInt32(3);
				pt.IsPublic=reader.GetBoolean(4);
			}

			return pt;
		}

		/// <summary>
		/// 查询某张照片的下一张照片
		/// </summary>
		/// <param name="pId"></param>
		/// <param name="abId"></param>
		/// <returns></returns>
		public Entity.Photo FindByIdNext(int pId,int abId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@pId",pId),
				new SqlParameter("@abId",abId),
			};

			SqlDataReader reader=SqlBasic.ExecuteReader(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_PHOTOS_SELECTBYIDNEXT,
				parms
				);

			Entity.Photo pt=new Com.SMS.Entity.Photo();
			while(reader.Read())
			{
				pt.PId=reader.GetInt32(0);
				pt.PPath=reader.GetString(1);
				pt.PDesc=reader.GetString(2);
				pt.AbId=reader.GetInt32(3);
				pt.IsPublic=reader.GetBoolean(4);
			}

			return pt;
		}

		/// <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_PHOTOS_SELECTBYUSER,
				dt,
				new SqlParameter("@userId",userId)
				);

			return dt;
		}
	}
}