customertype.cs

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

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

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

		public void Insert(CustomerTypeInfo type)
		{
			object[] parms = {
								 Common.GetNextIdByTable("CustomerTypeInfo","TypeId","MulLayer",(type.TypeId != null) ? type.TypeId.Trim() : null ,2),
								 type.TypeName,
								 type.BZ
							 };
			DAI.RunProcNonQuery("CRM_CustomerType_Insert",parms);
		}
		public void Delete(string typeId)
		{
			DAI.RunProcNonQuery("CRM_CustomerType_Delete",typeId);
		}

		public void Update(CustomerTypeInfo type)
		{
			object[] parms = {
								type.TypeId,
								type.TypeName,
								type.BZ
							 };
			DAI.RunProcNonQuery("CRM_CustomerType_Update",parms);
		}

		public DataTable GetAllType()
		{
			return DAI.RunProcTable("CRM_CustomerType_GetAllType");
		}

		public CustomerTypeInfo GetTypeById(string typeId)
		{
			CustomerTypeInfo type = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_CustomerType_GetTypeById",typeId))
			{
				if (rdr.Read())
				{
					type = new CustomerTypeInfo();

					type.TypeId = rdr["TypeId"].ToString();
					type.TypeName = rdr["TypeName"].ToString();
					type.BZ = rdr["BZ"].ToString();
				}
			}
			return type;
		}

		#endregion
	}
}