📄 computeform.h
字号:
this->工资核算表DataGridView->AllowUserToResizeRows = false;
this->工资核算表DataGridView->AutoGenerateColumns = false;
this->工资核算表DataGridView->BackgroundColor = System::Drawing::SystemColors::ActiveCaption;
this->工资核算表DataGridView->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(15) {this->dataGridViewTextBoxColumn3,
this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5, this->dataGridViewTextBoxColumn6, this->dataGridViewTextBoxColumn7,
this->dataGridViewTextBoxColumn8, this->dataGridViewTextBoxColumn9, this->dataGridViewTextBoxColumn10, this->dataGridViewTextBoxColumn11,
this->dataGridViewTextBoxColumn12, this->dataGridViewTextBoxColumn13, this->dataGridViewTextBoxColumn14, this->dataGridViewTextBoxColumn15,
this->dataGridViewTextBoxColumn2, this->dataGridViewTextBoxColumn1});
this->工资核算表DataGridView->DataSource = this->工资核算表BindingSource;
dataGridViewCellStyle1->Alignment = System::Windows::Forms::DataGridViewContentAlignment::MiddleLeft;
dataGridViewCellStyle1->BackColor = System::Drawing::Color::Green;
dataGridViewCellStyle1->Font = (gcnew System::Drawing::Font(L"宋体", 9, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point,
static_cast<System::Byte>(134)));
dataGridViewCellStyle1->ForeColor = System::Drawing::Color::Yellow;
dataGridViewCellStyle1->SelectionBackColor = System::Drawing::SystemColors::Highlight;
dataGridViewCellStyle1->SelectionForeColor = System::Drawing::SystemColors::HighlightText;
dataGridViewCellStyle1->WrapMode = System::Windows::Forms::DataGridViewTriState::False;
this->工资核算表DataGridView->DefaultCellStyle = dataGridViewCellStyle1;
this->工资核算表DataGridView->Dock = System::Windows::Forms::DockStyle::Fill;
this->工资核算表DataGridView->Location = System::Drawing::Point(0, 25);
this->工资核算表DataGridView->Name = L"工资核算表DataGridView";
this->工资核算表DataGridView->RowHeadersVisible = false;
this->工资核算表DataGridView->RowTemplate->Height = 23;
this->工资核算表DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::CellSelect;
this->工资核算表DataGridView->Size = System::Drawing::Size(562, 391);
this->工资核算表DataGridView->TabIndex = 2;
//
// dataGridViewTextBoxColumn3
//
this->dataGridViewTextBoxColumn3->DataPropertyName = L"员工姓名";
this->dataGridViewTextBoxColumn3->HeaderText = L"员工姓名";
this->dataGridViewTextBoxColumn3->Name = L"dataGridViewTextBoxColumn3";
this->dataGridViewTextBoxColumn3->ReadOnly = true;
this->dataGridViewTextBoxColumn3->Width = 60;
//
// dataGridViewTextBoxColumn4
//
this->dataGridViewTextBoxColumn4->DataPropertyName = L"基本工资";
this->dataGridViewTextBoxColumn4->HeaderText = L"基本工资";
this->dataGridViewTextBoxColumn4->Name = L"dataGridViewTextBoxColumn4";
this->dataGridViewTextBoxColumn4->Width = 60;
//
// dataGridViewTextBoxColumn5
//
this->dataGridViewTextBoxColumn5->DataPropertyName = L"津贴";
this->dataGridViewTextBoxColumn5->HeaderText = L"津贴";
this->dataGridViewTextBoxColumn5->Name = L"dataGridViewTextBoxColumn5";
this->dataGridViewTextBoxColumn5->Width = 60;
//
// dataGridViewTextBoxColumn6
//
this->dataGridViewTextBoxColumn6->DataPropertyName = L"奖金";
this->dataGridViewTextBoxColumn6->HeaderText = L"奖金";
this->dataGridViewTextBoxColumn6->Name = L"dataGridViewTextBoxColumn6";
this->dataGridViewTextBoxColumn6->Width = 60;
//
// dataGridViewTextBoxColumn7
//
this->dataGridViewTextBoxColumn7->DataPropertyName = L"工龄工资";
this->dataGridViewTextBoxColumn7->HeaderText = L"工龄工资";
this->dataGridViewTextBoxColumn7->Name = L"dataGridViewTextBoxColumn7";
this->dataGridViewTextBoxColumn7->Width = 60;
//
// dataGridViewTextBoxColumn8
//
this->dataGridViewTextBoxColumn8->DataPropertyName = L"岗位工资";
this->dataGridViewTextBoxColumn8->HeaderText = L"岗位工资";
this->dataGridViewTextBoxColumn8->Name = L"dataGridViewTextBoxColumn8";
this->dataGridViewTextBoxColumn8->Width = 60;
//
// dataGridViewTextBoxColumn9
//
this->dataGridViewTextBoxColumn9->DataPropertyName = L"其他应增项";
this->dataGridViewTextBoxColumn9->HeaderText = L"其他应增项";
this->dataGridViewTextBoxColumn9->Name = L"dataGridViewTextBoxColumn9";
this->dataGridViewTextBoxColumn9->Width = 70;
//
// dataGridViewTextBoxColumn10
//
this->dataGridViewTextBoxColumn10->DataPropertyName = L"所得税";
this->dataGridViewTextBoxColumn10->HeaderText = L"所得税";
this->dataGridViewTextBoxColumn10->Name = L"dataGridViewTextBoxColumn10";
this->dataGridViewTextBoxColumn10->Width = 60;
//
// dataGridViewTextBoxColumn11
//
this->dataGridViewTextBoxColumn11->DataPropertyName = L"养老险";
this->dataGridViewTextBoxColumn11->HeaderText = L"养老险";
this->dataGridViewTextBoxColumn11->Name = L"dataGridViewTextBoxColumn11";
this->dataGridViewTextBoxColumn11->Width = 60;
//
// dataGridViewTextBoxColumn12
//
this->dataGridViewTextBoxColumn12->DataPropertyName = L"医疗险";
this->dataGridViewTextBoxColumn12->HeaderText = L"医疗险";
this->dataGridViewTextBoxColumn12->Name = L"dataGridViewTextBoxColumn12";
this->dataGridViewTextBoxColumn12->Width = 60;
//
// dataGridViewTextBoxColumn13
//
this->dataGridViewTextBoxColumn13->DataPropertyName = L"住房基金";
this->dataGridViewTextBoxColumn13->HeaderText = L"住房基金";
this->dataGridViewTextBoxColumn13->Name = L"dataGridViewTextBoxColumn13";
this->dataGridViewTextBoxColumn13->Width = 60;
//
// dataGridViewTextBoxColumn14
//
this->dataGridViewTextBoxColumn14->DataPropertyName = L"其他应减项";
this->dataGridViewTextBoxColumn14->HeaderText = L"其他应减项";
this->dataGridViewTextBoxColumn14->Name = L"dataGridViewTextBoxColumn14";
this->dataGridViewTextBoxColumn14->Width = 70;
//
// dataGridViewTextBoxColumn15
//
this->dataGridViewTextBoxColumn15->DataPropertyName = L"说明";
this->dataGridViewTextBoxColumn15->HeaderText = L"说明";
this->dataGridViewTextBoxColumn15->Name = L"dataGridViewTextBoxColumn15";
//
// dataGridViewTextBoxColumn2
//
this->dataGridViewTextBoxColumn2->DataPropertyName = L"员工编号";
this->dataGridViewTextBoxColumn2->HeaderText = L"员工编号";
this->dataGridViewTextBoxColumn2->Name = L"dataGridViewTextBoxColumn2";
this->dataGridViewTextBoxColumn2->ReadOnly = true;
//
// dataGridViewTextBoxColumn1
//
this->dataGridViewTextBoxColumn1->DataPropertyName = L"自编号";
this->dataGridViewTextBoxColumn1->HeaderText = L"自编号";
this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";
this->dataGridViewTextBoxColumn1->ReadOnly = true;
//
// ComputeForm
//
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(562, 416);
this->Controls->Add(this->工资核算表DataGridView);
this->Controls->Add(this->工资核算表BindingNavigator);
this->Name = L"ComputeForm";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"工资核算";
this->Load += gcnew System::EventHandler(this, &ComputeForm::ComputeForm_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->工资核算表BindingNavigator))->EndInit();
this->工资核算表BindingNavigator->ResumeLayout(false);
this->工资核算表BindingNavigator->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 ComputeForm_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^ MyQueryTable = gcnew System::Data::DataTable();
String^ MySQL = "Select * From 在职员工视图 WHERE 员工编号 NOT IN (SELECT 员工编号 FROM 工资核算表)";
SqlDataAdapter^ MyAdapter = gcnew SqlDataAdapter(MySQL, MyConnection);
MyAdapter->Fill(MyQueryTable);
for each (DataRow^ MyRow in MyQueryTable->Rows)
{
String^ My自编号 = this->GetMyID();
String^ My员工编号 = MyRow[1]->ToString();
String^ My员工姓名 = MyRow[3]->ToString();
float My基本工资 =(float)Convert::ToDouble(MyRow[17]->ToString());
MySQL = "INSERT INTO 工资核算表([自编号] ,[员工编号], [员工姓名], [基本工资]) VALUES (@自编号 ,@员工编号, @员工姓名, @基本工资)";
MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
SqlCommand^ MyCommand = MyConnection->CreateCommand();
MyCommand->CommandText = MySQL;
MyCommand->Parameters->Add(gcnew SqlParameter("@自编号", SqlDbType::VarChar));
MyCommand->Parameters->Add(gcnew SqlParameter("@员工编号", SqlDbType::VarChar));
MyCommand->Parameters->Add(gcnew SqlParameter("@员工姓名", SqlDbType::VarChar));
MyCommand->Parameters->Add(gcnew SqlParameter("@基本工资", SqlDbType::Float));
MyCommand->Parameters["@自编号"]->Value = My自编号;
MyCommand->Parameters["@员工编号"]->Value = My员工编号;
MyCommand->Parameters["@员工姓名"]->Value = My员工姓名;
MyCommand->Parameters["@基本工资"]->Value = My基本工资;
MyCommand->ExecuteNonQuery();
}
//获取公司的部门信息
System::Data::DataTable^ MyDepartmentTable = gcnew System::Data::DataTable();
MySQL = "Select 部门名称 From 公司部门";
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: String^ GetMyID()
{
String^ MySQLConnectionString =MyPersonnelConnectionString;
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
SqlCommand^ MyCommand = MyConnection->CreateCommand();
MyCommand->CommandText = "Select max(自编号) 最大编号 From 工资核算表";
System::Object^ MyResult = MyCommand->ExecuteScalar();
System::Int64 MyID = 1;
if (MyResult != System::DBNull::Value)
{
String^ MyMaxID = MyResult->ToString()->Trim();
MyMaxID = MyMaxID->Substring(2, MyMaxID->Length - 2);
MyID = Convert::ToInt64(MyMaxID) + 1;
}
int MyLength = MyID.ToString()->Length;
String^ MyNewID = "";
switch (MyLength)
{
case 1:
MyNewID = "HS0000000" + MyID.ToString();
break;
case 2:
MyNewID = "HS000000" + MyID.ToString();
break;
case 3:
MyNewID = "HS00000" + MyID.ToString();
break;
case 4:
MyNewID = "HS0000" + MyID.ToString();
break;
case 5:
MyNewID = "HS000" + MyID.ToString();
break;
case 6:
MyNewID = "HS00" + MyID.ToString();
break;
case 7:
MyNewID = "HS0" + MyID.ToString();
break;
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
return MyNewID;
}
private: System::Void 查询ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e) {
try
{
this->工资核算表TableAdapter->FillBy(this->MyPersonnelDataSet->工资核算表, 部门ToolStripComboBox->Text);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -