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

public partial class web_SubmitOvertime_History : System.Web.UI.Page
{
    string kais = "";
    string jieshu = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        string strsql = "select * from 员工加班表 where 员工编号='" + Session["EmployeeID"].ToString() + "' and 提交时间>'"+kais+"' and 提交时间<'"+jieshu +"'";

        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(strsql ,conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "加班申请编号");
        grdResult.DataSource =ds.Tables["加班申请编号"];
        grdResult.DataBind();





    }
    protected void grdResult_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        { 
        lblApproverName.Text =e.Item .Cells [8].Text .ToString ();
        lblReason.Text = e.Item.Cells[10].Text.ToString();
        lblDenyReason .Text = e.Item.Cells[11].Text.ToString();
        }
    }
}