resume2page.cpp

是老板让做的一个招聘网站后台简历录入系统。可以支持照片上传

// Resume2Page.cpp : implementation file
//

#include "stdafx.h"
#include "ResumeManagement.h"
#include "Resume2Page.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#include "findresume.h"
/////////////////////////////////////////////////////////////////////////////
// CResume2Page property page

IMPLEMENT_DYNCREATE(CResume2Page, CPropertyPage)

CResume2Page::CResume2Page() : CPropertyPage(CResume2Page::IDD)
{
	//{{AFX_DATA_INIT(CResume2Page)
	m_formerCompanyname1 = _T("");
	m_formerCompanyname2 = _T("");
	m_jobDescribe1 = _T("");
	m_jobDescribe2 = _T("");
	m_jobPlace = _T("");
	m_plannedJob1 = _T("");
	m_plannedJob2 = _T("");
	m_plannedJob3 = _T("");
	m_plannedSalary = _T("");
	m_role1 = _T("");
	m_role2 = _T("");
	m_whatToDo = _T("");
	m_workExperiencedateBegin1 = COleDateTime::GetCurrentTime();
	m_workExperiencedateBegin2 = COleDateTime::GetCurrentTime();
	m_workExperiencedateEnd1 = COleDateTime::GetCurrentTime();
	m_workExperiencedateEnd2 = COleDateTime::GetCurrentTime();
	path = "";
	name = "";
	//}}AFX_DATA_INIT
}

CResume2Page::~CResume2Page()
{
}

void CResume2Page::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResume2Page)
	DDX_Text(pDX, IDC_formerCompanyname1, m_formerCompanyname1);
	DDX_Text(pDX, IDC_formerCompanyname2, m_formerCompanyname2);
	DDX_Text(pDX, IDC_jobDescribe1, m_jobDescribe1);
	DDX_Text(pDX, IDC_jobDescribe2, m_jobDescribe2);
	DDX_Text(pDX, IDC_jobPlace, m_jobPlace);
	DDX_Text(pDX, IDC_plannedJob1, m_plannedJob1);
	DDX_Text(pDX, IDC_plannedJob2, m_plannedJob2);
	DDX_Text(pDX, IDC_plannedJob3, m_plannedJob3);
	DDX_Text(pDX, IDC_plannedSalary, m_plannedSalary);
	DDX_Text(pDX, IDC_role1, m_role1);
	DDX_Text(pDX, IDC_role2, m_role2);
	DDX_Text(pDX, IDC_whatToDo, m_whatToDo);
	DDX_DateTimeCtrl(pDX, IDC_workExperiencedateBegin1, m_workExperiencedateBegin1);
	DDX_DateTimeCtrl(pDX, IDC_workExperiencedateBegin2, m_workExperiencedateBegin2);
	DDX_DateTimeCtrl(pDX, IDC_workExperiencedateEnd1, m_workExperiencedateEnd1);
	DDX_DateTimeCtrl(pDX, IDC_workExperiencedateEnd2, m_workExperiencedateEnd2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResume2Page, CPropertyPage)
	//{{AFX_MSG_MAP(CResume2Page)
	ON_BN_CLICKED(IDC_FINDDOC, OnFinddoc)
	ON_BN_CLICKED(IDC_DOWNLOAD, OnDownload)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResume2Page message handlers
#include "ResumeSheet.h"
#include "resumeinfo.h"
extern CResumeManagementApp theApp;
extern int flage;
extern HWND hWnd;
BOOL CResume2Page::OnSetActive() 
{
	UpdateData();
	// TODO: Add your specialized code here and/or call the base class
	CResumeSheet*p = (CResumeSheet*)GetParent();
	if(flage == 1)//表示当前的状态用户是再查看或修改简历，故此时应显示下载简历按钮
	{
		(CButton*)GetDlgItem(IDC_DOWNLOAD)->ShowWindow(SW_SHOWNORMAL);
		CString id = p->page1.m_id;
		CString	strSQL = "select*from resume where id='"+id+"'";
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
		long lDataSize = m_set->GetFields()->GetItem("resumeUpload")->ActualSize;///得到数据的长度
		if(0 == lDataSize)
		{
			CButton*btnP = (CButton*)GetDlgItem(IDC_DOWNLOAD);
			btnP ->ShowWindow(SW_HIDE);
		}
		m_set->Close();
	}
	p->SetWizardButtons(PSWIZB_BACK|PSWIZB_FINISH);
	return CPropertyPage::OnSetActive();
}
extern int flage;
BOOL CResume2Page::OnWizardFinish() //在此完成数据库操作
{
	UpdateData();
	CResumeSheet*p = (CResumeSheet*)GetParent();
	CString id = p->page1.m_id;
	/*******以下将实现将录入的数据插入到数据库的操作********/
    /*******************************************************/    
    try
	{  
		CString strSQL;
		if(flage == 0 )
		strSQL="select* from resume ";
		else 
			strSQL = "select*from resume where id='"+id+"'";
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
	    
		if(flage == 0)//因为修改时候不需下列语句故此判断
		   m_set->AddNew();
		
		CResumeInfo Info;
		Info.m_address = p->page1.m_address;
        Info.m_anotherLanguage1 = p->page1.m_anotherLanguage1;
		Info.m_anotherLanguageLevel = p->page1.m_anotherLanguageLevel;
		Info.m_birthday = p->page1.m_birthday;
		Info.m_code = p->page1.m_code;
		Info.m_computerCapability = p->page1.m_computerCapability;
		Info.m_currentAddress = p->page1.m_currentAddress;
		Info.m_eduDateBegin1 = p->page1.m_eduDateBegin1;
		Info.m_eduDateBegin2 = p->page1.m_eduDateBegin2;
		Info.m_eduDateBegin3 = p->page1.m_eduDateBegin3;
		Info.m_eduDateBegin4 = p->page1.m_eduDateBegin4;
		Info.m_eduDateBegin5 = p->page1.m_eduDateBegin5;
		Info.m_eduDateBegin6 = p->page1.m_eduDateBegin6;
		Info.m_eduDateEnd1 = p->page1.m_eduDateEnd1;
		Info.m_eduDateEnd2 = p->page1.m_eduDateEnd2;
		Info.m_eduDateEnd3 = p->page1.m_eduDateEnd3;
		Info.m_eduDateEnd4 = p->page1.m_eduDateEnd4;
		Info.m_eduDateEnd5 = p->page1.m_eduDateEnd5;
		Info.m_eduDateEnd6 = p->page1.m_eduDateEnd6;
		Info.m_eduSchool1 = p->page1.m_eduSchool1;
		Info.m_eduSchool2 = p->page1.m_eduSchool2;
		Info.m_eduSchool3 = p->page1.m_eduSchool3;
		Info.m_eduSchool4 = p->page1.m_eduSchool4;
		Info.m_eduSchool5 = p->page1.m_eduSchool5;
		Info.m_eduSchool6 = p->page1.m_eduSchool6;
		Info.m_eduType1 = p->page1.m_eduType1;
		Info.m_eduType2 = p->page1.m_eduType2;
		Info.m_eduType3 = p->page1.m_eduType3;
		Info.m_eduType4 = p->page1.m_eduType4;
		Info.m_eduType5 = p->page1.m_eduType5;
		Info.m_eduType6 = p->page1.m_eduType6;
		Info.m_email = p->page1.m_email;
		Info.m_englishLevel = p->page1.m_englishLevel;
		Info.m_englishMajorOrNot = p->page1.m_englishMajorOrNot;
		Info.m_formerCompanyname1 = p->page2.m_formerCompanyname1;
		Info.m_formerCompanyname2 = p->page2.m_formerCompanyname2;
		Info.m_height = p->page1.m_height;
        Info.m_id = p->page1.m_id;
		Info.m_idCard = p->page1.m_idCard;
		Info.m_jobDescribe1 = p->page2.m_jobDescribe1;
		Info.m_jobDescribe2 = p->page2.m_jobDescribe2;
		Info.m_jobPlace = p->page2.m_jobPlace;
		Info.m_major1 = p->page1.m_major1;
		Info.m_major2 = p->page1.m_major2;
		Info.m_major3 = p->page1.m_major3;
		Info.m_major4 = p->page1.m_major4;
		Info.m_major5 = p->page1.m_major5;
		Info.m_major6 = p->page1.m_major6;
        Info.m_merryOrNot = p->page1.m_merryOrNot;
		Info.m_moblePhone = p->page1.m_moblePhone;
		Info.m_moreSkillDescribe = p->page1.m_moreSkillDescribe;
		Info.m_name = p->page1.m_name;
		Info.m_nationnality = p->page1.m_nationnality;
		Info.m_plannedJob1 = p->page2.m_plannedJob1;
		Info.m_plannedJob2 = p->page2.m_plannedJob2;
		Info.m_plannedJob3 = p->page2.m_plannedJob3;
		Info.m_plannedSalary = p->page2.m_plannedSalary;
		Info.m_role1 = p->page2.m_role1;
		Info.m_role2 = p->page2.m_role2;
		Info.m_selfComment = p->page1.m_selfComment;
		Info.m_sex = p->page1.m_sex;
		Info.m_whatToDo = p->page2.m_whatToDo;
		Info.m_workExperiencedateBegin1 = p->page2.m_workExperiencedateBegin1;
		Info.m_workExperiencedateBegin2 = p->page2.m_workExperiencedateBegin2;
		Info.m_workExperiencedateEnd1 = p->page2.m_workExperiencedateEnd1;
		Info.m_workExperiencedateEnd2 = p->page2.m_workExperiencedateEnd2;
		TRACE(Info.m_id);


//		m_set->PutCollect("address",_variant_t(Info.m_address));
		m_set->PutCollect("anotherLanguage1",_variant_t(Info.m_anotherLanguage1));
		m_set->PutCollect("anotherLanguageLevel",_variant_t(Info.m_anotherLanguageLevel));
		m_set->PutCollect("birthday",_variant_t(Info.m_birthday));