querypersonnelform.h

这是一个用VC++编写的人事工资管理系统,开发平台为VS2005,是开发企业管理程序的程序员的很好参考!

			this->培训记录DataGridView->AllowUserToDeleteRows = false;
			this->培训记录DataGridView->AllowUserToResizeRows = false;
			this->培训记录DataGridView->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->培训记录DataGridView->BackgroundColor = System::Drawing::SystemColors::ActiveCaption;
			this->培训记录DataGridView->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->培训记录DataGridView->Location = System::Drawing::Point(0, 168);
			this->培训记录DataGridView->MultiSelect = false;
			this->培训记录DataGridView->Name = L"培训记录DataGridView";
			this->培训记录DataGridView->ReadOnly = true;
			this->培训记录DataGridView->RowHeadersVisible = false;
			dataGridViewCellStyle4->BackColor = System::Drawing::Color::Green;
			dataGridViewCellStyle4->ForeColor = System::Drawing::Color::Yellow;
			this->培训记录DataGridView->RowsDefaultCellStyle = dataGridViewCellStyle4;
			this->培训记录DataGridView->RowTemplate->Height = 23;
			this->培训记录DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->培训记录DataGridView->Size = System::Drawing::Size(542, 56);
			this->培训记录DataGridView->TabIndex = 38;
			// 
			// printPreviewDialog1
			// 
			this->printPreviewDialog1->AutoScrollMargin = System::Drawing::Size(0, 0);
			this->printPreviewDialog1->AutoScrollMinSize = System::Drawing::Size(0, 0);
			this->printPreviewDialog1->ClientSize = System::Drawing::Size(400, 300);
			this->printPreviewDialog1->Enabled = true;
			this->printPreviewDialog1->Icon = (cli::safe_cast<System::Drawing::Icon^  >(resources->GetObject(L"printPreviewDialog1.Icon")));
			this->printPreviewDialog1->Name = L"printPreviewDialog1";
			this->printPreviewDialog1->Visible = false;
			// 
			// 奖惩记录DataGridView
			// 
			this->奖惩记录DataGridView->AllowUserToAddRows = false;
			this->奖惩记录DataGridView->AllowUserToDeleteRows = false;
			this->奖惩记录DataGridView->AllowUserToResizeRows = false;
			this->奖惩记录DataGridView->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->奖惩记录DataGridView->BackgroundColor = System::Drawing::SystemColors::ActiveCaption;
			this->奖惩记录DataGridView->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->奖惩记录DataGridView->Location = System::Drawing::Point(0, 280);
			this->奖惩记录DataGridView->MultiSelect = false;
			this->奖惩记录DataGridView->Name = L"奖惩记录DataGridView";
			this->奖惩记录DataGridView->ReadOnly = true;
			this->奖惩记录DataGridView->RowHeadersVisible = false;
			dataGridViewCellStyle5->BackColor = System::Drawing::Color::Green;
			dataGridViewCellStyle5->ForeColor = System::Drawing::Color::Yellow;
			this->奖惩记录DataGridView->RowsDefaultCellStyle = dataGridViewCellStyle5;
			this->奖惩记录DataGridView->RowTemplate->Height = 23;
			this->奖惩记录DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->奖惩记录DataGridView->Size = System::Drawing::Size(542, 56);
			this->奖惩记录DataGridView->TabIndex = 40;
			// 
			// 查询ToolStripButton
			// 
			this->查询ToolStripButton->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"查询ToolStripButton.Image")));
			this->查询ToolStripButton->ImageTransparentColor = System::Drawing::Color::Magenta;
			this->查询ToolStripButton->Name = L"查询ToolStripButton";
			this->查询ToolStripButton->Size = System::Drawing::Size(121, 22);
			this->查询ToolStripButton->Text = L"查询员工人事档案";
			this->查询ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPersonnelForm::查询ToolStripButton_Click);
			// 
			// 姓名ToolStripTextBox
			// 
			this->姓名ToolStripTextBox->Name = L"姓名ToolStripTextBox";
			this->姓名ToolStripTextBox->Size = System::Drawing::Size(60, 25);
			this->姓名ToolStripTextBox->Text = L"%%";
			// 
			// toolStripLabel1
			// 
			this->toolStripLabel1->Name = L"toolStripLabel1";
			this->toolStripLabel1->Size = System::Drawing::Size(95, 22);
			this->toolStripLabel1->Text = L"请输入员工姓名:";
			// 
			// 家庭成员DataGridView
			// 
			this->家庭成员DataGridView->AllowUserToAddRows = false;
			this->家庭成员DataGridView->AllowUserToDeleteRows = false;
			this->家庭成员DataGridView->AllowUserToResizeRows = false;
			this->家庭成员DataGridView->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->家庭成员DataGridView->BackgroundColor = System::Drawing::SystemColors::ActiveCaption;
			this->家庭成员DataGridView->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->家庭成员DataGridView->Location = System::Drawing::Point(0, 95);
			this->家庭成员DataGridView->MultiSelect = false;
			this->家庭成员DataGridView->Name = L"家庭成员DataGridView";
			this->家庭成员DataGridView->ReadOnly = true;
			this->家庭成员DataGridView->RowHeadersVisible = false;
			dataGridViewCellStyle6->BackColor = System::Drawing::Color::Green;
			dataGridViewCellStyle6->ForeColor = System::Drawing::Color::Yellow;
			this->家庭成员DataGridView->RowsDefaultCellStyle = dataGridViewCellStyle6;
			this->家庭成员DataGridView->RowTemplate->Height = 23;
			this->家庭成员DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->家庭成员DataGridView->Size = System::Drawing::Size(542, 75);
			this->家庭成员DataGridView->TabIndex = 37;
			// 
			// toolStrip1
			// 
			this->toolStrip1->Items->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^  >(4) {this->toolStripLabel1, 
				this->姓名ToolStripTextBox, this->查询ToolStripButton, this->打印基本档案ToolStripButton});
			this->toolStrip1->Location = System::Drawing::Point(0, 0);
			this->toolStrip1->Name = L"toolStrip1";
			this->toolStrip1->Size = System::Drawing::Size(542, 25);
			this->toolStrip1->TabIndex = 35;
			this->toolStrip1->Text = L"toolStrip1";
			// 
			// 打印基本档案ToolStripButton
			// 
			this->打印基本档案ToolStripButton->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"打印基本档案ToolStripButton.Image")));
			this->打印基本档案ToolStripButton->ImageTransparentColor = System::Drawing::Color::Magenta;
			this->打印基本档案ToolStripButton->Name = L"打印基本档案ToolStripButton";
			this->打印基本档案ToolStripButton->Size = System::Drawing::Size(121, 22);
			this->打印基本档案ToolStripButton->Text = L"打印员工人事档案";
			this->打印基本档案ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPersonnelForm::打印基本档案ToolStripButton_Click);
			// 
			// 基本档案DataGridView
			// 
			this->基本档案DataGridView->AllowUserToAddRows = false;
			this->基本档案DataGridView->AllowUserToDeleteRows = false;
			this->基本档案DataGridView->AllowUserToResizeRows = false;
			this->基本档案DataGridView->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->基本档案DataGridView->BackgroundColor = System::Drawing::SystemColors::ActiveCaption;
			this->基本档案DataGridView->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->基本档案DataGridView->Location = System::Drawing::Point(0, 28);
			this->基本档案DataGridView->MultiSelect = false;
			this->基本档案DataGridView->Name = L"基本档案DataGridView";
			this->基本档案DataGridView->ReadOnly = true;
			this->基本档案DataGridView->RowHeadersVisible = false;
			dataGridViewCellStyle7->BackColor = System::Drawing::Color::Green;
			dataGridViewCellStyle7->ForeColor = System::Drawing::Color::Yellow;
			this->基本档案DataGridView->RowsDefaultCellStyle = dataGridViewCellStyle7;
			this->基本档案DataGridView->RowTemplate->Height = 23;
			this->基本档案DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->基本档案DataGridView->Size = System::Drawing::Size(542, 67);
			this->基本档案DataGridView->TabIndex = 36;
			this->基本档案DataGridView->SelectionChanged += gcnew System::EventHandler(this, &QueryPersonnelForm::基本档案DataGridView_SelectionChanged);
			// 
			// QueryPersonnelForm
			// 
			this->AutoScaleDimensions = System::Drawing::SizeF(6, 12);
			this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
			this->BackColor = System::Drawing::Color::FromArgb(static_cast<System::Int32>(static_cast<System::Byte>(0)), static_cast<System::Int32>(static_cast<System::Byte>(192)), 
				static_cast<System::Int32>(static_cast<System::Byte>(192)));
			this->ClientSize = System::Drawing::Size(542, 416);
			this->Controls->Add(this->工作简历DataGridView);
			this->Controls->Add(this->离职原因DataGridView);
			this->Controls->Add(this->工作业绩DataGridView);
			this->Controls->Add(this->培训记录DataGridView);
			this->Controls->Add(this->奖惩记录DataGridView);
			this->Controls->Add(this->家庭成员DataGridView);
			this->Controls->Add(this->toolStrip1);
			this->Controls->Add(this->基本档案DataGridView);
			this->Name = L"QueryPersonnelForm";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
			this->Text = L"查询员工个人人事档案资料";
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->工作简历DataGridView))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->离职原因DataGridView))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->工作业绩DataGridView))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->培训记录DataGridView))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->奖惩记录DataGridView))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->家庭成员DataGridView))->EndInit();
			this->toolStrip1->ResumeLayout(false);
			this->toolStrip1->PerformLayout();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->基本档案DataGridView))->EndInit();
			this->ResumeLayout(false);
			this->PerformLayout();

		}
#pragma endregion
		private: static String^ MyPersonnelConnectionString= L"Data Source=.;Initial Catalog=MyPersonnel;Integrated Security=True;Pooling=False";
		public: String^ MyCompany;
		private:System::Data::DataTable^ MyPersonnelTable ;
        private:System::Data::DataTable^ MyFamilyTable ;
        private:System::Data::DataTable^ MyTrainingTable ;
        private:System::Data::DataTable^ MyArchievementTable;
        private:System::Data::DataTable^ MyRewardsTable ;
        private:System::Data::DataTable^ MyLeaveTable ;
        private:System::Data::DataTable^ MyResumeTable;	
		private: System::Void 查询ToolStripButton_Click(System::Object^  sender, System::EventArgs^  e) {
			String^ MySQLConnectionString = MyPersonnelConnectionString;
            SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
            MyConnection->Open();