default.aspx.cs

一套OA系统,使用SQL Server为后台数据库ASP.NET C#语言开发

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 UDS.Components;

namespace UDS.SubModule.WorkAttendance
{
	/// <summary>
	/// _Default 的摘要说明。
	/// </summary>
	public class _Default : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnCheckAttendance;
		protected System.Web.UI.WebControls.Label lblDutyMessage;
		protected System.Web.UI.WebControls.TextBox txtAttendanceMemo;
		protected System.Web.UI.WebControls.DataGrid grdWeekAttendanceData;
		protected System.Web.UI.WebControls.Label lbl_Hour;
		protected System.Web.UI.WebControls.Label lbl_Minute;
		protected System.Web.UI.WebControls.Label lbl_Second;

		private static bool DutyStatus = true;
		protected System.Web.UI.WebControls.Label lbl_Time;//考勤状态 true上班 false下班
		private static int staffid;
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				staffid = Int32.Parse(Request.Cookies["UserID"].Value.Trim());
				//如果用户登陆并迟到
				if(Request.QueryString["notnormal"]!=null)
				{
					if((Request.QueryString["login"]!=null) &&(Request.QueryString["login"].ToString()=="in" ))
					{
						btnCheckAttendance.Text = "上班";
						DutyStatus = true;
						btnCheckAttendance.CommandArgument = "notnormal";
						lblDutyMessage.Text = "上班迟到，请填写理由！";
						txtAttendanceMemo.Visible = true;
					}
					else if((Request.QueryString["login"]!=null) &&(Request.QueryString["login"].ToString()=="out" ))
					{
						btnCheckAttendance.Text = "下班";
						DutyStatus = false;
						btnCheckAttendance.CommandArgument = "notnormal";
						lblDutyMessage.Text = "下班早退，请填写理由！";
						txtAttendanceMemo.Visible = true;
					}
					
				}
				else  //检查用户是否已经考勤
				{
					WA_Duty wd = new WA_Duty(Int32.Parse(Request.Cookies["UserID"].Value.Trim()));
					if(wd.HaveCompletedDuty(DateTime.Now)==0 )
					{
						lblDutyMessage.Text = "你已经完成了今天的考勤！";
						btnCheckAttendance.Visible = false;

					}
					else
					{
						if(!wd.HaveCheckedDuty(DateTime.Now))
						{
							btnCheckAttendance.Text = "上班";
							DutyStatus = true;
						}
						else
						{
							btnCheckAttendance.Text = "下班";
							DutyStatus = false;
						}
					}	
				}
				//显示时间
				lbl_Hour.Text = DateTime.Now.Hour.ToString();
				lbl_Minute.Text = DateTime.Now.Minute.ToString();
				lbl_Second.Text = DateTime.Now.Second.ToString();
				//显示本星期的考勤数据
				GridBind();
			}
			else
			{
				btnCheckAttendance.Text = "正在处理。。。。";
			}
			
		}
		//绑定考勤数据显示grid
		private void GridBind()
		{
			string weekstartdate,weekenddate;
			weekstartdate = weekenddate = DateTime.Now.ToShortDateString();
			switch((int)DateTime.Now.DayOfWeek)
			{
				case 0:
					weekstartdate = DateTime.Now.AddDays(-6).ToShortDateString();
					weekenddate   = DateTime.Now.ToShortDateString();
					break;
				case 1:
					weekstartdate = DateTime.Now.ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(6).ToShortDateString();
					break;
				case 2:
					weekstartdate = DateTime.Now.AddDays(-1).ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(5).ToShortDateString();
					break;
				case 3:
					weekstartdate = DateTime.Now.AddDays(-2).ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(4).ToShortDateString();
					break;
				case 4:
					weekstartdate = DateTime.Now.AddDays(-3).ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(3).ToShortDateString();
					break;
				case 5:
					weekstartdate = DateTime.Now.AddDays(-4).ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(2).ToShortDateString();
					break;
				case 6:
					weekstartdate = DateTime.Now.AddDays(-5).ToShortDateString();
					weekenddate   = DateTime.Now.AddDays(1).ToShortDateString();
					break;
			}

			Database db = new Database();
			SqlDataReader dr;
			SqlParameter[] prams = {
									   db.MakeInParam("@begintime",SqlDbType.DateTime,8,weekstartdate),
									   db.MakeInParam("@endtime",SqlDbType.DateTime,8,weekenddate),
									   db.MakeInParam("@ids",SqlDbType.VarChar,1000,staffid),
									   db.MakeInParam("@idtype",SqlDbType.VarChar,50,"staff")
								   };
			db.RunProc("sp_WA_GetAttendanceData",prams,out dr);
			DataTable table = Tools.ConvertDataReaderToDataTable(dr);
			grdWeekAttendanceData.DataSource = table.DefaultView;
			grdWeekAttendanceData.DataBind();
		}


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

		}
		#endregion

		protected void btnCheckAttendance_Click(object sender, System.EventArgs e)
		{
			try
			{
				WA_Duty wd = new WA_Duty(Int32.Parse(Request.Cookies["UserID"].Value.Trim()));
				//检查当天是否已经完成考勤
				int Duty = wd.HaveCompletedDuty(DateTime.Now);
				if(Duty==0)
				{
					lblDutyMessage.Text = "你已经完成了今天的考勤！";
					btnCheckAttendance.Visible = false;

				}
				else
				{
					//检查是否迟到早退
					if(DutyStatus==true) //上班考勤
					{
						if(((Button)(sender)).CommandArgument.ToString()!="notnormal")
						{
							if(wd.CheckStatus(DutyAction.OnDuty))
							{
								wd.RecordOnDutyData(DateTime.Now,true,"").ToString();
								lblDutyMessage.Text = "正常上班没有迟到。考勤成功！";
								btnCheckAttendance.Visible = false;
								DutyStatus = false;
							}
							else
							{
								lblDutyMessage.Text = "上班迟到，请填写理由！";
								txtAttendanceMemo.Visible = true;
								btnCheckAttendance.Text = "上班";
								btnCheckAttendance.CommandArgument = "notnormal";
							}
						}
						else
						{
							wd.RecordOnDutyData(DateTime.Now,false,txtAttendanceMemo.Text).ToString();
							lblDutyMessage.Text = "上班迟到。考勤成功！";
							txtAttendanceMemo.Visible = false;
							btnCheckAttendance.Visible = false;
							DutyStatus = false;
							btnCheckAttendance.CommandArgument = "";
						}
					}
					else  //下班考勤
					{
						if(((Button)(sender)).CommandArgument.ToString()!="notnormal")
						{
							if(wd.CheckStatus(DutyAction.OffDuty))
							{
								wd.RecordOffDutyData(Duty,DateTime.Now,true,"");
								lblDutyMessage.Text = "正常下班没有早退。考勤成功！";
								btnCheckAttendance.Visible = false;
								DutyStatus = true;
							}
							else
							{
								lblDutyMessage.Text = "下班早退，请填写理由！";
								txtAttendanceMemo.Visible = true;
								btnCheckAttendance.Text = "下班";
								btnCheckAttendance.CommandArgument = "notnormal";
							}
						}
						else
						{
							wd.RecordOffDutyData(Duty,DateTime.Now,false,txtAttendanceMemo.Text);
							lblDutyMessage.Text = "下班早退。考勤成功！";
							txtAttendanceMemo.Visible = false;
							btnCheckAttendance.Visible = false;
							DutyStatus = true;
							btnCheckAttendance.CommandArgument = "";
						}	

					}
				}
				GridBind();
			}
			catch(Exception ex)
			{
				UDS.Components.Error.Log(ex.Message);
				Server.Transfer("../Error.aspx");
			}
			
		}

	}
}