role.cs

oa办公系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// role 的摘要说明
/// </summary>
public class role
{
	public role()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 获取所有的角色
    /// </summary>
    /// <returns>返回DataView对象</returns>
    public DataView sel_allroles()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("sel_allrole", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds = new DataSet();
        sda.Fill(ds, "rolename");
        DataView dv = ds.Tables["rolename"].DefaultView;
        return dv;
    }


   /// <summary>
   /// 更新角色名称
   /// </summary>
   /// <param name="values">角色值</param>
   /// <param name="rolename">角色名称</param>
    public void update_roles(int values, string rolename)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_rolename", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@r_value", SqlDbType.Int).Value = values;
        cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 50).Value = rolename;
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }


    /// <summary>
    /// 为员工分配权限
    /// </summary>
    /// <param name="s_id">员工编号</param>
    /// <param name="roles">员工的角色</param>
    public void shareroles(int s_id,string roles)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("shareroles", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 50).Value = roles;
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }
}