addspedlg.cpp

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

// AddspeDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CAddspeDlg dialog


CAddspeDlg::CAddspeDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddspeDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddspeDlg)
	m_spename = _T("");
	m_specol = _T("");
	m_speid = _T("");
	//}}AFX_DATA_INIT
}


void CAddspeDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddspeDlg)
	DDX_Control(pDX, IDC_COMBO_COL, m_comboxspecol);
	DDX_Text(pDX, IDC_EDIT_ADDSPENAME, m_spename);
	DDX_CBString(pDX, IDC_COMBO_COL, m_specol);
	DDX_Text(pDX, IDC_EDIT_SPEID, m_speid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddspeDlg, CDialog)
	//{{AFX_MSG_MAP(CAddspeDlg)
	ON_BN_CLICKED(IDC_BUTTON_ADDSPE, OnButtonAddspe)
	ON_CBN_SETFOCUS(IDC_COMBO_COL, OnSetfocusComboCol)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddspeDlg message handlers

void CAddspeDlg::OnButtonAddspe() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_specol=="")
	{
		MessageBox("请选择学院","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	if(m_spename=="")
	{
		MessageBox("请输入专业名称","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr;
	db.Open(rsstu.GetDefaultConnect());
	sqlstr="select * from speinfo where spename='"+m_spename+"'";//修改SQL语句
	rs.Open(CRecordset::forwardOnly,sqlstr);
	if(!rs.IsBOF())
	{
		//记录已存在
		MessageBox("记录已存在!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}


	CString addsql="";
	addsql.Format("insert into speinfo values ('%s','%s','%s')",m_speid,m_spename,m_specol);
	CMainView::RunSQL(addsql);
		MessageBox("专业信息添加成功","添加成功",MB_ICONINFORMATION|MB_OK);
	
}

void CAddspeDlg::OnSetfocusComboCol() 
{
	// TODO: Add your control notification handler code here

	for(int i=m_comboxspecol.GetCount()-1;i>=0;i--)
		m_comboxspecol.DeleteString(i);
	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_comboxspecol.AddString(resul);
		rs.MoveNext();
	}	
	
	
}

BOOL CAddspeDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_speid="10001";
	UpdateData(FALSE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}