dailyreport.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_DailyReport : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

           

            lblToday.Text = DateTime.Now.ToString("yyyy/M/d");
            string strsql = " select  部门名称 from 部门表 ";
            SqlConnection conn = db.mysqll();
            conn.Open();
            SqlCommand cmd = new SqlCommand(strsql, conn);
            SqlDataReader rdd;
          
            rdd = cmd.ExecuteReader();

          while (rdd.Read())
            {


                cmbDeptList.Items.Add(rdd[0].ToString());
                cmbDeptList.DataBind();
                cmbDeptList.SelectedIndex = 0;
            }
            lblDeptID.Text = cmbDeptList.SelectedValue.ToString();
             
            
            conn.Close();
             
 

          

       

        }

    }
    protected void bind(string buMen) 
    {
        string strsql = "select * from 查看员工考勤情况 where 员工所属部门编号 =( select 部门编号 from 部门表 where 部门名称='" + buMen + "') and 日期='" + DateTime.Now.Date + "' ";
        SqlDataReader rd;

        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql,conn);
        rd= cmd.ExecuteReader(CommandBehavior.CloseConnection);
        if (rd.Read())
        {
            rd.Close();
            SqlDataAdapter da;
        da  = new SqlDataAdapter(strsql,conn);      
            DataSet ds = new DataSet();
            da.Fill(ds, "考勤编号");
            grdResult.DataSource = ds.Tables[0];
             
        }
        else
        {
            rd.Close();
           
          
        
        }
        grdResult.DataBind();

     
    }



   
    protected void btnSearch_Click(object sender, EventArgs e)
    {

        string buM = cmbDeptList.SelectedValue.ToString();
        bind(buM);
    }
    protected void grdResult_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void cmbDeptList_SelectedIndexChanged(object sender, EventArgs e)
    {
        lblDeptID.Text = cmbDeptList.SelectedValue.ToString();
    }
}