addteamdlg.cpp

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

// AddteamDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CAddteamDlg dialog


CAddteamDlg::CAddteamDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddteamDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddteamDlg)
	m_teamname = _T("");
	m_collage = _T("");
	m_adddata = 0;
	//}}AFX_DATA_INIT
}


void CAddteamDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddteamDlg)
	DDX_Control(pDX, IDC_DATETIMEPICKER, m_Timepicker);
	DDX_Control(pDX, IDC_COMBO_COL, m_combo_col);
	DDX_Text(pDX, IDC_EDIT_ADDTEAMNAME, m_teamname);
	DDX_CBString(pDX, IDC_COMBO_COL, m_collage);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER, m_adddata);
	//}}AFX_DATA_MAP
		//在这对对话框进行初始化,向组合框添加学院信息


}


BEGIN_MESSAGE_MAP(CAddteamDlg, CDialog)
	//{{AFX_MSG_MAP(CAddteamDlg)
	ON_BN_CLICKED(IDC_BUTTON_ADDTEAM, OnButtonAddteam)
	ON_CBN_SETFOCUS(IDC_COMBO_COL, OnSetfocusComboCol)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddteamDlg message handlers

void CAddteamDlg::OnButtonAddteam() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_collage=="")
	{
		MessageBox("请选择学院","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	if(m_teamname=="")
	{
		MessageBox("请输入学员队名称","添加错误",MB_ICONSTOP|MB_ICONSTOP);
		return;
	}
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CString sqlstr;
	db.Open(rsstu.GetDefaultConnect());
	sqlstr="select * from teaminfo where teamname='"+m_teamname+"' and belongcol='"+m_collage+"'";//修改SQL语句
	rs.Open(CRecordset::forwardOnly,sqlstr);
	if(!rs.IsBOF())
	{
		//记录已存在
		MessageBox("记录已存在!","添加错误",MB_OK|MB_ICONSTOP);
		return;
	}


	CString m_data=m_adddata.Format("%Y-%d-%d");
	CString addsql;
	addsql.Format("insert into teaminfo values ('%s','%s','%s')",m_data,m_teamname,m_collage);
	CMainView::RunSQL(addsql);
	MessageBox("学员队信息添加成功","添加成功",MB_ICONINFORMATION|MB_OK);

	
}

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

}

BOOL CAddteamDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_adddata=CTime::GetCurrentTime();
	UpdateData(FALSE);
	for(int i=m_combo_col.GetCount()-1;i>=0;i--)
		m_combo_col.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_combo_col.AddString(resul);
		rs.MoveNext();
	}	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}