frmtaxinfo.cs

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

				"rsist security info=False;initial catalog=hrmbook";
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmTaxInfo
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(376, 277);
			this.Controls.Add(this.dgdTaxInfo);
			this.Controls.Add(this.ToolBar1);
			this.Name = "frmTaxInfo";
			this.Text = "个人所得税率";
			this.Load += new System.EventHandler(this.frmTaxInfo_Load);
			((System.ComponentModel.ISupportInitialize)(this.dgdTaxInfo)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void frmTaxInfo_Load(object sender, System.EventArgs e)
		{
			try
			{
				// 定义一个DataGridStyle
				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 = "";
					if ( i == 0 || i == 1 )
						aCol.Width = 40;
					ts.GridColumnStyles.Add( aCol );
				}
				ts.AlternatingBackColor = Color.Gray;
				ts.AllowSorting = false;
				dgdTaxInfo.TableStyles.Add( ts );
				sqlConnection1.ConnectionString = DataBase.sConn;
				sqlDataAdapter1.Fill( dataSet11, "个人所得税表" );
				// 设置dgdTaxInfo的数据源
				ts.MappingName = dataSet11.Tables[ "个人所得税表" ].TableName;
				dgdTaxInfo.DataSource = dataSet11.Tables[ "个人所得税表" ].DefaultView;
			}
			catch ( Exception ex )
			{
				MessageBox.Show( ex.ToString() );
			}
		}

		private void ToolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if ( e.Button == tbbSave )
			{
				int row = dgdTaxInfo.CurrentCell.RowNumber;
				dgdTaxInfo.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 = dgdTaxInfo.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() );
				}
			}
		}
	}
}