//?addxinxi.cpp?:?implementation?file
//

#include?“stdafx.h“
#include?“caozuo.h“
#include?“addxinxi.h“
#include?“caozuoDlg.h“
#include?“Adosql.h“

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

Adosql?sql;
/////////////////////////////////////////////////////////////////////////////
//?addxinxi?dialog

addxinxi::addxinxi（CWnd*?pParent?/*=NULL*/）
	:?CDialog（addxinxi::IDD?pParent）
{
	//{{AFX_DATA_INIT（addxinxi）
	//}}AFX_DATA_INIT
}


void?addxinxi::DoDataExchange（CDataExchange*?pDX）
{
	CDialog::DoDataExchange（pDX）;
	//{{AFX_DATA_MAP（addxinxi）
	DDX_Control（pDX?IDC_EDIT9_fax?m_fax）;
	DDX_Control（pDX?IDC_EDIT8_mp?m_mp）;
	DDX_Control（pDX?IDC_EDIT7_gh?m_gh）;
	DDX_Control（pDX?IDC_EDIT6_gongzi?m_gongzi）;
	DDX_Control（pDX?IDC_EDIT5_job?m_job）;
	DDX_Control（pDX?IDC_EDIT4_nianling?m_nianling）;
	DDX_Control（pDX?IDC_EDIT3_xingbie?m_xingbie）;
	DDX_Control（pDX?IDC_EDIT2_xingming?m_xingming）;
	DDX_Control（pDX?IDC_EDIT11_dizhi?m_dizhi）;
	DDX_Control（pDX?IDC_EDIT10_EQQ?m_EQQ）;
	DDX_Control（pDX?IDC_EDIT1_bianhao?m_bianhao）;
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP（addxinxi?CDialog）
	//{{AFX_MSG_MAP（addxinxi）
	//}}AFX_MSG_MAP
END_MESSAGE_MAP（）

/////////////////////////////////////////////////////////////////////////////
//?addxinxi?message?handlers

void?addxinxi::OnOK（）?
{
	//?TODO:?Add?extra?validation?here
	try
	{
		_variant_t?RecordsAffected;
		CString?sno;
		CString?sname;
		CString?sex;
		CString?sage;
		CString?sjob;
		CString?sgz;
		CString?sgh;
		CString?smp;
		CString?sfa;
		CString?seq;
		CString?sad;

		_bstr_t?Insert;

		m_bianhao.GetWindowText（sno）;
		m_xingming.GetWindowText（sname）;
		m_nianling.GetWindowText（sage）;
		m_xingbie.GetWindowText（sex）;
		m_job.GetWindowText（sjob）;
		m_gongzi.GetWindowText（sgz）;
		m_gh.GetWindowText（sgh）;
		m_mp.GetWindowText（smp）;
		m_fax.GetWindowText（sfa）;
		m_EQQ.GetWindowText（seq）;
		m_dizhi.GetWindowText（sad）;//（編號(hào)姓名?*性別年齡工作崗位工資（月）固定電話移動(dòng)電話?*傳真Email/QQ居住地址）
			
		Insert?=?“Insert?into?userlist?values（‘“+sno+“‘‘“+sname+“‘‘“+sex+“‘‘“+sage+“‘‘“+sjob+“‘\
			‘“+sgz+?“‘‘“+sgh+“‘?‘“+smp+“‘?‘“+sfa+?“‘‘“+seq+“‘‘“+sad+“‘）“;
		psql->m_pRecordset?=?psql->m_pConnection->Execute（Insert?&RecordsAffected?adCmdText）;
		AfxMessageBox（“添加成功！“）;
		
		//清空輸入框
		m_bianhao.SetSel（0-1）;
		m_bianhao.Clear（）;
		m_xingming.SetSel（0-1）;
		m_xingming.Clear（）;
		m_nianling.SetSel（0-1）;
		m_nianling.Clear（）;
		m_xingbie.SetSel（0-1）;
		m_xingbie.Clear（）;
		m_job.SetSel（0-1）;
		m_job.Clear（）;
		m_gongzi.SetSel（0-1）;
		m_gongzi.Clear（）;
		m_gh.SetSel（0-1）;
		m_gh.Clear（）;
		m_mp.SetSel（0-1）;
		m_mp.Clear（）;
		m_fax.SetSel（0-1）;
		m_fax.Clear（）;
		m_EQQ.SetSel（0-1）;
		m_EQQ.Clear（）;
		m_dizhi.SetSel（0-1）;
		m_dizhi.Clear（）;
	}
	catch?（_com_error?e）
	{
		CString?errormessage;
		errormessage.Format（“添加失敗!\r\n錯(cuò)誤信息:%s“?e.ErrorMessage（）

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-11-08?17:34??查找、增加、刪除?修改\
?????目錄???????????0??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\
?????文件????????3121??2012-09-24?22:28??查找、增加、刪除?修改\caozuo\addxinxi.cpp
?????文件????????1365??2012-09-23?22:15??查找、增加、刪除?修改\caozuo\addxinxi.h
?????文件????????1096??2012-09-26?10:22??查找、增加、刪除?修改\caozuo\Adosql.cpp
?????文件?????????654??2012-09-21?22:52??查找、增加、刪除?修改\caozuo\Adosql.h
?????文件???????26000??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\caozuo.aps
?????文件????????4694??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\caozuo.clw
?????文件????????2096??2012-09-22?19:57??查找、增加、刪除?修改\caozuo\caozuo.cpp
?????文件????????4656??2012-09-24?11:55??查找、增加、刪除?修改\caozuo\caozuo.dsp
?????文件?????????520??2012-09-21?18:07??查找、增加、刪除?修改\caozuo\caozuo.dsw
?????文件????????1393??2012-09-21?20:25??查找、增加、刪除?修改\caozuo\caozuo.h
?????文件??????345088??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\caozuo.ncb
?????文件???????54784??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\caozuo.opt
?????文件????????1288??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\caozuo.plg
?????文件???????10433??2012-09-25?00:34??查找、增加、刪除?修改\caozuo\caozuo.rc
?????文件????????8059??2012-09-26?10:23??查找、增加、刪除?修改\caozuo\caozuoDlg.cpp
?????文件????????1468??2012-09-24?11:49??查找、增加、刪除?修改\caozuo\caozuoDlg.h
?????目錄???????????0??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\
?????文件???????58435??2012-09-24?22:28??查找、增加、刪除?修改\caozuo\Debug\addxinxi.obj
?????文件???????40793??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\Adosql.obj
?????文件??????155746??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\caozuo.exe
?????文件?????1049320??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\caozuo.ilk
?????文件???????16590??2012-09-23?00:05??查找、增加、刪除?修改\caozuo\Debug\caozuo.obj
?????文件?????7769344??2012-09-21?22:52??查找、增加、刪除?修改\caozuo\Debug\caozuo.pch
?????文件??????648192??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\caozuo.pdb
?????文件????????4960??2012-09-26?10:17??查找、增加、刪除?修改\caozuo\Debug\caozuo.res
?????文件???????96648??2012-11-21?17:24??查找、增加、刪除?修改\caozuo\Debug\caozuoDlg.obj
?????文件???????76486??2012-09-25?00:12??查找、增加、刪除?修改\caozuo\Debug\Delete.obj
?????文件???????90772??2012-06-06?13:09??查找、增加、刪除?修改\caozuo\Debug\msado15.tlh
?????文件???????76693??2012-06-06?13:09??查找、增加、刪除?修改\caozuo\Debug\msado15.tli
............此處省略18個(gè)文件信息