rolerightservice.cs

办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统办公系统

//============================================================
// Producnt name:		BoBoARTS.CodeMad
// Version: 			1.0
// Coded by:			Shen Bo ([e-mail])
// Auto generated at: 	2008-9-18 16:21:20
//============================================================

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Office.Model;

namespace Office.DAL
{
    public static partial class RoleRightService
    {
        /// <summary>
        /// add user roleright
        /// </summary>
        /// <param name="roleRight">RoleRight</param>
        /// <returns>RoleRight</returns>
        public static RoleRight AddRoleRight(RoleRight roleRight)
        {
            String sql = "insert into RoleRight (RoleId,NodeId) values (@RoleId,@NodeId)";
            sql += " ; select @@identity";
            try
            {
                SqlParameter[] para = new SqlParameter[] { 
                    new SqlParameter("@RoleId",roleRight.Role.RoleId),
                    new SqlParameter("@NodeId",roleRight.Node.NodeId)
                };
                int newID = DBHelper.GetScalar(sql, para);
                return GetRoleRightByRoleRightID(newID);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="RoleId"></param>
        /// <param name="NodeId"></param>
        /// <returns></returns>
        public static Boolean InsertRoleRight(String RoleId, String NodeId)
        {
            String sql = "insert into RoleRight (RoleId,NodeId) values (@RoleId,@NodeId)";
            try
            {
                SqlParameter[] para = new SqlParameter[] { 
                    new SqlParameter("@RoleId",RoleId),
                    new SqlParameter("@NodeId",NodeId)
                };
                int count = DBHelper.GetScalar(sql, para);
                return count > 0 ? true : false;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        /// <summary>
        /// delete roleright
        /// </summary>
        /// <param name="roleRight">RoleRight</param>
        /// <returns>Boolean</returns>
        public static Boolean DeleteRoleRight(RoleRight roleRight)
        {
            return DeleteRoleRightByRoleRightID(roleRight.RoleRightId);
        }
        /// <summary>
        /// delete RoleRight according to id
        /// </summary>
        /// <param name="roleRightID">roleRightID</param>
        /// <returns>Boolean</returns>
        public static Boolean DeleteRoleRightByRoleRightID(int roleRightID)
        {
            string sql = "delete RoleRight where RoleRightId ="+roleRightID;
            Boolean result = false;
            try
            {
                DBHelper.ExecuteCommand(sql);
                result = true;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
            return result;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="roleRightID"></param>
        /// <returns></returns>
        public static Boolean DeleteRoleRight(String RoleId, String NodeId)
        {
            string sql = "delete RoleRight where RoleId =" + RoleId + " and NodeId = "+NodeId;
            Boolean result = false;
            try
            {
                DBHelper.ExecuteCommand(sql);
                result = true;
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
            return result;
        }
        /// <summary>
        /// Modify RoleRight
        /// </summary>
        /// <param name="roleRight">RoleRight</param>
        /// <returns>Boolean</returns>
        public static Boolean ModifyRoleRight(RoleRight roleRight)
        {
            String sql = "update RoleRight set RoleId=@RoleId,NodeId=@NodeId where RoleRightId=@RoleRightId";
            try
            {
                SqlParameter[] para = new SqlParameter[] {
                    new SqlParameter("@RoleId",roleRight.Role.RoleId),
                    new SqlParameter("@NodeId",roleRight.Node.NodeId),
                    new SqlParameter("@RoleRightId",roleRight.RoleRightId)
                };
                int count = DBHelper.ExecuteCommand(sql, para);
                return count > 0 ? true : false;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        /// <summary>
        /// Get RoleRight according to id
        /// </summary>
        /// <param name="roleRightID">roleRightID</param>
        /// <returns>RoleRight</returns>
        public static RoleRight GetRoleRightByRoleRightID(int roleRightID)
        {
            String sql = "select * from RoleRight where RoleRightId=" + roleRightID;
            try
            {
                SqlDataReader read = DBHelper.GetReader(sql);
                if (read.Read())
                {
                    RoleRight right = new RoleRight();
                    right.RoleRightId = read.GetInt32(0);
                    right.Role = RoleInfoService.GetRoleInfoByRoleId(read.GetInt32(1));
                    right.Node = SysFunService.GetSysFunByNodeId(read.GetInt32(2));
                    read.Close();
                    return right;
                }
                else
                {
                    read.Close();
                    return null;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        /// <summary>
        /// Get All RoleRight
        /// </summary>
        /// <returns>IList<RoleRight></returns>
        public static IList<RoleRight> GetAllRoleRight()
        {
            return GetRoleRightBySql("select * from RoleRight");
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="roleID"></param>
        /// <returns></returns>
        public static IList<RoleRight> GetRoleRightByRoleId(Int32 roleID)
        {
            return GetRoleRightBySql("select * from RoleRight where RoleId=" + roleID);
        }
        #region 根据角色ID和父节点ID得到ROLERIGHT表中已经存在的子菜单信息
        /// <summary>
        /// 
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="nodeId"></param>
        /// <returns></returns>
        public static IList<RoleRight> GetRoleRightByRoleIdAndParentNodeId(Int32 roleId,Int32 nodeId)
        {
            string sql = "select * from View_Role where RoleId=" + roleId + " and ParentNodeId=" + nodeId + "";
            List<RoleRight> list = new List<RoleRight>();
            try
            {
                DataTable table = DBHelper.GetDataSet(sql);
                foreach (DataRow row in table.Rows)
                {
                    RoleRight right = new RoleRight();
                    right.Node = SysFunService.GetSysFunByNodeId((int)row["NodeId"]);
                    list.Add(right);
                }
                return list;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        #endregion

        /// <summary>
        /// Get RoleRight according to safe T-SQL sentence
        /// </summary>
        /// <param name="safeSql">safeSql</param>
        /// <returns>List<RoleRight></returns>
        private static IList<RoleRight> GetRoleRightBySql(string safeSql)
        {
            List<RoleRight> list = new List<RoleRight>();
            try
            {
                DataTable table = DBHelper.GetDataSet(safeSql);
                foreach (DataRow row in table.Rows)
                {
                    RoleRight right = new RoleRight();
                    right.RoleRightId = (int)row["RoleRightId"];
                    right.Role = RoleInfoService.GetRoleInfoByRoleId((int)row["RoleId"]);
                    right.Node = SysFunService.GetSysFunByNodeId((int)row["NodeId"]);

                    list.Add(right);
                }
                return list;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }
        /// <summary>
        /// Get RoleRight according to safe T-SQL sentence and parameter
        /// </summary>
        /// <param name="safeSql">safeSql</param>
        /// <param name="values">SqlParameter</param>
        /// <returns>List<RoleRight></returns>
        private static IList<RoleRight> GetRoleRightBySql(string safeSql,params SqlParameter[] values)
        {
            List<RoleRight> list = new List<RoleRight>();
            try
            {
                DataTable table = DBHelper.GetDataSet(safeSql,values);
                foreach (DataRow row in table.Rows)
                {
                    RoleRight right = new RoleRight();
                    right.RoleRightId = (int)row["RoleRightId"];
                    right.Role = RoleInfoService.GetRoleInfoByRoleId((int)row["RoleId"]);
                    right.Node = SysFunService.GetSysFunByNodeId((int)row["NodeId"]);

                    list.Add(right);
                }
                return list;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw ex;
            }
        }

    }
}