cjhzdlg.cpp

学生成绩管理系统,实现增加删除修改保存等功能

// CjhzDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StuManage.h"
#include "CjhzDlg.h"
#include "CjhzSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCjhzDlg dialog


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


void CCjhzDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCjhzDlg)
	DDX_Control(pDX, IDC_CJHZ_LIST, m_cjhzList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCjhzDlg, CDialog)
	//{{AFX_MSG_MAP(CCjhzDlg)
	ON_BN_CLICKED(IDC_SHOW_BUTTON, OnShowButton)
	ON_BN_CLICKED(IDC_DELETE_BUTTON, OnDeleteButton)
	ON_BN_CLICKED(IDC_SAVE_BUTTON, OnSaveButton)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	ON_BN_CLICKED(IDC_PRINT_BUTTON, OnPrintButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCjhzDlg message handlers

BOOL CCjhzDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_cjhzList.InsertColumn(0,"课程编号");
	m_cjhzList.InsertColumn(1,"课程名称");
	m_cjhzList.InsertColumn(2,"总成绩");
	m_cjhzList.InsertColumn(3,"平均成绩");
	m_cjhzList.InsertColumn(4,"及格人数");
	m_cjhzList.InsertColumn(5,"不及格人数");
	m_cjhzList.InsertColumn(6,"缺考人数");
	CRect rect;
	m_cjhzList.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	m_cjhzList.SetColumnWidth(0,wid/7);
    m_cjhzList.SetColumnWidth(1,wid/7);
	m_cjhzList.SetColumnWidth(2,wid/7);
	m_cjhzList.SetColumnWidth(3,wid/7);
	m_cjhzList.SetColumnWidth(4,wid/7);
	m_cjhzList.SetColumnWidth(5,wid/7);
	m_cjhzList.SetColumnWidth(6,wid/7);
	m_cjhzList.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCjhzDlg::OnShowButton() 
{
	// TODO: Add your control notification handler code here
	
    if(!m_database.IsOpen()) {
		m_database.Open(_T("xscjgl"));
	}
	m_cjhzList.DeleteAllItems();
    CCjhzSet m_CjhzSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from cjhz");
	m_database.ExecuteSQL(strSQL);
	m_CjhzSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_CjhzSet.GetRecordCount()!=0)
		m_CjhzSet.MoveFirst();
	int i=0;
	while(!m_CjhzSet.IsEOF()) {
		CString temp;
		m_CjhzSet.GetFieldValue("CourseNo",temp);
		m_cjhzList.InsertItem(i,temp);
		m_cjhzList.SetItemText(i,1,m_CjhzSet.m_CourseName);
		m_cjhzList.SetItemText(i,2,m_CjhzSet.m_TotalScore);
		m_cjhzList.SetItemText(i,3,m_CjhzSet.m_AvgScore);
		m_cjhzList.SetItemText(i,4,m_CjhzSet.m_PassNum);
		m_cjhzList.SetItemText(i,5,m_CjhzSet.m_NotPassNum);
		m_cjhzList.SetItemText(i,6,m_CjhzSet.m_Absence);
		m_CjhzSet.MoveNext();
		i++;
	}
	m_CjhzSet.Close();
}

void CCjhzDlg::OnCancel() 
{
	// TODO: Add your control notification handler code here
	OnOK();
}

void CCjhzDlg::OnDeleteButton() 
{
	// TODO: Add your control notification handler code here
	CCjhzSet m_CjhzSet;
	int i=m_cjhzList.GetSelectionMark();
	CString strSQL;
    int keyid=atoi(m_cjhzList.GetItemText(i,0));
	if(keyid<0) {
		MessageBox("请选择您要删除的一行！");
	}
	else {
		if(MessageBox("您确定要删除该记录吗?","是否删除",MB_OKCANCEL|MB_ICONQUESTION)==IDOK) {
			strSQL.Format("delete from cjhz where CourseNo='%d'",keyid);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
		}
	}
}

void CCjhzDlg::OnSaveButton() 
{
	// TODO: Add your control notification handler code here
	MessageBox("保存完毕");
	CDialog::OnOK();
}

void CCjhzDlg::OnPrintButton() 
{
	// TODO: Add your control notification handler code here
	MessageBox("该功能善未完善!");
}