frmprize.cs

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

			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;
			// 
			// 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";
			// 
			// 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, "奖励日期"));
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = "SELECT 序号, 职员编号, 奖励类型, 奖励金额, 是否计入工资, 奖励原因, 部门意见, 奖励日期 FROM 职员奖励表";
			this.sqlSelectCommand2.Connection = this.sqlConnection1;
			// 
			// 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, "序号"));
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmPrize
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(384, 261);
			this.Controls.Add(this.ToolBar1);
			this.Controls.Add(this.dgdPrizeInfo);
			this.Name = "frmPrize";
			this.Text = "职员奖励管理";
			this.Load += new System.EventHandler(this.frmPrize_Load);
			((System.ComponentModel.ISupportInitialize)(this.dgdPrizeInfo)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

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

		public void SetDataGrid()
		{
			sqlConnection1.ConnectionString = DataBase.sConn;
			sqlDataAdapter1.Fill( dataSet11 );
			// 定义一个DataGridTableStyle
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol;
			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;
			dgdPrizeInfo.TableStyles.Add( ts );
			dgdPrizeInfo.DataSource = dataSet11.Tables[ "职员奖励表" ].DefaultView;
		}

		private void ToolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if ( e.Button == tbbSave )
			{
				int row = dgdPrizeInfo.CurrentCell.RowNumber;
				dgdPrizeInfo.CurrentCell = new DataGridCell( row + 1, 0 );
				try
				{
					// 判断dataSet11的数据是否有变化
					// 即DataGrid控件上是否有数据更改或新增数据
					if ( dataSet11.HasChanges() )
					{
						// 通过sqlDataAdapter1更新数据库数据
						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 row = dgdPrizeInfo.CurrentRowIndex;
					if ( MessageBox.Show( "你要确认烧出此条记录么?","Configrm", MessageBoxButtons.YesNo ) == DialogResult.Yes )
						dataSet11.Tables[ "个人所得税表" ].Rows[ row ].Delete();
					else
						return;
					try
					{
						// 判断dataSet11的数据是否有变化
						// 即DataGrid控件上是否有数据更改或新增数据
						if ( dataSet11.HasChanges() )
						{
							// 通过sqlDataAdapter1更新数据库数据
							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() );
				}
			}
		}
	}
}