addressbookdetailmake.cs

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

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// AddressBookDetailMake 的摘要说明。
	/// </summary>
	public class AddressBookDetailMake
	{
		/// <summary>
		/// 添加地址本联系人
		/// </summary>
		/// <param name="abd"></param>
		/// <returns></returns>
		public bool Insert(int bookId, ArrayList users)
		{
			try
			{
				foreach (int userid in users)
				{
					SqlBasic.ExecuteNonQuery(
						SqlBasic.CONN_STRING,
						CommandType.Text,
						SqlCollections.SQL_AADDRESSBOOKDETAIL_INSERT,
						new SqlParameter("@AddressBookId",bookId),
						new SqlParameter("@userId",userid));
				}
				return true;
			}
			catch(Exception)
			{
				return false;
			}
		}

		/// <summary>
		/// 删除地址本联系人
		/// </summary>
		/// <param name="abdId"></param>
		/// <returns></returns>
		public bool Delete(int abdId)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_AADDRESSBOOKDETAIL_DELETE,new SqlParameter("@AddressBookDetailId",abdId));
			
			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 修改地址本联系人
		/// </summary>
		/// <param name="abd"></param>
		/// <param name="abdId"></param>
		/// <returns></returns>
		public bool Update(Entity.AddressBookDetail abd,int abdId)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@AddressBookId",abd.AddressBookId),
				new SqlParameter("@userId",abd.UserId),
				new SqlParameter("@AddressBookDetailId",abd.AddressBookDetailId)
			};

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

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

		/// <summary>
		/// 按地址本编号查询联系人
		/// </summary>
		/// <param name="bookId"></param>
		/// <returns></returns>
		public DataTable SelectByBookId(int bookId)
		{
			DataTable dt=new DataTable();
			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_AADDRESSBOOKDETAIL_SELECTBYBOOKID,dt,new SqlParameter("@AddressBookId",bookId));

			return dt;
		}
	}
}