addressbook.cs

企业短信收发系统

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

namespace MessageLibrary
{
	/// <summary>
	/// AddressBook 的摘要说明。
	/// </summary>
	public class AddressBook
	{
		public AddressBook()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		DataAccess da=new DataAccess();
		
		//添加地址本
		public int InsertAddressBook(string OwnerUserId,string AdderssBookName,string Remark)
		{
			int addressBookId=0;
			SqlParameter[] objSqlParameter=new SqlParameter[3];
			
			objSqlParameter.SetValue(new SqlParameter("@OwnerUserId",OwnerUserId),0);
			objSqlParameter.SetValue(new SqlParameter("@AdderssBookName",AdderssBookName),1);
			objSqlParameter.SetValue(new SqlParameter("@Remark",Remark),2);
			//获得AddressBookId
			addressBookId=Convert.ToInt32(da.ExcuteUpdatePro_Return("IsertAddressBook",objSqlParameter));
			return addressBookId;
		}
		//添加addressbookdetail
		public bool InsertAddBookDetail(string AddressBookId,string Contacterid)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[2];
			objSqlParameter.SetValue(new SqlParameter("@AddressBookId",AddressBookId),0);
			objSqlParameter.SetValue(new SqlParameter("@Contacterid",Contacterid),1);
			if(da.ExcuteUpdateProcedure("InsertAddBookDetail",objSqlParameter)==true)
			{
				return true;
			}
			else
			{
				return false;
			}

		}
		//获得地址本名称
		public DataSet GetAddressBookName(string myId,string addressbookname)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[2];
			objSqlParameter.SetValue(new SqlParameter("@OwnerUserId",myId),0);
			objSqlParameter.SetValue(new SqlParameter("@AddressBookName",addressbookname),1);
			DataSet ds=da.ExcuteProcedure("SelectAddBookName",objSqlParameter);
			return ds;
		}
		//获得地址本详细资料
		public DataSet GetAddressBookInfo(string AddressBookId)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[1];
			objSqlParameter.SetValue(new SqlParameter("@AddressBookId",AddressBookId),0);
			DataSet ds=da.ExcuteProcedure("SelectAddBookInfo",objSqlParameter);
			return ds;
		}
		//删除地址本中用户
		public bool DeleteAddressBookUser(string AddressBookId,string UserId)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[2];
			objSqlParameter.SetValue(new SqlParameter("@UserId",UserId),0);
			objSqlParameter.SetValue(new SqlParameter("@AddressBookId",AddressBookId),1);
			if(da.ExcuteUpdateProcedure("DeleteAddressBookUser",objSqlParameter))
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		public bool DeleteAddressBook(string addressid)
		{
			SqlParameter[] objSqlParameter=new SqlParameter[1];
			objSqlParameter.SetValue(new SqlParameter("@AddressBookId",addressid),0);
			if(da.ExcuteUpdateProcedure("DeleteAddressBook",objSqlParameter))
			{
				return true;
			}
			else
			{
				return false;
			}
		}
	}
}