scoreinfo.cpp

成绩管理系统很小

// Scoreinfo.cpp : implementation file
//

#include "stdafx.h"
#include "员工成绩.h"
#include "Scoreinfo.h"
#include "ScoreSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScoreinfo dialog


CScoreinfo::CScoreinfo(CWnd* pParent /*=NULL*/)
	: CDialog(CScoreinfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScoreinfo)
	m_ygno = 0;
	m_kcno = 0;
	m_sksj = COleDateTime::GetCurrentTime();
	m_skdd = _T("");
	m_teacherno = 0;
	m_score1 = 0;
	m_score2 = 0;
	m_pingyu = _T("");
	m_pass = 0;
	//}}AFX_DATA_INIT
}


void CScoreinfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreinfo)
	DDX_Text(pDX, IDC_EDIT1, m_ygno);
	DDX_Text(pDX, IDC_EDIT2, m_kcno);
	DDX_Text(pDX, IDC_EDIT3, m_sksj);
	DDX_Text(pDX, IDC_EDIT4, m_skdd);
	DDX_Text(pDX, IDC_EDIT5, m_teacherno);
	DDX_Text(pDX, IDC_EDIT6, m_score1);
	DDX_Text(pDX, IDC_EDIT7, m_score2);
	DDX_Text(pDX, IDC_EDIT8, m_pingyu);
	DDX_Text(pDX, IDC_EDIT9, m_pass);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CScoreinfo message handlers

void CScoreinfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString strSQL;
	int i=1;
	int flag=0;
	while(!flag){
	CScoreSet m_recordset(&m_database);
	strSQL.Format("select * from SCORE where EMP_NO=%d",i);
    m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_recordset.GetRecordCount()==0){
	strSQL.Format("insert into SCORE values(%d,%d,\'%d-%d-%d\',\'%s\',%d,%d,%d,\'%s\',%d)",m_ygno,
		m_kcno,m_sksj.GetYear(),m_sksj.GetMonth(),m_sksj.GetDay(),m_skdd,m_teacherno,m_score1,m_score2,m_pingyu,m_pass);
	m_database.ExecuteSQL(strSQL);
	m_database.Close();
CDialog::OnOK();
flag=1;
	}
	i++;
	}
	CDialog::OnOK();
}