frmpunish.cs

环境采用ASP.NET和SQL Server 2000 一款为中小企业量身订做的人力资源管理软件。主要包括以下功能：档案管理、考核管理、工资管理、培训管理、评价管理、合同管理、员工调动、员工离职、员工

			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand2;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand2;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("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.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand2;
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = "SELECT 序号, 职员编号, 惩罚类型, 惩罚金额, 是否计入工资, 惩罚原因, 部门意见, 惩罚日期 FROM 职员惩罚表";
			this.sqlSelectCommand2.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand2
			// 
			this.sqlInsertCommand2.CommandText = "INSERT INTO 职员惩罚表(职员编号, 惩罚类型, 惩罚金额, 是否计入工资, 惩罚原因, 部门意见, 惩罚日期) VALUES (@职员编号, @惩罚类" +
				"型, @惩罚金额, @是否计入工资, @惩罚原因, @部门意见, @惩罚日期); SELECT 序号, 职员编号, 惩罚类型, 惩罚金额, 是否计入工资, 惩罚" +
				"原因, 部门意见, 惩罚日期 FROM 职员惩罚表 WHERE (序号 = @@IDENTITY)";
			this.sqlInsertCommand2.Connection = this.sqlConnection1;
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职员编号", System.Data.SqlDbType.VarChar, 30, "职员编号"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚类型", System.Data.SqlDbType.VarChar, 20, "惩罚类型"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚金额", System.Data.SqlDbType.Float, 8, "惩罚金额"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否计入工资", System.Data.SqlDbType.VarChar, 10, "是否计入工资"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚原因", System.Data.SqlDbType.VarChar, 50, "惩罚原因"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门意见", System.Data.SqlDbType.VarChar, 100, "部门意见"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚日期", System.Data.SqlDbType.Int, 4, "惩罚日期"));
			// 
			// sqlUpdateCommand2
			// 
			this.sqlUpdateCommand2.CommandText = @"UPDATE 职员惩罚表 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_职员编号) AND (部门意见 = @Original_部门意见 OR @Original_部门意见 IS NULL AND 部门意见 IS NULL); SELECT 序号, 职员编号, 惩罚类型, 惩罚金额, 是否计入工资, 惩罚原因, 部门意见, 惩罚日期 FROM 职员惩罚表 WHERE (序号 = @序号)";
			this.sqlUpdateCommand2.Connection = this.sqlConnection1;
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职员编号", System.Data.SqlDbType.VarChar, 30, "职员编号"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚类型", System.Data.SqlDbType.VarChar, 20, "惩罚类型"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚金额", System.Data.SqlDbType.Float, 8, "惩罚金额"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否计入工资", System.Data.SqlDbType.VarChar, 10, "是否计入工资"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚原因", System.Data.SqlDbType.VarChar, 50, "惩罚原因"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@部门意见", System.Data.SqlDbType.VarChar, 100, "部门意见"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@惩罚日期", System.Data.SqlDbType.Int, 4, "惩罚日期"));
			this.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_惩罚类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "惩罚类型", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_惩罚金额", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "惩罚金额", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否计入工资", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否计入工资", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职员编号", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职员编号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门意见", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门意见", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@序号", System.Data.SqlDbType.Int, 4, "序号"));
			// 
			// sqlDeleteCommand2
			// 
			this.sqlDeleteCommand2.CommandText = @"DELETE FROM 职员惩罚表 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_职员编号) AND (部门意见 = @Original_部门意见 OR @Original_部门意见 IS NULL AND 部门意见 IS NULL)";
			this.sqlDeleteCommand2.Connection = this.sqlConnection1;
			this.sqlDeleteCommand2.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.sqlDeleteCommand2.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.sqlDeleteCommand2.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.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_惩罚类型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "惩罚类型", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_惩罚金额", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "惩罚金额", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否计入工资", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否计入工资", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职员编号", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职员编号", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_部门意见", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "部门意见", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=ACER;packet size=4096;integrated security=SSPI;data source=ACER;pe" +
				"rsist security info=False;initial catalog=hrmbook";
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmPunish
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(488, 341);
			this.Controls.Add(this.ToolBar1);
			this.Controls.Add(this.dgdPunishInfo);
			this.Name = "frmPunish";
			this.Text = "职员惩罚管理";
			this.Load += new System.EventHandler(this.frmPunish_Load);
			((System.ComponentModel.ISupportInitialize)(this.dgdPunishInfo)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void frmPunish_Load(object sender, System.EventArgs e)
		{
			SetDataGrid();
		}

		private void SetDataGrid()
		{
			sqlConnection1.ConnectionString = DataBase.sConn;
			sqlDataAdapter1.Fill( dataSet11 );			
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol = new DataGridTextBoxColumn();
			int numCols = dataSet11.Tables[ "职员惩罚表" ].Columns.Count;
			for ( int i = 0; i < numCols; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dataSet11.Tables[ "职员惩罚表" ].Columns[ i ].ColumnName;
				aCol.HeaderText = dataSet11.Tables[ "职员惩罚表" ].Columns[ i ].ColumnName;
				aCol.NullText = "";
				ts.GridColumnStyles.Add( aCol );
			}
			ts.AlternatingBackColor = Color.LightGray;
			ts.AllowSorting = false;
			ts.MappingName = dataSet11.Tables[ "职员惩罚表" ].TableName;
			dgdPunishInfo.TableStyles.Add( ts );
			dgdPunishInfo.DataSource = dataSet11.Tables[ "职员惩罚表" ].DefaultView;
		}

		private void ToolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			// If e.Button Is tbbSave Then
			if ( e.Button == tbbSave )
			{
				int row = dgdPunishInfo.CurrentCell.RowNumber;
				dgdPunishInfo.CurrentCell = new DataGridCell( row + 1, 0 );
				try
				{
					if( dataSet11.HasChanges() )
					{
						sqlDataAdapter1.Update(dataSet11);
						dataSet11.Tables[ "职员惩罚表"].DefaultView.RowFilter = "";
						MessageBox.Show("数据修改成功!");
					}
					else
						MessageBox.Show("无修改的数据!");
				}
				catch ( Exception ex )
				{
					MessageBox.Show( "修改的数据出错" + ex.ToString() );
				}
			}
			else if ( e.Button == tbbDel )
			{
				try
				{
					int iRow= dgdPunishInfo.CurrentRowIndex;
					if ( MessageBox.Show("你确认要删除此条记录吗？", "Confirm", MessageBoxButtons.YesNo) ==  DialogResult.Yes )
					{
						//从职员惩罚表表删除当前被选中记录()
						dataSet11.Tables[ "职员惩罚表"].Rows[ iRow ].Delete();
					}
					else
						return;
					try
					{
						if ( dataSet11.HasChanges() )
						{
							sqlDataAdapter1.Update( dataSet11 );
							dataSet11.Tables[ "职员惩罚表" ].DefaultView.RowFilter = "";
							MessageBox.Show( "数据修改成功!" );
						}
						else
							MessageBox.Show("无修改的数据!");
					}
					catch ( Exception ex )
					{
						MessageBox.Show( "删除数据出错" + ex.ToString() );
					}
				}
				catch ( Exception ex )
				{
					MessageBox.Show("删除数据出错" + ex.ToString() );
				}
			}
		}
	}
}