history.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 SubmitLeave_History : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            lblMessage.Visible = false;
            string strsql = "select * from 员工请假表 where 员工编号='" + Session["EmployeeID"].ToString() + "'";
            SqlDataReader rd3;
            SqlConnection conn = db.mysqll();
            conn.Open();
            SqlCommand cmd = new SqlCommand(strsql, conn);
            rd3 = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            if (rd3.Read())
            {
                grdResult.Visible = true;
                rd3.Close();




            }
            else
            {
                grdResult.Visible = false;
                rd3.Close();
                pnlDetail.Visible = false;
                lblMessage.Text = "你没有请假记录";
                lblMessage.Visible = true;
            }
            conn.Close();
        }
    }

    protected void btnSearch_Click(object sender, EventArgs e)
    {

        string strselect = "select * from 查看已提交的请假申请信息 where  开始时间 >= '" + txtStartTime.Text.Trim() + "' and 结束时间 <= '" + txtEndTime.Text.Trim() + "' and 员工编号='" + Session["EmployeeID"].ToString() + "'";
        SqlDataReader rd2;
        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strselect, conn);

        rd2 = cmd.ExecuteReader();

        if (rd2.Read())
        {
            grdResult.Visible = true;
            SqlConnection sqlcon = db.mysqll();
            SqlDataAdapter myda = new SqlDataAdapter(strselect, sqlcon);
            DataSet myds = new DataSet();
            sqlcon.Open();
            myda.Fill(myds, "请假申请编号");
            grdResult.DataSource = myds.Tables["请假申请编号"];

            grdResult.DataBind();
            lblMessage.Visible = false;
        }
        else
        {
            lblMessage.Text = "你没有请假记录";
            grdResult.Visible = false;
            pnlDetail.Visible = false;
        }
        rd2.Close();
        conn.Close();
    }
    protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        {
            int qjbh = Convert.ToInt32(e.Item.Cells[0].Text);
            pnlDetail.Visible = true;
            string jtxx = "select * from 员工请假表 where 请假申请编号='" + qjbh + "'";

            SqlDataReader rd5;
            SqlConnection conn = db.mysqll();
            conn.Open();
            SqlCommand cmd = new SqlCommand(jtxx, conn);
            rd5 = cmd.ExecuteReader();

            try
            {

                rd5.Read();


                if (rd5.Read())
                {
                    int bianh;
                    bianh = (int)rd5["审核者编号"];
                    string jlxm = "select 员工姓名 from 员工表 where 员工编号='" + bianh + "'";
                    cmd.CommandText = jlxm;
                    lblApproverName.Text = (string)cmd.ExecuteScalar();


                    lblReason.Text = rd5["理由说明"].ToString();
                    lblDenyReason.Text = rd5["拒绝申请理由"].ToString();
                }
                conn.Close();
            }
            catch
            {
                lblApproverName.Text = "";
                lblReason.Text = "";
                lblDenyReason.Text = "";

            }

        }
        else
        {
            grdResult.Visible = false;

            pnlDetail.Visible = false;
            lblMessage.Text = "你没有请假记录";
        }







    }
}