testxxdlg.cpp

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

// TestxxDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StuManage.h"
#include "TestxxDlg.h"
#include "TestxxReset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTestxxDlg dialog


CTestxxDlg::CTestxxDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTestxxDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTestxxDlg)
	m_courseName = _T("");
	m_courseNo = _T("");
	m_courseTime = _T("");
	m_courseType = _T("");
	//}}AFX_DATA_INIT
}


void CTestxxDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTestxxDlg)
	DDX_Control(pDX, IDC_COURSE_LIST, m_courselist);
	DDX_Text(pDX, IDC_COURSENAME_EDIT, m_courseName);
	DDX_Text(pDX, IDC_COURSENO_EDIT, m_courseNo);
	DDX_Text(pDX, IDC_COURSETIME_EDIT, m_courseTime);
	DDX_Text(pDX, IDC_COURSETYPE_EDIT, m_courseType);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTestxxDlg, CDialog)
	//{{AFX_MSG_MAP(CTestxxDlg)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_DELETE_BUTTON, OnDeleteButton)
	ON_BN_CLICKED(IDC_SAVE_BUTTON, OnSaveButton)
	ON_BN_CLICKED(IDC_MODIFY_BUTTON, OnModifyButton)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTestxxDlg message handlers

BOOL CTestxxDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_courselist.InsertColumn(0,"考试编号");
	m_courselist.InsertColumn(1,"课程代号");
	m_courselist.InsertColumn(2,"课程名称");
	m_courselist.InsertColumn(3,"课程类型");
	m_courselist.InsertColumn(4,"考试时间");
	CRect rect;
	m_courselist.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	m_courselist.SetColumnWidth(0,wid/5);
    m_courselist.SetColumnWidth(1,wid/5);
	m_courselist.SetColumnWidth(2,wid/5);
	m_courselist.SetColumnWidth(3,wid/5);
	m_courselist.SetColumnWidth(4,wid/5);
	m_courselist.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	RefreshList();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTestxxDlg::RefreshList()
{
    if(!m_database.IsOpen()) {
		m_database.Open(_T("xscjgl"));
	}
	m_courselist.DeleteAllItems();
    CTestxxReset m_TestxxSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from kssz");
	m_database.ExecuteSQL(strSQL);
	m_TestxxSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_TestxxSet.GetRecordCount()!=0)
		m_TestxxSet.MoveFirst();
	int i=0;
	while(!m_TestxxSet.IsEOF()) {
		CString temp;
		m_TestxxSet.GetFieldValue("TestID",temp);
		m_courselist.InsertItem(i,temp);
		m_courselist.SetItemText(i,1,m_TestxxSet.m_CourseNo);
		m_courselist.SetItemText(i,2,m_TestxxSet.m_CourseName);
		m_courselist.SetItemText(i,3,m_TestxxSet.m_CourseType);
		m_courselist.SetItemText(i,4,m_TestxxSet.m_CourseTime);
		m_TestxxSet.MoveNext();
		i++;
	}
	m_TestxxSet.Close();
}

void CTestxxDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//m_database.Close();
	CTestxxReset m_TestxxSet;
	if(!UpdateData())
		return;
	if(m_courseNo.GetLength()==0) {
		MessageBox("请输入课程代号!");
	    return;
	}
	if(m_courseName.GetLength()==0) {
		MessageBox("请输入课程名称!");
		return;
	}
	CString strSQL;
	int flag=0;
	int i=1;
	while(!flag) {
		CTestxxReset m_TestxxSet(&m_database);
		strSQL.Format("select * from kssz where TestID=%d",i);
		m_TestxxSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(m_TestxxSet.GetRecordCount()==0) {
			strSQL.Format("insert into kssz values(%d,\'%s',\'%s',\'%s',\'%s')",i,m_courseNo,m_courseName,m_courseTime,m_courseType);
			m_database.ExecuteSQL(strSQL);
			m_TestxxSet.Close();
			m_database.Close();	
			RefreshList();
			flag=1;
		}
		i++;
	}
	//CDialog::OnOK();	
}

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

void CTestxxDlg::OnSaveButton() 
{
	// TODO: Add your control notification handler code here
	CTestxxReset m_TestxxSet(&m_database);
	m_TestxxSet.m_CourseNo=m_courseNo;
	m_TestxxSet.m_CourseName=m_courseName;
	m_TestxxSet.m_CourseType=m_courseType;
	m_TestxxSet.m_CourseTime=m_courseTime;
	m_TestxxSet.Close();
	RefreshList();
	CDialog::OnOK();
}

void CTestxxDlg::OnModifyButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CTestxxReset m_TestxxSet;
	CString strSQL;
	int flag=0;
	//int i=atoi(m_stuNo);
	while(!flag) {
		CTestxxReset m_TestxxSet(&m_database);
		strSQL.Format("update kssz set CourseName='%s',CourseTime='%s',CourseType='%s' where CourseNo='%s'",m_courseName,m_courseTime,m_courseType,m_courseNo);
		m_database.ExecuteSQL(strSQL);
		m_database.Close();	
		RefreshList();
		flag=1;	
	}
}

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