searchvip.cpp

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

// SearchVip.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "SearchVip.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchVip dialog


CSearchVip::CSearchVip(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchVip::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchVip)
	m_SVedit = _T("");
	m_SVcom = 0;
	//}}AFX_DATA_INIT
}


void CSearchVip::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchVip)
	DDX_Control(pDX, IDC_SEARCHVIP, m_SearchVipList);
	DDX_Text(pDX, IDC_SEARCHVIPEDIT, m_SVedit);
	DDX_CBIndex(pDX, IDC_SEARCHVIPCOM, m_SVcom);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchVip, CDialog)
	//{{AFX_MSG_MAP(CSearchVip)
	ON_BN_CLICKED(IDC_SEARCHVIPBT, OnSearchvipbt)
	ON_CBN_DROPDOWN(IDC_SEARCHVIPCOM, OnDropdownSearchvipcom)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchVip message handlers
BOOL CSearchVip::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_SearchVipList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	
	m_SearchVipList.InsertColumn(0,_T("会员号"),LVCFMT_CENTER,80);
	m_SearchVipList.InsertColumn(1,_T("姓名"),LVCFMT_CENTER,80);
	m_SearchVipList.InsertColumn(2,_T("性别"),LVCFMT_CENTER,60);
	m_SearchVipList.InsertColumn(3,_T("身份证"),LVCFMT_CENTER,140);
	m_SearchVipList.InsertColumn(4,_T("年龄"),LVCFMT_CENTER,60);
	m_SearchVipList.InsertColumn(5,_T("联系电话"),LVCFMT_CENTER,120);
	m_SearchVipList.InsertColumn(6,_T("单位"),LVCFMT_CENTER,120);
	m_SearchVipList.InsertColumn(7,_T("登记日期"),LVCFMT_CENTER,120);
	m_SearchVipList.InsertColumn(8,_T("消费额"),LVCFMT_CENTER,80);
	return TRUE;
}

void CSearchVip::OnSearchvipbt() 
{
	m_SearchVipList.DeleteAllItems();
	SHOP::_RecordsetPtr pRst;
	this->UpdateData(true);

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

		while(!pRst->End)
		{
			_variant_t vVIPNO = pRst->Fields->GetItem("VIPNO")->Value;
			_variant_t vVIPNAME = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vVIPGENDER = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vVIPID = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vVIPAGE = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vVIPTELE = pRst->Fields->GetItem(long(5))->Value;
//			_variant_t vVIPREGDATE = pRst->Fields->GetItem(long(6))->Value;
			_variant_t vCOM = pRst->Fields->GetItem(long(7))->Value;
			_variant_t vCONSUME = pRst->Fields->GetItem(long(8))->Value;
			
			CString m_vipno = vVIPNO.bstrVal;
			CString m_vipname = vVIPNAME.bstrVal;
			int		m_vipgender = vVIPGENDER.iVal;
			CString m_vipid = vVIPID.bstrVal;
			int		m_vipage = vVIPAGE.iVal;
			CString m_viptele = vVIPTELE.bstrVal;
			CString m_vipcom = vCOM.bstrVal;
			int   m_vipconsume = vCONSUME.iVal;

			CString gender,consume,age,regdate;

			if(m_vipgender == 0)
				gender = "男";
			else
				gender = "女";
			
			age.Format("%d",m_vipage);
			consume.Format("%d",m_vipconsume);
			consume.Insert(consume.GetLength()-2,".");
			
			m_SearchVipList.InsertItem(0,m_vipno);
			m_SearchVipList.SetItemText(0,1,m_vipname);
			m_SearchVipList.SetItemText(0,2,gender);
			m_SearchVipList.SetItemText(0,3,m_vipid);
			m_SearchVipList.SetItemText(0,4,age);
			m_SearchVipList.SetItemText(0,5,m_viptele);
			m_SearchVipList.SetItemText(0,6,m_vipcom);
			m_SearchVipList.SetItemText(0,8,consume);
			
			pRst->MoveNext();
		}

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

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

void CSearchVip::OnDropdownSearchvipcom() 
{
	m_SVedit.Empty();
	this->UpdateData(false);		
}