photosetdialog.cpp

这是一个企业人力资源管理系统设计实例！比较实用！

// PhotoSetDialog.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "PhotoSetDialog.h"
#include "afxdb.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPhotoSetDialog dialog


CPhotoSetDialog::CPhotoSetDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CPhotoSetDialog::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPhotoSetDialog)
	m_address = _T("");
	m_email = _T("");
	m_mail = _T("");
	m_photonum = _T("");
	//}}AFX_DATA_INIT
}


void CPhotoSetDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPhotoSetDialog)
	DDX_Text(pDX, IDC_ADDRESS, m_address);
	DDX_Text(pDX, IDC_EMAIL, m_email);
	DDX_Text(pDX, IDC_MAIL, m_mail);
	DDX_Text(pDX, IDC_PHOTO, m_photonum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPhotoSetDialog, CDialog)
	//{{AFX_MSG_MAP(CPhotoSetDialog)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPhotoSetDialog message handlers

void CPhotoSetDialog::SelectSQL()
{
		
	CRecordset rs(&db);

	
	CString sql;
	sql.Format("select *  From address1 Where phone= %s",m_photonum);
	
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		MessageBox("查找结果不存在，请验证后从试");
		
	}
	
	if(!rs.IsEOF()) // 非空则获取员工信息
	{
		
		rs.GetFieldValue("phone",m_photonum); 
		rs.GetFieldValue("address",m_address); 
		rs.GetFieldValue("email",m_mail); 
		rs.GetFieldValue("youbian",m_email);
		
		
		
	}
	rs.Close();
    UpdateData(false);

}

BOOL CPhotoSetDialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	Old_photonum=m_photonum;
	SelectSQL();
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CPhotoSetDialog::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	CString sql;
	sql.Format("Delete from address1 Where phone=%s",Old_photonum);
    db.ExecuteSQL(sql);
	sql.Format("insert into address1 Values (%s,'%s','%s',%s)",m_photonum,m_address,m_mail,m_email);
	db.ExecuteSQL(sql);
	CDialog::OnOK();
}