role.cs

很不错的学生管理系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using es_data = com.egt.data;

namespace com.egt.business
{
    public class role
    {
        /*
    * 编码人员：胡鹏飞
    * 
    * 编码时间：2007-9-27
    * 
    * 内容：系统管理业务类
    */
        private SqlParameter[] para;
        private DataSet ds;

        /// <summary>
        /// 新建角色
        /// </summary>
        /// <param name="roatt"></param>
        /// <returns></returns>
        public int new_role(RoleAttribute roatt, string[] chooess)
        {
            SqlConnection con = es_data.DataBaseAdmin.GetConObject();
            con.Open();
            SqlTransaction trans = con.BeginTransaction(IsolationLevel.Serializable);
            try
            {
                para = new SqlParameter[1];
                para[0] = es_data.DataBaseAdmin.MakeInParam("@varnames", SqlDbType.VarChar, 30, roatt.names);
                ds = es_data.DataBaseAdmin.ExecuteDataSet(trans, "sp_role_new", para);
                for (int i = 0; i < chooess.Length; i++)
                {
                    para = new SqlParameter[2];
                    para[0] = es_data.DataBaseAdmin.MakeInParam("@introleid", SqlDbType.Int, 30, Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()));
                    para[1] = es_data.DataBaseAdmin.MakeInParam("@intpopedomid", SqlDbType.Int, 30, Convert.ToInt32(chooess[i]));
                    ds = es_data.DataBaseAdmin.ExecuteDataSet(trans, "sp_rolepopedom_new", para);
                }
                trans.Commit();
                return 1;
            }
            catch (Exception ex)
            {
                string ms = ex.Message;
                trans.Rollback();
                return 0;
            }
            finally
            {
                con.Close();
            }
        }

        /// <summary>
        /// 修改角色权限信息
        /// </summary>
        /// <param name="roatt"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public int update_role(RoleAttribute roatt, string[] dt,string zt)
        {
            SqlConnection con = es_data.DataBaseAdmin.GetConObject();
            con.Open();
            SqlTransaction trans = con.BeginTransaction(IsolationLevel.Serializable);
            try
            {
                if (zt == "增加")
                {
                    for (int i = 0; i < dt.Length; i++)
                    {
                        para = new SqlParameter[2];
                        para[0] = es_data.DataBaseAdmin.MakeInParam("@introleid", SqlDbType.Int, 30,roatt.id);
                        para[1] = es_data.DataBaseAdmin.MakeInParam("@intpopedomid", SqlDbType.Int, 30, Convert.ToInt32(dt[i]));
                        ds = es_data.DataBaseAdmin.ExecuteDataSet(trans, "sp_rolepopedom_new", para);
                    }
                }
                else
                {
                    for (int i = 0; i < dt.Length; i++)
                    {
                        para = new SqlParameter[2];
                        para[0] = es_data.DataBaseAdmin.MakeInParam("@introleid", SqlDbType.Int, 30, roatt.id);
                        para[1] = es_data.DataBaseAdmin.MakeInParam("@intpopedomid", SqlDbType.Int, 30, Convert.ToInt32(dt[i]));
                        ds = es_data.DataBaseAdmin.ExecuteDataSet(trans, "sp_rolepopedom_del", para);
                    }
                }
                trans.Commit();
                return 1;
            }
            catch (Exception ex)
            {
                string ms = ex.Message;
                trans.Rollback();
                return 0;
            }
            finally
            {
                con.Close();
            }
            return 1;
        }

        /// <summary>
        /// 查询所有权限信息
        /// </summary>
        /// <returns></returns>
        public DataSet select_popedom()
        {
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_popedom_select_all");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
                return null;
            return ds;
        }

        /// <summary>
        /// 查询所有角色列表
        /// </summary>
        /// <returns></returns>
        public DataSet select_role()
        {
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_roleid_select");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
                return null;
            return ds;
        }

        /// <summary>
        /// 查询角色所包含的权限
        /// </summary>
        /// <param name="roleid"></param>
        /// <returns></returns>
        public DataSet select_popedomnone(string roleid)
        {
            para = new SqlParameter[1];
            para[0] = es_data.DataBaseAdmin.MakeInParam("@introleid", SqlDbType.VarChar, 30, roleid);
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_popedom_selectnone", para);
            if (ds == null || ds.Tables[0].Rows.Count == 0)
                return null;
            return ds;
        }
    }
}