cancelreq.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_CancelReq : System.Web.UI.Page
{


    protected void Page_Load(object sender, EventArgs e)
    {


        if (!Page.IsPostBack)
        {
            //string strsql="select * from 员工请假表 where 员工编号='" + Session["EmployeeID"].ToString() + "'";
            //DataSet ds = new DataSet();
            //string a = GridView1.DataKeys[GridView1.SelectedIndex].Value.ToString();
            //Response.Write(a);


            string strsql = "select * from 员工请假表 where 员工编号='" + Session["EmployeeID"].ToString() + "' and 申请状态='已提交'";
            SqlConnection conn = db.mysqll();
            SqlCommand cmd = new SqlCommand(strsql, conn);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
            da.Fill(ds, "请假申请编号");
            grdResult.DataSource = ds.Tables["请假申请编号"];
            grdResult.DataBind();
            //    SqlDataReader rd3;


            //    conn.Open();
            //    SqlCommand cmd = new SqlCommand(strsql, conn);





            //    rd3 = cmd.ExecuteReader();
            //    rd3.Read();
            //    if (rd3.Read())
            //    {
            //        rd3.Close();
            //        try
            //        {
            //            string strselect = "select * from 员工请假表 where 请假申请编号='" + Request.QueryString["请假申请编号"].ToString().Trim() + "'";
            //            SqlDataReader rd4;
            //            cmd.CommandText = strselect;

            //            rd4 = cmd.ExecuteReader();
            //            if (rd4.Read())
            //            {
            //                lblReason.Text = rd4["理由说明"].ToString();
            //            }
            //        }
            //        catch
            //        {
            //            lblReason.Text = "";
            //        }

            //    }
            //    else
            //    {
            //        rd3.Close();
            //        grdResult.Visible = false;
            //        lblMessage.Text = "没有相关信息";
            //    }
        }

    }







    protected void Header1_Load(object sender, EventArgs e)
    {

    }
    protected void btnYes_Click(object sender, EventArgs e)
    {
        string comStr = "delete from 员工请假表 where 请假申请编号='" + grdResult.DataKeyField[grdResult.SelectedIndex].ToString() + "'";

        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(comStr, conn);


        Response.Write("<script>alert(\"取消成功！\");</script>");
        grdResult.DataBind();
        conn.Close();

    }
    protected void btnNo_Click(object sender, EventArgs e)
    {
        pnlMakeSure.Visible = false;
    }

    protected void grdResult_SelectedIndexChanged(object sender, EventArgs e)
    {


    }
    protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.CommandName == "Cancel")
        {
            pnlMakeSure.Visible = true;


        }
        if (e.CommandName == "Detail")
        {
            lblApproverName.Text = "";
            lblReason.Text = "";
            //int qjbh = Convert .ToInt32 ( grdResult.SelectedIndex .ToString ());
            int qjbh = Convert.ToInt32(e.Item.Cells[0].Text);

            string strsql2 = " select * from 员工请假表　where 请假申请编号＝'" + qjbh + "'";
            SqlConnection conn = db.mysqll();
            conn.Open();
            SqlCommand cmd = new SqlCommand(strsql2, conn);
            SqlDataReader rd = cmd.ExecuteReader();
            rd.Read();
            if (rd.Read())
            {
                lblReason.Text = rd["理由说明"].ToString();
                int shenhbh = (int)rd["审核者编号"];
                string shh = "select 员工姓名 from 员工表 where 员工编号='" + shenhbh + "'";
                cmd.CommandText = shh;
                lblApproverName.Text = (string)cmd.ExecuteScalar();
                cmd.Dispose();



            }

            //string strsql = "select * from 员工请假表 where 员工编号='" + Session["EmployeeID"].ToString() + "' and 申请状态='已提交'";
            ////SqlConnection conn = db.mysqll();
            //////SqlDataReader rd3;


            ////conn.Open();
            ////SqlCommand cmd = new SqlCommand(strsql, conn);





            //rd3 = cmd.ExecuteReader();
            //rd3.Read();
            //if (rd3.Read())
            //{
            //    rd3.Close();
            //    try
            //    {
            //        int qj = Convert.ToInt32(grdResult.SelectedIndex.ToString());
            //        string strselect = "select * from 员工请假表 where 请假申请编号='" +grdResult .SelectedIndex .ToString ()  + "'";
            //        SqlDataReader rd4;
            //        cmd.CommandText = strselect;

            //        rd4 = cmd.ExecuteReader();
            //        if (rd4.Read())
            //        {
            //            lblReason.Text = rd4["理由说明"].ToString();
            //            int shenhbh = (int)rd4["审核者编号"];
            //            string shh = "select 员工姓名 from 员工表 where 员工编号='"+ shenhbh +"'";
            //            cmd.CommandText = shh;
            //            lblApproverName.Text =(string ) cmd.ExecuteScalar();
            //            cmd.Dispose();

            //        }
            //    }
            //    catch
            //    {
            //        lblReason.Text = "";
            //    }

            //}
            else
            {
                //rd3.Close();
                grdResult.Visible = false;
                lblMessage.Text = "没有相关信息";
                pnlDetail.Visible = false;
            }




        }

    }
}