liutuidlg.cpp

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

// LiuTuiDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CLiuTuiDlg dialog


CLiuTuiDlg::CLiuTuiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLiuTuiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLiuTuiDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CLiuTuiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLiuTuiDlg)
	DDX_Control(pDX, IDC_LIST_TUI, m_tui);
	DDX_Control(pDX, IDC_LIST_LIU, m_liu);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CLiuTuiDlg message handlers

BOOL CLiuTuiDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_liu.SetExtendedStyle   (LVS_EX_FULLROWSELECT   |LVS_EX_GRIDLINES   |LVS_EX_INFOTIP);
	m_tui.SetExtendedStyle   (LVS_EX_FULLROWSELECT   |LVS_EX_GRIDLINES   |LVS_EX_INFOTIP);

    int  nWidth = 110 ;
    m_liu.InsertColumn( 0 , "学号" ,LVCFMT_LEFT,80 );
	m_liu.InsertColumn( 1 , "姓名" ,LVCFMT_LEFT,50 );
    m_tui.InsertColumn( 0 , "学号" ,LVCFMT_LEFT,80 );
	m_tui.InsertColumn( 1 , "姓名" ,LVCFMT_LEFT,50 );


	// TODO: Add extra initialization here
	// 统计留级退学学生名单
	UpdateData(TRUE);
	CDatabase db;
	CStuinfoSet rsstu;
	CRecordset rs(&db);
	CRecordset rscount(&db);
	CString sqlstr,resul;
	int i,j;
	db.Open(rsstu.GetDefaultConnect());
/*****************列出留级学生名单********************/	
	i=j=0;
	sqlstr.Format("select stunum,name from stuinfo");
	rs.Open(CRecordset::forwardOnly,sqlstr);
	while(!rs.IsEOF())
	{
		CString stunum,name;
		rs.GetFieldValue((int)0,stunum);
		rs.GetFieldValue((int)1,name);
		sqlstr.Format("select count(*) from scoreinfo where stunum='%s' and score<60",stunum);
		rscount.Open(CRecordset::forwardOnly,sqlstr);
		rscount.GetFieldValue((int)0,resul);
		i=atof(resul);
		if(i>=3&&i<5)
		{
			m_liu.InsertItem(j,stunum);
			m_liu.SetItemText(j,1,name);
		}
		if(i>=5)
		{
			m_tui.InsertItem(j,stunum);
			m_tui.SetItemText(j,1,name);
		}
		rscount.Close();
		rs.MoveNext();

	}

	rs.Close();	
	return TRUE;  
}