individual.aspx.cs

人事管理系统

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

public partial class web_CheckLeave_Individual : System.Web.UI.Page
{
    int bumb = 0;
    string yg = "";
    protected void Page_Load(object sender, EventArgs e)
    {

        pnlDetail.Visible = false;
        pnlChooseDept.Visible = false;
        cmbEmpList.Visible = false;
        string zhiw = "";
        string strsql = "select * from 员工表 where 员工编号=" + Session["EmployeeID"];

        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql ,conn);
        SqlDataReader rd = cmd.ExecuteReader();
        rd.Read();
        if (rd.Read())
        {
           
            zhiw = rd["职位名称"].ToString();
            bumb = Convert.ToInt32(rd["部门编号"].ToString () );
            rd.Close();
        }
        else { rd.Close(); }
        if (zhiw =="总经理")
        {
            pnlChooseDept.Visible = true;
            cmbEmpList.Visible = true;
            string strsql1 = "select 部门名称 from 部门表 ";
            cmd.CommandText = strsql1;
            SqlDataAdapter da = new SqlDataAdapter(strsql1,conn);
            DataSet ds = new DataSet();
            da.Fill(ds,"部门编号");
            cmbDeptList.DataSource = ds.Tables["部门编号"];
           

        }
        else if (zhiw == "经理")
        {
            string strsql2 = " select 员工姓名 from 员工表 where 员工所属部门编号="+bumb;
            cmd.CommandText = strsql2;
            SqlDataAdapter da = new SqlDataAdapter(strsql2 ,conn);
            DataSet ds = new DataSet();
            da.Fill(ds,"员工编号");
            cmbEmpList.DataSource = ds.Tables["员工编号"];

        
        }
        conn.Close();

    }
    protected void cmbDeptList_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection conn = db.mysqll();
        conn.Open();
       
        string strsql3 = "select 员工姓名 from 查看员工基本信息 where 部门名称='" + cmbDeptList.SelectedValue.ToString() + "'";
        SqlCommand cmd = new SqlCommand(strsql3, conn);
        SqlDataAdapter daa = new SqlDataAdapter(strsql3, conn);
        DataSet dss = new DataSet();
        daa.Fill(dss, "员工");
        cmbEmpList.DataSource = dss.Tables["员工"];
        conn.Close();
    }
    protected void cmbEmpList_SelectedIndexChanged(object sender, EventArgs e)
    {

        yg = cmbDeptList.SelectedValue.ToString();

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        string strsql4 = "select * from 查看员工基本信息 where 部门名称='" + cmbDeptList.SelectedValue.ToString() + "'and 员工姓名='"+yg +"'";
        SqlConnection conn = db.mysqll();
        conn.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(strsql4,conn);
        da.Fill(ds,"员工编号");
        grdResult.DataSource = ds.Tables["员工编号"];
        grdResult.DataBind();
        conn.Close();

    }
    protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        {
            pnlDetail.Visible = true;
            lblApproverName.Text = e.Item.Cells[7].Text.ToString ();

            lblReason.Text = e.Item.Cells[9].Text.ToString();
            lblDenyReason .Text = e.Item.Cells[10].Text.ToString();
        }
    }
}