resume2page.cpp

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

		m_set->PutCollect("code",_variant_t(Info.m_code));
		m_set->PutCollect("computerCapability",_variant_t(Info.m_computerCapability));
		m_set->PutCollect("currentAddress",_variant_t(Info.m_currentAddress));
		m_set->PutCollect("eduDateBegin1",_variant_t(Info.m_eduDateBegin1));
		m_set->PutCollect("eduDateBegin2",_variant_t(Info.m_eduDateBegin2));
		m_set->PutCollect("eduDateBegin3",_variant_t(Info.m_eduDateBegin3));
		m_set->PutCollect("eduDateBegin4",_variant_t(Info.m_eduDateBegin4));
		m_set->PutCollect("eduDateBegin5",_variant_t(Info.m_eduDateBegin5));
		m_set->PutCollect("eduDateBegin6",_variant_t(Info.m_eduDateBegin6));
		m_set->PutCollect("eduDateEnd1",_variant_t(Info.m_eduDateEnd1));
		m_set->PutCollect("eduDateEnd2",_variant_t(Info.m_eduDateEnd2));
		m_set->PutCollect("eduDateEnd3",_variant_t(Info.m_eduDateEnd3));
		m_set->PutCollect("eduDateEnd4",_variant_t(Info.m_eduDateEnd4));
		m_set->PutCollect("eduDateEnd5",_variant_t(Info.m_eduDateEnd5));
		m_set->PutCollect("eduDateEnd6",_variant_t(Info.m_eduDateEnd6));
		m_set->PutCollect("eduSchool1",_variant_t(Info.m_eduSchool1));
		m_set->PutCollect("eduSchool2",_variant_t(Info.m_eduSchool2));
		m_set->PutCollect("eduSchool3",_variant_t(Info.m_eduSchool3));
		m_set->PutCollect("eduSchool4",_variant_t(Info.m_eduSchool4));
		m_set->PutCollect("eduSchool5",_variant_t(Info.m_eduSchool5));
		m_set->PutCollect("eduSchool6",_variant_t(Info.m_eduSchool6));
		m_set->PutCollect("eduType1",_variant_t(Info.m_eduType1));
		m_set->PutCollect("eduType2",_variant_t(Info.m_eduType2));
		m_set->PutCollect("eduType3",_variant_t(Info.m_eduType3));
		m_set->PutCollect("eduType4",_variant_t(Info.m_eduType4));
		m_set->PutCollect("eduType5",_variant_t(Info.m_eduType5));
		m_set->PutCollect("eduType6",_variant_t(Info.m_eduType6));
		m_set->PutCollect("email",_variant_t(Info.m_email));
		m_set->PutCollect("englishLevel",_variant_t(Info.m_englishLevel));
		m_set->PutCollect("englishMajorOrNot",_variant_t(Info.m_englishMajorOrNot));
		m_set->PutCollect("formerCompanyname1",_variant_t(Info.m_formerCompanyname1));
		m_set->PutCollect("formerCompanyname2",_variant_t(Info.m_formerCompanyname2));
		CString h;
		h.Format("%d cm",Info.m_height);
		m_set->PutCollect("height",_variant_t(Info.m_height));

	    if(flage == 0)
		m_set->PutCollect("id",_variant_t(Info.m_id));
		//若是正在修改则不能插入ID（它是主键）
		m_set->PutCollect("idCard",_variant_t(Info.m_idCard));
		m_set->PutCollect("jobDescribe1",_variant_t(Info.m_jobDescribe1));
		m_set->PutCollect("jobDescribe2",_variant_t(Info.m_jobDescribe2));
		m_set->PutCollect("jobPlace",_variant_t(Info.m_jobPlace));
		m_set->PutCollect("major1",_variant_t(Info.m_major1));
		m_set->PutCollect("major2",_variant_t(Info.m_major2));
		m_set->PutCollect("major3",_variant_t(Info.m_major3));
		m_set->PutCollect("major4",_variant_t(Info.m_major4));
		m_set->PutCollect("major5",_variant_t(Info.m_major5));
		m_set->PutCollect("major6",_variant_t(Info.m_major6));
		m_set->PutCollect("merryOrNot",_variant_t(Info.m_merryOrNot));
		m_set->PutCollect("mobilePhone",_variant_t(Info.m_moblePhone));
		m_set->PutCollect("moreSkillDescribe",_variant_t(Info.m_moreSkillDescribe));
		m_set->PutCollect("name",_variant_t(Info.m_name));
		m_set->PutCollect("nationnality",_variant_t(Info.m_nationnality));
		m_set->PutCollect("plannedJob1",_variant_t(Info.m_plannedJob1));
		m_set->PutCollect("plannedJob2",_variant_t(Info.m_plannedJob2));
		m_set->PutCollect("plannedJob3",_variant_t(Info.m_plannedJob3));
		m_set->PutCollect("plannedSalary",_variant_t(Info.m_plannedSalary));
		m_set->PutCollect("role1",_variant_t(Info.m_role1));
		m_set->PutCollect("role2",_variant_t(Info.m_role2));
		m_set->PutCollect("commentSelf",_variant_t(Info.m_selfComment));
		m_set->PutCollect("sex",_variant_t(Info.m_sex));
		m_set->PutCollect("whatToDo",_variant_t(Info.m_whatToDo));
		m_set->PutCollect("workExperiencedateBegin1",_variant_t(Info.m_workExperiencedateBegin1));
		m_set->PutCollect("workExperiencedateBegin2",_variant_t(Info.m_workExperiencedateBegin2));
		m_set->PutCollect("workExperiencedateEnd1",_variant_t(Info.m_workExperiencedateEnd1));
		m_set->PutCollect("workExperiencedateEnd2",_variant_t(Info.m_workExperiencedateEnd2));
		m_set->PutCollect("address",_variant_t(Info.m_address));
///////////////////////////上传简历/////////////////////////////////////////////
		if(!path.IsEmpty())
		{
			DWORD FileSize,count;   
			// LONG   num;   
			char *pBuf;   
			VARIANT varBLOB;   
			SAFEARRAY *psa;   
			CFile   f;   
			CFileException   e;   
			HGLOBAL hfilemem;   

			SAFEARRAYBOUND rgsabound[1];   
			try
			{
				f.Open(path,CFile::modeRead,&e); 
			}
			catch(	CFileException   e)
			{
				MessageBox("上传时，简历不能处于打开状态");
			}
			f.SeekToBegin();   
			FileSize=f.GetLength();   
			hfilemem=GlobalAlloc(GMEM_MOVEABLE,(FileSize));     
			pBuf=(char*)GlobalLock(hfilemem);   
			count=f.Read(pBuf,FileSize);     
			f.Close();   
			if(pBuf)   
			{           
				rgsabound[0].lLbound = 0;   
				rgsabound[0].cElements = FileSize;   
				psa   =   SafeArrayCreate(VT_UI1,1,rgsabound);                                             ///创建SAFEARRAY对象   

				for(long i=0;i<(long)FileSize;i++)   
					SafeArrayPutElement   (psa, &i, pBuf++);  ///将pBuf指向的二进制数据保存到SAFEARRAY对象psa中   
				
				varBLOB.vt = VT_ARRAY|VT_UI1;                                                                       ///将varBLOB的类型设置为BYTE类型的数组   
				varBLOB.parray = psa;       ///为varBLOB变量赋值 		
				m_set->GetFields()->GetItem("resumeUpload")->AppendChunk(varBLOB);///加入BLOB类
			}
		}
		m_set->Update();
		m_set->Close();
	}
	catch(_com_error e)
	{
	}
    /********************数据库操作：插入数据，上传简历***********************************/    
    flage = 0;//向导完毕后要将flage设置为原来的值（全局变量初始为0）
	::PostMessage(hWnd,WM_REFRESH2,0,0);
	return CPropertyPage::OnWizardFinish();
}



LRESULT CResume2Page::OnWizardNext() 
{
	// TODO: Add your specialized code here and/or call the base class
	UpdateData();
	
	return CPropertyPage::OnWizardNext();
}

//DEL void CResume2Page::CalcWindowRect(LPRECT lpClientRect, UINT nAdjustType) 
//DEL {
//DEL 
//DEL 	CPropertyPage::CalcWindowRect(lpClientRect, nAdjustType);
//DEL }

CString CResume2Page::ToString(COleDateTime t)
{
	int year=t.GetYear();
	int month=t.GetMonth();
	int day=t.GetDay();
	CString m_convertBirthday;
	m_convertBirthday.Format("%d-%d-%d",year,month,day);
    return m_convertBirthday;
		

}

void CResume2Page::OnFinddoc() 
{
	static char BASED_CODE Filter[] = "DOC文件(*.doc) |*.doc|  文本(*txt)|*txt|  所有文件 (*.*)|*.*||";
	CFileDialog   dlgOpen(TRUE,0,0,OFN_HIDEREADONLY|OFN_FILEMUSTEXIST,(LPCTSTR)Filter,NULL);   
	if(dlgOpen.DoModal()==IDOK)   
	{   
	   path=dlgOpen.GetPathName();   
	   name=dlgOpen.GetFileName();   //取得要分割的文件名（不包含路径、扩展名）   
	}   
	
}


void CResume2Page::OnDownload() 
{

	UpdateData();
	CString myPaht,myName;
	static char BASED_CODE Filter[] = "DOC文件(*.doc) |*.doc|  文本(*txt)|*txt|  所有文件 (*.*)|*.*||";
	CFileDialog   dlgOpen(FALSE,0,0,OFN_HIDEREADONLY|OFN_FILEMUSTEXIST,(LPCTSTR)Filter,NULL);   
	if(dlgOpen.DoModal()==IDOK)   
	{   
	   myPaht=dlgOpen.GetPathName();   
	   myName=dlgOpen.GetFileName();   //取得要分割的文件名（不包含路径、扩展名）   
	}  
	CResumeSheet*p = (CResumeSheet*)GetParent();
	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(lDataSize > 0)
	{
		CFile newFile( myPaht, CFile::modeCreate|CFile::modeWrite);
		_variant_t varBLOB;
		varBLOB = m_set->GetFields()->GetItem("resumeUpload")->GetChunk(lDataSize);
		if(varBLOB.vt == (VT_ARRAY | VT_UI1))                                 ///判断数据类型是否正确
		{
			char *pBuf = NULL;
			SafeArrayAccessData(varBLOB.parray,(void **)&pBuf);              ///得到指向数据的指针
			newFile.Write( pBuf, lDataSize );//写到新建的文件中去
			SafeArrayUnaccessData (varBLOB.parray);
		}
	 }
}

//DEL BOOL CResume2Page::OnInitDialog() 
//DEL {
//DEL 	CPropertyPage::OnInitDialog();
//DEL 	return TRUE;  
//DEL }