company.cs

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

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

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

		public void Insert(CompanyInfo company)
		{
			object[] parms = {
								company.CompanyId,
								company.CompanyName,
								company.Leader,
								company.DeputyId,
								company.Phone,
								company.Address,
								company.PostCode,
								company.Fax,
								company.Email,
								company.HomePage,
								company.BZ
							 };
			DAI.RunProcNonQuery("CRM_Company_Insert",parms);
		}

		public CompanyInfo GetCompanyById(string companyId)
		{
			CompanyInfo company = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Company_GetCompanyById",companyId))
			{
				if (rdr.Read())
				{
					company = new CompanyInfo();

					company.CompanyId = rdr["CompanyId"].ToString();
					company.CompanyName = rdr["CompanyName"].ToString();
					company.Leader = rdr["Leader"].ToString();
					company.DeputyId = rdr["DeputyId"].ToString();
					company.Phone = rdr["Phone"].ToString();
					company.Address = rdr["Address"].ToString();
					company.PostCode = rdr["PostCode"].ToString();
					company.Fax = rdr["Fax"].ToString();
					company.Email = rdr["Email"].ToString();
					company.HomePage = rdr["HomePage"].ToString();
					company.BZ = rdr["BZ"].ToString();
				}
			}
			return company;
		}

		public void Delete(string companyId)
		{
			DAI.RunProcNonQuery("CRM_Company_Delete",companyId);
		}

		public void Update(CompanyInfo company)
		{
			object[] parms = {
								 company.CompanyId,
								 company.CompanyName,
								 company.Leader,
								 company.DeputyId,
								 company.Phone,
								 company.Address,
								 company.PostCode,
								 company.Fax,
								 company.Email,
								 company.HomePage,
								 company.BZ
							 };
			DAI.RunProcNonQuery("CRM_Company_Update",parms);
		}

		public DataTable GetAllCompany()
		{
			return DAI.RunProcTable("CRM_Company_GetAllCompany");
		}

		#endregion
	}
}