deputy.cs

某个公司需要维持良好的客户关系

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using CRM.IDAL;
using CRM.Model;

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// Deputy 的摘要说明。
	/// </summary>
	public class Deputy : IDeputy
	{
		#region IDeputy 成员

		public void Insert(DeputyInfo deputy)
		{
			object[] parms = {
								Common.GetNextIdByTable("DeputyInfo","DeputyId","SingleLayer",null,10),
								deputy.TrueName,
								deputy.Sex,
								deputy.Birthday,
								deputy.Address,
								deputy.Phone,
								deputy.MobilePhone,
								deputy.PostCode,
								deputy.Email,
								deputy.BZ
							 };
			DAI.RunProcNonQuery("CRM_Deputy_Insert",parms);
		}

		public DataTable GetAllDeputy()
		{
			return DAI.RunProcTable("CRM_Deputy_GetAllDeputy");
		}

		public DeputyInfo GetDeputyById(string deputyId)
		{
			DeputyInfo deputy = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Deputy_GetDeputyById",deputyId))
			{
				if (rdr.Read())
				{
					deputy = new DeputyInfo();

					deputy.DeputyId = rdr["DeputyId"].ToString();
					deputy.TrueName = rdr["TrueName"].ToString();
					deputy.Sex = rdr["Sex"].ToString();
					deputy.Birthday = rdr["Birthday"].ToString();
					deputy.Address = rdr["Address"].ToString();
					deputy.Phone = rdr["Address"].ToString();
					deputy.MobilePhone = rdr["MobilePhone"].ToString();
					deputy.PostCode = rdr["PostCode"].ToString();
					deputy.Email = rdr["Email"].ToString();
					deputy.BZ = rdr["BZ"].ToString();
				}
			}
			return deputy;
		}

		public void Delete(string deputyId)
		{
			DAI.RunProcNonQuery("CRM_Deputy_Delete",deputyId);
		}

		public void Update(DeputyInfo deputy)
		{
			object[] parms = {
								 deputy.DeputyId,
								 deputy.TrueName,
								 deputy.Sex,
								 deputy.Birthday,
								 deputy.Address,
								 deputy.Phone,
								 deputy.MobilePhone,
								 deputy.PostCode,
								 deputy.Email,
								 deputy.BZ
							 };
			DAI.RunProcNonQuery("CRM_Deputy_Update",parms);
		}

		#endregion
	}
}