noleave.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;
using System.Data.SqlClient;

public partial class AskforLeave_NoLeave : System.Web.UI.Page
{
    DataBase db = new DataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
            if (grdLeave.Rows.Count == 0)
            {
                Label5.Visible = true;
                Label5.Text = "没有能取消的请假记录！";
            }
        }
    }
    public static string LeaveId1;
    protected void grdLeave_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       //获取GridView中某列的值
        string LeaveId = grdLeave.Rows[e.RowIndex].Cells[0].Text.ToString();
        int lehour=Convert.ToInt32(grdLeave.Rows[e.RowIndex].Cells[3].Text);     
        string cmd = "delete leave where StartTime='" + LeaveId + "' and EmployeeId='"+Session["EmployeeId"]+"'";
        db.QueryExec(cmd);
        string cmd1 = "update Employees set shengyuHolidays='" + (Convert.ToInt32(Session["shengyuHolidays"]) + lehour) + "'where Employeeid='" + Session["EmployeeId"] + "'";
        db.QueryExec(cmd1);
        Session["shengyuHolidays"] = Convert.ToInt32(Session["shengyuHolidays"]) + lehour;
       
        Response.Write("<script>alert('" + LeaveId + "')</script>");
        bind();
    }
    public void bind()
    {
        string cmd = "select * from Leave where EmployeeId='" + Session["EmployeeId"] + "'";
        //DataBase db = new DataBase();
        DataSet ds = db.QueryDataSet(cmd);
        grdLeave.DataSource = ds;
        grdLeave.DataBind();
    }
  
    protected void grdLeave_SelectedIndexChanged(object sender, EventArgs e)
    {
        string LeaveId1 = grdLeave.SelectedRow.Cells[0].Text;
        string cmd = "select EmpName,LeaveFor from Employees,Leave where Employees.EmployeeId=Leave.EmployeeId and Leave.EmployeeId='" + Session["EmployeeId"] + "' and StartTime='" + LeaveId1 + "'";
        String SqlConnectionString = "database=PersonalManagement;server=(local);user id=sa";
        SqlConnection sql = new SqlConnection(SqlConnectionString);
        sql.Open();
        SqlCommand sqlcmd = new SqlCommand(cmd, sql);
        SqlDataReader sqlread = sqlcmd.ExecuteReader();
        if (sqlread.Read())
        {
            Label1.Visible = true;
            Label2.Visible = true;
            Label3.Visible = true;
            Label4.Visible = true;
            Label2.Text = sqlread.GetValue(0).ToString();
            Label4.Text = sqlread.GetValue(1).ToString();
        }
        bind();
    }
}