daystatictisframe.cs

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

#region 命名空间...
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
#endregion
namespace WindowsApplication
{
	public class DayStatictisFrame : System.Windows.Forms.Form
	{
		#region 控件...
		private CrystalDecisions.Windows.Forms.CrystalReportViewer csReportView;
		private System.Windows.Forms.Label TitleLabel;
		private SqlDataAdapter sqlDataAdapter=null;
		private System.ComponentModel.Container components = null;
		private string strCombobox="";
		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 WindowsApplication.dayStatictisSet dayStatictisSet;
		private System.Data.SqlClient.SqlDataAdapter sqlStatictis;
		private System.Data.SqlClient.SqlConnection sqlConnection;
		private string strDateTime="";
		#endregion
		#region 空的构造函数...
		public DayStatictisFrame()
		{
			InitializeComponent();
		}
		#endregion
		#region 有参数构造函数
		public DayStatictisFrame(string strBox,string strDateTime)
		{
            InitializeComponent();
			this.strCombobox=strBox;
			this.strDateTime=strDateTime;
		}
		#endregion
		#region 清理函数...
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
		#endregion
		#region Windows 窗体设计器生成的代码
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(DayStatictisFrame));
			this.csReportView = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
			this.TitleLabel = new System.Windows.Forms.Label();
			this.sqlStatictis = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection = new System.Data.SqlClient.SqlConnection();
			this.dayStatictisSet = new WindowsApplication.dayStatictisSet();
			((System.ComponentModel.ISupportInitialize)(this.dayStatictisSet)).BeginInit();
			this.SuspendLayout();
			// 
			// csReportView
			// 
			this.csReportView.ActiveViewIndex = -1;
			this.csReportView.BackColor = System.Drawing.Color.White;
			this.csReportView.DisplayGroupTree = false;
			this.csReportView.ForeColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
			this.csReportView.Location = new System.Drawing.Point(0, 40);
			this.csReportView.Name = "csReportView";
			this.csReportView.ReportSource = null;
			this.csReportView.Size = new System.Drawing.Size(856, 456);
			this.csReportView.TabIndex = 0;
			// 
			// TitleLabel
			// 
			this.TitleLabel.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(128)), ((System.Byte)(128)), ((System.Byte)(255)));
			this.TitleLabel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.TitleLabel.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.TitleLabel.ForeColor = System.Drawing.SystemColors.ActiveCaptionText;
			this.TitleLabel.Location = new System.Drawing.Point(0, 0);
			this.TitleLabel.Name = "TitleLabel";
			this.TitleLabel.Size = new System.Drawing.Size(856, 40);
			this.TitleLabel.TabIndex = 1;
			this.TitleLabel.Text = "日考勤统计";
			this.TitleLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// sqlStatictis
			// 
			this.sqlStatictis.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlStatictis.InsertCommand = this.sqlInsertCommand1;
			this.sqlStatictis.SelectCommand = this.sqlSelectCommand1;
			this.sqlStatictis.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								   new System.Data.Common.DataTableMapping("Table", "Day_Statictis_Table", new System.Data.Common.DataColumnMapping[] {
																																																						  new System.Data.Common.DataColumnMapping("编号", "编号"),
																																																						  new System.Data.Common.DataColumnMapping("职工名称", "职工名称"),
																																																						  new System.Data.Common.DataColumnMapping("统计日期", "统计日期"),
																																																						  new System.Data.Common.DataColumnMapping("统计星期", "统计星期"),
																																																						  new System.Data.Common.DataColumnMapping("统计时间", "统计时间"),
																																																						  new System.Data.Common.DataColumnMapping("未到次数", "未到次数"),
																																																						  new System.Data.Common.DataColumnMapping("迟到次数", "迟到次数"),
																																																						  new System.Data.Common.DataColumnMapping("备注", "备注")})});
			this.sqlStatictis.UpdateCommand = this.sqlUpdateCommand1;