www.pudn.com > UDS1.1_51aspx.rar > Linkman.cs


using System; 
using System.Data; 
using System.Data.SqlClient; 
 
namespace UDS.Components 
{ 
	///  
	/// Linkman 的摘要说明。 
	///  
	public class MyLinkman 
	{ 
		public MyLinkman() 
		{ 
		} 
 
		#region 得到联系人列表 
		///  
		/// 得到我的联系人 
		///  
		/// 联系人类型(0:所有联系人1:员工联系人2:客户联系人3:自定义联系人) 
		/// 用户id 
		///  
		public SqlDataReader GetMyLinkman(int type,int staffid) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									    data.MakeInParam("@type",SqlDbType.Int,4,type), 
										data.MakeInParam("@staffid",SqlDbType.Int,4,staffid) 
			}; 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetList",prams,out dr); 
			return(dr); 
		} 
		#endregion 
 
		#region 得到自定义联系人 
		///  
		/// 得到自定义联系人 
		///  
		///  
		public SqlDataReader GetCustomLinkman(int id) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@id",SqlDbType.Int,4,id) 
								   }; 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetCustomLinkman",prams,out dr); 
			return(dr); 
			 
		} 
		#endregion 
 
		#region 得到自定义联系人类别 
 
		public SqlDataReader GetCustomLinkmanType(int id) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@id",SqlDbType.Int,4,id) 
								   }; 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetCustomLinkmanTypeByCustomLinkmanID",prams,out dr); 
			return(dr); 
		} 
 
		#endregion 
 
		#region 获得所有联系人分类关系数据 
		///  
		/// 获得所有联系人分类关系数据 
		///  
		///  
		public SqlDataReader GetLinkmanTypeRelation() 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetAllLinkmanTypeData",out dr); 
			return(dr); 
		} 
		#endregion 
 
		#region 添加自定义联系人 
		///  
		/// 添加自定义联系人 
		///  
		/// CustomLinkman结构 
		/// 添加的ID 
		public int AddCustomLinkman(CustomLinkman clinkman,int staffid) 
		{ 
			int result = 0; 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									    data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name), 
										data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender), 
										data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone), 
										data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email), 
										data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress), 
										data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip), 
										data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress), 
										data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip), 
										data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile), 
										data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone), 
										data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo), 
										data.MakeInParam("@Staffid",SqlDbType.Int,4,staffid), 
										data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age) 
								   }; 
			result = data.RunProc("sp_Linkman_AddCustomLinkman",prams); 
		 
			if(clinkman.Type.IndexOf(',',0)!=-1) 
			{ 
				string [] arrtype = clinkman.Type.Split(','); 
				for(int i = 0;i 
		/// 更新自定义联系人 
		///  
		///  
		public void UpdateCustomLinkman(CustomLinkman clinkman) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@ID",SqlDbType.Int,4,clinkman.ID), 
									   data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name), 
									   data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender), 
									   data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone), 
									   data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email), 
									   data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress), 
									   data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip), 
									   data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress), 
									   data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip), 
									   data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile), 
									   data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone), 
									   data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo), 
									   data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age), 
									   data.MakeInParam("@Type",SqlDbType.VarChar,200,clinkman.Type) 
								   }; 
			data.RunProc("sp_Linkman_UpdateCustomLinkman",prams); 
		} 
		#endregion 
 
		#region 获得自定义联系人分类 
 
		///  
		/// 获得自定义联系人分类 
		///  
		///  
		public SqlDataReader GetCustomLinkmanType() 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetCustomLinkmanType",out dr); 
			return(dr); 
		} 
 
		#endregion 
 
		#region 根据分类得到自定义联系人 
		///  
		/// 根据分类得到自定义联系人 
		///  
		/// 类别id 
		///  
		public SqlDataReader GetCustomLinkmanByType(int type,int staffid) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
										data.MakeInParam("@typeid",SqlDbType.Int,4,type), 
										data.MakeInParam("@staffid",SqlDbType.Int,4,staffid) 
								   }; 
			SqlDataReader dr = null; 
			data.RunProc("sp_Linkman_GetCustomLinkmanByType",prams,out dr); 
			return(dr); 
 
		} 
		#endregion 
 
		#region 更新自定义联系人分类 
		///  
		/// 更新自定义联系人分类 
		///  
		///  
		public void UpdateCustomLinkmanType(CustomLinkman clinkman) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			if(clinkman.Type.IndexOf(',',0)!=-1) 
			{ 
				string [] arrtype = clinkman.Type.Split(','); 
				for(int i = 0;i 
		/// 添加联系人到联系人列表 
		///  
		/// 联系人类别1:员工联系人2:客户联系人3:自定义联系人 
		/// 联系人id 
		/// 用户id 
		public void AddLinkmanToList(int type,int id,int staffid) 
		{ 
			Database db = new Database(); 
			SqlParameter[] prams = { 
									     db.MakeInParam("@type",SqlDbType.Int,4,type), 
										 db.MakeInParam("@id",SqlDbType.Int,4,id), 
										 db.MakeInParam("@staffid",SqlDbType.Int,4,staffid) 
			}; 
			db.RunProc("sp_Linkman_AddToLinkmanList",prams); 
		} 
		#endregion 
 
		#region 删除联系人列表中的联系人 
		///  
		/// 删除联系人列表中的联系人 
		///  
		/// 联系人列表中的id 
		public void DelLinkmanFromList(int type,int linkmanid) 
		{ 
			Database db = new Database(); 
			SqlParameter[] prams = { 
									   db.MakeInParam("@type",SqlDbType.Int,4,type), 
									   db.MakeInParam("@linkmanid",SqlDbType.Int,4,linkmanid) 
								   }; 
			db.RunProc("sp_Linkman_DelLinkmanFromList",prams); 
		} 
		#endregion 
 
		#region 检查此人是否已经在联系人列表中 
		///  
		/// 检查此人是否已经在联系人列表中 
		///  
		/// 联系人类型(0:所有联系人1:员工联系人2:客户联系人3:自定义联系人) 
		/// 用户id 
		/// 联系人id 
		///  
		public bool HaveInList(int type,int staffid,int id) 
		{ 
			UDS.Components.Database data = new UDS.Components.Database(); 
			SqlParameter[] prams = { 
									   data.MakeInParam("@type",SqlDbType.Int,4,type), 
									   data.MakeInParam("@staffid",SqlDbType.Int,4,staffid), 
									   data.MakeInParam("@id",SqlDbType.Int,4,id) 
								   }; 
			return((data.RunProc("sp_Linkman_HaveInList",prams)==1)?true:false); 
		} 
		#endregion 
 
	} 
 
	#region 自定义联系人结构 
	///  
	/// 自定义联系人结构 
	///  
	public class CustomLinkman 
	{ 
		private int m_id; 
		private string m_name=""; 
		private bool m_gender; 
		private string m_email=""; 
		private string m_unittelephone=""; 
		private string m_unitaddress=""; 
		private string m_unitzip=""; 
		private string m_familytelephone=""; 
		private string m_familyaddress=""; 
		private string m_familyzip=""; 
		private string m_type=""; 
		private string m_mobile=""; 
		private string m_memo=""; 
		private string m_age = ""; 
 
		///  
		/// ID 
		///  
		public int ID 
		{ 
			get{return m_id;} 
			set{m_id = value;} 
		} 
		///  
		/// 姓名 
		///  
		public string Name 
		{ 
			get{return m_name;} 
			set{m_name = value;} 
		} 
 
		///  
		/// 性别 
		///  
		public bool Gender 
		{ 
			get{return m_gender;} 
			set{m_gender = value;} 
		} 
 
 
		///  
		/// Email 
		///  
		public string Email 
		{ 
			get{return m_email;} 
			set{m_email = value;} 
		} 
 
		///  
		/// 单位电话 
		///  
		public string UnitTelephone 
		{ 
			get{return m_unittelephone;} 
			set{m_unittelephone = value;} 
		} 
		///  
		/// 单位地址 
		///  
		public string UnitAddress 
		{ 
			get{return m_unitaddress;} 
			set{m_unitaddress = value;} 
		} 
 
		///  
		/// 单位邮编 
		///  
		public string UnitZip 
		{ 
			get{return m_unitzip;} 
			set{m_unitzip = value;} 
		} 
 
		///  
		/// 家庭电话 
		///  
		public string FamilyTelephone 
		{ 
			get{return m_familytelephone;} 
			set{m_familytelephone = value;} 
		} 
 
		///  
		/// 家庭地址 
		///  
		public string FamilyAddress 
		{ 
			get{return m_familyaddress;} 
			set{m_familyaddress = value;} 
		} 
 
		///  
		/// 家庭邮编 
		///  
		public string FamilyZip 
		{ 
			get{return m_familyzip;} 
			set{m_familyzip = value;} 
		} 
 
		///  
		/// 所属分类 
		///  
		public string Type 
		{ 
			get{return m_type;} 
			set{m_type = value;} 
		} 
 
		///  
		/// 手机 
		///  
		public string Mobile 
		{ 
			get{return m_mobile;} 
			set{m_mobile = value;} 
		} 
 
		///  
		/// 备注 
		///  
		public string Memo 
		{ 
			get{return m_memo;} 
			set{m_memo = value;} 
		} 
 
		///  
		/// 年龄 
		///  
		public string Age 
		{ 
			get{return m_age;} 
			set{m_age = value;} 
		} 
	} 
	#endregion 
}