telephone.cs

人力资源管理系统

using System;
using System.Data ;
using COAdmin.COMMON;
using COAdmin.DAL ;

namespace COAdmin.BLL
{
	/// <summary>
	/// TelePhone 的摘要说明。
	/// </summary>
	public class TelePhone
	{
		public TelePhone()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		private int _telID ;
		private int _custID ;
		private int _area ;
		private int _phone;
		private int _ext ;
		private string _telType ;
		private string _priority ;
		
		public int TelID
		{
			get{ return _telID ; }
			set{ _telID = value ;}
		}

		public int CustID
		{
			get{ return _custID ; }
			set{ _custID = value ;}
		}

		public int Area
		{
			get{ return _area ; }
			set{ _area = value ;}
		}

		public int Phone
		{
			get{ return _phone ; }
			set{ _phone = value ;}
		}

		public int Ext
		{
			get{ return _ext ; }
			set{ _ext = value ;}
		}

		public string TelType
		{
			get{ return _telType ; }
			set{ _telType = value ;}
		}

		public string Priority
		{
			get{ return _priority ; }
			set{ _priority = value ;}
		}

		#region 公共方法
		/// <summary>
		/// 根据电话ID获取电话信息
		/// </summary>
		/// <param name="telID">电话ID</param>
		/// <returns></returns>
		public int GetTel(int telID)
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Telephone_Get" ;
			//存储过程参数
			object[] para = new object[] {telID} ;

			// 调用数据访问方法查询电话信息
			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count > 0)
			{
				// 查询成功
				DataRow dr = dt.Rows[0] ;
				// 指定电话属性
				AssignAttribute(dr) ;
				ret = 0 ;
			}
			return ret ;
		}

		/// <summary>
		/// 根据客户ID查询电话信息
		/// </summary>
		/// <param name="usrCustomerID">客户ID</param>
		/// <returns></returns>
		public DataTable GetTelByCustID(int usrCustomerID)
		{
			//存储过程名
			string spName = "CO_TelePhone_GetByCust" ;
			//存储过程参数
			object[] para = new object[] {usrCustomerID};

			// 调用数据访问方法查询电话信息，并返回结果
			return DataAccess.ExecuteDataTable(spName,para) ;
			
		}

		/// <summary>
		/// 指定电话信息各属性
		/// </summary>
		/// <param name="dr"></param>
		private void AssignAttribute(DataRow dr)
		{
			this._area = CommHandler.StringToInt(dr["Area"].ToString()) ;
			this._custID = this._custID ;
			this._phone = CommHandler.StringToInt(dr["Phone"].ToString()) ;
			this._telID = CommHandler.StringToInt(dr["TelID"].ToString()) ;
			this._ext = CommHandler.StringToInt(dr["Ext"].ToString()) ;
			this._priority = dr["Priority"].ToString() ;
			this._telType = dr["TelType"].ToString() ;
		}

		/// <summary>
		/// 删除电话许诺西
		/// </summary>
		/// <param name="telID">电话ID</param>
		/// <returns></returns>
		public static int DeleteTel(int telID)
		{
			//存储过程名
			string spName = "CO_TelePhone_Delete" ;

			//存储过程参数
			object[] para = new object[] {telID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;
		}

		/// <summary>
		/// 添加电话信息
		/// </summary>
		/// <returns></returns>
		public int AddTel()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_TelePhone_Add" ;
			//存储过程参数
			object[] para = new object[] {"",_custID,_area ,_phone,_ext ,_telType ,_priority} ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		/// <summary>
		/// 修改电话信息
		/// </summary>
		/// <returns></returns>
		public int ModifyTel()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_TelePhone_Modify" ;
			//存储过程参数
			object[] para = new object[] {_telID,_custID,_area ,_phone,_ext ,_telType ,_priority} ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}			
		#endregion
	}
}