personneladddlg.cpp

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

// PersonnelAddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SalaryManagement.h"
#include "PersonnelAddDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPersonnelAddDlg dialog
BOOL CPersonnelAddDlg::OnInitDialog(){  //重载初始化对话框的虚函数
	//初始化自动生成的数据
	if(pDepartment->GetDepartmentName()=="A部门")  //专门操作数据库中A部门的表
		m_id="A";
	else if(pDepartment->GetDepartmentName()=="B部门")  //专门操作数据库中B部门的表
		m_id="B";
	else if(pDepartment->GetDepartmentName()=="C部门")  //专门操作数据库中C部门的表
		m_id="C";
	m_department=pDepartment->GetDepartmentName();
	m_position="销售员";  //固定新职员为销售员

	CDialog::OnInitDialog();  //调用CDialog基类的初始化对话框虚函数
	return TRUE;
}
CPersonnelAddDlg::CPersonnelAddDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPersonnelAddDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPersonnelAddDlg)
	m_name = _T("");
	m_position = _T("");
	m_department = _T("");
	m_id = _T("");
	m_idnumber = _T("");
	//}}AFX_DATA_INIT
}


void CPersonnelAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPersonnelAddDlg)
	DDX_Text(pDX, IDC_PERSONNEL_ADD_NAME_EDIT, m_name);
	DDX_Text(pDX, IDC_PERSONNEL_ADD_POSITION_EDIT, m_position);
	DDX_Text(pDX, IDC_PERSONNEL_ADD_DEPARTMENT_EDIT, m_department);
	DDX_Text(pDX, IDC_PERSONNEL_ADD_ID_EDIT, m_id);
	DDX_Text(pDX, IDC_PERSONNEL_ADD_ID2_EDIT, m_idnumber);
	DDV_MaxChars(pDX, m_idnumber, 5);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPersonnelAddDlg, CDialog)
	//{{AFX_MSG_MAP(CPersonnelAddDlg)
	ON_BN_CLICKED(IDC_PERSONNEL_ADD_CANCEL_BUTTON, OnPersonnelAddCancelButton)
	ON_BN_CLICKED(IDC_PERSONNEL_ADD_SUBMIT_BUTTON, OnPersonnelAddSubmitButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPersonnelAddDlg message handlers

void CPersonnelAddDlg::OnPersonnelAddCancelButton(){  //取消添加新职员
	EndDialog(IDCANCEL);
}

void CPersonnelAddDlg::OnPersonnelAddSubmitButton(){  //提交添加的新职员
	CString SQL;  //要查询的SQL语句

	UpdateData(TRUE);  //更新成员变量中的数据
	if(m_name==""){
		MessageBox("请输入新职员的姓名");
		return;
	}
	else if(m_idnumber==""){
		MessageBox("请输入职员号");
		return;
	}
	m_id+=m_idnumber;  //组合起职员号
	//得到要插入的销售额的表
	CString year;
	SQL="select * from zNext";  //得到年份
	database.GetRecordset(SQL);
	if(database.m_pRecordset->adoEOF==0)
		year=(LPCTSTR)(_bstr_t)database.m_pRecordset->GetCollect("年");
	//判断是对哪个部门进行操作
	if(pDepartment->GetDepartmentName()=="A部门"){  //专门操作数据库中A部门的表
		SQL="insert into ADepartEmployee (职员号,姓名,职位,所在部门,基本工资,扣除) values ('"+m_id+"','"+m_name+"','"+m_position+"','"+m_department+"',1000,100)";
		database.ExecuteSQL(SQL);
		SQL="insert into AYear"+year+" (职员号,姓名,一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月,全年) ";
		SQL+="values ('"+m_id+"','"+m_name+"',0,0,0,0,0,0,0,0,0,0,0,0,0)";
		database.ExecuteSQL(SQL);
	}
	else if(pDepartment->GetDepartmentName()=="B部门"){  //专门操作数据库中B部门的表
		SQL="insert into BDepartEmployee (职员号,姓名,职位,所在部门,基本工资,扣除) values ('"+m_id+"','"+m_name+"','"+m_position+"','"+m_department+"',1000,100)";
		database.ExecuteSQL(SQL);
		SQL="insert into BYear"+year+" (职员号,姓名,一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月,全年) ";
		SQL+="values ('"+m_id+"','"+m_name+"',0,0,0,0,0,0,0,0,0,0,0,0,0)";
		database.ExecuteSQL(SQL);
	}
	else if(pDepartment->GetDepartmentName()=="C部门"){  //专门操作数据库中C部门的表
		SQL="insert into CDepartEmployee (职员号,姓名,职位,所在部门,基本工资,扣除) values ('"+m_id+"','"+m_name+"','"+m_position+"','"+m_department+"',1000,100)";
		database.ExecuteSQL(SQL);
		SQL="insert into CYear"+year+" (职员号,姓名,一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月,全年) ";
		SQL+="values ('"+m_id+"','"+m_name+"',0,0,0,0,0,0,0,0,0,0,0,0,0)";
		database.ExecuteSQL(SQL);
	}
	//执行这条SQL语句,向数据库中插入新的记录
	pDepartment->UpdateEmployeeNumber(pDepartment->GetEmployeeNumber()+1);  //更新部门的职员数(+1)
	EndDialog(IDOK);
}