📄 querypayform.h
字号:
// 年份ToolStripComboBox
//
this->年份ToolStripComboBox->DropDownHeight = 150;
this->年份ToolStripComboBox->DropDownStyle = System::Windows::Forms::ComboBoxStyle::DropDownList;
this->年份ToolStripComboBox->DropDownWidth = 40;
this->年份ToolStripComboBox->IntegralHeight = false;
this->年份ToolStripComboBox->Name = L"年份ToolStripComboBox";
this->年份ToolStripComboBox->Size = System::Drawing::Size(75, 25);
//
// 发放月份ToolStripLabel
//
this->发放月份ToolStripLabel->Name = L"发放月份ToolStripLabel";
this->发放月份ToolStripLabel->Size = System::Drawing::Size(35, 22);
this->发放月份ToolStripLabel->Text = L"月份:";
//
// 月份ToolStripComboBox
//
this->月份ToolStripComboBox->DropDownStyle = System::Windows::Forms::ComboBoxStyle::DropDownList;
this->月份ToolStripComboBox->Name = L"月份ToolStripComboBox";
this->月份ToolStripComboBox->Size = System::Drawing::Size(75, 25);
//
// 部门ToolStripLabel
//
this->部门ToolStripLabel->Name = L"部门ToolStripLabel";
this->部门ToolStripLabel->Size = System::Drawing::Size(35, 22);
this->部门ToolStripLabel->Text = L"部门:";
//
// 部门ToolStripComboBox
//
this->部门ToolStripComboBox->DropDownWidth = 75;
this->部门ToolStripComboBox->Name = L"部门ToolStripComboBox";
this->部门ToolStripComboBox->Size = System::Drawing::Size(75, 25);
this->部门ToolStripComboBox->Text = L"%%";
//
// 查询ToolStripButton
//
this->查询ToolStripButton->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"查询ToolStripButton.Image")));
this->查询ToolStripButton->Name = L"查询ToolStripButton";
this->查询ToolStripButton->Size = System::Drawing::Size(49, 22);
this->查询ToolStripButton->Text = L"查询";
this->查询ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::查询ToolStripButton_Click);
//
// 打印全部信息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(97, 22);
this->打印全部信息ToolStripButton->Text = L"打印全部信息";
this->打印全部信息ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::打印全部信息ToolStripButton_Click);
//
// 打印银行入帐单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(109, 20);
this->打印银行入帐单ToolStripButton->Text = L"打印银行入帐单";
this->打印银行入帐单ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::打印银行入帐单ToolStripButton_Click);
//
// 打印养老险入帐单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, 20);
this->打印养老险入帐单ToolStripButton->Text = L"打印养老险入帐单";
this->打印养老险入帐单ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::打印养老险入帐单ToolStripButton_Click);
//
// 打印医疗险入帐单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, 20);
this->打印医疗险入帐单ToolStripButton->Text = L"打印医疗险入帐单";
this->打印医疗险入帐单ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::打印医疗险入帐单ToolStripButton_Click);
//
// 打印住房基金入帐单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(133, 20);
this->打印住房基金入帐单ToolStripButton->Text = L"打印住房基金入帐单";
this->打印住房基金入帐单ToolStripButton->Click += gcnew System::EventHandler(this, &QueryPayForm::打印住房基金入帐单ToolStripButton_Click);
//
// QueryPayForm
//
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->工资发放表BindingNavigator);
this->Name = L"QueryPayForm";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"全部员工工资信息";
this->Load += gcnew System::EventHandler(this, &QueryPayForm::QueryPayForm_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->MyPersonnelDataSet))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->工资发放表BindingSource))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->工资发放表DataGridView))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->工资发放表BindingNavigator))->EndInit();
this->工资发放表BindingNavigator->ResumeLayout(false);
this->工资发放表BindingNavigator->PerformLayout();
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::Void 工资发放表BindingNavigatorSaveItem_Click(System::Object^ sender, System::EventArgs^ e) {
this->Validate();
this->工资发放表BindingSource->EndEdit();
this->工资发放表TableAdapter->Update(this->MyPersonnelDataSet->工资发放表);
}
private: System::Void QueryPayForm_Load(System::Object^ sender, System::EventArgs^ e) {
// TODO: 这行代码将数据加载到表“MyPersonnelDataSet.工资发放表”中。您可以根据需要移动或移除它。
//this->工资发放表TableAdapter->Fill(this->MyPersonnelDataSet->工资发放表);
String^ MySQLConnectionString = MyPersonnelConnectionString;
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
//获取公司的部门信息
System::Data::DataTable^ MyDepartmentTable = gcnew System::Data::DataTable();
String^ MySQL = "Select 部门名称 From 公司部门";
SqlDataAdapter^ MyAdapter = gcnew SqlDataAdapter(MySQL, MyConnection);
MyAdapter->Fill(MyDepartmentTable);
for each (DataRow^ MyRow in MyDepartmentTable->Rows)
{
this->部门ToolStripComboBox->Items->Add(MyRow[0]->ToString());
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
for (int i = 2006; i < 2100; i++)
{
this->年份ToolStripComboBox->Items->Add(i.ToString());
}
for (int i = 1; i < 13; i++)
{
this->月份ToolStripComboBox->Items->Add(i.ToString());
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
}
private: System::Void 查询ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e) {
try
{
this->工资发放表TableAdapter->FillBy(this->MyPersonnelDataSet->工资发放表, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(月份ToolStripComboBox->Text,
System::Int32::typeid)))), 部门ToolStripComboBox->Text, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(年份ToolStripComboBox->Text,
System::Int32::typeid)))));
}
catch (System::Exception^ ex) {
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
private: System::Void 打印全部信息ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e) {
//导出Excel表格数据文件
ApplicationClass^ MyExcel;
Workbooks^ MyWorkBooks;
Workbook^ MyWorkBook;
Worksheet^ MyWorkSheet;
char MyColumns;
Range^ MyRange;
array<System::Object^,2>^ MyData=gcnew array<System::Object^,2>(500,35);
int Count, i, j;
MyExcel = gcnew ApplicationClass();
MyExcel->Visible = true;
if (MyExcel == nullptr)
{
MessageBox::Show("Excel程序无法启动！", "信息提示", MessageBoxButtons::OK, MessageBoxIcon::Information);
return;
}
MyWorkBooks = MyExcel->Workbooks;
MyWorkBook = MyWorkBooks->Add(Missing::Value);
MyWorkSheet = (Worksheet^)MyWorkBook->Worksheets[1];
switch(this->MyPersonnelDataSet->工资发放表->Columns->Count + 64)
{
case 64:
MyRange=MyWorkSheet->Range["A5","A5"];
break;
case 65:
MyRange=MyWorkSheet->Range["A5","B5"];
break;
case 66:
MyRange=MyWorkSheet->Range["A5","C5"];
break;
case 67:
MyRange=MyWorkSheet->Range["A5","D5"];
break;
case 68:
MyRange=MyWorkSheet->Range["A5","E5"];
break;
case 69:
MyRange=MyWorkSheet->Range["A5","F5"];
break;
case 70:
MyRange=MyWorkSheet->Range["A5","G5"];
break;
case 71:
MyRange=MyWorkSheet->Range["A5","H5"];
break;
case 72:
MyRange=MyWorkSheet->Range["A5","I5"];
break;
case 73:
MyRange=MyWorkSheet->Range["A5","J5"];
break;
case 74:
MyRange=MyWorkSheet->Range["A5","K5"];
break;
case 75:
MyRange=MyWorkSheet->Range["A5","L5"];
break;
case 76:
MyRange=MyWorkSheet->Range["A5","M5"];
break;
case 77:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -