position.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;
using System.Collections;

/// <summary>
/// position 的摘要说明
/// </summary>
public class position
{
	public position()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    //添加部门信息
    public void add_department(string name, string content)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("add_department",con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@d_name", SqlDbType.VarChar, 50).Value = name;
        cmd.Parameters.Add("@d_content", SqlDbType.Text).Value = content;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   

    }

    //绑定部门信息
    public DataView band_department()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select_department", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds=new DataSet();
        sda.Fill(ds,"table");
        DataView dv = ds.Tables["table"].DefaultView;
        return dv;
        //con.Close();
    }

    //添加职位信息
    public void AddPosition(ArrayList arr)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("add_position", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@p_name", SqlDbType.VarChar,50).Value = arr[0];
        cmd.Parameters.Add("@d_id", SqlDbType.Int).Value = arr[1];
        cmd.Parameters.Add("@p_content", SqlDbType.Text).Value = arr[2];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   
    }

    //根据部门查询岗位信息
    public DataView select_position(int department_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select_position", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@d_id", SqlDbType.Int).Value = department_id;
        DataSet ds = new DataSet();
        sda.Fill(ds, "table");
        DataView dv = ds.Tables["table"].DefaultView;
        return dv;
        //con.Close();
    } 

    //读取要编辑的部门信息
    public SqlDataReader ReadDepartment(int d_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select_departmentallInfo", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@d_id", SqlDbType.Int).Value = d_id;
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }  
    }

    //更新部门信息
    public void update_department(ArrayList arr)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_department", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@d_id", SqlDbType.Int).Value = arr[0];
        cmd.Parameters.Add("@d_name", SqlDbType.VarChar, 50).Value = arr[1];
        cmd.Parameters.Add("@d_content", SqlDbType.Text).Value = arr[2];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   

    }
    //删除部门信息
    public void delete_department(int d_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("del_department", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@d_id", SqlDbType.Int).Value = d_id;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   
    }

    //根据部分名称查询部门ID号
    public string   Sel_departmentName(string d_name)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("sel_departmentname", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@d_name", SqlDbType.VarChar, 50).Value = d_name;
        try
        {
            string d_id = cmd.ExecuteScalar().ToString();
            return d_id;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }  
    }
    ///读取要编辑的职位信息
    public SqlDataReader ReadPosition(int p_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("read_position", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@p_id", SqlDbType.Int).Value = p_id;
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }


    //更新职位的信息
    public void update_position(ArrayList arr)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_position", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@p_id", SqlDbType.Int).Value = arr[0];
        cmd.Parameters.Add("@p_name", SqlDbType.VarChar, 50).Value = arr[1];
        cmd.Parameters.Add("@d_content", SqlDbType.Text).Value = arr[2];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   
    }

    //删除职位信息
    public void delete_position(int p_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("delete_position", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@p_id", SqlDbType.Int).Value = p_id;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }   
    }

}