summary.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_Salary_Summary : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {  
            rdoAscendList.Visible = false;

            txtStartTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy/M/d");

            //设定“结束时间”文本框的显示内容为第二天。
            txtEndTime.Text = DateTime.Now.AddDays(1).ToString("yyyy/M/d");

             


            int iEmpID;

            //检查员工的登录信息是否丢失，是则显示出错信息。
            if (Session["EmployeeID"] == null)
            {
                lblMessage.Text = "登录信息丢失，请重新登录！";
                lblMessage.Visible = true;
                return;
            }

            //获取保存在 Session 中的员工编号信息。
            iEmpID = int.Parse((string)(Session["EmployeeID"]));

         

            int bm=0;
           
             string ygzc = "";
                string strsql = "select * from 员工表  where 员工编号='" + Session["EmployeeID"].ToString() + "'";
                SqlDataReader rd;
                SqlConnection conn = db.mysqll();
                conn.Open();
                SqlCommand cmd = new SqlCommand(strsql, conn);
                rd = cmd.ExecuteReader();
                if (rd.Read())
                {

                    ygzc = rd["员工职位名称"].ToString();
                    bm=(int)rd["员工所属部门编号"];
                }

                rd.Close();
                if (ygzc != "经理" && ygzc !="总经理")
            {
                lblMessage.Text = "对不起，该网页属经理专用，请退出！";
                lblMessage.Visible = true;
                btnSearch.Visible = false;
                pnlOption.Visible = false;
                pnlChooseDept.Visible = false;
                return;
            }

            pnlOption.Visible = true;

            //保存部门编号。
            lblDeptID.Text = bm.ToString ();


            //从数据库中获取总经理的员工编号。
            int iCEOID = 0;
            string strsql1 = "select 员工编号 from 员工表 where  员工职位名称='总经理'";
            cmd.CommandText = strsql1;
            iCEOID = (int)cmd.ExecuteScalar();

            cmd.Dispose();
            if (iEmpID == iCEOID)
            {
                //如果登录用户为总经理，则执行如下操作：

                //显示部门选择下拉框。
                pnlChooseDept.Visible = true;
                string strsql4 = " select  部门名称 from 部门表 ";
               
              cmd.CommandText =strsql4;
                SqlDataReader rdd;

                rdd = cmd.ExecuteReader();

                while (rdd.Read())
                {


                    cmbDeptList.Items.Add(rdd[0].ToString());
                    cmbDeptList.DataBind();
                    cmbDeptList.SelectedIndex = 0;
                }
                lblDeptID.Text = cmbDeptList.SelectedValue.ToString();


                conn.Close();

                //DataSet dsDept = new DataSet();

                ////从数据库中获取所有部门的列表。
                //string st = "select * from 部门表";
                ////where  部门编号 = '" + bm + "'

                //cmd.CommandText = st;
                //SqlDataReader rdd= cmd.ExecuteReader();
                //while (rdd.Read())
                //{


                //    cmbDeptList.Items.Add(rdd[0].ToString());
                //    cmbDeptList.DataBind();
                //    cmbDeptList.SelectedIndex = 0;
                //}
                //SqlDataAdapter da = new SqlDataAdapter(st, conn);
                //da.Fill(dsDept, "部门编号");


                ////用部门列表填充部门选择下拉框。

                //cmbDeptList.DataSource = dsDept.Tables["部门编号"];
                //cmbDeptList.DataTextField = "部门名称";
                //cmbDeptList.DataValueField = "部门编号";
                //cmbDeptList.DataBind();
                //cmbDeptList .Items.Add [dsDept];

                //默认情况下，下拉框选中第一个部门。
                cmbDeptList.SelectedIndex = 0;

                //保存选中部门的编号。
                lblDeptID.Text = cmbDeptList.SelectedValue.ToString();

            }
            else {

                string strsql2 = "select 部门名称 from 部门表 where 部门编号="+bm;
                cmd.CommandText = strsql2;
                string bummc = "";
                bummc = (string )cmd.ExecuteScalar();
                cmbDeptList.Items.Add(bummc);


            }

        }

    }
    protected void chkSort_CheckedChanged(object sender, EventArgs e)
    {
        rdoAscendList.Visible = true;
    }
    protected void cmbDeptList_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {


        string strsql = rdoAscendList.SelectedValue;
      string  bmbh = cmbDeptList.DataValueField;
        //[ASC|DESC],排序字段2
        string px = "";
        if (strsql =="1")
        {
            px = "DESC";
        }
        if (strsql=="2") { px = "DESC"; }
        string strsql4 = "select * from 查看员工薪资历史信息 where 部门编号='"+ bmbh +"' 基本工资 '"+px+"'" ;
        SqlConnection conn = db.mysqll();
        conn.Open();
        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand(strsql4 ,conn);
        SqlDataAdapter da = new SqlDataAdapter(strsql4 ,conn);
        da.Fill(ds,"薪资编号");

        if (ds.Tables[0].Rows.Count > 0)
        {

            grdResult.DataSource = ds.Tables["薪资编号"];

        }
        else {

            lblMessage.Text = "没有相关的信息";
        
        
        }




    }
}