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_CheckOvertime_Summary : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //如果网页是第一次生成时，执行如下操作：

            //设置界面控件的显示方式。
            grdResult.Visible = false;
            lblMessage.Visible = false;
            pnlChooseDept.Visible = false;
            pnlHeader.Visible = false;
        
           
            int iEmpID;

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

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

            //从数据库中获取员工的其他信息。
           

            
            string StrSelect = "select * from 员工表 where 员工编号='" + Session["EmployeeID"].ToString() + "' and 员工职位名称 like '%经理' ";

            SqlDataReader Dr;
            SqlConnection conn = db.mysqll();
            conn.Open();
            SqlCommand cmd = new SqlCommand(StrSelect, conn);
            Dr = cmd.ExecuteReader();
            if (!Dr.Read())
            {
                lblMessage.Text = "对不起，该网页属经理专用，请退出！";
                lblMessage.Visible = true;
                Dr.Close();
                return;
            }
            else
            {
                //重设界面控件的显示方式。
                pnlHeader.Visible = true;

                //保存部门编号。
                lblDeptID.Text = Dr["员工所属部门编号"].ToString();

                 
                if (Dr["员工职位职位名称"].ToString() == "总经理")
                {
                    pnlChooseDept.Visible = true;

                    DataSet dsDept = new DataSet();



                    Dr.Close();
                     
                    string str = "select 部门编号,部门名称 from  部门表 ";
                    SqlDataAdapter dat;
                    DataSet dst = new DataSet();
                    dat = new SqlDataAdapter(str,conn);
                   
                    dat.Fill(dst);
                    cmbDeptList.DataSource = dst.Tables[0];
                    cmbDeptList.DataTextField = "部门名称";
                    cmbDeptList.DataValueField = "部门编号";
                    cmbDeptList.DataBind();
              

                    lblDeptID.Text = cmbDeptList.SelectedValue.ToString();


                }


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

            }




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

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

    }
}