depart.cs

来自「某个公司需要维持良好的客户关系」· CS 代码 · 共 95 行

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

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

		public void Insert(DepartInfo depart)
		{
			object[] parms = {
								depart.DepartId,
								depart.departName,
								depart.Leader,
								depart.Phone,
								depart.Address,
								depart.PostCode,
								depart.Fax,
								depart.Email,
								depart.HomePage,
								depart.CompanyId,
								depart.BZ
							 };
			DAI.RunProcNonQuery("CRM_Depart_Insert",parms);
		}

		public DepartInfo GetDepartById(string departId)
		{
			DepartInfo depart = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Depart_GetDepartById",departId))
			{
				if (rdr.Read())
				{
					depart = new DepartInfo();

					depart.DepartId = rdr["DepartId"].ToString();
					depart.departName = rdr["departName"].ToString();
					depart.Leader = rdr["Leader"].ToString();
					depart.Phone = rdr["Phone"].ToString();
					depart.Address = rdr["Address"].ToString();
					depart.PostCode = rdr["PostCode"].ToString();
					depart.Fax = rdr["Fax"].ToString();
					depart.Email = rdr["Email"].ToString();
					depart.HomePage = rdr["HomePage"].ToString();
					depart.BZ = rdr["BZ"].ToString();
				}
			}
			return depart;
		}

		public DataTable GetAllDepart()
		{
			return DAI.RunProcTable("CRM_Depart_GetAllDepart");;
		}

		public void Delete(string departId)
		{
			DAI.RunProcNonQuery("CRM_Depart_Delete",departId);
		}

		public void Update(DepartInfo depart)
		{
			object[] parms = {
								 depart.DepartId,
								 depart.departName,
								 depart.Leader,
								 depart.Phone,
								 depart.Address,
								 depart.PostCode,
								 depart.Fax,
								 depart.Email,
								 depart.HomePage,
								 depart.CompanyId,
								 depart.BZ
							 };
			DAI.RunProcNonQuery("CRM_Depart_Update",parms);
		}

		public DataTable GetDepartByCompanyId(string companyId)
		{
			return DAI.RunProcTable("CRM_Depart_GetDepartByCompanyId",companyId);
		}

		#endregion
	}
}