emp_uncomeframe.cs

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

			// 
			// unComeSet
			// 
			this.unComeSet.DataSetName = "UnComeSet";
			this.unComeSet.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Employee_UnCome", 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("状态", "状态")})});
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = "SELECT 编号, 日期, 职工名称, 状态 FROM Employee_UnCome WHERE (日期 LIKE @Param26) AND (状态 LIK" +
				"E @Param25) AND (职工名称 LIKE @Param27)";
			this.sqlSelectCommand2.Connection = this.sqlConnection1;
			this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param25", System.Data.SqlDbType.VarChar, 50, "状态"));
			this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param26", System.Data.SqlDbType.VarChar, 50, "日期"));
			this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param27", System.Data.SqlDbType.VarChar, 50, "职工名称"));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=localhost;integrated security=SSPI;database=SystemODBC";
			// 
			// Emp_UnComeFrame
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(746, 423);
			this.Name = "Emp_UnComeFrame";
			this.Text = "Emp_UnCome";
			this.Load += new System.EventHandler(this.Emp_UnComeFrame_Load);
			((System.ComponentModel.ISupportInitialize)(this.statusZhuangTai)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusText)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.unComeSet)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion
		#region 初始化事件...
		private void Emp_UnComeFrame_Load(object sender, System.EventArgs e)
		{
			#region  初始化 searchUnComeSet
			this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%%";
			this.sqlDataAdapter1.SelectCommand.Parameters[1].Value="%%";
			this.sqlDataAdapter1.SelectCommand.Parameters[2].Value="%%";
			#endregion
			#region 初始化状态栏
			try
			{
				DataTable UncomeTable=new DataTable();
				UncomeTable=selectUnComecount();
				if(UncomeTable.Rows.Count<=0)
				{
					return;
				}
				for(int i=0;i<UncomeTable.Rows.Count;i++)
				{
					try
					{
						base.statusText.Text="今天未到人数:"+UncomeTable.Rows[i][0].ToString().Trim();
						UnComeCount=Int32.Parse(UncomeTable.Rows[i][0].ToString().Trim());
					}
					catch(System.FormatException eles)
					{
						MessageBox.Show(this,eles.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
			}
			catch(Exception ele)
			{
				MessageBox.Show(ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			#endregion
			#region 绑定数据表
			this.sqlDataAdapter1.Fill(this.unComeSet);
			this.sqlDataAdapter.Fill(this.unComeSet);
			DataTable tempUnComeTable=new DataTable();
			tempUnComeTable=this.unComeSet.Tables[0];
			base.dataAdapter=this.sqlDataAdapter;
			base.ds=this.unComeSet;
			base.dataGrid.DataSource=tempUnComeTable;
			base.cmOrders=(System.Windows.Forms.CurrencyManager) BindingContext[tempUnComeTable];
			#endregion
		}
		#endregion
		#region  判断未到次数
		private DataTable selectUnComecount()
		{
			DataTable data=new DataTable();
			try
			{
				string selectStautsSql="select count(状态)状态 from Employee_UnCome where 状态='未到'and 日期 ='"+System.DateTime.Now.ToLongDateString().Trim()+"'";
				data=ExcuteSql(selectStautsSql,"Employee_Late");
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString()," 提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			return data;
		}
		#endregion
		#region DataFunction
		private DataTable ExcuteSql(string strSql,string tableName)
		{
			DataSet dsSet=new DataSet();
			DataTable dsTable=new DataTable();
			ConnectionData conn=new ConnectionData();
			try
			{
				dsSet=conn.ExcuteDataSetResult(strSql,tableName);
				dsTable=dsSet.Tables[0];
			}
			catch(Exception eles)
			{
				MessageBox.Show(this,eles.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			return dsTable;
		}
		#endregion
		#region 绑定数据表
		private DataTable returnUnComeTable()
		{
			DataTable data=new DataTable();
			try
			{
                string selectUnComeStr="select * from Employee_UnCome";
				data=ExcuteSql(selectUnComeStr,"Employee_UnCome");
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			return data;
		}
		#endregion
		#region 加入日统计表中数据...
		private void InsertIntoDayStatictis()
		{
			try
			{
				
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
		#region 查询事件...
		private void btnSearch_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%%";
				this.sqlDataAdapter1.SelectCommand.Parameters[1].Value="%%";
				this.sqlDataAdapter1.SelectCommand.Parameters[2].Value="%%";
				if(this.textSearchA.Text!="")
				{
					this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%"+this.textSearchA.Text+"%";
				}
				if(this.textSearchB.Text!="")
				{
					this.sqlDataAdapter1.SelectCommand.Parameters[1].Value="%"+this.textSearchB.Text+"%";
				}
				if(this.textSearchC.Text!="")
				{
                    this.sqlDataAdapter1.SelectCommand.Parameters[2].Value="%"+this.textSearchC.Text+"%";
				}
				unComeSet.Employee_UnCome.Clear();
				this.sqlDataAdapter1.Fill(unComeSet);
//				base.dataAdapter=this.sqlDataAdapter1;
//				base.ds=this.unComeSet;
				base.dataGrid.DataSource=unComeSet.Tables[0];
			}
			catch(Exception ele)
			{
				MessageBox.Show(this,ele.ToString(),"提示信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		#endregion
	}
}