www.pudn.com > rsdagl.rar > JianSuo.cpp

// JianSuo.cpp : 实现文件 
// 
 
/*#include "stdafx.h" 
#include "人事管理系统.h" 
#include "JianSuo.h" 
#include ".\jiansuo.h" 
#include "MainQuery.h" 
 
 
// CJianSuo 对话框 
 
IMPLEMENT_DYNAMIC(CJianSuo, CDialog) 
CJianSuo::CJianSuo(CWnd* pParent /*=NULL*/) 
/*	: CDialog(CJianSuo::IDD, pParent) 
	, m_pMainQuery(NULL) 
	, IsMainQuery(false) 
	 
{ 
} 
 
CJianSuo::~CJianSuo() 
{ 
} 
 
void CJianSuo::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	DDX_Control(pDX, IDC_STATIC1, m_logos); 
	DDX_Control(pDX, IDC_BIAODUAN, cb1); 
	DDX_Control(pDX, IDC_CONDITION, cb2); 
} 
 
 
BEGIN_MESSAGE_MAP(CJianSuo, CDialog) 
	ON_BN_CLICKED(IDOK, OnBnClickedOk) 
	ON_WM_DESTROY() 
	ON_BN_CLICKED(ID_RECORD_PREV, OnBnClickedRecordPrev) 
	ON_CBN_CLOSEUP(IDC_BIAODUAN, OnCbnCloseupBiaoduan) 
	ON_BN_CLICKED(ADSERCH, OnBnClickedAdserch) 
END_MESSAGE_MAP() 
 
// CJianSuo 消息处理程序 
 
void CJianSuo::OnBnClickedOk() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	CString Cbd,Ctj2; //表段,条件 
	GetDlgItemText(IDC_BIAODUAN,Cbd); 
	GetDlgItemText(IDC_CONDITION,Ctj2); 
	if(strcmp(Cbd,"")==0||strcmp(Ctj2,"")==0) 
	{ 
		AfxMessageBox("您没有选择查询字段,查询失败!",MB_OK); 
		return; 
	} 
	if(!IsMainQuery) 
	{ 
		m_pMainQuery =new CMainQuery(); 
		m_pMainQuery->Create(IDD_MAINQUERY); 
		m_pMainQuery->ShowWindow(SW_SHOW); 
		IsMainQuery = true; 
	} 
	else 
	{ 
		m_pMainQuery->ShowWindow(SW_SHOW); 
	} 
	 
	m_pMainQuery->SelectItem(Ctj2,Cbd); 
 
 
} 
 
void CJianSuo::OnDestroy() 
{ 
	CDialog::OnDestroy(); 
	delete m_pMainQuery; 
 
	// TODO: 在此处添加消息处理程序代码 
} 
 
BOOL CJianSuo::OnInitDialog() 
{ 
	CDialog::OnInitDialog(); 
 
	// TODO:  在此添加额外的初始化 
	m_logos.settext("              简易信息检索系统"); 
	CRect rect; 
	GetWindowRect(rect); 
	SetWindowPos(&wndTopMost,rect.left,rect.top,rect.right,rect.bottom,SWP_NOMOVE|SWP_NOSIZE|SWP_NOACTIVATE); 
	m_pRecordset.CreateInstance(_uuidof(Recordset)); 
	try 
	{ 
		m_pRecordset->Open("SELECT * FROM 基本信息 ORDER BY 员工编号",theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
	} 
	catch(_com_error se) 
	{ 
		AfxMessageBox(se.ErrorMessage()); 
		return false; 
	} 
 
	return TRUE;  // return TRUE unless you set the focus to a control 
	// 异常: OCX 属性页应返回 FALSE 
} 
 
void CJianSuo::OnBnClickedRecordPrev() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	OnOK(); 
} 
 
 
 
 
void CJianSuo::OnCbnCloseupBiaoduan() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	CString Cbd; 
	GetDlgItemText(IDC_BIAODUAN,Cbd); 
	while(cb2.GetCount()!=0)cb2.DeleteString(0); 
	int i=0; 
	while(!m_pRecordset->adoEOF) 
	{ 
		int j=0; 
		CString vygbh; 
		vygbh=m_pRecordset->GetCollect(_bstr_t(Cbd));	 
		for(j;jMoveNext(); 
	} 
	m_pRecordset->MoveFirst(); 
} 
 
void CJianSuo::OnBnClickedAdserch() 
{ 
	try 
	{ 
 
		CString c_biaoduan,c_tiaojian,c_neirong; 
		GetDlgItemText(IDC_COMBO2,c_biaoduan); 
		GetDlgItemText(IDC_COMBO3,c_tiaojian); 
		GetDlgItemText(IDC_COMBO6,c_neirong); 
 
		if(strcmp(c_tiaojian,"大于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			sql_command.Format("SELECT * FROM 基本信息 WHERE %s>%s",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			m_pRecordset->Close(); 
			 
		} 
		if(strcmp(c_tiaojian,"小于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			sql_command.Format("SELECT * FROM 基本信息 WHERE %s<%s",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			m_pRecordset->Close(); 
			 
		} 
		if(strcmp(c_tiaojian,"等于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			sql_command.Format("SELECT * FROM 基本信息 WHERE %s=%s",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			m_pRecordset->Close(); 
			 
		} 
	} 
	catch(_com_error e) 
	{ 
	} 
 
}*/ 
#include "stdafx.h" 
#include "人事管理系统.h" 
#include "JianSuo.h" 
#include ".\jiansuo.h" 
#include "MainQuery.h" 
 
 
// CJianSuo 对话框 
 
IMPLEMENT_DYNAMIC(CJianSuo, CDialog) 
CJianSuo::CJianSuo(CWnd* pParent /*=NULL*/) 
	: CDialog(CJianSuo::IDD, pParent) 
	, m_pMainQuery(NULL) 
	, IsMainQuery(false) 
{ 
} 
 
CJianSuo::~CJianSuo() 
{ 
} 
 
void CJianSuo::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	DDX_Control(pDX, IDC_STATIC1, m_logos); 
	DDX_Control(pDX, IDC_BIAODUAN, cb1); 
	DDX_Control(pDX, IDC_CONDITION, cb2); 
	DDX_Control(pDX, IDC_CONDITION2, cb3); 
	DDX_Control(pDX, IDC_CONDITION4, cb4); 
} 
 
 
BEGIN_MESSAGE_MAP(CJianSuo, CDialog) 
	ON_BN_CLICKED(IDOK, OnBnClickedOk) 
	ON_WM_DESTROY() 
	ON_BN_CLICKED(ID_RECORD_PREV, OnBnClickedRecordPrev) 
	ON_BN_CLICKED(ADSERCH, OnBnClickedAdserch) 
	ON_CBN_CLOSEUP(IDC_CONDITION2, OnCbnCloseupCondition2) 
	ON_CBN_CLOSEUP(IDC_BIAODUAN, OnCbnCloseupBiaoduan) 
END_MESSAGE_MAP() 
 
// CJianSuo 消息处理程序 
 
void CJianSuo::OnBnClickedOk() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	CString Cbd,Ctj2; //表段,条件 
	GetDlgItemText(IDC_BIAODUAN,Cbd); 
	GetDlgItemText(IDC_CONDITION,Ctj2); 
	if(strcmp(Cbd,"")==0||strcmp(Ctj2,"")==0) 
	{ 
		AfxMessageBox("缺少查询信息,查询失败!",MB_OK); 
		return; 
	} 
	if(!IsMainQuery) 
	{ 
		m_pMainQuery =new CMainQuery(); 
		m_pMainQuery->Create(IDD_MAINQUERY); 
		m_pMainQuery->ShowWindow(SW_SHOW); 
		IsMainQuery = true; 
	} 
	else 
	{ 
		m_pMainQuery->ShowWindow(SW_SHOW); 
	} 
	 
	m_pMainQuery->SelectItem(Ctj2,Cbd); 
 
 
} 
 
void CJianSuo::OnDestroy() 
{ 
	CDialog::OnDestroy(); 
	delete m_pMainQuery; 
 
	// TODO: 在此处添加消息处理程序代码 
} 
 
BOOL CJianSuo::OnInitDialog() 
{ 
	CDialog::OnInitDialog(); 
 
	// TODO:  在此添加额外的初始化 
	m_logos.settext("              简易信息检索系统"); 
	CRect rect; 
//	GetWindowRect(rect); 
//	SetWindowPos(&wndTopMost,rect.left,rect.top,rect.right,rect.bottom,SWP_NOMOVE|SWP_NOSIZE|SWP_NOACTIVATE); 
 
	 
 
	return TRUE;  // return TRUE unless you set the focus to a control 
	// 异常: OCX 属性页应返回 FALSE 
} 
 
void CJianSuo::OnBnClickedRecordPrev() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	OnOK(); 
} 
 
void CJianSuo::OnBnClickedAdserch() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
		 
 
		CString c_biaoduan,c_tiaojian,c_neirong; 
		GetDlgItemText(IDC_CONDITION2,c_biaoduan); 
		GetDlgItemText(IDC_CONDITION3,c_tiaojian); 
		GetDlgItemText(IDC_CONDITION4,c_neirong); 
		if(strcmp(c_biaoduan,"")==0||strcmp(c_tiaojian,"")==0||strcmp(c_neirong,"")==0) 
		{ 
			AfxMessageBox("缺少查询信息,查询失败!",MB_OK); 
			return; 
		}	 
	try 
	{ 
		if(strcmp(c_tiaojian,"大于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			if(c_biaoduan=="员工编号") 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s>%s",c_biaoduan,c_neirong); 
			else 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s>'%s'",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			//m_pRecordset->Close(); 
			 
		} 
		if(strcmp(c_tiaojian,"小于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			if(c_biaoduan=="员工编号") 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s<%s",c_biaoduan,c_neirong); 
			else 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s<'%s'",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			//m_pRecordset->Close(); 
			 
		} 
		if(strcmp(c_tiaojian,"等于")==0) 
		{ 
			int number=0; 
			int number2=1;	 
			CString sql_command; 
			if(c_biaoduan=="员工编号") 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s=%s",c_biaoduan,c_neirong); 
			else 
				sql_command.Format("SELECT * FROM 基本信息 WHERE %s='%s'",c_biaoduan,c_neirong); 
			m_pRecordset.CreateInstance(_uuidof(Recordset)); 
			bstr_t QuerySql = sql_command; 
			m_pRecordset->Open(_variant_t(QuerySql),theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj; 
			if(!IsMainQuery) 
			{ 
				m_pMainQuery =new CMainQuery(); 
				m_pMainQuery->Create(IDD_MAINQUERY); 
				m_pMainQuery->ShowWindow(SW_SHOW); 
				IsMainQuery = true; 
			} 
			else 
			{ 
				m_pMainQuery->ShowWindow(SW_SHOW); 
			} 
			m_pMainQuery->m_listview.DeleteAllItems(); 
			while(!m_pRecordset->adoEOF) 
			{ 
 
				vygbh=m_pRecordset->GetCollect("员工编号");			//1	 
				if(vygbh.vt!=VT_NULL)	 
					Cygbh=(LPCSTR)_bstr_t(vygbh);	 
				vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
				if(vygxm.vt!=VT_NULL) 
					Cygxm=(LPCSTR)_bstr_t(vygxm); 
				vbm=m_pRecordset->GetCollect("所属部门");		//3 
				if(vbm.vt!=VT_NULL) 
					Cbm=(LPCSTR)_bstr_t(vbm); 
				vxb=m_pRecordset->GetCollect("性别");			//4	 
				if(vxb.vt!=VT_NULL) 
					Cxb=(LPCSTR)_bstr_t(vxb);	 
				vcsny=m_pRecordset->GetCollect("出生年月");		//5 
				if(vcsny.vt!=VT_NULL) 
					Ccsny=(LPCSTR)_bstr_t(vcsny); 
				vmz=m_pRecordset->GetCollect("民族");			//6  
				if(vmz.vt!=VT_NULL) 
					Cmz=(LPCSTR)_bstr_t(vmz);	 
				vjg=m_pRecordset->GetCollect("户口");			//7 	 
				if(vjg.vt!=VT_NULL)	 
					Cjg=(LPCSTR)_bstr_t(vjg); 
				vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
				if(vhyzk.vt!=VT_NULL) 
					Chyzk=(LPCSTR)_bstr_t(vhyzk); 
				vxl=m_pRecordset->GetCollect("学历");			//9 
				if(vxl.vt!=VT_NULL) 
					Cxl=(LPCSTR)_bstr_t(vxl);	 
				vzw=m_pRecordset->GetCollect("当前职位");		//10 
				if(vzw.vt!=VT_NULL) 
					Czw=(LPCSTR)_bstr_t(vzw);	 
				vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
				if(vsfzh.vt!=VT_NULL) 
					Csfzh=(LPCSTR)_bstr_t(vsfzh); 
				vsj=m_pRecordset->GetCollect("手机");			//12 
				if(vsj.vt!=VT_NULL) 
					Csj=(LPCSTR)_bstr_t(vsj);	 
				vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
				if(vzzzk.vt!=VT_NULL) 
					Czzzk=(LPCSTR)_bstr_t(vzzzk); 
				vxsdj=m_pRecordset->GetCollect("薪水等级");		//14	 
				if(vxsdj.vt!=VT_NULL) 
					Cxsdj=(LPCSTR)_bstr_t(vxsdj);		 
				CString ct;	 
				ct.Format("%d",number2);	 
				m_pMainQuery->m_listview.InsertItem(number,ct);	 
				m_pMainQuery->m_listview.SetItemText(number,1,Cygbh);	 
				m_pMainQuery->m_listview.SetItemText(number,2,Cygxm);	 
				m_pMainQuery->m_listview.SetItemText(number,3,Cbm);	 
				m_pMainQuery->m_listview.SetItemText(number,4,Cxb);		 
				m_pMainQuery->m_listview.SetItemText(number,5,Ccsny);		 
				m_pMainQuery->m_listview.SetItemText(number,6,Cmz);	 
				m_pMainQuery->m_listview.SetItemText(number,7,Cjg);		 
				m_pMainQuery->m_listview.SetItemText(number,8,Chyzk);	 
				m_pMainQuery->m_listview.SetItemText(number,9,Cxl);	 
				m_pMainQuery->m_listview.SetItemText(number,10,Czw);	 
				m_pMainQuery->m_listview.SetItemText(number,11,Csfzh);	 
				m_pMainQuery->m_listview.SetItemText(number,12,Csj);	 
				m_pMainQuery->m_listview.SetItemText(number,13,Czzzk); 
				m_pMainQuery->m_listview.SetItemText(number,14,Cxsdj);	 
				number++;		 
				number2++;		 
				m_pRecordset->MoveNext(); 
			} 
			//m_pRecordset->Close(); 
			 
		} 
	} 
	catch(_com_error e) 
	{ 
	} 
m_pRecordset->Close(); 
} 
 
void CJianSuo::OnCbnCloseupCondition2() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	m_pRecordset.CreateInstance(_uuidof(Recordset)); 
	try 
	{ 
		m_pRecordset->Open("SELECT * FROM 基本信息 ORDER BY 员工编号",theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
	} 
	catch(_com_error se) 
	{ 
		AfxMessageBox(se.ErrorMessage()); 
		return ; 
	} 
	m_pRecordset->MoveFirst(); 
	CString Cbd; 
	GetDlgItemText(IDC_CONDITION2,Cbd); 
	while(cb4.GetCount()!=0)cb4.DeleteString(0); 
	int i=0; 
	while(!m_pRecordset->adoEOF) 
	{ 
		int j=0; 
		CString vygbh; 
		vygbh=m_pRecordset->GetCollect(_bstr_t(Cbd));	 
		for(j;jMoveNext(); 
	} 
	m_pRecordset->Close(); 
} 
void CJianSuo::OnCbnCloseupBiaoduan() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	m_pRecordset.CreateInstance(_uuidof(Recordset)); 
	try 
	{ 
		m_pRecordset->Open("SELECT * FROM 基本信息 ORDER BY 员工编号",theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
	} 
	catch(_com_error se) 
	{ 
		AfxMessageBox(se.ErrorMessage()); 
		return ; 
	} 
	m_pRecordset->MoveFirst(); 
	CString Cbd; 
	GetDlgItemText(IDC_BIAODUAN,Cbd); 
	while(cb2.GetCount()!=0)cb2.DeleteString(0); 
	int i=0; 
	while(!m_pRecordset->adoEOF) 
	{ 
		int j=0; 
		CString vygbh; 
		vygbh=m_pRecordset->GetCollect(_bstr_t(Cbd));	 
		for(j;jMoveNext(); 
	} 
	m_pRecordset->Close(); 
}