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 Attendance_Summary : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            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())
            {
                txtStartTime.Text = DateTime.Now.AddMonths(-1).Date.ToString();
                txtEndTime.Text = DateTime.Now.AddDays(1).Date.ToString();
                pnlOption.Visible = true;

                if (Dr["员工职位名称"].ToString() == "总经理")
                {
                    Dr.Close();
                    pnlChooseDept.Visible = true;
                    string str = "select 部门名称 from  部门表 ";
                    SqlDataReader rdd;
                    cmd.CommandText = str;
                    rdd = cmd.ExecuteReader();
                     
                    while (rdd.Read())
                    {
                        cmbDeptList.Items.Add(rdd[0].ToString());
                    }

                }
                else
                {
                    Session["bum"] = Dr["部门名称"].ToString();
                    Dr.Close();

                }

            }
            else
            {
                pnlChooseDept.Visible = false;
                pnlOption.Visible = false;
                Dr.Close();
                
                lblMessage.Text = "对不起，该页属经理专用，请退出";
            }



        }
    }
    private void bind(string sql)
    {
        SqlDataAdapter da;

        SqlConnection conn = db.mysqll();
        conn.Open();

        DataSet ds = new DataSet();
        da = new SqlDataAdapter(sql,conn);

        da.Fill(ds, "员工编号");

        grdResult.DataSource = ds.Tables["员工编号"];
        
        grdResult.DataBind();

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

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        try
        {
            if (cmbDeptList.Visible)
            {
                string strsql = "select * from 查看员工考勤情况  where 部门名称='" + cmbDeptList.SelectedValue.ToString() + "' order by " + rdoTypeList.SelectedValue.ToString() + "  " + rdoAscendList.SelectedValue.ToString();


                bind(strsql);
            }
            else
            {

                string strsql = "select * from 查看员工考勤情况  where 部门名称='" + Session["bum"].ToString() + "' order by " + rdoTypeList.SelectedValue.ToString() + "  " + rdoAscendList.SelectedValue.ToString();
                bind(strsql);
            }
        }
        catch { return; }
    }
    protected void txtStartTime_TextChanged(object sender, EventArgs e)
    {

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

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

    }
    protected void grdResult_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strsql = "select * from 查看员工考勤情况 where 员工编号='" + grdResult.DataKeyField [grdResult.SelectedIndex].ToString() + "' ";
        SqlDataReader dr;
        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql ,conn);
        dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            Response.Redirect("ShowAttendDetail.aspx?id=" + grdResult.DataKeyField [grdResult.SelectedIndex].ToString());


        }
        else
        {
            Response.Write("<script>alert(\"该人在这段时间内没有缺勤！\");</script>");

        }


    }
}