addinfodlg.cpp

一个通信录程序

// AddInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Address.h"
#include "AddInfoDlg.h"
#include "PersonSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddInfoDlg dialog


CAddInfoDlg::CAddInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddInfoDlg)
	m_name = _T("");
	m_hometelephone = _T("");
	m_handphone = _T("");
	m_address = _T("");
	m_workplace = _T("");
	m_email = _T("");
	m_oicq = _T("");
	m_sex = _T("");
	m_relation = _T("");
	//}}AFX_DATA_INIT
}


void CAddInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddInfoDlg)
	DDX_Control(pDX, IDC_EDIT1, m_ctrlname);
	DDX_Control(pDX, IDC_EDIT7, m_ctrloicq);
	DDX_Control(pDX, IDC_COMBO1, m_ctrlsex);
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDV_MaxChars(pDX, m_name, 10);
	DDX_Text(pDX, IDC_EDIT2, m_hometelephone);
	DDV_MaxChars(pDX, m_hometelephone, 20);
	DDX_Text(pDX, IDC_EDIT3, m_handphone);
	DDV_MaxChars(pDX, m_handphone, 20);
	DDX_Text(pDX, IDC_EDIT4, m_address);
	DDV_MaxChars(pDX, m_address, 50);
	DDX_Text(pDX, IDC_EDIT5, m_workplace);
	DDV_MaxChars(pDX, m_workplace, 50);
	DDX_Text(pDX, IDC_EDIT6, m_email);
	DDV_MaxChars(pDX, m_email, 30);
	DDX_Text(pDX, IDC_EDIT7, m_oicq);
	DDV_MaxChars(pDX, m_oicq, 20);
	DDX_CBString(pDX, IDC_COMBO1, m_sex);
	DDV_MaxChars(pDX, m_sex, 5);
	DDX_Text(pDX, IDC_EDIT8, m_relation);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CAddInfoDlg)
	ON_BN_CLICKED(IDC_RESET_BUTTON, OnResetButton)
	ON_BN_CLICKED(IDC_EXIT_BUTTON, OnExitButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddInfoDlg message handlers


/////////////////////////////////////////////////////////////////////////
//名称：OnOk
//功能：确认记录录入
//作者：赵权([e-mail])
//日期：2003.12
////////////////////////////////////////////////////////////////////////
void CAddInfoDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);//得到输入的内容
	CString strSQL,strchkSQL;
	int i=1;
	int flag=0;
	//从主码为1开始在数据库的相应表中搜索，如果找到记录，则主码值加1，直到数据库中
	//无该主码值对应的记录，则将该主码值分配给新的记录
	if(!m_name.IsEmpty())//如果姓名填写了
	{
		while(!flag)
		{
			CPersonSet m_recordset(&m_database);
			strSQL.Format("select * from person where ID=%d",i);
			m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			if(m_recordset.GetRecordCount()==0)
			{
				strSQL.Format("insert into person values(%d,'%s','%s','%s','%s','%s','%s','%s','%s','%s')"
				,i,m_name,m_sex,m_relation,m_hometelephone,m_handphone,m_address,m_workplace,m_email,m_oicq);
				m_database.ExecuteSQL(strSQL);
				m_database.Close();
				CDialog::OnOK();
				flag=1;
			}
			i++;		
		}
	}
	else//如果姓名项为空
	{
		MessageBox("“姓名”项一定要填写！","提示",MB_OK|MB_ICONINFORMATION);
		m_ctrlname.SetFocus();
	}
	//CDialog::OnOK();
}


/////////////////////////////////////////////////////////////////////////
//名称：OnResetButton
//功能：清空编辑框中的数据
//作者：赵权([e-mail])
//日期：2003.12
////////////////////////////////////////////////////////////////////////
void CAddInfoDlg::OnResetButton() 
{
	// TODO: Add your control notification handler code here
	m_address.Empty();
	m_email.Empty();
	m_handphone.Empty();
	m_hometelephone.Empty();
	m_name.Empty();
	m_oicq.Empty();
	m_workplace.Empty();
	m_sex.Empty();
	m_relation.Empty();
	UpdateData(FALSE);
}


/////////////////////////////////////////////////////////////////////////
//名称：OnInitDialog
//功能：初始化对话框
//作者：赵权([e-mail])
//日期：2003.12
////////////////////////////////////////////////////////////////////////
BOOL CAddInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_ctrlsex.SetCurSel(0);//设置组合框的默认选项为"男"
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


/////////////////////////////////////////////////////////////////////////
//名称：OnExitButton
//功能：退出记录录入对话框
//作者：赵权([e-mail])
//日期：2003.12
////////////////////////////////////////////////////////////////////////
void CAddInfoDlg::OnExitButton() 
{
	// TODO: Add your control notification handler code here
	m_database.Close();
	CAddInfoDlg::OnCancel();
}