level.cs

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

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

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

		public void Insert(LevelInfo level)
		{
			object[] parms = {
								Common.GetNextIdByTable("LevelInfo","LevelId","SingleLayer",null,10),
								level.LevelName,
								level.LevelPicPath,
								level.BZ
							 };
			DAI.RunProcNonQuery("CRM_Level_Insert",parms);
		}

		public void Delete(string levelId)
		{
			DAI.RunProcNonQuery("CRM_Level_Delete",levelId);
		}

		public void Update(LevelInfo level)
		{
			object[] parms = {
								 level.LevelId,
								 level.LevelName,
								 level.LevelPicPath,
								 level.BZ
							 };
			DAI.RunProcNonQuery("CRM_Level_Update",parms);
		}

		public DataTable GetAllLevel()
		{
			return DAI.RunProcTable("CRM_Level_GetAllLevel");
		}

		public LevelInfo GetLevelById(string levelId)
		{
			LevelInfo level = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Level_GetLevelById",levelId))
			{
				if (rdr.Read())
				{
					level = new LevelInfo();

					level.LevelId = rdr["LevelId"].ToString();
					level.LevelName = rdr["LevelName"].ToString();
					level.LevelPicPath = rdr["LevelPicPath"].ToString();
					level.BZ = rdr["BZ"].ToString();
				}
			}
			return level;
		}

		#endregion
	}
}