scoredlg.cpp

这是一个课程设计

// ScoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Scoremanager.h"
#include "ScoreDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScoreDlg dialog


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


void CScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreDlg)
	DDX_Control(pDX, IDC_LIST_SCORE, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScoreDlg, CDialog)
	//{{AFX_MSG_MAP(CScoreDlg)
	ON_BN_CLICKED(ID_SCORE_EDIT, OnScoreEdit)
	ON_BN_CLICKED(ID_SCORE_DEL, OnScoreDel)
	ON_BN_CLICKED(ID_SCORE_ADD, OnScoreAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CScoreDlg message handlers

BOOL CScoreDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
        if(!m_database.IsOpen())
        {
            m_database.Open(_T("Scoremanager"));
            m_recordSet.m_pDatabase=&m_database;
		}
              
	m_list.InsertColumn(0,"学生号");
    m_list.InsertColumn(1,"学生名");
    m_list.InsertColumn(2,"课程号");
    m_list.InsertColumn(3,"课程名");
    m_list.InsertColumn(4,"平时成绩");
    m_list.InsertColumn(5,"考试成绩");
	m_list.InsertColumn(6,"总成绩");
    
	RECT rectList;
	m_list.GetWindowRect(&rectList);
	int wid=rectList.right-rectList.left-4;
	for(int i=0;i<7;i++)
	m_list.SetColumnWidth(i,wid/7);
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	RefreshList();
        return true;
}


void CScoreDlg::RefreshList()
{
m_list.DeleteAllItems();
CString strSQL;
strSQL.Format("select* from student,course,score  where student.student_no=score.student_no and course.course_no=score.course_no and score.active_status='Y'");
m_recordSet.Open(CRecordset::forwardOnly,strSQL);
for(int i=0;i<m_recordSet.GetRecordCount();i++)
{
CString temp;
m_recordSet.GetFieldValue("student_no",temp);
m_list.InsertItem(i,temp); 
m_recordSet.GetFieldValue("student_name",temp);
m_list.SetItemText(i,1,temp);
m_recordSet.GetFieldValue("course_no",temp);
m_list.SetItemText(i,2,temp);  
m_recordSet.GetFieldValue("course_name",temp);
m_list.SetItemText(i,3,temp);
m_recordSet.GetFieldValue("score_peacetime",temp);

int a;
a=atoi(temp);
m_list.SetItemText(i,4,temp);
m_recordSet.GetFieldValue("score_exam",temp);
int b;
b=atoi(temp);
m_list.SetItemText(i,5,temp);
int c=a*0.3+b*0.7;
temp.Format("%d",   c); 
m_list.SetItemText(i,6,temp);
m_recordSet.MoveNext();
}
m_recordSet.Close();	
RefreshList();
}

void CScoreDlg::OnScoreEdit() 
{


}

void CScoreDlg::OnScoreDel() 
{
 int row=m_list.GetSelectionMark();
 CString s=m_list.GetItemText(row,0);
 CString s1=m_list.GetItemText(row,2);
   if(s=="")
       MessageBox("请选择");
   else
   {  
	   if(MessageBox("确定要删除该记录吗？","删除询问",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)	
	   {
	   CString strSQL;
	   strSQL.Format("update score set active_status='N' where student_no=%s and course_no=%s",s,s1);
	   m_database.ExecuteSQL(strSQL);
	   }
   }
   RefreshList();
}


void CScoreDlg::OnCancel() 
{
	
	CDialog::OnCancel();
}

void CScoreDlg::OnScoreAdd() 
{
	// TODO: Add your control notification handler code here
	
}