addteacherdlg.cpp

C++课程设计 C++开放的高校职工管理软件 附带源代码及报告

// AddTeacherDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "AddTeacherDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddTeacherDlg dialog


CAddTeacherDlg::CAddTeacherDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddTeacherDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddTeacherDlg)
	m_editName = _T("");
	m_editAge = 0;
	m_intSex = -1;
	//}}AFX_DATA_INIT
}


void CAddTeacherDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddTeacherDlg)
	DDX_Control(pDX, IDC_COMBO_EDUCATION, m_comboEducation);
	DDX_Control(pDX, IDC_COMBO_ORIENTATION, m_comboOrientation);
	DDX_Control(pDX, IDC_COMBO_JOBTITLE, m_comboJobTitle);
	DDX_Control(pDX, IDC_COMBO_KIND, m_comboKind);
	DDX_Control(pDX, IDC_COMBO_POST, m_comboPost);
	DDX_Text(pDX, IDC_EDIT_NAME, m_editName);
	DDX_Text(pDX, IDC_EDIT_AGE, m_editAge);
	DDV_MinMaxInt(pDX, m_editAge, 10, 99);
	DDX_Radio(pDX, IDC_RADIO_SEX1, m_intSex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddTeacherDlg, CDialog)
	//{{AFX_MSG_MAP(CAddTeacherDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddTeacherDlg message handlers

BOOL CAddTeacherDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	CString strConnection="File Name=my_data.udl";
	pDB=new CADODatabase;
	pDB->Open(strConnection);
	pRs=new CADORecordset(pDB);

	GetDlgItem(IDC_EDIT_AGE)->SetWindowText("20");

	((CButton *)GetDlgItem(IDC_RADIO_SEX1))->SetCheck(true);
	((CButton *)GetDlgItem(IDC_RADIO_SEX2))->SetCheck(false);



	m_comboKind.AddString("行政人员");
	m_comboKind.AddString("教师");
	m_comboKind.AddString("一般员工");
	m_comboKind.AddString("退休人员");
	m_comboKind.AddString("返聘人员");
	m_comboKind.AddString("临时工");
	m_comboKind.SetCurSel(0);

	m_comboPost.AddString("无");
	m_comboPost.AddString("科级");
	m_comboPost.AddString("处级");
	m_comboPost.AddString("地级");
	m_comboPost.SetCurSel(0);

	m_comboJobTitle.AddString("无");
	m_comboJobTitle.AddString("初级");
	m_comboJobTitle.AddString("中级");
	m_comboJobTitle.AddString("高级");
	m_comboJobTitle.SetCurSel(0);

	m_comboOrientation.AddString("群众");
	m_comboOrientation.AddString("中共党员");
	m_comboOrientation.AddString("民主党派");
	m_comboOrientation.SetCurSel(0);

	m_comboEducation.AddString("中专");
	m_comboEducation.AddString("大专");
	m_comboEducation.AddString("大学");
	m_comboEducation.AddString("硕士");
	m_comboEducation.AddString("博士");
	m_comboEducation.SetCurSel(0);

	return TRUE;
}

void CAddTeacherDlg::OnOK() 
{
	UpdateData(TRUE);
	
	if(m_editName=="")
	{
		MessageBox("请输入姓名!");
		
		CEdit   *pEdit   =(CEdit*)   GetDlgItem(IDC_EDIT_NAME);   
		pEdit->SetFocus();  

		return;
	}

	CString kind,sex,post,jobTitle,orientation,education;

	m_comboKind.GetWindowText(kind);

	if(m_intSex==0)
		sex="男";
	else if(m_intSex==1)
		sex="女";
	else
		sex="保密";
	
	m_comboPost.GetWindowText(post);
	m_comboJobTitle.GetWindowText(jobTitle);
	m_comboOrientation.GetWindowText(orientation);
	m_comboEducation.GetWindowText(education);

	if(m_editAge<10||m_editAge>99)
		return; 

	CString strSQL;
	strSQL.Format("insert into info(name,kind,sex,age,post,job_title,orientation,education) values('%s','%s','%s',%d,'%s','%s','%s','%s')",m_editName,kind,sex,m_editAge,post,jobTitle,orientation,education);
	pDB->Execute(strSQL);

		MessageBox("员工 "+m_editName+" 添加成功");

	CDialog::OnOK();
}