yhzcdlg.cpp

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

// YhzcDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StuManage.h"
#include "YhzcDlg.h"
#include "UserRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CYhzcDlg dialog


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


void CYhzcDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYhzcDlg)
	DDX_Control(pDX, IDC_USERPWD_EDIT, m_UserPwd);
	DDX_Control(pDX, IDC_USERNAME_EDIT, m_UserName);
	DDX_Control(pDX, IDC_CONFIRMPWD_EDIT, m_ConfirmPwd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYhzcDlg, CDialog)
	//{{AFX_MSG_MAP(CYhzcDlg)
	ON_BN_CLICKED(IDC_OK, OnOk)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYhzcDlg message handlers

void CYhzcDlg::OnOk() 
{
	// TODO: Add your control notification handler code here
	CEdit* pUsername=(CEdit*) this->GetDlgItem(IDC_USERNAME_EDIT);
    CEdit* pPassword=(CEdit*) this->GetDlgItem(IDC_USERPWD_EDIT);
	CEdit* pConfirm=(CEdit*) this->GetDlgItem(IDC_CONFIRMPWD_EDIT);
	//分别将文本框的值赋给4个字符串 
	CString username,password,confirmPassword;
	pUsername->GetWindowText(username);
	pPassword->GetWindowText(password);
	pConfirm->GetWindowText(confirmPassword);
	
	if(password!=confirmPassword) {
	    MessageBox("两次输入密码不一致，请重新输入新密码");
		pPassword->SetWindowText("");
		pConfirm->SetWindowText("");
		pPassword->SetFocus();
	}
	else {
		UpdateData(TRUE);
	    CString strSQL;
		int i=1;
	    int flag=0;
		while(!flag) {
			CUserRecordSet *m_UserRecordSet=new CUserRecordSet(&m_database);
		    strSQL.Format("select * from yhdl where UserID=%d",i);
			m_UserRecordSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			if(m_UserRecordSet->GetRecordCount()==0) {
		        strSQL.Format("insert into yhdl values(%d,\'%s\',\'%s\')",i,username,password);
		        m_database.ExecuteSQL(strSQL);
		        m_database.Close();
		        CDialog::OnOK();
		        flag=1;
			}
			i++;
		}
		CDialog::OnOK();
	}	
}

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