sysrole.cs

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

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

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

		public void Insert(SysRoleInfo role)
		{
			object[] parms = {
								Common.GetNextIdByTable("SysRoleInfo","RoleId","SingleLayer",null,10),
								role.RoleName,
								role.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysRole_Insert",parms);
		}

		public DataTable GetAllSysRole()
		{
			return DAI.RunProcTable("CRM_SysRole_GetAllSysRole");
		}

		public SysRoleInfo GetSysRoleById(string roleId)
		{
			SysRoleInfo role = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysRole_GetSysRoleById",roleId))
			{
				if (rdr.Read())
				{
					role = new SysRoleInfo();
					role.RoleId = rdr["RoleId"].ToString();
					role.RoleName = rdr["RoleName"].ToString();
					role.BZ = rdr["BZ"].ToString();
				}
			}
			return role;
		}

		public void Delete(string roleId)
		{
			DAI.RunProcNonQuery("CRM_SysRole_Delete",roleId);
		}

		public void Update(SysRoleInfo role)
		{
			object[] parms = {
								 role.RoleId,
								 role.RoleName,
								 role.BZ
							 };
			DAI.RunProcNonQuery("CRM_SysRole_Update",parms);
		}

		#endregion
	}
}