addsubdg.cpp

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

// AddsubDg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CAddsubDg dialog


CAddsubDg::CAddsubDg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddsubDg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddsubDg)
	m_subname = _T("");
	m_date = _T("");
	m_belongspc = _T("");
	//}}AFX_DATA_INIT
}


void CAddsubDg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddsubDg)
	DDX_Control(pDX, IDC_STATIC_SPC, m_static);
	DDX_Control(pDX, IDC_COMBOSPC, m_combox);
	DDX_Text(pDX, IDC_EDIT_SUBNAME, m_subname);
	DDX_Text(pDX, IDC_EDIT_DATE, m_date);
	DDX_CBString(pDX, IDC_COMBOSPC, m_belongspc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddsubDg, CDialog)
	//{{AFX_MSG_MAP(CAddsubDg)
	ON_BN_CLICKED(IDC_RADIO_PLUBLIC, OnRadioPlublic)
	ON_BN_CLICKED(IDC_RADIO_SPECIL, OnRadioSpecil)
	ON_BN_CLICKED(IDC_BUTTON_ADD, OnButtonAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddsubDg message handlers

void CAddsubDg::OnRadioPlublic() 
{
	// TODO: Add your control notification handler code here
	m_combox.ShowWindow(SW_HIDE);
	m_static.ShowWindow(SW_HIDE);
	
}

void CAddsubDg::OnRadioSpecil() 
{
	// TODO: Add your control notification handler code here
	m_static.ShowWindow(SW_NORMAL);
	m_combox.ShowWindow(SW_NORMAL);


	
}

void CAddsubDg::OnButtonAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString sqlstr;
	if(m_subname=="")
	{
		MessageBox("请输入课程名称","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}

	if(IsDlgButtonChecked(IDC_RADIO_PLUBLIC))
	{
			CDatabase db;
			CStuinfoSet rsstu;
			CRecordset rs(&db);
			db.Open(rsstu.GetDefaultConnect());
			sqlstr="select * from subinfo where subname='"+m_subname+"'";//修改SQL语句
			rs.Open(CRecordset::forwardOnly,sqlstr);
			
			if(!rs.IsBOF())
			{
				//记录已存在
				MessageBox("该公共基础课记录已存在!","添加错误",MB_OK|MB_ICONSTOP);
				return;
			}
			rs.Close();
			sqlstr.Format("insert into subinfo values ('%s','公共基础课','%s','')",m_subname,m_date);
			
	}
	else if(IsDlgButtonChecked(IDC_RADIO_SPECIL))
	{
			if(m_belongspc=="")
			{
				MessageBox("请选择所属专业","添加错误",MB_ICONSTOP|MB_ICONSTOP);
				return;
			}
			CDatabase db;
			CStuinfoSet rsstu;
			CRecordset rs(&db);
			db.Open(rsstu.GetDefaultConnect());
			sqlstr="select subname from subinfo where subname='"+m_subname+"' and belongspc='"+m_belongspc+"'";//修改SQL语句
			rs.Open(CRecordset::forwardOnly,sqlstr);
			if(!rs.IsBOF())
			{
				//记录已存在
				MessageBox("该专业课记录已存在!","添加错误",MB_OK|MB_ICONSTOP);
				return;
			}
			rs.Close();
			sqlstr.Format("insert into subinfo values ('%s','专业课','%s','%s')",m_subname,m_date,m_belongspc);
	}

	CMainView::RunSQL(sqlstr);
		MessageBox("课程信息添加成功","添加成功",MB_ICONINFORMATION|MB_OK);

	
}

BOOL CAddsubDg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	((CButton*)GetDlgItem(IDC_RADIO_SPECIL))->SetCheck(TRUE);

	for(int i=m_combox.GetCount()-1;i>=0;i--)
		m_combox.DeleteString(i);
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr,resul;
	sqlstr="select spename from speinfo";
	db.Open(rsstu.GetDefaultConnect());
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((int)0,resul);
		m_combox.AddString(resul);
		rs.MoveNext();
	}	
	m_subname="";
	m_date="2004春";
	UpdateData(FALSE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}