searchemp.cpp

书店销售管理系统 用c++写的

// SearchEmp.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "SearchEmp.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchEmp dialog


CSearchEmp::CSearchEmp(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchEmp::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchEmp)
	m_SEedit = _T("");
	m_SEcom = 0;
	//}}AFX_DATA_INIT
}


void CSearchEmp::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchEmp)
	DDX_Control(pDX, IDC_SEARCHEMP, m_SearchEmpList);
	DDX_Text(pDX, IDC_SEARCHEMPEDIT, m_SEedit);
	DDX_CBIndex(pDX, IDC_SEARCHEMPCOM, m_SEcom);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchEmp, CDialog)
	//{{AFX_MSG_MAP(CSearchEmp)
	ON_BN_CLICKED(IDC_SEARCHEMPBT, OnSearchempbt)
	ON_CBN_DROPDOWN(IDC_SEARCHEMPCOM, OnDropdownSearchempcom)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchEmp message handlers
BOOL CSearchEmp::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_SearchEmpList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	
	m_SearchEmpList.InsertColumn(0,_T("员工号"),LVCFMT_CENTER,80);
	m_SearchEmpList.InsertColumn(1,_T("姓名"),LVCFMT_CENTER,80);
	m_SearchEmpList.InsertColumn(2,_T("性别"),LVCFMT_CENTER,60);
	m_SearchEmpList.InsertColumn(3,_T("年龄"),LVCFMT_CENTER,60);
	m_SearchEmpList.InsertColumn(4,_T("身份证"),LVCFMT_CENTER,140);
	m_SearchEmpList.InsertColumn(5,_T("电话"),LVCFMT_CENTER,120);
	m_SearchEmpList.InsertColumn(6,_T("住址"),LVCFMT_CENTER,120);
	m_SearchEmpList.InsertColumn(7,_T("电子邮件"),LVCFMT_CENTER,100);
	return TRUE;
}

void CSearchEmp::OnSearchempbt() 
{
	m_SearchEmpList.DeleteAllItems();
	SHOP::_RecordsetPtr pRst;
	this->UpdateData(true);

	SHOP::_CommandPtr cmd(__uuidof(SHOP::Command));
	CString com;
	_bstr_t condition;
	condition = "%"+m_SEedit+"%";
	
	try
	{
		if(m_SEcom == 0)
		{
			cmd->CommandText = "select * from EMP where EMPID like ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("EMPID",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("EMPID")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
		if(m_SEcom == 1)
		{
			cmd->CommandText = "select * from EMP where EMPNAME like ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("EMPNAME",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("EMPNAME")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}

		while(!pRst->End)
		{
			_variant_t vEMPNO = pRst->Fields->GetItem("EMPID")->Value;
			_variant_t vEMPNAME = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vEMPGENDER = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vEMPAGE = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vEMPID = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vEMPADDRESS = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vEMPTELE = pRst->Fields->GetItem(long(6))->Value;
			_variant_t vEMPEMAIL = pRst->Fields->GetItem(long(7))->Value;
			
			CString m_empno = vEMPNO.bstrVal;
			CString m_empname = vEMPNAME.bstrVal;
			int		m_empgender = vEMPGENDER.iVal;
			int		m_empage = vEMPAGE.iVal;
			CString m_empid = vEMPID.bstrVal;
			CString m_emptele = vEMPTELE.bstrVal;
			CString m_empaddress = vEMPADDRESS.bstrVal;
			CString m_empemail = vEMPEMAIL.bstrVal;

			CString gender,age;
			if(m_empgender == 0)
				gender = "男";
			else
				gender = "女";
			age.Format("%d",m_empage);
			
			m_SearchEmpList.InsertItem(0,m_empno);
			m_SearchEmpList.SetItemText(0,1,m_empname);
			m_SearchEmpList.SetItemText(0,2,gender);
			m_SearchEmpList.SetItemText(0,3,age);
			m_SearchEmpList.SetItemText(0,4,m_empid);
			m_SearchEmpList.SetItemText(0,5,m_emptele);
			m_SearchEmpList.SetItemText(0,6,m_empaddress);
			m_SearchEmpList.SetItemText(0,7,m_empemail);
			
			pRst->MoveNext();
		}

		pRst->Close();
		pRst.Release();

	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}
}

void CSearchEmp::OnDropdownSearchempcom() 
{
	m_SEedit.Empty();
	this->UpdateData(false);
}