submitotreq.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.SubmitOvertime
{
	/// <summary>
	/// SubmitOTReq 的摘要说明。
	/// </summary>
	public partial class SubmitOTReq : System.Web.UI.Page
	{
        protected void Page_Load(object sender, System.EventArgs e)
        {
            if (!IsPostBack)
            {
               
                if (Session["EmployeeID"] == null)
                {
                    lblErrorMsg.Text = "登录信息丢失，请重新登录！";
                    return;
                }


                int iEmpID = int.Parse((string)(Session["EmployeeID"]));

                string strsql = "select * from 员工表 where 员工编号='"+Session["EmployeeID"].ToString ()+"'" ;
                SqlConnection conn=db.mysqll ();
                conn.Open ();
                SqlCommand cmd=new SqlCommand (strsql ,conn);
                SqlDataReader rd=cmd.ExecuteReader ();
               string bmbh="";
                if (rd.Read ()){
                
               lblName.Text = rd["员工姓名"].ToString ();
               bmbh = rd["员工所属部门编号"].ToString();
             
                
                }
                rd.Close();

                
                cldStartDate.SelectedDate = DateTime.Now.AddDays(1.0);

                 
                cldEndDate.SelectedDate = DateTime.Now.AddDays(1.0);
                string strsql3 = "select * from 部门表 where  部门编号= '"+bmbh+"' ";
                cmd.CommandText = strsql3;
                string jlbh = "";
                string jlxm = "";
                SqlDataReader rdd = cmd.ExecuteReader();
                if (rdd.Read())
                {
                    jlbh = rdd["部门经理编号"].ToString();


                }
                else { return; }
                rdd.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 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() + "小时";
            }
        }
        public string zongjinli()
        {
            string strsql2 = "select * from 员工表 where 员工职位名称='总经理'";
            SqlDataReader rd2;
            SqlConnection conn = db.mysqll();
            conn.Open();

            SqlCommand cmd = new SqlCommand(strsql2, conn);
             
            rd2 = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            string laozong;
            if (rd2.Read())
            {
                laozong = rd2["员工姓名"].ToString();
                
            }
            else
            {
                laozong = "暂没总经理";
            }
            rd2.Close();
            return laozong;
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string zs = "";
            string zhs = "";
          zhs =  rdoOptionList.SelectedValue .ToString ();
          if (zhs == "1")
          { zs = "折算成年假"; }
          if (zhs == "2")
          { zs = "折算成津贴"; }

           
            
            
            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 (txtReason.Text == "")
                {
                    lblErrorMsg.Text = "加班事由不能为空";
                    return;
                }


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


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

            }
        }
        
        protected void cldStartDate_SelectionChanged(object sender, EventArgs e)
        {
            if (cldStartDate.SelectedDate.Month + "/" + cldStartDate.SelectedDate.Day == "1/1")
            {

                cldStartDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
              

            }
            else if (cldStartDate.SelectedDate.Month + "/" + cldStartDate.SelectedDate.Day == "3/8")
            {
                cldStartDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }

            else if (cldStartDate.SelectedDate.Month + "/" + cldStartDate.SelectedDate.Day == "5/1")
            {
                cldStartDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }

            else if (cldStartDate.SelectedDate.Month + "/" + cldStartDate.SelectedDate.Day == "10/1")
            {
                cldStartDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }
              

            else
            {
                cldStartDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#00C0C0");
               
        }
            }
        protected void cldEndDate_SelectionChanged(object sender, EventArgs e)
        {
            if (cldEndDate.SelectedDate.Month + "/" + cldEndDate.SelectedDate.Day == "1/1")
            {

                cldEndDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");


            }
            else if (cldEndDate.SelectedDate.Month + "/" + cldEndDate.SelectedDate.Day == "3/8")
            {
                cldEndDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }

            else if (cldEndDate.SelectedDate.Month + "/" + cldEndDate.SelectedDate.Day == "5/1")
            {
                cldEndDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }

            else if (cldEndDate.SelectedDate.Month + "/" + cldEndDate.SelectedDate.Day == "10/1")
            {
                cldEndDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#339933");
            }


            else
            {
                cldEndDate.SelectedDayStyle.BackColor = ColorTranslator.FromHtml("#00C0C0");

            }
        }
}
}