dlgchakan.cpp

用Ｖｉｓｕａｌ ｃ＋＋写

// DlgChakan.cpp : implementation file
//

#include "stdafx.h"
#include "mining.h"
#include "DlgChakan.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgChakan dialog


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


void CDlgChakan::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgChakan)
	DDX_Control(pDX, IDC_LIST1, m_listctl);
	DDX_Control(pDX, IDC_COMBO1, m_combo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgChakan, CDialog)
	//{{AFX_MSG_MAP(CDlgChakan)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgChakan message handlers

BOOL CDlgChakan::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CString	chengjiName,xueshengName;
	m_chengjiRec.Open(AFX_DB_USE_DEFAULT_TYPE,"SELECT * FROM 学校成绩表");
	m_xueshengRec.Open(AFX_DB_USE_DEFAULT_TYPE,"SELECT * FROM 过级成绩表");
	chengjiName=m_chengjiRec.GetTableName();
	xueshengName=m_xueshengRec.GetTableName();
	
	m_combo.AddString(chengjiName.GetBuffer(10));
	m_combo.AddString(xueshengName.GetBuffer(10));
	m_combo.SetCurSel(0);
	chengjiName.ReleaseBuffer();
	xueshengName.ReleaseBuffer();
	ShowList(0);
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgChakan::OnSelchangeCombo1() 
{
	int nIndex;
	nIndex=m_combo.GetCurSel();
	if(m_oldIndex==nIndex)
		return;
	m_listctl.DeleteAllItems();
	m_listctl.DeleteColumn(0);
	m_listctl.DeleteColumn(0);
	m_listctl.DeleteColumn(0);
	m_listctl.DeleteColumn(0);
	
	ShowList(nIndex);
}



void CDlgChakan::ShowList(int nIndex)
{
	
	m_oldIndex=nIndex;
	m_listctl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	if(nIndex==0)
	{
		
		m_listctl.InsertColumn(0,_T("学号"),LVCFMT_LEFT);
		m_listctl.InsertColumn(1,_T("教学机时"));
		m_listctl.InsertColumn(2,_T("自由机时"));
		m_listctl.InsertColumn(3,_T("期末成绩"));

		//设置列的宽度
		for(int j=0;j<4;j++)
		{
			m_listctl.SetColumnWidth(j ,90);
		}

		int i=0;
		m_chengjiRec.MoveFirst();
		do
		{  
			CString s;
			m_listctl.InsertItem(i,m_chengjiRec.m_column1,0);
			s.Format("%d",(int)m_chengjiRec.m_column2);
			m_listctl.SetItemText(i,1,s);
			s.Format("%d",(int)m_chengjiRec.m_column3);
			m_listctl.SetItemText(i,2,s);
			s.Format("%d",(int)m_chengjiRec.m_column4);
			m_listctl.SetItemText(i,3,s);
			i++;
			m_chengjiRec.MoveNext();
		
		} while(!m_chengjiRec.IsEOF());
        m_chengjiRec.MoveFirst();
	}
	else
		if(nIndex==1)
		{
			m_listctl.InsertColumn(0,_T("学号"),LVCFMT_IMAGE|LVCFMT_LEFT);
			m_listctl.InsertColumn(1,_T("姓名"));
			m_listctl.InsertColumn(2,_T("专业"));
			m_listctl.InsertColumn(3,_T("过级成绩"));

			//设置列的宽度
			for(int j=0;j<4;j++)
			{
				m_listctl.SetColumnWidth(j ,90);
			}

			int i=0;
			m_xueshengRec.MoveFirst();
			do
			{  
				CString s;
				m_listctl.InsertItem(i,m_xueshengRec.m_column1,0);
				m_listctl.SetItemText(i,1,m_xueshengRec.m_column2);
				m_listctl.SetItemText(i,2,m_xueshengRec.m_column3);
				s.Format("%d",(int)m_xueshengRec.m_column4);
				m_listctl.SetItemText(i,3,s);
				i++;
				m_xueshengRec.MoveNext();
		
			} while(!m_xueshengRec.IsEOF());
			m_xueshengRec.MoveFirst();
		}


}

void CDlgChakan::OnClose() 
{
	m_chengjiRec.Close();
	m_xueshengRec.Close();
	CDialog::OnClose();
}