manageattend.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 Attendance_ManageAttend : System.Web.UI.Page
{
  
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            if (Session["EmployeeID"] == null)
            {
                lblMessage.Text = "登录信息丢失，请重新登录！";
                lblMessage.Visible = true;
                return;
            }
            grdResult.Visible = false;
            lblMessage.Visible = false;
            btnAskReview.Visible = false;
            txtStartTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy/M/d");
            txtEndTime.Text = DateTime.Now.AddDays(1).ToString("yyyy/M/d");

           
           
        }
    }
    
    protected void bind()
    {
        string strsql = "select * from 员工考勤表 where 日期 > '" + txtStartTime.Text.Trim() + "' and 日期 < '" + txtEndTime.Text.Trim() + "'and 员工编号='" + Session["EmployeeID"].ToString() + "' ";
        SqlDataAdapter da;
        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql, conn);
      
       
        DataSet myds = new DataSet();
        da = new SqlDataAdapter(strsql, conn);      
        da.Fill(myds, "考勤编号");
        grdResult.DataSource = myds.Tables ["考勤编号"];
        
        grdResult.DataBind();
        if (myds.Tables[0].Rows.Count > 0)
        {
            //找到记录
            grdResult.DataSource = myds.Tables[0];
            grdResult.DataBind();
            grdResult.SelectedIndex = -1;
            btnAskReview.Visible = false;
            grdResult.Visible = true;
            lblMessage.Visible = false;
        }
        else
        {
            //没有找到记录
            lblMessage.Text = "没有找到任何记录！";
            grdResult.Visible = false;
            btnAskReview.Visible = false;
            lblMessage.Visible = true;
            return;
        }
        return;
    }
    protected void btnAskReview_Click(object sender, EventArgs e)
    {
        string strsql = "update 员工考勤表 set 请求重新审核 = 1  where 员工编号=" + Session["EmployeeID"];
        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql ,conn);
        cmd.ExecuteNonQuery();
        if (cmd.ExecuteNonQuery()>0)
        {


            Response.Write("<script>alert(\" 提交成功！\");</script>");
        
        }
        conn.Close();

        
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
       
        bind();
    }
    protected void grdResult_SelectedIndexChanged(object sender, EventArgs e)
    {
        btnAskReview.Visible = true;
    }
    protected void txtStartTime_TextChanged(object sender, EventArgs e)
    {

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

    }
}