checkotreq.aspx.cs

人事管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace BlueHill.CheckOvertime
{
    /// <summary>
    /// CheckOTReq 的摘要说明。
    /// </summary>
    public partial class CheckOTReq : System.Web.UI.Page
    {
        protected void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if (!IsPostBack)
            {
                if (Session["EmployeeID"].ToString() == null)
                {
                    lblMessage.Text = "登录信息丢失，请重新登录！";
                    lblMessage.Visible = true;
                    return;
                }
                string ygzc = "";
                string strsql = "select * from 员工表  where 员工编号='" + Session["EmployeeID"].ToString() + "'and 员工职位名称 like '%经理' ";
                SqlDataReader rd;
                SqlConnection conn = db.mysqll();
                conn.Open();
                SqlCommand cmd = new SqlCommand(strsql, conn);
                rd = cmd.ExecuteReader();
             
                if (rd.Read())
                {
                     

                    ygzc = rd["员工职位名称"].ToString();
                    Label1.Text = ygzc;

                }
                else
                {
                    lblMessage.Text = "对不起，该网页属经理专用，请退出！";
                    lblMessage.Visible = true;
                    return;
                }
               

                rd.Close();





                conn.Close();

                RefreshPage();

                return;
            }


        }
        void RefreshPage()
        {



            string strsql = "select * from  员工加班表 where 审核者编号 ='" + Session["EmployeeID"].ToString() + "' and 申请状态='已提交'";
            SqlDataAdapter da;

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

            DataSet dsResult = new DataSet();

            da = new SqlDataAdapter(strsql, conn);
            da.Fill(dsResult, "加班申请编号");




            if (dsResult.Tables[0].Rows.Count > 0)
            {
                //找到了要审批的记录，则以 DataGrid 的形式显示结果。
                grdResult.DataSource = dsResult.Tables[0];
                grdResult.DataBind();
                grdResult.Visible = true;
            }
            else
            {
                grdResult.Visible = false;
                //没有找到任何记录，则显示提示信息。
                lblMessage.Text = "没有要审批的记录！";
                lblMessage.Visible = true;
            }
        }



        #region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
        }
        #endregion
        protected void btnOK_Click(object sender, EventArgs e)
        {
            int iOTID;
            int iRetValue;
            string strDenyReason;
            strDenyReason = txtDenyReason.Text.Trim();
            if (strDenyReason == "")
            {
                Response.Write("<script>alert('否决理由不能为空!')</script>");
                return;
            }
            else
            {

                //获取用户单击的记录所对应的记录编号。
                iOTID = int.Parse(lblOTID.Text);
                string strupdate = "update 员工加班表 set 申请状态='已否决',拒绝申请的理由='" + strDenyReason + "' where 加班申请编号='" + iOTID + "'";

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

                iRetValue = cmd.ExecuteNonQuery();
                if (iRetValue > 0)
                {

                    Response.Write("<script>alert('否决成功!')</script>");

                    RefreshPage();
                }
                else
                {
                    lblMessage.Text = "对不起，提交失败！";
                    lblMessage.Visible = true;
                }
                pnlDenyReason.Visible = false;
            }
        }
        protected void btnCancel_Click(object sender, EventArgs e)
        {
            pnlDenyReason.Visible = false;
        }
        protected void grdResult_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
        protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
        {
            if ( e.CommandName == "Detail" ) 
			{

				//获取用户单击的记录所对应的加班事由信息。
				lblReason.Text = e.Item.Cells[11].Text;
				pnlDetail.Visible = true;
				pnlDenyReason.Visible = false;
			}

			//判断用户是否单击了“否决”按钮。
			if ( e.CommandName == "Deny" )
			{

				//获取用户单击的记录所对应的记录编号。
				lblOTID.Text = e.Item.Cells[0].Text;
				txtDenyReason.Text = "";
				pnlDenyReason.Visible = true;
				pnlDetail.Visible = false;

			}


			//判断用户是否单击了“批准”按钮。
			if ( e.CommandName == "Approve" )
			{
                int iOTID;
                int iRetValue;

                //获取用户单击的记录所对应的记录编号。
                iOTID = int.Parse(e.Item.Cells[0].Text);
                string strupdate = "update 员工加班表 set 申请状态='已批准' where 加班申请编号='" + iOTID + "'";
                SqlConnection conn=db.mysqll ();
                conn.Open ();
                SqlCommand cmd=new SqlCommand (strupdate,conn);

                iRetValue = cmd.ExecuteNonQuery();
                if(iRetValue>0)
                {

                    Response.Write("<script>alert('批准成功!')</script>");

                     RefreshPage();
                }
                else
                {
                 lblMessage.Text = "对不起，提交失败！";
                    lblMessage.Visible = true;
                }
        }
}
    }
}