kaoqinrizhihistoryframe.cs

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

			this.sqlDataAdapter.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									 new System.Data.Common.DataTableMapping("Table", "KaoQinManager_History", 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.sqlDataAdapter.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM KaoQinManager_History WHERE (编号 = @Original_编号) AND (日期 = @Original_日期 OR @Original_日期 IS NULL AND 日期 IS NULL) AND (早退人数 = @Original_早退人数 OR @Original_早退人数 IS NULL AND 早退人数 IS NULL) AND (时间 = @Original_时间 OR @Original_时间 IS NULL AND 时间 IS NULL) AND (未到人数 = @Original_未到人数 OR @Original_未到人数 IS NULL AND 未到人数 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (请假人数 = @Original_请假人数 OR @Original_请假人数 IS NULL AND 请假人数 IS NULL) AND (迟到人数 = @Original_迟到人数 OR @Original_迟到人数 IS NULL AND 迟到人数 IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_日期", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "日期", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_早退人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "早退人数", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_时间", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "时间", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_未到人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "未到人数", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_请假人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "请假人数", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_迟到人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "迟到人数", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection
			// 
			this.sqlConnection.ConnectionString = "workstation id=localhost;integrated security=SSPI;database=SystemODBC";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO KaoQinManager_History(日期, 时间, 早退人数, 迟到人数, 未到人数, 请假人数, 状态) VALUES (@日期" +
				", @时间, @早退人数, @迟到人数, @未到人数, @请假人数, @状态); SELECT 编号, 日期, 时间, 早退人数, 迟到人数, 未到人数, 请假" +
				"人数, 状态 FROM KaoQinManager_History WHERE (编号 = @@IDENTITY)";
			this.sqlInsertCommand1.Connection = this.sqlConnection;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.VarChar, 50, "日期"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@时间", System.Data.SqlDbType.VarChar, 50, "时间"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@早退人数", System.Data.SqlDbType.VarChar, 50, "早退人数"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@迟到人数", System.Data.SqlDbType.VarChar, 50, "迟到人数"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@未到人数", System.Data.SqlDbType.VarChar, 50, "未到人数"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@请假人数", System.Data.SqlDbType.VarChar, 50, "请假人数"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 50, "状态"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 编号, 日期, 时间, 早退人数, 迟到人数, 未到人数, 请假人数, 状态 FROM KaoQinManager_History";
			this.sqlSelectCommand1.Connection = this.sqlConnection;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE KaoQinManager_History SET 日期 = @日期, 时间 = @时间, 早退人数 = @早退人数, 迟到人数 = @迟到人数, 未到人数 = @未到人数, 请假人数 = @请假人数, 状态 = @状态 WHERE (编号 = @Original_编号) AND (日期 = @Original_日期 OR @Original_日期 IS NULL AND 日期 IS NULL) AND (早退人数 = @Original_早退人数 OR @Original_早退人数 IS NULL AND 早退人数 IS NULL) AND (时间 = @Original_时间 OR @Original_时间 IS NULL AND 时间 IS NULL) AND (未到人数 = @Original_未到人数 OR @Original_未到人数 IS NULL AND 未到人数 IS NULL) AND (状态 = @Original_状态 OR @Original_状态 IS NULL AND 状态 IS NULL) AND (请假人数 = @Original_请假人数 OR @Original_请假人数 IS NULL AND 请假人数 IS NULL) AND (迟到人数 = @Original_迟到人数 OR @Original_迟到人数 IS NULL AND 迟到人数 IS NULL); SELECT 编号, 日期, 时间, 早退人数, 迟到人数, 未到人数, 请假人数, 状态 FROM KaoQinManager_History WHERE (编号 = @编号)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@日期", System.Data.SqlDbType.VarChar, 50, "日期"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@时间", System.Data.SqlDbType.VarChar, 50, "时间"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@早退人数", System.Data.SqlDbType.VarChar, 50, "早退人数"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@迟到人数", System.Data.SqlDbType.VarChar, 50, "迟到人数"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@未到人数", System.Data.SqlDbType.VarChar, 50, "未到人数"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@请假人数", System.Data.SqlDbType.VarChar, 50, "请假人数"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 50, "状态"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_日期", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "日期", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_早退人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "早退人数", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_时间", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "时间", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_未到人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "未到人数", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_请假人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "请假人数", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_迟到人数", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "迟到人数", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.Int, 4, "编号"));
			// 
			// kaoQinHistorySet
			// 
			this.kaoQinHistorySet.DataSetName = "KaoQinHistorySet";
			this.kaoQinHistorySet.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// KaoQinRiZhiHistoryFrame
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(862, 459);
			this.Name = "KaoQinRiZhiHistoryFrame";
			this.Load += new System.EventHandler(this.KaoQinRiZhiHistoryFrame_Load);
			((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.stStauts)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.stUserOperator)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.stDateText)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.stTimeText)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.stState)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGridSource)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.kaoQinHistorySet)).EndInit();

		}
		#endregion
		#region init Event...
		private void KaoQinRiZhiHistoryFrame_Load(object sender, System.EventArgs e)
		{
			#region 填充DataGrid
			sqlDataAdapter.Fill(kaoQinHistorySet);
			base.dataAdapter=this.sqlDataAdapter;
			base.ds=kaoQinHistorySet;
			base.dataGridSource.DataSource=kaoQinHistorySet.Tables[0];
			base.cmOrders=(System.Windows.Forms.CurrencyManager)BindingContext[kaoQinHistorySet.Tables[0]];
			base.stStauts.Text="所有记录:"+selectCount.selectCount.selectCountStr("select count(*) from KaoQinManager_History","KaoQinManager_History").Trim();
			#endregion
		}
		#endregion
	}
}