bargain.cs

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

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

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

		/// <summary>
		/// 获得指定客户相关的所有合同信息
		/// </summary>
		/// <param name="customerId">客户ID</param>
		/// <returns></returns>
		public DataTable GetBargainByCustomerId(string customerId)
		{
			return DAI.RunProcTable("CRM_Bargain_GetBargainByCustomerId",customerId);
		}

		public void Insert(BargainInfo bargain)
		{
			//把数据库表的值一一罗列
			object[] parms = {
								Common.GetNextIdByTable("BargainInfo","BargainId","SingleLayer",null,10),
								bargain.CustomerId,
								bargain.Content,
								bargain.Status,
								bargain.BZ
							 };
			DAI.RunProcNonQuery("CRM_Bargain_Insert",parms);//调用存储过程（SQL语句），插入数据库表
		}

		public BargainInfo GetBargainById(string bargainId)
		{
			BargainInfo bargain = null;
			using(SqlDataReader rdr = DAI.RunProcReader("CRM_Bargain_GetBargainById",bargainId) )
			{
				if (rdr.Read())
				{
					bargain = new BargainInfo();

					bargain.BargainId = rdr["BargainId"].ToString();
					bargain.CustomerId = rdr["CustomerId"].ToString();
					bargain.Content = rdr["Content"].ToString();
					bargain.SubmitDate = rdr["SubmitDate"].ToString();
					bargain.Status = rdr["Status"].ToString();
					bargain.BZ = rdr["Status"].ToString();
				}
			}
			return bargain;
		}

		public DataTable GetAllBargain()
		{
			return DAI.RunProcTable("CRM_Bargain_GetAllBargain");
		}

		public void Delete(string bargainId)
		{
			DAI.RunProcNonQuery("CRM_Bargain_Delete",bargainId);
		}

		public void Update(BargainInfo bargain)
		{
			object[] parms = {
								bargain.BargainId,
								bargain.CustomerId,
								bargain.Content,
								bargain.Status,
								bargain.BZ
							 };
			DAI.RunProcNonQuery("CRM_Bargain_Update",parms);
		}

		public DataTable GetBargainByUserId(string userid)
		{
			return DAI.RunProcTable("CRM_Bargain_GetBargainByUserId",userid);
		}

		#endregion
	}
}