admintwo.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
{
	/// <summary>
	/// admin2 的摘要说明。
	/// </summary>
	public class admin2 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label labId;
		protected System.Web.UI.WebControls.Button btnSubmit;
		protected System.Web.UI.WebControls.Button btnCancle;
		protected System.Web.UI.WebControls.Button btnKz;
		protected System.Web.UI.WebControls.Button btnJz;
		protected System.Web.UI.WebControls.Button btnLz;
		protected System.Web.UI.WebControls.Calendar dateLz;
		protected System.Web.UI.WebControls.Calendar dateKz;
		protected System.Web.UI.WebControls.Calendar dateJz;
		protected System.Web.UI.WebControls.DropDownList ddBm;
		protected System.Web.UI.WebControls.TextBox txtMemo;
		protected System.Web.UI.WebControls.TextBox txtLz;
		protected System.Web.UI.WebControls.TextBox txtJz;
		protected System.Web.UI.WebControls.TextBox txtKz;
		protected System.Web.UI.WebControls.TextBox txtId;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtAge;
		protected System.Web.UI.WebControls.TextBox txtZw;
		protected System.Web.UI.WebControls.TextBox txtPhone;
		protected System.Web.UI.WebControls.Label labMemo;
		protected System.Web.UI.WebControls.Label labLz;
		protected System.Web.UI.WebControls.Label labJz;
		protected System.Web.UI.WebControls.Label labKz;
		protected System.Web.UI.WebControls.Label labPhone;
		protected System.Web.UI.WebControls.Label labZw;
		protected System.Web.UI.WebControls.Label labBm;
		protected System.Web.UI.WebControls.Label labAge;
		protected System.Web.UI.WebControls.Label labSex;
		protected System.Web.UI.WebControls.Label labName;
		protected System.Data.OleDb.OleDbCommand com;
		protected System.Web.UI.WebControls.DropDownList ddSex;
		protected System.Web.UI.WebControls.Label info;
		protected System.Web.UI.WebControls.Label labTitle;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.Label txtPwd;
		protected System.Web.UI.WebControls.TextBox pwd;
		protected System.Data.OleDb.OleDbDataReader reader;
		protected System.Data.OleDb.OleDbDataReader reader1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Data.OleDb.OleDbConnection con;
		protected System.Data.DataSet ds;
		protected System.Data.OleDb.OleDbDataAdapter da;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(System.Convert.ToString(Session["admin"]).Equals(""))
			{
				Response.Redirect("admin.aspx");
			}
			else
			{
				string strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("message.mdb")+";User Id=admin;Password=;";
				con=new System.Data.OleDb.OleDbConnection(strcon);
				if(!IsPostBack)
				{
					con.Open();
					info.Text="";
					com=new System.Data.OleDb.OleDbCommand("select bName from bumen",con);
					reader=com.ExecuteReader();
					while(reader.Read())
					{
						this.ddBm.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.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
			this.btnCancle.Click += new System.EventHandler(this.btnCancle_Click);
			this.btnKz.Click += new System.EventHandler(this.btnKz_Click);
			this.btnJz.Click += new System.EventHandler(this.btnJz_Click);
			this.btnLz.Click += new System.EventHandler(this.btnLz_Click);
			this.dateLz.SelectionChanged += new System.EventHandler(this.dateLz_SelectionChanged);
			this.dateKz.SelectionChanged += new System.EventHandler(this.dateKz_SelectionChanged);
			this.dateJz.SelectionChanged += new System.EventHandler(this.dateJz_SelectionChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnKz_Click(object sender, System.EventArgs e)
		{
			if(!dateJz.Visible && !dateLz.Visible)
			{
				this.dateKz.Visible=true;
			}
		}

		private void btnJz_Click(object sender, System.EventArgs e)
		{
			if(!dateLz.Visible && !dateKz.Visible)
			{
				this.dateJz.Visible=true;
			}
		}

		private void btnLz_Click(object sender, System.EventArgs e)
		{
			if(!dateKz.Visible && !dateJz.Visible)
			{
				this.dateLz.Visible=true;
			}
		}

		private void dateKz_SelectionChanged(object sender, System.EventArgs e)
		{
			this.txtKz.Text=this.dateKz.SelectedDates[0].ToShortDateString();
			this.dateKz.Visible=false;
		}

		private void dateLz_SelectionChanged(object sender, System.EventArgs e)
		{
			this.txtLz.Text=this.dateLz.SelectedDates[0].ToShortDateString();
			this.dateLz.Visible=false;
		}

		private void dateJz_SelectionChanged(object sender, System.EventArgs e)
		{
			this.txtJz.Text=this.dateJz.SelectedDates[0].ToShortDateString();
			this.dateJz.Visible=false;
		}

		private void btnCancle_Click(object sender, System.EventArgs e)
		{
			QKtxt();
		}

		private void btnSubmit_Click(object sender, System.EventArgs e)
		{
			string insertSql,strMemo,strLz,strPhone;
			if(this.txtId.Text.Trim().Equals(""))
			{
				info.Text="员工编号不能为空!";
			}
			else
			{
				if(this.pwd.Text.Trim().Equals(""))
				{
					info.Text="员工密码不能为空!";
				}
				else
				{
					if(this.txtName.Text.Trim().Equals(""))
					{
						info.Text="员工姓名不能为空!";
					}
					else
					{
						if(this.txtAge.Text.Trim().Equals(""))
						{
							info.Text="员工年龄不能为空!";
						}
						else
						{
							if(this.ddBm.SelectedItem.Text.ToString().Trim().Equals(""))
							{
								info.Text="员工部门不能为空!";
							}
							else
							{
								if(this.txtZw.Text.Trim().Equals(""))
								{
									info.Text="员工职位不能为空!";
								}
								else
								{
									if(this.txtKz.Text.Trim().Equals(""))
									{
										info.Text="开资日期不能为空!";
									}
									else
									{
										if(this.txtJz.Text.Trim().Equals(""))
										{
											info.Text="就职日期不能为空!";
										}
										else
										{
											string sqlstr="select id from usermessage where id='"+txtId.Text.Trim()+"'";
											int intCount=0;
											con.Open();
											com=new System.Data.OleDb.OleDbCommand(sqlstr,con);
											reader1=com.ExecuteReader();
											while(reader1.Read())
											{
												intCount++;
											}
											reader1.Close();
											com.Dispose();
											con.Close();
											if(intCount==0)
											{
												if(txtMemo.Text.Trim().Equals(""))
												{
													strMemo=" ";
												}
												else
												{
													strMemo=txtMemo.Text;
												}
												if(this.txtPhone.Text.Trim().Equals(""))
												{
													strPhone=" ";
												}
												else
												{
													strPhone=txtPhone.Text;
												}
												if(txtLz.Text.Trim().Equals(""))
												{
													strLz=" ";
												}
												else
												{
													strLz=txtLz.Text;
												}
												insertSql="insert into usermessage values('"+txtId.Text+"','"+txtName.Text+"','"+
													ddSex.SelectedItem.Text+"','"+txtAge.Text+"','"+ddBm.SelectedItem.Text+
													"','"+txtZw.Text+"','"+strPhone+"','"+
													txtKz.Text+"','"+txtJz.Text+"','"+strLz+"','"+strMemo+"','"+pwd.Text+"')";
												con.Open();
												com=new System.Data.OleDb.OleDbCommand(insertSql,con);
												com.ExecuteNonQuery();
												QKtxt();
												info.Text="添加信息成功!";	
											}
											else
											{
												info.Text="您添加的职员编号已存在!";
											}
											con.Close();
										}
									}
								}
							}
						}
					}
				}
			}
		}

		/*QKtxt方法用于清空页面的文本框信息*/
		public void QKtxt()
		{
			this.pwd.Text="";
			this.txtAge.Text="";
			this.txtId.Text="";
			this.txtJz.Text="";
			this.txtKz.Text="";
			this.txtLz.Text="";
			this.txtMemo.Text="";
			this.txtName.Text="";
			this.txtPhone.Text="";
			this.txtZw.Text="";
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			txtLz.Text="";
		}
	}
}