staff.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>
/// staff (员工信息)
/// </summary>
public class staff
{
	public staff()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 添加员工信息
    /// </summary>
    /// <param name="arrstaff">数组，用于保存输入员工的信息</param>
    /// <returns>返回员工的编号</returns>
    public int  Addstaff(ArrayList arrstaff)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("add_staff", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_name", SqlDbType.VarChar, 50).Value = arrstaff[0];
        cmd.Parameters.Add("@s_sex", SqlDbType.VarChar,10).Value = arrstaff[1];
        cmd.Parameters.Add("@s_nation", SqlDbType.VarChar, 20).Value = arrstaff[2];
        cmd.Parameters.Add("@s_birthday", SqlDbType.DateTime).Value = arrstaff[3];
        cmd.Parameters.Add("@s_collage", SqlDbType.VarChar, 100).Value = arrstaff[4];
        cmd.Parameters.Add("@s_edu", SqlDbType.VarChar, 50).Value = arrstaff[5];
        cmd.Parameters.Add("@s_phone", SqlDbType.VarChar, 50).Value = arrstaff[6];
        cmd.Parameters.Add("@s_mobile", SqlDbType.VarChar, 15).Value = arrstaff[7];
        cmd.Parameters.Add("@s_email", SqlDbType.VarChar, 50).Value = arrstaff[8];
        cmd.Parameters.Add("@s_department", SqlDbType.VarChar, 50).Value = arrstaff[9];
        cmd.Parameters.Add("@s_departmentid", SqlDbType.Int).Value = arrstaff[10];
        cmd.Parameters.Add("@s_position", SqlDbType.VarChar, 50).Value = arrstaff[11];
        cmd.Parameters.Add("@s_positionid", SqlDbType.Int).Value = arrstaff[12];
        cmd.Parameters.Add("@s_registerDate", SqlDbType.DateTime).Value = arrstaff[13];
        cmd.Parameters.Add("@s_password",SqlDbType.VarChar,16).Value=arrstaff[14];
        try
        {
            int staff_id = Convert.ToInt32(cmd.ExecuteScalar());
            return staff_id;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }
    }


    //更新员工信息
    public void UpdateStaff(ArrayList ArrUpdate)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_staff", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_name", SqlDbType.VarChar, 50).Value = ArrUpdate[0];
        cmd.Parameters.Add("@s_sex", SqlDbType.VarChar, 10).Value = ArrUpdate[1];
        cmd.Parameters.Add("@s_nation", SqlDbType.VarChar, 20).Value = ArrUpdate[2];
        cmd.Parameters.Add("@s_birthday", SqlDbType.DateTime).Value = ArrUpdate[3];
        cmd.Parameters.Add("@s_collage", SqlDbType.VarChar, 100).Value = ArrUpdate[4];
        cmd.Parameters.Add("@s_edu", SqlDbType.VarChar, 50).Value = ArrUpdate[5];
        cmd.Parameters.Add("@s_phone", SqlDbType.VarChar, 50).Value = ArrUpdate[6];
        cmd.Parameters.Add("@s_mobile", SqlDbType.VarChar, 15).Value = ArrUpdate[7];
        cmd.Parameters.Add("@s_email", SqlDbType.VarChar, 50).Value = ArrUpdate[8];
        cmd.Parameters.Add("@s_department", SqlDbType.VarChar, 50).Value = ArrUpdate[9];
        cmd.Parameters.Add("@s_departmentid", SqlDbType.Int).Value = ArrUpdate[10];
        cmd.Parameters.Add("@s_position", SqlDbType.VarChar, 50).Value = ArrUpdate[11];
        cmd.Parameters.Add("@s_positionid", SqlDbType.Int).Value = ArrUpdate[12];
        cmd.Parameters.Add("@s_status", SqlDbType.Int).Value = ArrUpdate[13];
        cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 50).Value = ArrUpdate[14];
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = ArrUpdate[15];
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
        finally
        {
            con.Close();
        }
    }


    //
    /// <summary>
    /// 员工登录
    /// </summary>
    /// <param name="uname">用户名</param>
    /// <param name="password">密码</param>
    /// <returns>sqldataread对象</returns>
    public SqlDataReader login(int uname,string password)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("login_staff", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = uname;
        cmd.Parameters.Add("@s_password", SqlDbType.VarChar, 16).Value = password;
        SqlDataReader dr = cmd.ExecuteReader();
        return dr;
    }

    //查询员工的所有信息
    public DataView sel_staff()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("sel_staff", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds = new DataSet();
        sda.Fill(ds, "staff");
        DataView dv = ds.Tables["staff"].DefaultView;
        return dv;
    }

    //查询员工的详细信息
    public SqlDataReader sel_staffInfo(int s_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("sel_personInfo", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //
    /// <summary>
    /// 删除用户信息
    /// </summary>
    /// <param name="s_id">员工编号</param>
    public void del_StaffAllInfo(string s_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("del_staff", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    
    /// <summary>
    /// 重设密码
    /// </summary>
    /// <param name="s_id">员工编号</param>
    /// <param name="s_pass">新的密码</param>
    public void set_password(string s_id,string s_pass)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("set_PassWord", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        cmd.Parameters.Add("@s_password", SqlDbType.VarChar, 16).Value = s_pass;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //更改密码
    public void Update_password(string s_id, string s_pass)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("set_PassWord", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        cmd.Parameters.Add("@s_password", SqlDbType.VarChar, 16).Value = s_pass;
        try
        {
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //根据用户选择的条件查询用户信息＝＝＝＝员工编号
    public DataView SelectStaffInfo_id(String CWord)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Sel_staff_id", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_id", SqlDbType.Int).Value = Convert.ToInt32(CWord);
        DataSet ds = new DataSet();
        sda.Fill(ds, "staff");
        DataView dv = ds.Tables["staff"].DefaultView;
        return dv;   
    }
    //根据用户选择的条件查询用户信息＝＝＝＝＝姓名
    public DataView SelectStaffInfo_Name(string CWord)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Sel_Staff_Name", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_name", SqlDbType.VarChar,50).Value = CWord;
        DataSet ds = new DataSet();
        sda.Fill(ds, "staff");
        DataView dv = ds.Tables["staff"].DefaultView;
        return dv;
    }
    //根据用户选择的条件查询用户信息＝＝＝＝＝部门
    public DataView SelectStaffInfo_Department(string CWord)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Sel_Staff_Department", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_department", SqlDbType.VarChar, 50).Value = CWord;
        DataSet ds = new DataSet();
        sda.Fill(ds, "staff");
        DataView dv = ds.Tables["staff"].DefaultView;
        return dv;
    }
    
    //根据部门查询员工信息
    public DataView sel_staffdepartment(string department)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select_departmentstaff", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_department", SqlDbType.VarChar, 50).Value = department;
        DataSet ds = new DataSet();
        sda.Fill(ds, "staff");
        DataView dv = ds.Tables["staff"].DefaultView;
        return dv;
    }

    //查询用户的个人考勤信息
    public DataView SelectAttendance(string s_id,string month)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Select_Attendance", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        sda.SelectCommand.Parameters.Add("@workDate", SqlDbType.VarChar,10).Value = month;
        DataSet ds = new DataSet();
        sda.Fill(ds, "Attendance");
        DataView dv = ds.Tables["Attendance"].DefaultView;
        return dv;
    }

    //查询所有的考勤信息
    public DataView SelectAllAttendance()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("allAttendance", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds = new DataSet();
        sda.Fill(ds, "Attendance");
        DataView dv = ds.Tables["Attendance"].DefaultView;
        return dv;
    }

    //统计旷工早退信息
    public SqlDataReader SelectTotle(string s_id,string month)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("totalMessage", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = s_id;
        cmd.Parameters.Add("@workDate", SqlDbType.VarChar, 10).Value = month;
        SqlDataReader dr = cmd.ExecuteReader();
        return dr;
    }
}