addstudlg.cpp

ACCESS数据库+MFC编写的学生数据库管理系统

// AddstuDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学籍管理系统.h"
#include "AddstuDlg.h"
#include "MainView.h"
#include "StuinfoSet1.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddstuDlg dialog


CAddstuDlg::CAddstuDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddstuDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddstuDlg)
	m_addbirthday = 0;
	m_addenrolment = 0;
	m_addcollage = _T("");
	m_addsex = _T("");
	m_addspc = _T("");
	m_addteam = _T("");
	m_addcon = _T("");
	m_addname = _T("");
	m_addnum = _T("");
	m_addnative = _T("");
	m_addrace = _T("");
	//}}AFX_DATA_INIT
}


void CAddstuDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddstuDlg)
	DDX_Control(pDX, IDC_COMBO_RACE, m_comboxrace);
	DDX_Control(pDX, IDC_COMBO_ADDSEX, m_comboxsex);
	DDX_Control(pDX, IDC_COMBO_ADDTEAM, m_comboxteam);
	DDX_Control(pDX, IDC_COMBO_ADDSPC, m_comboxspc);
	DDX_Control(pDX, IDC_COMBO_ADDCOLLAGE, m_comboxcollage);
	DDX_DateTimeCtrl(pDX, IDC_ADDBIRTHDAY, m_addbirthday);
	DDX_DateTimeCtrl(pDX, IDC_ADDENROLMENT, m_addenrolment);
	DDX_CBString(pDX, IDC_COMBO_ADDCOLLAGE, m_addcollage);
	DDX_CBString(pDX, IDC_COMBO_ADDSEX, m_addsex);
	DDX_CBString(pDX, IDC_COMBO_ADDSPC, m_addspc);
	DDX_CBString(pDX, IDC_COMBO_ADDTEAM, m_addteam);
	DDX_Text(pDX, IDC_EDIT_ADDCON, m_addcon);
	DDX_Text(pDX, IDC_EDIT_ADDNAME, m_addname);
	DDX_Text(pDX, IDC_EDIT_ADDNUM, m_addnum);
	DDX_CBString(pDX, IDC_COMBO_ADDNAV, m_addnative);
	DDX_CBString(pDX, IDC_COMBO_RACE, m_addrace);
	//}}AFX_DATA_MAP





}


BEGIN_MESSAGE_MAP(CAddstuDlg, CDialog)
	//{{AFX_MSG_MAP(CAddstuDlg)
	ON_BN_CLICKED(IDC_BUTTON_REDO, OnButtonRedo)
	ON_BN_CLICKED(IDC_BUTTON_ADD, OnButtonAdd)
	ON_CBN_KILLFOCUS(IDC_COMBO_ADDCOLLAGE, OnKillfocusComboAddcollage)
	ON_CBN_SELCHANGE(IDC_COMBO_ADDCOLLAGE, OnSelchangeComboAddcollage)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddstuDlg message handlers

void CAddstuDlg::OnOK() 
{
	// TODO: Add extra validation here

}

void CAddstuDlg::OnButtonRedo() 
{
	// TODO: Add your control notification handler code here
	
}


void CAddstuDlg::OnButtonAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_addnum=="")
	{
		MessageBox("请输入学号!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}
	if(m_addnum.GetLength()!=12)
	{
		MessageBox("学号长度是12位,请检查输入!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}
	if(m_addname=="")
	{
		MessageBox("请输入姓名!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr;
	db.Open(rsstu.GetDefaultConnect());
	sqlstr="select * from stuinfo where stunum='"+m_addnum+"'";//修改SQL语句
	rs.Open(CRecordset::forwardOnly,sqlstr);
	if(!rs.IsBOF())
	{
		//记录已存在
		MessageBox("该学号记录已存在,请检查输入!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}

	CString addsql;
	CString m_birday=m_addbirthday.Format("%Y-%d-%d");
	CString m_enrolment=m_addenrolment.Format("%Y-%d-%d");
	addsql.Format("insert into stuinfo values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",m_addnum,m_addname,m_addsex,m_addrace,m_birday,m_enrolment,m_addnative,m_addcollage,m_addspc,m_addteam,m_addcon);
	CMainView::RunSQL(addsql);
	
	CDialog::OnOK();
	
}















void CAddstuDlg::OnKillfocusComboAddcollage() 
{
	// 学员队表
	CAddstuDlg::UpdateData(TRUE);
	for(int i=m_comboxteam.GetCount()-1;i>=0;i--)
		m_comboxteam.DeleteString(i);
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr,resul;
	sqlstr.Format("select teamname from teaminfo where belongcol = '%s'",m_addcollage);
	db.Open(rsstu.GetDefaultConnect());
		rs.Close();
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((int)0,resul);
		m_comboxteam.AddString(resul);
		rs.MoveNext();
	}
	rs.Close();


	//专业表
	for(i=m_comboxspc.GetCount()-1;i>=0;i--)
		m_comboxspc.DeleteString(i);
	sqlstr.Format("select spename from speinfo where belongcol = '%s'",m_addcollage);
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((int)0,resul);
		m_comboxspc.AddString(resul);
		rs.MoveNext();
	}
	rs.Close();


	
}



BOOL CAddstuDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//在这对对话框进行初始化,向组合框添加学院信息

	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr,resul;
	sqlstr="select * from colinfo";
	db.Open(rsstu.GetDefaultConnect());
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((int)0,resul);
		m_comboxcollage.AddString(resul);
		rs.MoveNext();
	}
	//时间赋初值
	CTime time1(1985,1,1,0,0,0);
	m_addbirthday=time1;
	CTime time2(2004,8,28,0,0,0);
	m_addenrolment=time2;
	//m_addenrolment=CTime::GetCurrentTime();//获取当前时间
	UpdateData(FALSE);

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CAddstuDlg::OnSelchangeComboAddcollage() 
{
	// TODO: Add your control notification handler code here



	
}