sysfunc.cs

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

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

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

		public void Insert(SysFuncInfo func)
		{
			object[] parms = {
								Common.GetNextIdByTable("SysFuncInfo","FuncId","SingleLayer",null,10),
								func.FuncName,
								func.Path,
								func.BZ
							 };
			DAI.RunProcNonQuery("CRM_Func_Insert",parms);
		}

		public DataTable GetAllSysFunc()
		{
			return DAI.RunProcTable("CRM_Func_GetAllSysFunc");
		}

		public SysFuncInfo GetSysFuncById(string funcId)
		{
			SysFuncInfo func = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Func_GetSysFuncById",funcId))
			{
				if (rdr.Read())
				{
					func = new SysFuncInfo();

					func.FuncId = rdr["FuncId"].ToString();
					func.FuncName = rdr["FuncName"].ToString();
					func.Path = rdr["Path"].ToString();
					func.BZ = rdr["BZ"].ToString();
				}
			}
			return func;
		}

		public DataTable GetFuncByRoleId(string roleId)
		{
			return DAI.RunProcTable("CRM_Func_GetFuncByRoleId",roleId);
		}

		public void Delete(string funcid)
		{
			DAI.RunProcNonQuery("CRM_Func_Delete",funcid);
		}

		public void Update(SysFuncInfo func)
		{
			object[] parms = {
								 func.FuncId,
								 func.FuncName,
								 func.Path,
								 func.BZ
							 };
			DAI.RunProcNonQuery("CRM_Func_Update",parms);
		}
		
		public string GetActionUserControlPath(string father,string action)
		{
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysUserControl_GetActionUserControlPath",father,action))
		    {
				if (rdr.Read())
				{
					return rdr["Path"].ToString();
				}
				return null;
			}
		}

		#endregion
	}
}