login.aspx.cs

考勤系统

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.OleDb;

namespace KaoQin
{
	/******************************
	*       用户考勤窗体          *
	*****************************/
	public class login : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label labId;
		protected System.Web.UI.WebControls.DropDownList ddId;
		protected System.Web.UI.WebControls.Label labName;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.Button btnBingJia;
		protected System.Web.UI.WebControls.Button btnShiJia;
		protected System.Web.UI.WebControls.Label info;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox txtPwd;
		protected System.Data.OleDb.OleDbDataReader reader;
		protected System.Web.UI.WebControls.Button btnKuangGong;
		protected System.Data.OleDb.OleDbConnection con;
		protected System.Data.OleDb.OleDbCommand com;
		protected System.Data.OleDb.OleDbDataAdapter da;
		protected System.Web.UI.WebControls.Button btnShangBan;
		protected System.Web.UI.WebControls.Button btnXiaBan;
		protected System.Data.DataSet ds;
	
		/*****************************
		 *   当加载页面时执行此方法  *
		 * ***************************/
		private void Page_Load(object sender, System.EventArgs e)
		{
			string strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("message.mdb")+";User Id=admin;Password=;";
			con=new OleDbConnection(strcon);	
			if(!IsPostBack)
			{
				con.Open();
				com=new OleDbCommand("select id from usermessage",con);
				reader=com.ExecuteReader();
				while(reader.Read())
				{
					ddId.Items.Add(reader.GetString(0));
				}
				reader.Close();
				com.Dispose();
				con.Close();
			}
		}

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

		}
		#endregion

		/*******************************
		 * 当点击上班按钮时执行此方法  *
		 * *****************************/
		private void btnShangBan_Click(object sender, System.EventArgs e)
		{
			string id,name="",selSql,selSql2,selSql3,insertSql,strToday,strTime,strPwd="",strHour,strMinute,strCiDao,strKuangGong;
			string strYear,strMon;
			int count=0;
			id=ddId.SelectedItem.Text.Trim();
			strToday=System.DateTime.Today.ToShortDateString();
			strTime=System.DateTime.Now.ToShortTimeString();
			strHour=System.DateTime.Now.Hour.ToString();
			strMinute=System.DateTime.Now.Minute.ToString();
			strYear=System.DateTime.Now.Year.ToString();
			strMon=System.DateTime.Now.Month.ToString();
			selSql="select name from usermessage where id='"+id+"'";
			selSql2="select name from kaoqin where id='"+id+"' and kqdate='"+strToday+"'";
			selSql3="select password from usermessage where id='"+id+"'";
			if(txtName.Text.Equals(""))
			{
				info.Text="请选择用户编号！";
			}
			else
			{
				con.Open();
				com=new OleDbCommand(selSql3,con);
				reader=com.ExecuteReader();
				while(reader.Read())
				{
					strPwd=reader.GetString(0);
				}
				reader.Close();
				com.Dispose();
				con.Close();
				if(txtPwd.Text.Equals(strPwd))
				{
					con.Open();
					com=new OleDbCommand(selSql2,con);
					reader=com.ExecuteReader();
					while(reader.Read())
					{
						count++;
					}
					reader.Close();
					com.Dispose();
					con.Close();
					if(count==0)
					{
						con.Open();
						com=new OleDbCommand(selSql,con);
						reader=com.ExecuteReader();
						while(reader.Read())
						{
							name=reader.GetString(0);
						}
						reader.Close();
						com.Dispose();
						con.Close();
						if(System.Convert.ToInt32(strHour)>9 || (System.Convert.ToInt32(strHour)==9 && System.Convert.ToInt32(strMinute)>0))
						{
							strKuangGong="旷工";
							strCiDao="否";
						}
						else if(System.Convert.ToInt32(strHour)>8 || (System.Convert.ToInt32(strHour)==8 && System.Convert.ToInt32(strMinute)>30))
						{
							strCiDao="迟到";
							strKuangGong="0";
						}
						else
						{
							strKuangGong="0";
							strCiDao="否";
						}
						insertSql="insert into kaoqin values('"+id+"','"+name+"','"+strToday+"','"+strTime+"','0','"+strCiDao+"',' ',' ',' ','"+strKuangGong+"','"+strYear+"','"+strMon+"')";
						con.Open();
						com=new OleDbCommand(insertSql,con);
						com.ExecuteNonQuery();
						com.Dispose();
						con.Close();
						info.Text="考勤成功！";
					}
					else
					{
						info.Text="系统已经记录您的考勤信息，不能重新记录！";
					}
				}
				else
				{
					info.Text="用户密码错误！";
				}
			}
			con.Close();
		}

		/***************************************
		 * 当点击用户编号下拉菜单时执行此方法  *
		 * *************************************/
		private void ddId_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string id,selSql,name="";
			id=ddId.SelectedItem.Text;
			selSql="select name from usermessage where id='"+id+"'";
			con.Open();
			com=new OleDbCommand(selSql,con);
			reader=com.ExecuteReader();
			while(reader.Read())
			{
				name=reader.GetString(0);
			}
			reader.Close();
			com.Dispose();
			con.Close();
			txtName.Text=name;
		}

		/******************************
		 * 当点击下班按钮时执行此方法 *
		 * ****************************/
		private void btnXiaBan_Click(object sender, System.EventArgs e)
		{
			string id,selSql,selSql2,selSql3,selSql4,selSql5,strPwd="",insertSql,strToday,strTime,strHour,strMinute,strZaoTui,strKuangGong;
			int count=0,count2=0,count3=0,count4=0;
			id=ddId.SelectedItem.Text.Trim();
			strToday=System.DateTime.Today.ToShortDateString();
			strTime=System.DateTime.Now.ToShortTimeString();
			strHour=System.DateTime.Now.Hour.ToString();
			strMinute=System.DateTime.Now.Minute.ToString();
			selSql="select name from kaoqin where id='"+id+"' and kqdate='"+strToday+"' and lgdate='0'";
			selSql2="select name from kaoqin where id='"+id+"' and kqdate='"+strToday+"'";
			selSql3="select password from usermessage where id='"+id+"'";
			selSql4="select name from kaoqin where id='"+id+"' and dgdate='0' and kqdate='"+strToday+"'";
			selSql5="select name from kaoqin where id='"+id+"' and kg='旷工'";
			if(txtName.Text.Equals(""))
			{
				info.Text="请选择用户编号！";
			}
			else
			{
				con.Open();
				com=new OleDbCommand(selSql3,con);
				reader=com.ExecuteReader();
				while(reader.Read())
				{
					strPwd=reader.GetString(0);
				}
				reader.Close();
				com.Dispose();
				con.Close();
				if(txtPwd.Text.Equals(strPwd))
				{
					con.Open();
					com=new OleDbCommand(selSql4,con);
					reader=com.ExecuteReader();
					while(reader.Read())
					{
						count3++;
					}
					reader.Close();
					com.Dispose();
					con.Close();
					if(count3!=0)
					{
						info.Text="系统没有记录您今天的上班信息，因此不能记录您的下班信息！";
					}
					else
					{
						con.Open();
						com=new OleDbCommand(selSql2,con);
						reader=com.ExecuteReader();
						while(reader.Read())
						{
							count2++;
						}
						reader.Close();
						com.Dispose();
						con.Close();
						if(count2==0)
						{
							info.Text="系统没有记录您今天的上班信息，因此不能记录您的下班信息！";
						}
						else
						{
							con.Open();
							com=new OleDbCommand(selSql,con);
							reader=com.ExecuteReader();
							while(reader.Read())