menuitembll.cs

CRM管理系统 CRM管理系统

//------------------------------------*/
//版权所有：杭州商易信息技术有限公司
//功能描述：操作菜单类
//    作者：沈伟
//    日期：2008/08/27
//------------------------------------*/
using System;
using System.Data;
using System.Text;


namespace Itsv.BLL.SystemManage
{
    public class MenuItemBLL
    {
        private static readonly Itsv.DAL.SystemManage.MenuItemDAL dal = new Itsv.DAL.SystemManage.MenuItemDAL();
        #region  成员方法
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int menu_id)
        {
            return dal.Exists(menu_id);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(Itsv.Model.MenuItems model)
        {
            dal.Add(model);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Itsv.Model.MenuItems model)
        {
            dal.Update(model);
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int menu_id)
        {
            dal.Delete(menu_id);
        }
        ///<summary>
        ///得到一个对象实体
        ///<summary>
        public Itsv.Model.MenuItems GetModel(int menu_id)
        {
            return dal.GetModel(menu_id);
        }
        ///<summary>
        ///获得数据列表
        ///<summary>
        public DataSet GetList(string strWhere, ref string msg)
        {
            try
            {
                return dal.GetList(strWhere);
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                return null;
            }
        }
        ///<summary>
        ///得到用户菜单
        ///</summary>
        /// <param name="user_id"></param>
        /// <param name="msg"></param>
        /// <returns></returns>
        public DataSet GetListByUser(string account, ref string msg)
        {
            try
            {
                string s = " menu_id in ( select distinct( menu_id )  from dbo.Role_MenuItem where role_id in ( select role_id from dbo.User_Role where  account='" + account + "') )";
                return dal.GetList(s);
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                return null;
            }
        }
        public DataSet GetMenuList(int roleid, ref string msg)
        {
            try
            {

                return dal.GetMenuList(roleid);
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                return null;
            }

        }
        
       #endregion
    }                                                                                        
}