upleave.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 DataAccess;

public partial class AskforLeave_UPLeave : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LableName.Text = Session["EmpName"].ToString() + "  欢迎您！";
            LabelHour.Text = Session["shengyuHolidays"].ToString();
        }
    }
    public static int bj1 = 0;
    public static int bj2 = 0;
    public static int levTime = 0;
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        bj1 = 1;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        hours();

    }
    public void hours()
    {
        if (bj1 == 1 && bj2 == 1)
        {
            if (calstratim.SelectedDate.Year % 4 == 0 || calstratim.SelectedDate.Year % 100 == 0)//判断是不是闰年
            {
                levTime = ((calendtime.SelectedDate.Year - calstratim.SelectedDate.Year) * 366 + Convert.ToInt32(calendtime.SelectedDate.DayOfYear) - Convert.ToInt32(calstratim.SelectedDate.DayOfYear)) * 8+ Convert.ToInt32(dropendtime.SelectedValue)- Convert.ToInt32(dropstartime.SelectedValue);
            }
            else
            {
                levTime = ((calendtime.SelectedDate.Year - calstratim.SelectedDate.Year) * 365 + Convert.ToInt32(calendtime.SelectedDate.DayOfYear) - Convert.ToInt32(calstratim.SelectedDate.DayOfYear)) * 8 + Convert.ToInt32(dropendtime.SelectedValue) - Convert.ToInt32(dropstartime.SelectedValue);
            } 
            if (levTime > 0)
            {

                Response.Write("<script>alert('总共请假" + levTime + "小时')</script>");
                levTime = 0;
            }
            else
            {
                Response.Write("<script>alert('你玩我啊！！')</script>");
                levTime = 0;
            }
        }
        else
            Response.Write("<script>alert('请选择日期！！')</script>");
    }
    protected void Calendar2_SelectionChanged(object sender, EventArgs e)
    {
        bj2 = 1;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        int hour = Convert.ToInt32((Convert.ToInt32(calendtime.SelectedDate.DayOfYear) - Convert.ToInt32(calstratim.SelectedDate.DayOfYear)) * 8 + Convert.ToInt32(dropendtime.SelectedValue) - Convert.ToInt32(dropstartime.SelectedValue));
        if (hour > 0&&bj1 == 1 && bj2 == 1)
        {
            DataBase db = new DataBase();
            //用于查询员工ID的
            string cmd = "select EmployeeId from employees where EmpLogin='" + Session["emplogin"] + "'";
            int employeeid = Convert.ToInt32(db.QueryValue(cmd));
            string cmd1 = "insert into Leave(EmployeeId,UpTime,StartTime,EndTime,LeaveFor,Hours,LeaveType) values('" + employeeid + "','" + DateTime.Now + "','" + calstratim.SelectedDate.ToShortDateString() + "  " + dropstartime.SelectedItem.Text + "','" + calendtime.SelectedDate.ToShortDateString() + "  " + dropendtime.SelectedItem + "','" + TxtLeave.Text + "','" + hour + "','以提交')";
            db.QueryExec(cmd1);
            string cmd2 = "update Employees set shengyuHolidays='" + (Convert.ToInt32(LabelHour.Text) -hour) + "'where Employeeid='" + employeeid + "'";
            Session["shengyuHolidays"] = Convert.ToInt32(LabelHour.Text) - hour;//用于更改 Session["shengyuHolidays"]里面的值
            LabelHour.Text = Session["shengyuHolidays"].ToString(); //用于更改 lable里面的值使他是最新的
            
            db.QueryExec(cmd2);
           
            Response.Write("<script>alert('OK！！')</script>");
        }
        else
            Response.Write("<script>alert('时间错误！！')</script>");
    }
    protected void TxtLeave_TextChanged(object sender, EventArgs e)
    {

    }
}