// RegisterDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MenuManage.h"
#include "RegisterDlg.h"

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

extern CMenuManageApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CRegisterDlg dialog


CRegisterDlg::CRegisterDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRegisterDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRegisterDlg)
	m_strUserName = _T("");
	m_strUserNative = _T("");
	m_nUserNum = 0;
	m_strUserPwd = _T("");
	m_strUserPwdAgain = _T("");
	m_nUserSex = 0;
	m_strUserAdddress = _T("");
	m_nUserAge = 0;
	//}}AFX_DATA_INIT
}


void CRegisterDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRegisterDlg)
	DDX_Text(pDX, IDC_EDIT_USERNAME, m_strUserName);
	DDX_Text(pDX, IDC_EDIT_USERNATIVE, m_strUserNative);
	DDX_Text(pDX, IDC_EDIT_USERNUM, m_nUserNum);
	DDX_Text(pDX, IDC_EDIT_USERPWD, m_strUserPwd);
	DDX_Text(pDX, IDC_EDIT_USERPWD_AGAIN, m_strUserPwdAgain);
	DDX_Radio(pDX, IDC_MALE, m_nUserSex);
	DDX_Text(pDX, IDC_EDIT_USERADDRESS, m_strUserAdddress);
	DDX_Text(pDX, IDC_EDIT_USERAGE, m_nUserAge);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRegisterDlg, CDialog)
	//{{AFX_MSG_MAP(CRegisterDlg)
	ON_BN_CLICKED(ID_REGISTER_BTN, OnRegisterBtn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRegisterDlg message handlers

void CRegisterDlg::OnRegisterBtn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(!m_strUserName.IsEmpty() && !m_strUserNative.IsEmpty() &&!m_strUserAdddress.IsEmpty() &&!m_strUserPwd.IsEmpty()&&
	!m_strUserPwdAgain.IsEmpty() && m_nUserNum != 0 &&m_nUserAge != 0)
	{
		if(m_strUserPwd.CompareNoCase(m_strUserPwdAgain) != 0  )
		{
			MessageBox("密碼有誤，請重新輸入密碼。","系統注冊");
		}
		else
		{
			try
			{
				m_pRecordset.CreateInstance("ADODB.Recordset");
				m_pRecordset->Open("SELECT * FROM UserInfo",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
				
			}
			catch(_com_error e)///捕捉異常
			{
				CString temp;
				temp.Format("連接數據庫錯誤信息:%s",e.ErrorMessage());
				AfxMessageBox(temp);
				return;
			}
			
			m_pRecordset->AddNew();
			//UserName---UserNum---UserPwd---UserLevel---UserSex---UserAge---UserNative---UserAddress//
			m_pRecordset->PutCollect("UserName",_variant_t(m_strUserName));
			m_pRecordset->PutCollect("UserPwd",_variant_t(m_strUserPwd));	
			m_pRecordset->PutCollect("UserNative",_variant_t(m_strUserNative));
			m_pRecordset->PutCollect("UserAddress",_variant_t(m_strUserAdddress));
			
			CString str;
			str.Format("%d",m_nUserNum);
			m_pRecordset->PutCollect("UserNum",_variant_t(str));
			str.Format("%d",m_nUserSex);
			m_pRecordset->PutCollect("UserSex",_variant_t(str));
			str.Format("%d",m_nUserAge);
			m_pRecordset->PutCollect("UserAge",_variant_t(str));
			
			m_pRecordset->Update();				
			m_pRecordset->Close(); 
			m_pRecordset = NULL; 
			
			MessageBox("恭喜您注冊成功","系統注冊");
			
			CDialog::OnOK();
			return;
		}
	}
	else
	{
		MessageBox("請輸入完整注冊信息","系統注冊");
	}
	
}