📄 queryallcheckform.h
字号:
//
// dataGridViewTextBoxColumn22
//
this->dataGridViewTextBoxColumn22->DataPropertyName = L"19";
this->dataGridViewTextBoxColumn22->HeaderText = L"19";
this->dataGridViewTextBoxColumn22->Name = L"dataGridViewTextBoxColumn22";
this->dataGridViewTextBoxColumn22->ReadOnly = true;
this->dataGridViewTextBoxColumn22->Width = 20;
//
// dataGridViewTextBoxColumn23
//
this->dataGridViewTextBoxColumn23->DataPropertyName = L"20";
this->dataGridViewTextBoxColumn23->HeaderText = L"20";
this->dataGridViewTextBoxColumn23->Name = L"dataGridViewTextBoxColumn23";
this->dataGridViewTextBoxColumn23->ReadOnly = true;
this->dataGridViewTextBoxColumn23->Width = 20;
//
// dataGridViewTextBoxColumn24
//
this->dataGridViewTextBoxColumn24->DataPropertyName = L"21";
this->dataGridViewTextBoxColumn24->HeaderText = L"21";
this->dataGridViewTextBoxColumn24->Name = L"dataGridViewTextBoxColumn24";
this->dataGridViewTextBoxColumn24->ReadOnly = true;
this->dataGridViewTextBoxColumn24->Width = 20;
//
// dataGridViewTextBoxColumn25
//
this->dataGridViewTextBoxColumn25->DataPropertyName = L"22";
this->dataGridViewTextBoxColumn25->HeaderText = L"22";
this->dataGridViewTextBoxColumn25->Name = L"dataGridViewTextBoxColumn25";
this->dataGridViewTextBoxColumn25->ReadOnly = true;
this->dataGridViewTextBoxColumn25->Width = 20;
//
// dataGridViewTextBoxColumn26
//
this->dataGridViewTextBoxColumn26->DataPropertyName = L"23";
this->dataGridViewTextBoxColumn26->HeaderText = L"23";
this->dataGridViewTextBoxColumn26->Name = L"dataGridViewTextBoxColumn26";
this->dataGridViewTextBoxColumn26->ReadOnly = true;
this->dataGridViewTextBoxColumn26->Width = 20;
//
// dataGridViewTextBoxColumn27
//
this->dataGridViewTextBoxColumn27->DataPropertyName = L"24";
this->dataGridViewTextBoxColumn27->HeaderText = L"24";
this->dataGridViewTextBoxColumn27->Name = L"dataGridViewTextBoxColumn27";
this->dataGridViewTextBoxColumn27->ReadOnly = true;
this->dataGridViewTextBoxColumn27->Width = 20;
//
// dataGridViewTextBoxColumn28
//
this->dataGridViewTextBoxColumn28->DataPropertyName = L"25";
this->dataGridViewTextBoxColumn28->HeaderText = L"25";
this->dataGridViewTextBoxColumn28->Name = L"dataGridViewTextBoxColumn28";
this->dataGridViewTextBoxColumn28->ReadOnly = true;
this->dataGridViewTextBoxColumn28->Width = 20;
//
// dataGridViewTextBoxColumn29
//
this->dataGridViewTextBoxColumn29->DataPropertyName = L"26";
this->dataGridViewTextBoxColumn29->HeaderText = L"26";
this->dataGridViewTextBoxColumn29->Name = L"dataGridViewTextBoxColumn29";
this->dataGridViewTextBoxColumn29->ReadOnly = true;
this->dataGridViewTextBoxColumn29->Width = 20;
//
// dataGridViewTextBoxColumn30
//
this->dataGridViewTextBoxColumn30->DataPropertyName = L"27";
this->dataGridViewTextBoxColumn30->HeaderText = L"27";
this->dataGridViewTextBoxColumn30->Name = L"dataGridViewTextBoxColumn30";
this->dataGridViewTextBoxColumn30->ReadOnly = true;
this->dataGridViewTextBoxColumn30->Width = 20;
//
// dataGridViewTextBoxColumn31
//
this->dataGridViewTextBoxColumn31->DataPropertyName = L"28";
this->dataGridViewTextBoxColumn31->HeaderText = L"28";
this->dataGridViewTextBoxColumn31->Name = L"dataGridViewTextBoxColumn31";
this->dataGridViewTextBoxColumn31->ReadOnly = true;
this->dataGridViewTextBoxColumn31->Width = 20;
//
// dataGridViewTextBoxColumn32
//
this->dataGridViewTextBoxColumn32->DataPropertyName = L"29";
this->dataGridViewTextBoxColumn32->HeaderText = L"29";
this->dataGridViewTextBoxColumn32->Name = L"dataGridViewTextBoxColumn32";
this->dataGridViewTextBoxColumn32->ReadOnly = true;
this->dataGridViewTextBoxColumn32->Width = 20;
//
// dataGridViewTextBoxColumn33
//
this->dataGridViewTextBoxColumn33->DataPropertyName = L"30";
this->dataGridViewTextBoxColumn33->HeaderText = L"30";
this->dataGridViewTextBoxColumn33->Name = L"dataGridViewTextBoxColumn33";
this->dataGridViewTextBoxColumn33->ReadOnly = true;
this->dataGridViewTextBoxColumn33->Width = 20;
//
// dataGridViewTextBoxColumn34
//
this->dataGridViewTextBoxColumn34->DataPropertyName = L"31";
this->dataGridViewTextBoxColumn34->HeaderText = L"31";
this->dataGridViewTextBoxColumn34->Name = L"dataGridViewTextBoxColumn34";
this->dataGridViewTextBoxColumn34->ReadOnly = true;
this->dataGridViewTextBoxColumn34->Width = 20;
//
// dataGridViewTextBoxColumn35
//
this->dataGridViewTextBoxColumn35->DataPropertyName = L"考勤年份";
this->dataGridViewTextBoxColumn35->HeaderText = L"考勤年份";
this->dataGridViewTextBoxColumn35->Name = L"dataGridViewTextBoxColumn35";
this->dataGridViewTextBoxColumn35->ReadOnly = true;
//
// dataGridViewTextBoxColumn36
//
this->dataGridViewTextBoxColumn36->DataPropertyName = L"考勤月份";
this->dataGridViewTextBoxColumn36->HeaderText = L"考勤月份";
this->dataGridViewTextBoxColumn36->Name = L"dataGridViewTextBoxColumn36";
this->dataGridViewTextBoxColumn36->ReadOnly = true;
//
// dataGridViewTextBoxColumn1
//
this->dataGridViewTextBoxColumn1->DataPropertyName = L"自编号";
this->dataGridViewTextBoxColumn1->HeaderText = L"自编号";
this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";
this->dataGridViewTextBoxColumn1->ReadOnly = true;
//
// dataGridViewTextBoxColumn2
//
this->dataGridViewTextBoxColumn2->DataPropertyName = L"员工编号";
this->dataGridViewTextBoxColumn2->HeaderText = L"员工编号";
this->dataGridViewTextBoxColumn2->Name = L"dataGridViewTextBoxColumn2";
this->dataGridViewTextBoxColumn2->ReadOnly = true;
//
// QueryAllCheckForm
//
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->fillBy1ToolStrip);
this->Name = L"QueryAllCheckForm";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"全部员工考勤信息";
this->Load += gcnew System::EventHandler(this, &QueryAllCheckForm::QueryAllCheckForm_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->MyPersonnelDataSet))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->考勤记录BindingSource))->EndInit();
this->fillBy1ToolStrip->ResumeLayout(false);
this->fillBy1ToolStrip->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::Void 考勤记录BindingNavigatorSaveItem_Click(System::Object^ sender, System::EventArgs^ e) {
this->Validate();
this->考勤记录BindingSource->EndEdit();
this->考勤记录TableAdapter->Update(this->MyPersonnelDataSet->考勤记录);
}
private: System::Void QueryAllCheckForm_Load(System::Object^ sender, System::EventArgs^ e) {
// TODO: 这行代码将数据加载到表“MyPersonnelDataSet.考勤记录”中。您可以根据需要移动或移除它。
//this->考勤记录TableAdapter->Fill(this->MyPersonnelDataSet->考勤记录);
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());
}
}
private: System::Void 查询ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e) {
try
{
this->考勤记录TableAdapter->FillBy1(this->MyPersonnelDataSet->考勤记录, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(年份ToolStripComboBox->Text,
System::Int32::typeid)))), 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) {
if (this->MyPersonnelDataSet->考勤记录->Rows->Count < 1)
{
return;
}
//导出Excel表格数据文件
ApplicationClass^ MyExcel;
Workbooks^ MyWorkBooks;
Workbook^ MyWorkBook;
Worksheet^ MyWorkSheet;
char MyColumns;
Range^ MyRange;
array<System::Object^,2>^ MyData=gcnew array<System::Object^,2>(5000,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];
MyRange = MyWorkSheet->Range["A5", "AF5"];
MyData[0, 0] = "员工姓名";
for (i = 1; i < 32; i++)
{
MyData[0, i] = i.ToString();
}
j = 1;
//输出数据库记录
for each (DataRow^ MyRow in this->MyPersonnelDataSet->考勤记录->Rows)
{
for (i = 2; i <34; i++)
{
MyData[j, i-2] = MyRow[i]->ToString();
}
j++;
}
MyRange = MyRange->Resize[this->MyPersonnelDataSet->考勤记录->Rows->Count + 1, 32];
MyRange->Value2 = MyData;
MyRange->EntireColumn->AutoFit();
MyWorkSheet->Cells[2, 2] = this->MyCompany + "员工考勤表";
MyWorkSheet->Cells[4, 1] = "考勤日期：" + this->年份ToolStripComboBox->Text + "年" + this->月份ToolStripComboBox->Text + "月";
MyWorkSheet->Cells[this->MyPersonnelDataSet->考勤记录->Rows->Count + 7, 1] = "考勤符号说明：出勤 /， 迟到>， 早退<， 产假√，事假#，病假+，婚假△，旷工×";
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -