infor.cpp

人事管理系统.SQL的数据库．所用密码和用户名均是５３１

// Infor.cpp : implementation file
//

#include "stdafx.h"
#include "people2.h"
#include "Infor.h"
#include "people.h"

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

/////////////////////////////////////////////////////////////////////////////
// CInfor dialog


CInfor::CInfor(CWnd* pParent /*=NULL*/)
	: CDialog(CInfor::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInfor)
	m_Age = _T("");
	m_Department = _T("");
	m_Departnum = _T("");
	m_Edulevel = _T("");
	m_Email = _T("");
	m_Remark = _T("");
	m_Phone = _T("");
	m_Number = _T("");
	m_Name = _T("");
	m_Job = _T("");
	m_Sex = _T("");
	m_Edit = _T("");
	//}}AFX_DATA_INIT
}


void CInfor::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInfor)
	DDX_Control(pDX, IDC_BUTTON1, m_select);
	DDX_Text(pDX, IDC_Age_EDIT, m_Age);
	DDX_Text(pDX, IDC_Department_EDIT, m_Department);
	DDX_Text(pDX, IDC_Departnum_EDIT, m_Departnum);
	DDX_Text(pDX, IDC_Edulevel_EDIT, m_Edulevel);
	DDX_Text(pDX, IDC_Email_EDIT, m_Email);
	DDX_Text(pDX, IDC_Remark_EDIT, m_Remark);
	DDX_Text(pDX, IDC_Phone_EDIT, m_Phone);
	DDX_Text(pDX, IDC_Number_EDIT, m_Number);
	DDX_Text(pDX, IDC_Name_EDIT, m_Name);
	DDX_Text(pDX, IDC_Job_EDIT, m_Job);
	DDX_CBString(pDX, IDC_COMBO, m_Sex);
	DDX_Text(pDX, IDC_EDIT1, m_Edit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CInfor, CDialog)
	//{{AFX_MSG_MAP(CInfor)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CInfor message handlers

void CInfor::HaveNumber(CString Number)
{//连接数据库
	PEOPLEConn m_PeopleConn;
	m_PeopleConn.OnInitPEOPLEConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL="SELECT *FROM 职工信息 WHERE PNumber='"+Number+"'";
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_PeopleConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
	{	
		MessageBox("编号不存在");
	}
	

		
			else {
		Cpeople p;
		p.GetData(m_Edit);
		m_Number=p.GetNumber();
		m_Age=p.GetAge();
		m_Email=p.GetEmail();
		m_Department=p.GetDepartment();
		m_Departnum=p.GetDepartnum();
		m_Sex=p.GetSex();
		m_Name=p.GetName();
		m_Edulevel=p.GetEdulevel();
		m_Job=p.GetJob();
		m_Phone=p.GetPhone();
		m_Remark=p.GetRemark();
		UpdateData(false);
	}
}

void CInfor::OnButton1() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_Edit=="")
		MessageBox("请输入您的个人编号");
	else{	HaveNumber(m_Edit);}
	
}