addition.cpp

学生信息管理系统

// Addition.cpp : implementation file
//

#include "stdafx.h"
#include "SIMS.h"
#include "Addition.h"
#include "CountrySet.h"
#include "NationSet.h"
#include "InformationSet.h"
#include "SpecializeSet.h"
#include "SIMSDlg.h"

extern CDatabase db;

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

/////////////////////////////////////////////////////////////////////////////
// CAddition dialog


CAddition::CAddition(CWnd* pParent /*=NULL*/)
	: CDialog(CAddition::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddition)
	m_address = _T("");
	m_email = _T("");
	m_hometown = _T("");
	m_id = _T("");
	m_men = _T("");
	m_name = _T("");
	m_no = _T("");
	m_teleno = _T("");
	m_specialize = _T("");
	m_nation = _T("");
	m_country = _T("");
	m_gender = _T("");
	m_health = _T("");
	m_states = _T("");
	//}}AFX_DATA_INIT
}


void CAddition::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddition)
	DDX_Control(pDX, IDC_STARTTIME, m_CdStartTime);
	DDX_Control(pDX, IDC_BIRTHDAY, m_CdBirthday);
	DDX_Control(pDX, IDC_NAME, m_CEditName);
	DDX_Control(pDX, IDC_STATES, m_ComboStates);
	DDX_Control(pDX, IDC_HEALTH, m_ComboHealth);
	DDX_Control(pDX, IDC_GENDER, m_ComboGender);
	DDX_Control(pDX, IDC_NATION, m_ComboNation);
	DDX_Control(pDX, IDC_COUNTRY, m_ComboCountry);
	DDX_Control(pDX, IDC_SPECIALIZE, m_ComboSpecialize);
	DDX_Text(pDX, IDC_ADDRESS, m_address);
	DDX_Text(pDX, IDC_EMAIL, m_email);
	DDX_Text(pDX, IDC_HOMTTOWN, m_hometown);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_MEN, m_men);
	DDX_Text(pDX, IDC_NAME, m_name);
	DDX_Text(pDX, IDC_NUMBER, m_no);
	DDX_Text(pDX, IDC_TELENO, m_teleno);
	DDX_CBString(pDX, IDC_SPECIALIZE, m_specialize);
	DDX_CBString(pDX, IDC_NATION, m_nation);
	DDX_CBString(pDX, IDC_COUNTRY, m_country);
	DDX_CBString(pDX, IDC_GENDER, m_gender);
	DDX_CBString(pDX, IDC_HEALTH, m_health);
	DDX_CBString(pDX, IDC_STATES, m_states);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddition, CDialog)
	//{{AFX_MSG_MAP(CAddition)
	ON_WM_CTLCOLOR()
	ON_BN_CLICKED(IDRESET, OnReset)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddition message handlers

BOOL CAddition::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_brush.CreateSolidBrush(RGB(74,142,184));
	if(m_bMode) InitAddition();
	else InitModify();
	return TRUE;
}

HBRUSH CAddition::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	pDC->SetBkMode(TRANSPARENT);
	return m_brush;
}

void CAddition::OnOK() 
{
	CString str;
	m_CEditName.GetWindowText(str);
	if(str=="")
	{
		MessageBox("姓名不能为空","提示");
		return;
	}
	UpdateData(true);
	CInformationSet* pCI=new CInformationSet(&db);
	m_nSpecialize=m_ComboSpecialize.GetCurSel();
	m_nCountry=m_ComboCountry.GetCurSel();
	m_nNation=m_ComboNation.GetCurSel();
	m_nSpecialize++;
	m_nCountry++;
	m_nNation++;
	CString m_strBirthday,m_strStarttime;
	m_CdBirthday.GetWindowText(m_strBirthday);
	m_CdStartTime.GetWindowText(m_strStarttime);
	m_strSQL.Format("insert into STUDENT_INFORMATION values('%s','%s',%d,'%s',\
		'%s','%s',%d,%d,'%s','%s','%s','%s','%s','%s','%s','%s')",\
		m_no,m_name,m_nSpecialize,m_gender,m_strBirthday,\
		m_hometown,m_nCountry,m_nNation,m_id,m_health,m_strStarttime,\
		m_states,m_address,m_teleno,m_email,m_men);
	if(MessageBox("确定修改吗?","确认",1)==IDOK) CDialog::OnOK();
}

void CAddition::OnReset() 
{
	m_CdBirthday.SetTime(&mc_birthday);
	m_CdStartTime.SetTime(&mc_starttime);
	UpdateData(false);
}

void CAddition::InitAddition()
{
	SetWindowText("添加学生信息");
	CInformationSet* pCI=new CInformationSet(&db);
	pCI->Open(CRecordset::forwardOnly,"select MAX(SDT_NO) from STUDENT_INFORMATION");
	int temp=0;
	int count;
	char buf[20];
	pCI->GetFieldValue(temp,m_no);
	count=atoi(m_no);
	count++;
	itoa(count,buf,10);
	m_no=buf;
	delete pCI;
	m_gender="男";
	m_ComboGender.SetCurSel(0);
	CSpecializeSet* pCS=new CSpecializeSet(&db);
	pCS->Open(CRecordset::forwardOnly,"select* from SPECIALIZE_CODE");
	while(!pCS->IsEOF())
	{
		m_specialize=pCS->m_SPECIALIZE_NAME;
		m_ComboSpecialize.AddString(m_specialize);
		pCS->MoveNext();
	}
	m_specialize="统计";
	delete pCS;
	CCountrySet* pCC=new CCountrySet(&db);
	pCC->Open(CRecordset::forwardOnly,"select* from COUNTRY_CODE");
	while(!pCC->IsEOF())
	{
		m_country=pCC->m_COUNTRY_NAME_CN;
		m_ComboCountry.AddString(m_country);
		pCC->MoveNext();
	}
	m_country="中国";
	delete pCC;
	CNationSet* pCN=new CNationSet(&db);
	pCN->Open(CRecordset::forwardOnly,"select* from NATION_CODE");
	while(!pCN->IsEOF())
	{
		m_nation=pCN->m_NATION_NAME;
		m_ComboNation.AddString(m_nation);
		pCN->MoveNext();
	}
	m_nation="汉族";
	m_CdStartTime.SetTime(&CTime::GetCurrentTime());
	delete pCN;
	m_health="良好";
	m_states="在校";
	UpdateData(false);
}

void CAddition::InitModify()
{
	InitAddition();
	SetWindowText("修改学生信息");
	m_address=mc_address;
	m_CdBirthday.SetTime(&mc_birthday);
	m_email=mc_email;
	m_hometown=mc_hometown;
	m_id=mc_id;
	m_men=mc_men;
	m_name=mc_name;
	m_no=mc_no;
	m_CdStartTime.SetTime(&mc_starttime);
	m_teleno=mc_teleno;
	m_specialize=mc_specialize;
	m_nation=mc_nation;
	m_country=mc_country;
	m_gender=mc_gender;
	m_health=mc_health;
	m_states=mc_states;
	UpdateData(false);
}