menuitemdal.cs

CRM管理系统 CRM管理系统

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

namespace Itsv.DAL.SystemManage
{
    public class MenuItemDAL
    {
#region 成员方法
        ///<summary>
        ///是否存在记录
        ///</summary>
        public bool Exists(int menu_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from MenuItems where menu_id=" + menu_id + "");
            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            int cmdresult;
            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }
            if (cmdresult == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        ///<summary>
        ///增加一条数据
        ///</summary>
        public void Add(Itsv.Model.MenuItems model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into MenuItems(");
            strSql.Append("menucode,name,showname,sort,parentcode,url,imageindex,helpcode,tip,sAction,inuse");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + model.menucode + "',");
            strSql.Append("'" + model.name + "',");
            strSql.Append("'" + model.showname + "',");
            strSql.Append("" + model.sort + ",");
            strSql.Append("'" + model.parentcode + "',");
            strSql.Append("'" + model.url + "',");
            strSql.Append("" + model.imageindex + ",");
            strSql.Append("'" + model.helpcode + "',");
            strSql.Append("'" + model.tip + "',");
            strSql.Append("'" + model.sAction + "',");
            strSql.Append("" + model.inuse + "");
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
        ///<summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Itsv.Model.MenuItems model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update MenuItems set ");
            strSql.Append("menucode='" + model.menucode + "',");
            strSql.Append("name='" + model.name + "',");
            strSql.Append("showname='" + model.showname + "',");
            strSql.Append("sort=" + model.sort + ",");
            strSql.Append("parentcode='" + model.parentcode + "',");
            strSql.Append("url='" + model.url + "',");
            strSql.Append("imageindex=" + model.imageindex + ",");
            strSql.Append("helpcode='" + model.helpcode + "',");
            strSql.Append("tip='" + model.tip + "',");
            strSql.Append("sAction='" + model.sAction + "',");
            strSql.Append("inuse=" + model.inuse + "");
            strSql.Append(" where menu_id=" + model.menu_id + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
        ///<summary>
        ///删除一条数据
        ///</summary>
        public void Delete(int menu_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete MenuItems ");
            strSql.Append(" where menu_id=" + menu_id);
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
        ///<summary>
        ///得到一个对象实体
        ///</summary>
        public Itsv.Model.MenuItems GetModel(int menu_id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from MenuItems ");
            strSql.Append(" where menu_id=" + menu_id);
            Itsv.Model.MenuItems model = new Itsv.Model.MenuItems();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            model.menu_id = menu_id;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.menucode = ds.Tables[0].Rows[0]["menucode"].ToString();
                model.name = ds.Tables[0].Rows[0]["name"].ToString();
                model.showname = ds.Tables[0].Rows[0]["showname"].ToString();
                if (ds.Tables[0].Rows[0]["sort"].ToString() != "")
                {
                    model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString());
                }
                model.parentcode = ds.Tables[0].Rows[0]["parentcode"].ToString();
                model.url = ds.Tables[0].Rows[0]["url"].ToString();
                if (ds.Tables[0].Rows[0]["imageindex"].ToString() != "")
                {
                    model.imageindex = int.Parse(ds.Tables[0].Rows[0]["imageindex"].ToString());
                }
                model.helpcode = ds.Tables[0].Rows[0]["helpcode"].ToString();
                model.tip = ds.Tables[0].Rows[0]["tip"].ToString();
                model.sAction = ds.Tables[0].Rows[0]["sAction"].ToString();
                if (ds.Tables[0].Rows[0]["inuse"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["inuse"].ToString() == "1") || (ds.Tables[0].Rows[0]["inuse"].ToString().ToLower() == "true"))
                    {
                        model.inuse = true;
                    }
                    else
                    {
                        model.inuse = false;
                    }
                }

                return model;
            }
            else
            {
                return null;
            }
        }
        ///<summary>
        ///获取数据列表
        ///</summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from MenuItems ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" ORDER BY parentcode, sort, menu_id ");
            return DbHelperSQL.Query(strSql.ToString());
        }
        ///<summary>
        ///获取菜单列表
        ///</summary>
        /// <param name="roleid"></param>
        /// <returns></returns>
        public DataSet GetMenuList(int roleid)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("select c.* ,checked=case role_id when ");
            sb.Append(roleid.ToString());
            sb.Append("then 1 ");
            sb.Append("  else 0  end ");
            sb.Append(" from (select a.*,b.role_id  from dbo.MenuItems a left join (");
            sb.Append("select * from dbo.Role_MenuItem where role_id=");
            sb.Append(roleid.ToString());
            sb.Append(") b");
            sb.Append(" on a.menu_id=b.menu_id) c");
            return DbHelperSQL.Query(sb.ToString());
        }
#endregion








    }
}