modifydlg.cpp

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

// ModifyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "teachermis.h"
#include "ModifyDlg.h"
#include "ado.h"

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

/////////////////////////////////////////////////////////////////////////////
// CModifyDlg dialog


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


void CModifyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyDlg)
	DDX_Control(pDX, IDC_COMBO_PSOT, m_comboPost);
	DDX_Control(pDX, IDC_COMBO_ORIENTATION, m_comboOrientation);
	DDX_Control(pDX, IDC_COMBO_KIND, m_comboKind);
	DDX_Control(pDX, IDC_COMBO_JOBTITLE, m_comboJobTitle);
	DDX_Control(pDX, IDC_COMBO_EDUCATION, m_comboEducation);
	DDX_Text(pDX, IDC_EDIT_NAME, m_editName);
	DDX_Text(pDX, IDC_STATIC_ID, m_editID);
	DDX_Radio(pDX, IDC_RADIO_SEX1, m_intSex);
	DDX_Text(pDX, IDC_EDIT_AGE, m_editAge);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CModifyDlg message handlers

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

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

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

	pRs->Open("select * from info where id="+m_editID,CADORecordset.openQuery);
	if((pRs->IsOpen())&&(pRs->GetRecordCount()!=0))
	{
		pRs->GetFieldValue("name",m_editName);
		pRs->GetFieldValue("kind",kind);
		pRs->GetFieldValue("sex",sex);
		pRs->GetFieldValue("age",age);
		pRs->GetFieldValue("post",post);
		pRs->GetFieldValue("job_title",jobTitle);
		pRs->GetFieldValue("orientation",orientation);
		pRs->GetFieldValue("education",education);
		UpdateData(FALSE);
	}

	GetDlgItem(IDC_EDIT_NAME)->SetWindowText(m_editName);
	GetDlgItem(IDC_EDIT_AGE)->SetWindowText(age);

	

	if(sex=="男")
	{
		((CButton *)GetDlgItem(IDC_RADIO_SEX1))->SetCheck(true);
		((CButton *)GetDlgItem(IDC_RADIO_SEX2))->SetCheck(false);
	}
	else if(sex=="女")
	{
		((CButton *)GetDlgItem(IDC_RADIO_SEX1))->SetCheck(false);
		((CButton *)GetDlgItem(IDC_RADIO_SEX2))->SetCheck(true);
	}

	m_comboKind.AddString(kind);
	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(post);
	m_comboPost.AddString("无");
	m_comboPost.AddString("科级");
	m_comboPost.AddString("处级");
	m_comboPost.AddString("地级");
	m_comboPost.SetCurSel(0);

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

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

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

	return TRUE;
}

//DEL void CModifyDlg::setID(int id)
//DEL {
//DEL 	m_editID=id;
//DEL }

void CModifyDlg::setID(CString id)
{
	m_editID=id;
}

void CModifyDlg::OnOK() 
{
	UpdateData(TRUE);

	if(m_editName=="")
	{
		MessageBox("姓名不能为空！");
		
		CEdit   *pEdit   =(CEdit*)   GetDlgItem(IDC_EDIT_NAME);   
		pEdit->SetFocus();   

		return;
	}

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

	if(m_intSex==0)
		sex="男";
	else if(m_intSex==1)
		sex="女";
	else
		sex="保密";
	
	m_comboKind.GetWindowText(kind);
	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("update info set name='%s',kind='%s',sex='%s',age=%d,post='%s',job_title='%s',orientation='%s',education='%s' where id=%s",m_editName,kind,sex,m_editAge,post,jobTitle,orientation,education,m_editID);
	pDB->Execute(strSQL);

	MessageBox("编号为 "+m_editID+" 的教师修改成功");
	//MessageBox(strSQL);
		
	CDialog::OnOK();
}