initialisitiondlg.cpp

数据库开发的工资管理系统

#include "stdafx.h"
#include "SalaryManagement.h"
#include "InitialisitionDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
CInitialisitionDlg::CInitialisitionDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInitialisitionDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInitialisitionDlg)
	m_year = 0;
	m_month = 0;
	m_m_rate = 1;
	m_s_rate = 5;
	m_t_rate = 1;
	//}}AFX_DATA_INIT
}
void CInitialisitionDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInitialisitionDlg)
	DDX_Text(pDX, IDC_INITIALISITION_YEAR_EDIT, m_year);
	DDX_Text(pDX, IDC_INITIALISITION_MONTH_EDIT, m_month);
	DDX_Text(pDX, IDC_INITIALISITION_M_RATE_EDIT, m_m_rate);
	DDV_MinMaxInt(pDX, m_m_rate, 0, 100);
	DDX_Text(pDX, IDC_INITIALISITION_S_RATE_EDIT, m_s_rate);
	DDV_MinMaxInt(pDX, m_s_rate, 0, 100);
	DDX_Text(pDX, IDC_INITIALISITION_T_EDIT, m_t_rate);
	DDV_MinMaxInt(pDX, m_t_rate, 0, 100);
	//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CInitialisitionDlg, CDialog)
	//{{AFX_MSG_MAP(CInitialisitionDlg)
	ON_BN_CLICKED(IDC_INITIALISITION_CONFIRM_BUTTON, OnInitialisitionConfirmButton)
	ON_BN_CLICKED(IDC_INITIALISITION_CANCEL_BUTTON, OnInitialisitionCancelButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CInitialisitionDlg message handlers

void CInitialisitionDlg::OnInitialisitionConfirmButton(){  //提交所更改的系统日期
	CString SQL;  //建立用来执行的SQL语句

	UpdateData(TRUE);
	if(m_month>12||m_month<1){
		MessageBox("输入月份应该为1-12");
		return;
	}
	if(m_year<2000||m_year>3000){
		MessageBox("输入年份应该为2000-3000");
		return;
	}
	char temp[5];  //把数字转换成字符串
	CString year;
	CString month;
	CString m_rate;  //经理提成
	CString s_rate;  //销售员提成
	CString t_rate;  //奖金提成
	sprintf(temp,"%d",m_year);  //用sprintf函数
	year=temp;
	sprintf(temp,"%d",m_month);
	month=temp;
	sprintf(temp,"%d",m_m_rate);
	m_rate=temp;
	sprintf(temp,"%d",m_s_rate);
	s_rate=temp;
	sprintf(temp,"%d",m_t_rate);
	t_rate=temp;
	//变换月份，使其与销售额表相一致
	if(month=="1") month="一月";
	else if(month=="2") month="二月";
	else if(month=="3") month="三月";
	else if(month=="4") month="四月";
	else if(month=="5") month="五月";
	else if(month=="6") month="六月";
	else if(month=="7") month="七月";
	else if(month=="8") month="八月";
	else if(month=="9") month="九月";
	else if(month=="10") month="十月";
	else if(month=="11") month="十一月";
	else if(month=="12") month="十二月";

	SQL="update zNext set 年='"+year+"',月='"+month+"',职员提成率="+s_rate+",经理提成率="+m_rate+",奖金率="+t_rate;
	database.ExecuteSQL(SQL);

	//创建各个部门的年 销售额表
	A_Department.GetDepartmentEmployee();
	A_Department.Create_Table(year);
	A_Department.DeleteDepartmentEmployee();

	B_Department.GetDepartmentEmployee();
	B_Department.Create_Table(year);
	B_Department.DeleteDepartmentEmployee();

	C_Department.GetDepartmentEmployee();
	C_Department.Create_Table(year);
	C_Department.DeleteDepartmentEmployee();
	EndDialog(IDOK);
}

void CInitialisitionDlg::OnInitialisitionCancelButton(){  //退出此对话框
	EndDialog(IDCANCEL);
}