checkattendance.aspx.cs

ASP C#代码实例 适合初学人士学习使用

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using OfficeAuto.Components;

namespace OfficeAuto.DesktopModules.WorkAttendance
{
	/// <summary>
	/// CheckAttendance 的摘要说明。
	/// </summary>
	public class CheckAttendance : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.CompareValidator cvdate;
		protected System.Web.UI.WebControls.RadioButton rbtnthisweek;
		protected System.Web.UI.WebControls.RadioButton rbtnthismonth;
		protected System.Web.UI.WebControls.TextBox Begintime;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfB;
		protected System.Web.UI.WebControls.TextBox Endtime;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfE;
		protected System.Web.UI.WebControls.ListBox StaffList;
		protected System.Web.UI.WebControls.ValidationSummary vsMessage;
		protected System.Web.UI.WebControls.Button SearchBtn;
		protected System.Web.UI.WebControls.DropDownList BoundList;
		protected System.Web.UI.WebControls.DataGrid AttendanceList;
		protected System.Data.DataView dvDuty;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			///判断用户是否登录，否则跳转到登录页面
			if(Session["UserID"] == null)
			{
				Response.Redirect("~/Default.aspx");
			}

			if(!Page.IsPostBack)
			{				
				//绑定两个select框
				DataBindObject(StaffList);
			}			
		}

		private void DataBindObject(object sender)
		{
			StaffDB staff = new StaffDB();
			SqlDataReader dr = staff.GetStaffByOStatus(1);

			((ListBox)sender).DataSource = dr;
			((ListBox)sender).DataTextField = "Realname";
			((ListBox)sender).DataValueField = "Staff_ID";
			((ListBox)sender).DataBind();
			
			dr.Close();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.SearchBtn.Click += new System.EventHandler(this.SearchBtn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void SearchBtn_Click(object sender, System.EventArgs e)
		{
			DataSet ds = new DataSet();

			//得到考勤数据
			DutyTime duty = new DutyTime();
			SqlDataReader recd = duty.GetAttendances(DateTime.Parse(Begintime.Text.Trim()),
				DateTime.Parse(Endtime.Text.Trim()),
				Int32.Parse(StaffList.SelectedValue));

			DataTable dutydb =  SystemTools.ConvertDataReaderToDataTable(recd);	
			ds.Tables.Add(dutydb);
			dvDuty = ds.Tables[0].DefaultView;

			AttendanceList.DataSource = dvDuty;
			AttendanceList.DataBind();
		}

		public string GetGridData(string staffid,int type)
		{
			//type:0 正常 1：迟到 2：早退 3：未考勤 4：总考勤天数
			switch(type)
			{
				case 0:
					dvDuty.RowFilter = "OnDutyStatus = 0 and OffDuty_Status = 0 and staff_id=" + staffid;
					break;
				case 1:
					dvDuty.RowFilter = "OnDutyStatus=1 and staff_id=" + staffid;
					break;
				case 2:
					dvDuty.RowFilter = "OffDutyStatus=1 and staff_id=" + staffid;
					break;
				case 3:
					dvDuty.RowFilter = "staff_id=" + staffid;
					return((dvDuty.Count - dvDuty.Count).ToString());
				case 4:
					break;
			}
			return(dvDuty.Count.ToString());		 
		} 
	}
}