📄 findresume.cpp

📁 是老板让做的一个招聘网站后台简历录入系统。可以支持照片上传
💻 CPP
字号:
// FindResume.cpp : implementation file
//

#include "stdafx.h"
#include "ResumeManagement.h"
#include "FindResume.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFindResume dialog

extern HWND hWnd;
CFindResume::CFindResume(CWnd* pParent /*=NULL*/)
	: CDialog(CFindResume::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindResume)
	m_nameOrID = _T("");
	id ="";
	hWnd = this->m_hWnd;
	//}}AFX_DATA_INIT
}


void CFindResume::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindResume)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_COMBO1, m_choice);
	DDX_Text(pDX, IDC_NAMEORID, m_nameOrID);
	//}}AFX_DATA_MAP

}


BEGIN_MESSAGE_MAP(CFindResume, CDialog)
	//{{AFX_MSG_MAP(CFindResume)
	ON_BN_CLICKED(IDC_BUTTON1, OnDisplay)
	ON_BN_CLICKED(IDC_REVIEW, OnReview)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_CBN_CLOSEUP(IDC_COMBO1, OnCloseupCombo1)
	ON_WM_DESTROY()
	ON_BN_CLICKED(IDC_FRESHLIST, OnFreshlist)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFindResume message handlers
BOOL CFindResume::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	DWORD  style;
	style=m_list.GetExStyle();//读取样式；
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES);//设置样式；
	m_list.SetExtendedStyle(style);
	m_list.InsertColumn(0,"简历编号",LVCFMT_LEFT,130);
	m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,130);
	((CComboBox*)GetDlgItem(IDC_COMBO1))->AddString("简历编号");
	((CComboBox*)GetDlgItem(IDC_COMBO1))->AddString("登记者姓名");
	((CComboBox*)GetDlgItem(IDC_COMBO1))->AddString("所有简历");
	((CComboBox*)GetDlgItem(IDC_COMBO1))->SetCurSel(1);//默认下拉列表框选中的是“按简历编号查找”
	((CEdit*)GetDlgItem(IDC_NAMEORID))->SetFocus();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
extern CResumeManagementApp theApp;
void CFindResume::OnDisplay() 
{

	m_list.DeleteAllItems();
	UpdateData();
	CString strSQL;
	strSQL="select* from resume where ";
	_RecordsetPtr m_set("ADODB.Recordset");//记录集

	if(m_choice =="")
	{
		MessageBox("请选择查询条件");
		return;
	}
	if(m_choice =="简历编号")
	{
		m_list.DeleteAllItems();
        strSQL += "id='"+m_nameOrID+"'";
		try//从数据库中读取信息，填充列表控件
		{
			m_set->Open(_bstr_t(strSQL),_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
			int i=0;
			while(!(m_set->EndOfFile))
			{
				CString id = (LPCSTR)(_bstr_t)m_set->GetCollect("id");
				CString name = (LPCSTR)(_bstr_t)m_set->GetCollect("name");
				m_list.InsertItem(i,id);
				m_list.SetItemText(i,1,name);
			    i++;
				m_set->MoveNext();
			}
		}
		catch(_com_error&e)
		{
			AfxMessageBox(e.ErrorMessage());
		}	
	}
	else if(m_choice == "登记者姓名")
	{
		m_list.DeleteAllItems();
		strSQL += "name='"+m_nameOrID+"'";
		try//从数据库中读取信息，填充列表控件
		{
			_RecordsetPtr m_set("ADODB.Recordset");
			m_set->Open(_bstr_t(strSQL),_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
			int i=0;
			while(!(m_set->EndOfFile))
			{
				CString id = (LPCSTR)(_bstr_t)m_set->GetCollect("id");
				CString name = (LPCSTR)(_bstr_t)m_set->GetCollect("name");
				m_list.InsertItem(i,id);
				m_list.SetItemText(i,1,name);
			    i++;
				m_set->MoveNext();
			}
		}
		catch(_com_error&e)
		{
			AfxMessageBox(e.ErrorMessage());
		}	
	}
	else if(this->m_choice == "所有简历")
	{
 		m_list.DeleteAllItems();
 		try
  		{
		  _RecordsetPtr m_set("ADODB.Recordset");
		  CString sqlStr = "select*from resume ";
  		m_set->Open((_variant_t)sqlStr,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
			while(!(m_set->EndOfFile))
			{
				m_list.InsertItem(i,(_bstr_t)m_set->GetCollect("id"));
				m_list.SetItemText(i,1,(_bstr_t)m_set->GetCollect("name"));
				i++;
				m_set->MoveNext();
			}

		}

  		catch(_com_error&e)
  		{
  			AfxMessageBox(e.ErrorMessage());
  		}
		this->UpdateData(false);
	}

//	m_nameOrID = "";
//	UpdateData(false);

}
#include "resumesheet.h"
extern int flage;
void CFindResume::OnReview()//预览的同时可以修改 
{
    flage = 1;//flage为1时表示要修改
	// TODO: Add your control notification handler code here
	if(id!="")//id为用户选中列表框上显示的条目后返回的该条目（简历）的编号
		      //若用户没选中列表框上的条目ID仍我空
	{

		UpdateData();
		CResumeSheet sheet("简历预览");
		CString temp;
	/*******以下将实现将录入的数据插入到数据库的操作********/
    /*******************************************************/    
			_RecordsetPtr m_set("ADODB.Recordset");//记录集
		try
		{  
			CString strSQL;
			strSQL="select* from resume where id='"+id+"'";
			m_set->Open((_bstr_t)strSQL,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
			
			sheet.page1.m_address = (LPCSTR)(_bstr_t) m_set->GetCollect("address");
			sheet.page1.m_anotherLanguage1 = (LPCSTR)(_bstr_t) m_set->GetCollect("anotherLanguage1");
			sheet.page1.m_anotherLanguageLevel = (LPCSTR)(_bstr_t) m_set->GetCollect("anotherLanguageLevel"); 
			sheet.page1.m_birthday = (COleDateTime) m_set->GetCollect("birthday"); 
			sheet.page1.m_code = (LPCSTR)(_bstr_t) m_set->GetCollect("code"); 
			sheet.page1.m_computerCapability = (LPCSTR)(_bstr_t) m_set->GetCollect("computerCapability"); 
			sheet.page1.m_currentAddress = (LPCSTR)(_bstr_t) m_set->GetCollect("currentAddress"); 
			sheet.page1.m_eduDateBegin1 = (COleDateTime) m_set->GetCollect("eduDateBegin1"); 
			sheet.page1.m_eduDateBegin2 = (COleDateTime) m_set->GetCollect("eduDateBegin2"); 
			sheet.page1.m_eduDateBegin3 = (COleDateTime) m_set->GetCollect("eduDateBegin3"); 
			sheet.page1.m_eduDateBegin4 = (COleDateTime) m_set->GetCollect("eduDateBegin4"); 
			sheet.page1.m_eduDateBegin5 = (COleDateTime) m_set->GetCollect("eduDateBegin5"); 
			sheet.page1.m_eduDateBegin6 = (COleDateTime) m_set->GetCollect("eduDateBegin6"); 
			sheet.page1.m_eduDateEnd1 = (COleDateTime) m_set->GetCollect("eduDateEnd1"); 
			sheet.page1.m_eduDateEnd2 = (COleDateTime) m_set->GetCollect("eduDateEnd2"); 
			sheet.page1.m_eduDateEnd3 = (COleDateTime) m_set->GetCollect("eduDateEnd3"); 
			sheet.page1.m_eduDateEnd4 = (COleDateTime) m_set->GetCollect("eduDateEnd4"); 
			sheet.page1.m_eduDateEnd5 = (COleDateTime) m_set->GetCollect("eduDateEnd5"); 
			sheet.page1.m_eduDateEnd6 = (COleDateTime) m_set->GetCollect("eduDateEnd6"); 
			sheet.page1.m_eduSchool1 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool1"); 
			sheet.page1.m_eduSchool2 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool2"); 
			sheet.page1.m_eduSchool3 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool3"); 
			sheet.page1.m_eduSchool4 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool4"); 
			sheet.page1.m_eduSchool5 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool5"); 
			sheet.page1.m_eduSchool6 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduSchool6"); 
			sheet.page1.m_eduType1 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType1"); 
			sheet.page1.m_eduType2 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType2"); 
			sheet.page1.m_eduType3 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType3"); 
			sheet.page1.m_eduType4 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType4"); 
			sheet.page1.m_eduType5 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType5"); 
			sheet.page1.m_eduType6 = (LPCSTR)(_bstr_t) m_set->GetCollect("eduType6"); 
			sheet.page1.m_email = (LPCSTR)(_bstr_t) m_set->GetCollect("email"); 
			sheet.page1.m_englishLevel = (LPCSTR)(_bstr_t) m_set->GetCollect("englishLevel"); 
			sheet.page1.m_englishMajorOrNot = (LPCSTR)(_bstr_t) m_set->GetCollect("englishMajorOrNot"); 
			sheet.page2.m_formerCompanyname1 = (LPCSTR)(_bstr_t) m_set->GetCollect("formerCompanyname1"); 
			sheet.page2.m_formerCompanyname2 = (LPCSTR)(_bstr_t) m_set->GetCollect("formerCompanyname2"); 
			sheet.page1.m_height = (LPCSTR)(_bstr_t) m_set->GetCollect("height"); 
			 sheet.page1.m_id = (LPCSTR)(_bstr_t) m_set->GetCollect("id"); 
			 sheet.page1.m_idCard = (LPCSTR)(_bstr_t) m_set->GetCollect("idCard"); 
			 sheet.page2.m_jobDescribe1 = (LPCSTR)(_bstr_t) m_set->GetCollect("jobDescribe1"); 
			 sheet.page2.m_jobDescribe2 = (LPCSTR)(_bstr_t) m_set->GetCollect("jobDescribe2"); 
			 sheet.page2.m_jobPlace = (LPCSTR)(_bstr_t) m_set->GetCollect("jobPlace"); 
			 sheet.page1.m_major1 = (LPCSTR)(_bstr_t) m_set->GetCollect("major1"); 
			 sheet.page1.m_major2 = (LPCSTR)(_bstr_t) m_set->GetCollect("major2"); 
			 sheet.page1.m_major3 = (LPCSTR)(_bstr_t) m_set->GetCollect("major3"); 
			 sheet.page1.m_major4 = (LPCSTR)(_bstr_t) m_set->GetCollect("major4"); 
			 sheet.page1.m_major5 = (LPCSTR)(_bstr_t) m_set->GetCollect("major5"); 
			 sheet.page1.m_major6 = (LPCSTR)(_bstr_t) m_set->GetCollect("major6"); 
			 sheet.page1.m_merryOrNot = (LPCSTR)(_bstr_t) m_set->GetCollect("merryOrNot"); 
			 sheet.page1.m_moblePhone = (LPCSTR)(_bstr_t) m_set->GetCollect("mobilePhone"); 
			 sheet.page1.m_moreSkillDescribe = (LPCSTR)(_bstr_t) m_set->GetCollect("moreSkillDescribe"); 
			 sheet.page1.m_name = (LPCSTR)(_bstr_t) m_set->GetCollect("name"); 
			 sheet.page1.m_nationnality = (LPCSTR)(_bstr_t) m_set->GetCollect("nationnality"); 
			 sheet.page2.m_plannedJob1 = (LPCSTR)(_bstr_t) m_set->GetCollect("plannedJob1"); 
			 sheet.page2.m_plannedJob2 = (LPCSTR)(_bstr_t) m_set->GetCollect("plannedJob2"); 
			 sheet.page2.m_plannedJob3 = (LPCSTR)(_bstr_t) m_set->GetCollect("plannedJob3"); 
			 sheet.page2.m_plannedSalary = (LPCSTR)(_bstr_t) m_set->GetCollect("plannedSalary"); 
			 sheet.page2.m_role1 = (LPCSTR)(_bstr_t) m_set->GetCollect("role1"); 
			 sheet.page2.m_role2 = (LPCSTR)(_bstr_t) m_set->GetCollect("role2"); 
			 sheet.page1.m_selfComment = (LPCSTR)(_bstr_t) m_set->GetCollect("commentSelf"); 
			 sheet.page1.m_sex = (LPCSTR)(_bstr_t) m_set->GetCollect("sex"); 
			 sheet.page2.m_whatToDo = (LPCSTR)(_bstr_t) m_set->GetCollect("whatToDo"); 
			 sheet.page2.m_workExperiencedateBegin1 = (COleDateTime) m_set->GetCollect("workExperiencedateBegin1"); 
			 sheet.page2.m_workExperiencedateBegin2 = (COleDateTime) m_set->GetCollect("workExperiencedateBegin2"); 
			 sheet.page2.m_workExperiencedateEnd1 = (COleDateTime) m_set->GetCollect("workExperiencedateEnd1"); 
			 sheet.page2.m_workExperiencedateEnd2 = (COleDateTime) m_set->GetCollect("workExperiencedateEnd2"); 
			 m_set->Close();
		}
		catch(_com_error e){}
		sheet.DoModal();

	 
	}
	else
		MessageBox("先选中左边的列表框中的条目");
}

void CFindResume::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{

	ifChoose = true;
	POSITION pos=m_list.GetFirstSelectedItemPosition();//获得单击的位置
	if(pos)
	{
		int nFistSelItem=m_list.GetNextSelectedItem(pos);//获得单击条目
		id=m_list.GetItemText(nFistSelItem,0);//获得ID编号
	}	
	*pResult = 0;
}

void CFindResume::OnDelete() 
{
	if(id!="")//id为用户选中列表框上显示的条目后返回的该条目（简历）的编号
		      //若用户没选中列表框上的条目ID仍为空
	{
		if(IDNO==MessageBox("确定要删除吗?",NULL,MB_YESNO))
			return;
		UpdateData();
		CResumeSheet sheet("简历预览");
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		try
		{  
			CString strSQL;
			strSQL="delete from resume where id='"+id+"'";
			m_set->Open((_bstr_t)strSQL,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
			m_set->Close();
			if(this->m_choice=="简历编号")
				id = "";//删除成功后该简历就被删除，ID也自然为空
		}
		catch(_com_error e){}
		Refresh();
		//sheet.DoModal();
	}
	else
		MessageBox("先选中左边的列表框中的条目");

}

void CFindResume::Refresh()
{
    OnDisplay();
}
void CFindResume::OnCloseupCombo1()
{
  		this->UpdateData();
	if(this->m_choice == "所有简历")
	{
 		m_list.DeleteAllItems();
 		try
  		{
		  _RecordsetPtr m_set("ADODB.Recordset");
		  CString sqlStr = "select*from resume ";
  		m_set->Open((_variant_t)sqlStr,_variant_t(theApp.m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
			while(!(m_set->EndOfFile))
			{
				m_list.InsertItem(i,(_bstr_t)m_set->GetCollect("id"));
				m_list.SetItemText(i,1,(_bstr_t)m_set->GetCollect("name"));
				i++;
				m_set->MoveNext();
			}

		}

  		catch(_com_error&e)
  		{
  			AfxMessageBox(e.ErrorMessage());
  		}
		this->UpdateData(false);
	}
}

extern int flage;
void CFindResume::OnDestroy() 
{
	CDialog::OnDestroy();
    flage = 0;//当查找窗口退出时，将flage设置0	
}
void CFindResume::Refresh2(WPARAM wParam,LPARAM lParam)//自己定义的消息处理函数 ON_WM_Refresh
{
	Refresh();
}

void CFindResume::OnFreshlist() 
{
	// TODO: Add your control notification handler code here
		Refresh();

}
💿 文件大小 123 K
👤 上传用户 xiongxianwang8
📂 所属分类数据库系统
🏷️ 相关标签

#网站 #后台
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -