submitlvreq.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.SubmitLeave
{
	/// <summary>
	/// SubmitLvReq 的摘要说明。
	/// </summary>
	public partial class SubmitLvReq : System.Web.UI.Page
	{
        private ArrayList alHolidayL = new ArrayList(10);
        
        private ArrayList alHolidayR = new ArrayList(10);
	
        
		protected void Page_Load(object sender, System.EventArgs e)
		{
             //在此处放置用户代码以初始化页面
            if (!Page.IsPostBack)
            {
               
				//如果网页是第一次生成时，执行如下操作：
        
				
				//检查员工的登录信息是否丢失，是则显示出错信息。
				if ( Session["EmployeeID"] == null )
				{
					lblErrorMsg.Text = "登录信息丢失，请重新登录！";
					return;
				}
                cldStartDate.SelectedDate = DateTime.Today;
                cldEndDate.SelectedDate = DateTime.Today;
            string strsql1 = "select * from 员工表 where 员工编号='" + Session["EmployeeID"].ToString() + "'";

                string strsql = "select * from 查看员工基本信息  where 员工编号='" + Session["EmployeeID"].ToString() + "'";
                    SqlDataReader rd;
                    SqlConnection conn = db.mysqll();
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(strsql, conn);
                   
                   rd = cmd.ExecuteReader();
                    
                    if (rd.Read())
                    {
                        lblName.Text = rd["员工姓名"].ToString();
                        lblALhours.Text = rd["员工剩余假期"].ToString();
                                         
                    }
                    rd.Close();
                    string strsql2 = "select 员工姓名 from 员工表  where 员工所属部门编号=(select 员工所属部门编号 from 员工表 where  员工编号= '" + Session["EmployeeID"].ToString() + "')  and  员工职位名称='经理 '";
                    cmd.CommandText = strsql2;
                  
                    string bumjl = (string)cmd.ExecuteScalar();
                    cmbApproverList.Items.Add(bumjl);

                    // 在此处放置用户代码以初始化页面
                 

                    cmbApproverList.Items.Add(zongjinli());
                    conn.Close();
            }
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
		}
		#endregion
       
        protected void Calendar1_SelectionChanged(object sender, EventArgs e)
        {

        }
        public string zongjinli()
        {
            string strsql2 = "select * from 员工表 where 员工职位名称='总经理'";
            SqlDataReader rd2;
            SqlConnection conn = db.mysqll();
            conn.Open();
            
            SqlCommand cmd = new SqlCommand(strsql2, conn);
            //cmd.EndExecuteNonQuery();
            rd2 = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            string laozong;
            if (rd2.Read())
            {
                laozong = rd2["员工姓名"].ToString();
                
            }
            else
            {
                laozong = "暂没总经理";
            }
            rd2.Close();
            return laozong;
        }
      
        protected void Header2_Load(object sender, EventArgs e)
        {

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

            TimeSpan time = cldEndDate.SelectedDate - cldStartDate.SelectedDate;
            
            int qj1 = Convert.ToInt32(cmbStartTime.SelectedValue) - 9;
            int qi2 = Convert.ToInt32(cmbEndTime.SelectedValue) - 9;
            int qjxhs;
            if (qj1 > 3) { qj1 = qj1 - 1; }
            if (qi2 > 3) { qi2 = 8 - qi2 + 1; }
            else { qi2 = 8 - qi2; }
            qjxhs = 8 - qj1 - qi2;
            int a = (int)time.TotalDays * 8;
            a = a + qjxhs;

            if (a <= 0)
            {
                lblTotalHours.Text = "起始时间不能晚于结束时间";
            }
            else
            {

                lblTotalHours.Text = "你的请假时间为:" + a.ToString() + "小时";
            }
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {

                int lblTotalHours = Convert.ToInt32(this.Label3.Text);
                TimeSpan time = cldEndDate.SelectedDate - cldStartDate.SelectedDate;
                int qj1 = Convert.ToInt32(cmbStartTime.SelectedValue) - 9;
                int qi2 = Convert.ToInt32(cmbEndTime.SelectedValue) - 9;
                int qjxhs;
                if (qj1 > 3) { qj1 = qj1 - 1; }
                if (qi2 > 3) { qi2 = 8 - qi2 + 1; }
                else { qi2 = 8 - qi2; }
                qjxhs = 8 - qj1 - qi2;
                int a = (int)time.TotalDays * 8;
                a = a + qjxhs;

                if (a < 0)
                {
                    lblTest.Text = "起始时间不能晚于结束时间";
                }
                else
                {


                    if (a > lblTotalHours)
                    {
                        lblTest.Text = "你的剩余假期不足";
                    }
                    else
                    {
                        if (a > 40)
                        {
                            string zjl = zongjinli();
                            if (cmbApproverList.SelectedValue != zjl)
                            {
                                Response.Write("<script>alert(\"因为你的假期超过五天，所以你的审批者必需为总经理！\");</script>");

                            }
                            else
                            {
                                string jlbianhao = "select * from 员工表 where 员工姓名='" + cmbApproverList.SelectedValue + "'";
                                SqlDataReader rd3;
                                SqlConnection conn = db.mysqll();
                                SqlCommand cmd = new SqlCommand(jlbianhao ,conn);
                            rd3= cmd.ExecuteReader(CommandBehavior.CloseConnection);
                            string bumbh;
                                if (rd3.Read())
                                {
                                    jlbianhao = rd3["员工编号"].ToString();
                                    bumbh =rd3["部门编号"].ToString ();

                                }
                                bumbh = rd3["部门编号"].ToString();

                                rd3.Close();
                                int bianhao = Convert.ToInt32(jlbianhao);
                                
                                string Sqlqj = "insert into 员工请假表 (员工编号,提交时间,开始时间,结束时间,理由说明,类型编号,小时数,申请状态,审核者编号,拒绝申请的理由,部门编号) values('" + Session["EmployeeID"].ToString() + "','" + DateTime.Now + "','" + cldStartDate.SelectedDate + "','" + cldEndDate.SelectedDate + "','" + txtReason.Text.ToString() + "','','" + a + "','已提交','" + bianhao + "','','"+bumbh+"')";
                                cmd.CommandText = Sqlqj;
                                //cmd.EndExecuteNonQuery();
                                conn.Close();

                                Response.Write("<script>alert(\"请假申请提交成功！\");</script>");

                            }



                        }
                        


                    }
                }
            }
            catch
            {
                Response.Write("<script>alert(\"请假失败请稍后再试！\");</script>");

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

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

        }
}
}