kaqintongjiframe.cs

独立完成考勤管理软件加打卡系统（C＃） 是打卡加管理系统软件

#region Name Place
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
using System.IO;
#endregion
namespace WindowsApplication
{
	public class kaqintongjiFrame : System.Windows.Forms.Form
	{
		#region Control
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.RadioButton radioToday;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Button btnOk;
		private System.Windows.Forms.Button btnDaoChu;
		private System.Windows.Forms.Button btnCancel;
		private System.Windows.Forms.DateTimePicker EndDateTime;
		private System.Windows.Forms.DateTimePicker startDateTime;
		private System.Windows.Forms.CheckBox chkEvening;
		private System.Windows.Forms.CheckBox chkMiddle;
		private System.Windows.Forms.CheckBox chkMorning;
		private System.Windows.Forms.RadioButton radioWeek;
		private System.Windows.Forms.RadioButton radioLastWeek;
		private System.Windows.Forms.ComboBox emp_NameComboBox;
		private System.Windows.Forms.Button btnMonth;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		private System.Data.SqlClient.SqlConnection sqlConnection;
		private WindowsApplication.KaoQinManagerSet kaoQinManagerSet;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;
		#endregion
		#region Data deFine
		private ConnectionData conn=new ConnectionData();
		#endregion
		#region Function
		public kaqintongjiFrame()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
		#endregion
		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(kaqintongjiFrame));
			this.label1 = new System.Windows.Forms.Label();
			this.radioToday = new System.Windows.Forms.RadioButton();
			this.radioWeek = new System.Windows.Forms.RadioButton();
			this.radioLastWeek = new System.Windows.Forms.RadioButton();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.chkEvening = new System.Windows.Forms.CheckBox();
			this.chkMiddle = new System.Windows.Forms.CheckBox();
			this.chkMorning = new System.Windows.Forms.CheckBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.EndDateTime = new System.Windows.Forms.DateTimePicker();
			this.label3 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.startDateTime = new System.Windows.Forms.DateTimePicker();
			this.label4 = new System.Windows.Forms.Label();
			this.btnOk = new System.Windows.Forms.Button();
			this.btnDaoChu = new System.Windows.Forms.Button();
			this.btnCancel = new System.Windows.Forms.Button();
			this.emp_NameComboBox = new System.Windows.Forms.ComboBox();
			this.btnMonth = new System.Windows.Forms.Button();
			this.sqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection = new System.Data.SqlClient.SqlConnection();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.kaoQinManagerSet = new WindowsApplication.KaoQinManagerSet();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.kaoQinManagerSet)).BeginInit();
			this.SuspendLayout();
			// 
			// label1
			// 
			this.label1.BackColor = System.Drawing.SystemColors.Desktop;
			this.label1.Font = new System.Drawing.Font("宋体", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(0, 0);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(464, 32);
			this.label1.TabIndex = 0;
			this.label1.Text = "考勤统计";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// radioToday
			// 
			this.radioToday.Checked = true;
			this.radioToday.Cursor = System.Windows.Forms.Cursors.Hand;
			this.radioToday.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.radioToday.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.radioToday.ForeColor = System.Drawing.Color.Blue;
			this.radioToday.Location = new System.Drawing.Point(32, 40);
			this.radioToday.Name = "radioToday";
			this.radioToday.Size = new System.Drawing.Size(64, 24);
			this.radioToday.TabIndex = 1;
			this.radioToday.TabStop = true;
			this.radioToday.Text = "今天";
			this.radioToday.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.radioToday.Click += new System.EventHandler(this.radioToday_Click);
			this.radioToday.MouseEnter += new System.EventHandler(this.radioLastWeek_MouseEnter);
			this.radioToday.MouseLeave += new System.EventHandler(this.radioLastWeek_MouseLeave);
			this.radioToday.CheckedChanged += new System.EventHandler(this.radioToday_CheckedChanged);
			// 
			// radioWeek
			// 
			this.radioWeek.Cursor = System.Windows.Forms.Cursors.Hand;
			this.radioWeek.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.radioWeek.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.radioWeek.ForeColor = System.Drawing.Color.Blue;
			this.radioWeek.Location = new System.Drawing.Point(120, 40);
			this.radioWeek.Name = "radioWeek";
			this.radioWeek.Size = new System.Drawing.Size(72, 24);
			this.radioWeek.TabIndex = 2;
			this.radioWeek.Text = "本周";
			this.radioWeek.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.radioWeek.Click += new System.EventHandler(this.radioWeek_Click);
			this.radioWeek.MouseEnter += new System.EventHandler(this.radioLastWeek_MouseEnter);
			this.radioWeek.MouseLeave += new System.EventHandler(this.radioLastWeek_MouseLeave);
			this.radioWeek.CheckedChanged += new System.EventHandler(this.radioWeek_CheckedChanged);
			// 
			// radioLastWeek
			// 
			this.radioLastWeek.Cursor = System.Windows.Forms.Cursors.Hand;
			this.radioLastWeek.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.radioLastWeek.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.radioLastWeek.ForeColor = System.Drawing.Color.Blue;
			this.radioLastWeek.Location = new System.Drawing.Point(208, 40);
			this.radioLastWeek.Name = "radioLastWeek";
			this.radioLastWeek.Size = new System.Drawing.Size(72, 24);
			this.radioLastWeek.TabIndex = 3;
			this.radioLastWeek.Text = "上周";
			this.radioLastWeek.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.radioLastWeek.Click += new System.EventHandler(this.radioLastWeek_Click);
			this.radioLastWeek.MouseEnter += new System.EventHandler(this.radioLastWeek_MouseEnter);
			this.radioLastWeek.MouseLeave += new System.EventHandler(this.radioLastWeek_MouseLeave);
			this.radioLastWeek.CheckedChanged += new System.EventHandler(this.radioLastWeek_CheckedChanged);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.chkEvening);
			this.groupBox1.Controls.Add(this.chkMiddle);
			this.groupBox1.Controls.Add(this.chkMorning);
			this.groupBox1.Cursor = System.Windows.Forms.Cursors.Hand;
			this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.groupBox1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.groupBox1.ForeColor = System.Drawing.Color.Blue;
			this.groupBox1.Location = new System.Drawing.Point(304, 40);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(144, 200);
			this.groupBox1.TabIndex = 4;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "统计数据";
			// 
			// chkEvening
			// 
			this.chkEvening.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.chkEvening.Location = new System.Drawing.Point(40, 152);
			this.chkEvening.Name = "chkEvening";
			this.chkEvening.Size = new System.Drawing.Size(80, 24);
			this.chkEvening.TabIndex = 2;
			this.chkEvening.Text = "下午";
			this.chkEvening.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// chkMiddle
			// 
			this.chkMiddle.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.chkMiddle.Location = new System.Drawing.Point(40, 96);
			this.chkMiddle.Name = "chkMiddle";
			this.chkMiddle.Size = new System.Drawing.Size(80, 24);
			this.chkMiddle.TabIndex = 1;
			this.chkMiddle.Text = "中午";
			this.chkMiddle.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// chkMorning
			// 
			this.chkMorning.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.chkMorning.Location = new System.Drawing.Point(40, 40);
			this.chkMorning.Name = "chkMorning";
			this.chkMorning.Size = new System.Drawing.Size(80, 24);
			this.chkMorning.TabIndex = 0;
			this.chkMorning.Text = "早上";
			this.chkMorning.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.EndDateTime);
			this.groupBox2.Controls.Add(this.label3);
			this.groupBox2.Controls.Add(this.label2);
			this.groupBox2.Controls.Add(this.startDateTime);
			this.groupBox2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.groupBox2.ForeColor = System.Drawing.Color.Blue;
			this.groupBox2.Location = new System.Drawing.Point(16, 72);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(280, 120);
			this.groupBox2.TabIndex = 5;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "统计时间";
			// 
			// EndDateTime
			// 
			this.EndDateTime.CalendarForeColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.EndDateTime.CalendarMonthBackground = System.Drawing.Color.Gray;
			this.EndDateTime.CalendarTitleBackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.EndDateTime.CalendarTitleForeColor = System.Drawing.Color.FromArgb(((System.Byte)(64)), ((System.Byte)(64)), ((System.Byte)(64)));
			this.EndDateTime.CalendarTrailingForeColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.EndDateTime.Cursor = System.Windows.Forms.Cursors.Hand;
			this.EndDateTime.Location = new System.Drawing.Point(120, 72);
			this.EndDateTime.Name = "EndDateTime";
			this.EndDateTime.Size = new System.Drawing.Size(120, 21);
			this.EndDateTime.TabIndex = 8;
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(8, 72);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(88, 23);
			this.label3.TabIndex = 7;
			this.label3.Text = "结束时间:";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(8, 24);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(88, 23);
			this.label2.TabIndex = 6;
			this.label2.Text = "起始时间:";
			this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// startDateTime
			// 
			this.startDateTime.CalendarForeColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.startDateTime.CalendarMonthBackground = System.Drawing.Color.Gray;
			this.startDateTime.CalendarTitleBackColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.startDateTime.CalendarTitleForeColor = System.Drawing.Color.FromArgb(((System.Byte)(64)), ((System.Byte)(64)), ((System.Byte)(64)));
			this.startDateTime.CalendarTrailingForeColor = System.Drawing.Color.FromArgb(((System.Byte)(192)), ((System.Byte)(192)), ((System.Byte)(255)));
			this.startDateTime.Cursor = System.Windows.Forms.Cursors.Hand;
			this.startDateTime.Location = new System.Drawing.Point(120, 24);
			this.startDateTime.Name = "startDateTime";
			this.startDateTime.Size = new System.Drawing.Size(120, 21);
			this.startDateTime.TabIndex = 6;
			// 
			// label4
			// 
			this.label4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label4.ForeColor = System.Drawing.Color.Blue;
			this.label4.Location = new System.Drawing.Point(32, 216);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(88, 23);
			this.label4.TabIndex = 9;
			this.label4.Text = "结束排序:";
			this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// btnOk
			// 
			this.btnOk.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnOk.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnOk.ForeColor = System.Drawing.Color.Blue;
			this.btnOk.Location = new System.Drawing.Point(24, 272);
			this.btnOk.Name = "btnOk";
			this.btnOk.Size = new System.Drawing.Size(96, 24);
			this.btnOk.TabIndex = 11;
			this.btnOk.Text = "统计日考勤(&O)";
			this.btnOk.Click += new System.EventHandler(this.btnOk_Click);
			this.btnOk.MouseEnter += new System.EventHandler(this.btnDaoChu_MouseEnter);
			this.btnOk.MouseLeave += new System.EventHandler(this.btnDaoChu_MouseLeave);
			// 
			// btnDaoChu
			// 
			this.btnDaoChu.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnDaoChu.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.btnDaoChu.ForeColor = System.Drawing.Color.Blue;
			this.btnDaoChu.Location = new System.Drawing.Point(256, 272);