addmakeupdlg.cpp

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

// AddmakeupDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CAddmakeupDlg dialog


CAddmakeupDlg::CAddmakeupDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddmakeupDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddmakeupDlg)
	m_boxsub = _T("");
	m_date = 0;
	m_time = 0;
	m_address = _T("");
	//}}AFX_DATA_INIT
}


void CAddmakeupDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddmakeupDlg)
	DDX_Control(pDX, IDC_COMBO_SUB, m_comboxsub);
	DDX_CBString(pDX, IDC_COMBO_SUB, m_boxsub);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERDATE, m_date);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERTIME, m_time);
	DDX_Text(pDX, IDC_EDIT_ADDRESS, m_address);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CAddmakeupDlg message handlers

void CAddmakeupDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);


	if(m_boxsub=="")
	{
		MessageBox("请选择课程","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	if(m_address=="")
	{
		MessageBox("请输入补考地点","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr;
	db.Open(rsstu.GetDefaultConnect());
	sqlstr="select * from makeupinfo where subname='"+m_boxsub+"'";//修改SQL语句
	rs.Open(CRecordset::forwardOnly,sqlstr);
	if(!rs.IsBOF())
	{
		//记录已存在
		MessageBox("该课程补考信息已录入过,请检查记录!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}



	CString m_datas=m_date.Format("%Y-%d-%d");
	CString m_times=m_date.Format("%H:%M:%S");
	CString addsql="";
	addsql.Format("insert into makeupinfo values ('%s','%s','%s')",m_boxsub,m_address,m_datas+" "+m_times);
	CMainView::RunSQL(addsql);

	CDialog::OnOK();
}

BOOL CAddmakeupDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_date=CTime::GetCurrentTime();
	m_time=CTime::GetCurrentTime();

	UpdateData(FALSE);
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr,resul;
	sqlstr="select subname from subinfo";
	db.Open(rsstu.GetDefaultConnect());
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((int)0,resul);
		m_comboxsub.AddString(resul);
		rs.MoveNext();
	}		// TODO: Add extra initialization here
	
	return TRUE; 
}