📄 salarymanage.h
字号:
#pragma once
#include "LinkDataBase.h"
#include "DataGridComboboxColumn.h"
#include "DataGridNoActiveCellColumn.h"
using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;
namespace My
{
/// <summary>
/// SalaryManage 摘要
///
/// 警告: 如果您更改该类的名称，则将需要更改
/// 与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的
/// “资源文件名”属性。 否则，
/// 设计器将不能与此窗体关联的
/// 本地化资源正确交互。
/// </summary>
public __gc class SalaryManage : public System::Windows::Forms::Form
{
//--------------------成员声明------------------------
private:
LinkDataBase* MyDataBase; //数据库连接类
DataSet* ds;
String* strTableName;
String* strSQL;
CurrencyManager* cmSalary;
protected: System::Windows::Forms::ImageList * imageList1;
SqlDataAdapter* SalaryAdapter;
//-------------------成员声明结束-----------------------
public:
SalaryManage(void)
{
InitializeComponent();
this->MyDataBase = new LinkDataBase();
this->strSQL = S"SELECT 职员基本信息表.职员编号, 职员基本信息表.姓名, 月工资统计表.日期, 月工资统计表.应发金额合计, 月工资统计表.应扣金额合计, 月工资统计表.工资合计, 月工资统计表.个人所得税, 月工资统计表.实发金额, 月工资统计表.发放否, 月工资统计表.月份, 月工资统计表.职员编号 AS Expr1 FROM 职员基本信息表 INNER JOIN 月工资统计表 ON 职员基本信息表.职员编号 = 月工资统计表.职员编号";
this->strTableName = S"工资单";
this->ds = this->MyDataBase->SelectDataBase(this->strSQL,this->strTableName);
}
protected:
void Dispose(Boolean disposing)
{
if (disposing && components)
{
components->Dispose();
}
__super::Dispose(disposing);
}
private: System::Windows::Forms::ToolBarButton * tBtnLastRecord;
private: System::Windows::Forms::ToolBarButton * tBtnQuit;
private: System::Windows::Forms::ToolBarButton * tBtnNextRecord;
private: System::Windows::Forms::GroupBox * groupBox1;
private: System::Windows::Forms::Label * label6;
private: System::Windows::Forms::Label * label5;
private: System::Windows::Forms::Label * label4;
private: System::Windows::Forms::Label * label3;
private: System::Windows::Forms::Label * label2;
private: System::Windows::Forms::Label * label1;
private: System::Windows::Forms::ToolBarButton * tBtnPreviousRecord;
private: System::Windows::Forms::ToolBarButton * tBtnCancelModify;
private: System::Windows::Forms::ToolBarButton * tBtnModifyRecord;
private: System::Windows::Forms::ToolBarButton * tBtnFirstRecord;
private: System::Windows::Forms::ToolBar * toolBar1;
private: System::Windows::Forms::GroupBox * groupBox2;
private: System::Windows::Forms::Label * label19;
private: System::Windows::Forms::Label * label7;
private: System::Windows::Forms::Label * label8;
private: System::Windows::Forms::Label * label9;
private: System::Windows::Forms::Label * label10;
private: System::Windows::Forms::Label * label11;
private: System::Windows::Forms::Label * label12;
private: System::Windows::Forms::Label * label13;
private: System::Windows::Forms::Label * label14;
private: System::Windows::Forms::Label * label15;
private: System::Windows::Forms::Label * label16;
private: System::Windows::Forms::Label * label17;
private: System::Windows::Forms::Label * label18;
private: System::Windows::Forms::Label * label20;
private: System::Windows::Forms::Label * label21;
private: System::Windows::Forms::TextBox * tBoxContractAllowance;
private: System::Windows::Forms::TextBox * tBoxBaseSalary;
private: System::Windows::Forms::TextBox * tBoxFloatSalary;
private: System::Windows::Forms::TextBox * tBoxFoodAllowance;
private: System::Windows::Forms::TextBox * tBoxHouseAllowance;
private: System::Windows::Forms::TextBox * tBoxTemporyAllowance;
private: System::Windows::Forms::TextBox * tBoxDutySalary;
private: System::Windows::Forms::TextBox * tBoxWoundInsurance;
private: System::Windows::Forms::TextBox * tBoxBearInsurance;
private: System::Windows::Forms::TextBox * tBoxJobInsurance;
private: System::Windows::Forms::TextBox * tBoxEndownInsurance;
private: System::Windows::Forms::TextBox * tBoxMedicare;
private: System::Windows::Forms::TextBox * tBoxHouseFund;
private: System::Windows::Forms::TextBox * tBoxAmerce;
private: System::Windows::Forms::TextBox * tBoxAttendance;
private: System::Windows::Forms::TextBox * tBoxLeave;
private: System::Windows::Forms::TextBox * tBoxEleWaterRate;
private: System::Windows::Forms::TextBox * tBoxRent;
private: System::Windows::Forms::TextBox * tBoxBonus;
private: System::Windows::Forms::TextBox * tBoxAssessSalary;
private: System::Windows::Forms::TextBox * tBoxAgeSalary;
private: System::Windows::Forms::DataGrid * dgrdSalary;
private: System::Windows::Forms::Label * label22;
private: System::Windows::Forms::Label * label23;
private: System::Windows::Forms::TextBox * tBoxCurrentDate;
private: System::Windows::Forms::TextBox * tBoxImportDate;
private: System::Windows::Forms::Button * btnImport;
private: System::Windows::Forms::Button * btnCalculate;
private: System::Windows::Forms::Button * btnHandout;
private: System::ComponentModel::IContainer * components;
private:
/// <summary>
/// 必需的设计器变量。
/// </summary>
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
void InitializeComponent(void)
{
this->components = new System::ComponentModel::Container();
System::Resources::ResourceManager * resources = new System::Resources::ResourceManager(__typeof(My::SalaryManage));
this->tBtnLastRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnQuit = new System::Windows::Forms::ToolBarButton();
this->tBtnNextRecord = new System::Windows::Forms::ToolBarButton();
this->groupBox1 = new System::Windows::Forms::GroupBox();
this->tBoxWoundInsurance = new System::Windows::Forms::TextBox();
this->label14 = new System::Windows::Forms::Label();
this->tBoxBearInsurance = new System::Windows::Forms::TextBox();
this->tBoxJobInsurance = new System::Windows::Forms::TextBox();
this->tBoxEndownInsurance = new System::Windows::Forms::TextBox();
this->label15 = new System::Windows::Forms::Label();
this->label16 = new System::Windows::Forms::Label();
this->label17 = new System::Windows::Forms::Label();
this->label18 = new System::Windows::Forms::Label();
this->label20 = new System::Windows::Forms::Label();
this->label21 = new System::Windows::Forms::Label();
this->tBoxMedicare = new System::Windows::Forms::TextBox();
this->tBoxHouseFund = new System::Windows::Forms::TextBox();
this->tBoxAmerce = new System::Windows::Forms::TextBox();
this->tBoxAttendance = new System::Windows::Forms::TextBox();
this->label7 = new System::Windows::Forms::Label();
this->tBoxLeave = new System::Windows::Forms::TextBox();
this->tBoxEleWaterRate = new System::Windows::Forms::TextBox();
this->tBoxRent = new System::Windows::Forms::TextBox();
this->label8 = new System::Windows::Forms::Label();
this->label9 = new System::Windows::Forms::Label();
this->label10 = new System::Windows::Forms::Label();
this->label11 = new System::Windows::Forms::Label();
this->label12 = new System::Windows::Forms::Label();
this->label13 = new System::Windows::Forms::Label();
this->tBoxBonus = new System::Windows::Forms::TextBox();
this->tBoxAssessSalary = new System::Windows::Forms::TextBox();
this->tBoxAgeSalary = new System::Windows::Forms::TextBox();
this->tBoxDutySalary = new System::Windows::Forms::TextBox();
this->label19 = new System::Windows::Forms::Label();
this->tBoxTemporyAllowance = new System::Windows::Forms::TextBox();
this->tBoxHouseAllowance = new System::Windows::Forms::TextBox();
this->tBoxFoodAllowance = new System::Windows::Forms::TextBox();
this->label6 = new System::Windows::Forms::Label();
this->label5 = new System::Windows::Forms::Label();
this->label4 = new System::Windows::Forms::Label();
this->label3 = new System::Windows::Forms::Label();
this->label2 = new System::Windows::Forms::Label();
this->label1 = new System::Windows::Forms::Label();
this->tBoxContractAllowance = new System::Windows::Forms::TextBox();
this->tBoxFloatSalary = new System::Windows::Forms::TextBox();
this->tBoxBaseSalary = new System::Windows::Forms::TextBox();
this->tBtnPreviousRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnCancelModify = new System::Windows::Forms::ToolBarButton();
this->tBtnModifyRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnFirstRecord = new System::Windows::Forms::ToolBarButton();
this->dgrdSalary = new System::Windows::Forms::DataGrid();
this->toolBar1 = new System::Windows::Forms::ToolBar();
this->imageList1 = new System::Windows::Forms::ImageList(this->components);
this->groupBox2 = new System::Windows::Forms::GroupBox();
this->btnHandout = new System::Windows::Forms::Button();
this->btnCalculate = new System::Windows::Forms::Button();
this->btnImport = new System::Windows::Forms::Button();
this->label23 = new System::Windows::Forms::Label();
this->tBoxImportDate = new System::Windows::Forms::TextBox();
this->label22 = new System::Windows::Forms::Label();
this->tBoxCurrentDate = new System::Windows::Forms::TextBox();
this->groupBox1->SuspendLayout();
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dgrdSalary))->BeginInit();
this->groupBox2->SuspendLayout();
this->SuspendLayout();
//
// tBtnLastRecord
//
this->tBtnLastRecord->ImageIndex = 7;
this->tBtnLastRecord->Text = S"尾记录";
this->tBtnLastRecord->ToolTipText = S"尾记录";
//
// tBtnQuit
//
this->tBtnQuit->ImageIndex = 11;
this->tBtnQuit->Text = S"退出";
this->tBtnQuit->ToolTipText = S"退出";
//
// tBtnNextRecord
//
this->tBtnNextRecord->ImageIndex = 8;
this->tBtnNextRecord->Text = S"下一记录";
this->tBtnNextRecord->ToolTipText = S"下一记录";
//
// groupBox1
//
this->groupBox1->Controls->Add(this->tBoxWoundInsurance);
this->groupBox1->Controls->Add(this->label14);
this->groupBox1->Controls->Add(this->tBoxBearInsurance);
this->groupBox1->Controls->Add(this->tBoxJobInsurance);
this->groupBox1->Controls->Add(this->tBoxEndownInsurance);
this->groupBox1->Controls->Add(this->label15);
this->groupBox1->Controls->Add(this->label16);
this->groupBox1->Controls->Add(this->label17);
this->groupBox1->Controls->Add(this->label18);
this->groupBox1->Controls->Add(this->label20);
this->groupBox1->Controls->Add(this->label21);
this->groupBox1->Controls->Add(this->tBoxMedicare);
this->groupBox1->Controls->Add(this->tBoxHouseFund);
this->groupBox1->Controls->Add(this->tBoxAmerce);
this->groupBox1->Controls->Add(this->tBoxAttendance);
this->groupBox1->Controls->Add(this->label7);
this->groupBox1->Controls->Add(this->tBoxLeave);
this->groupBox1->Controls->Add(this->tBoxEleWaterRate);
this->groupBox1->Controls->Add(this->tBoxRent);
this->groupBox1->Controls->Add(this->label8);
this->groupBox1->Controls->Add(this->label9);
this->groupBox1->Controls->Add(this->label10);
this->groupBox1->Controls->Add(this->label11);
this->groupBox1->Controls->Add(this->label12);
this->groupBox1->Controls->Add(this->label13);
this->groupBox1->Controls->Add(this->tBoxBonus);
this->groupBox1->Controls->Add(this->tBoxAssessSalary);
this->groupBox1->Controls->Add(this->tBoxAgeSalary);
this->groupBox1->Controls->Add(this->tBoxDutySalary);
this->groupBox1->Controls->Add(this->label19);
this->groupBox1->Controls->Add(this->tBoxTemporyAllowance);
this->groupBox1->Controls->Add(this->tBoxHouseAllowance);
this->groupBox1->Controls->Add(this->tBoxFoodAllowance);
this->groupBox1->Controls->Add(this->label6);
this->groupBox1->Controls->Add(this->label5);
this->groupBox1->Controls->Add(this->label4);
this->groupBox1->Controls->Add(this->label3);
this->groupBox1->Controls->Add(this->label2);
this->groupBox1->Controls->Add(this->label1);
this->groupBox1->Controls->Add(this->tBoxContractAllowance);
this->groupBox1->Controls->Add(this->tBoxFloatSalary);
this->groupBox1->Controls->Add(this->tBoxBaseSalary);
this->groupBox1->Dock = System::Windows::Forms::DockStyle::Bottom;
this->groupBox1->Location = System::Drawing::Point(0, 253);
this->groupBox1->Name = S"groupBox1";
this->groupBox1->Size = System::Drawing::Size(640, 168);
this->groupBox1->TabIndex = 5;
this->groupBox1->TabStop = false;
//
// tBoxWoundInsurance
//
this->tBoxWoundInsurance->Location = System::Drawing::Point(552, 136);
this->tBoxWoundInsurance->Name = S"tBoxWoundInsurance";
this->tBoxWoundInsurance->Size = System::Drawing::Size(88, 21);
this->tBoxWoundInsurance->TabIndex = 98;
this->tBoxWoundInsurance->Text = S"";
//
// label14
//
this->label14->Location = System::Drawing::Point(552, 120);
this->label14->Name = S"label14";
this->label14->Size = System::Drawing::Size(56, 16);
this->label14->TabIndex = 97;
this->label14->Text = S"工伤保险";
//
// tBoxBearInsurance
//
this->tBoxBearInsurance->Location = System::Drawing::Point(456, 136);
this->tBoxBearInsurance->Name = S"tBoxBearInsurance";
this->tBoxBearInsurance->Size = System::Drawing::Size(88, 21);
this->tBoxBearInsurance->TabIndex = 96;
this->tBoxBearInsurance->Text = S"";
//
// tBoxJobInsurance
//
this->tBoxJobInsurance->Location = System::Drawing::Point(360, 136);
this->tBoxJobInsurance->Name = S"tBoxJobInsurance";
this->tBoxJobInsurance->Size = System::Drawing::Size(88, 21);
this->tBoxJobInsurance->TabIndex = 95;
this->tBoxJobInsurance->Text = S"";
//
// tBoxEndownInsurance
//
this->tBoxEndownInsurance->Location = System::Drawing::Point(272, 136);
this->tBoxEndownInsurance->Name = S"tBoxEndownInsurance";
this->tBoxEndownInsurance->Size = System::Drawing::Size(80, 21);
this->tBoxEndownInsurance->TabIndex = 94;
this->tBoxEndownInsurance->Text = S"";
//
// label15
//
this->label15->Location = System::Drawing::Point(456, 120);
this->label15->Name = S"label15";
this->label15->Size = System::Drawing::Size(56, 16);
this->label15->TabIndex = 93;
this->label15->Text = S"生育保险";
//
// label16
//
this->label16->Location = System::Drawing::Point(360, 120);
this->label16->Name = S"label16";
this->label16->Size = System::Drawing::Size(56, 16);
this->label16->TabIndex = 92;
this->label16->Text = S"失业保险";
//
// label17
//
this->label17->Location = System::Drawing::Point(272, 120);
this->label17->Name = S"label17";
this->label17->Size = System::Drawing::Size(64, 16);
this->label17->TabIndex = 91;
this->label17->Text = S"养老保险";
//
// label18
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -