manvip.cpp

赛克思书店销售管理系统.可用于二次开发,以C++与sql 写.

// ManVip.cpp : implementation file
//

#include "stdafx.h"
#include "Project.h"
#include "ManVip.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManVip dialog


CManVip::CManVip(CWnd* pParent /*=NULL*/)
	: CDialog(CManVip::IDD, pParent)
{
	//{{AFX_DATA_INIT(CManVip)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CManVip::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CManVip)
	DDX_Control(pDX, IDC_LIST1, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CManVip, CDialog)
	//{{AFX_MSG_MAP(CManVip)
	ON_BN_CLICKED(IDC_DELVIP, OnDelVip)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CManVip message handlers
BOOL CManVip::OnInitDialog()
{
	CDialog::OnInitDialog();

	m_List.SetTextColor(RGB (0, 0, 0));
	m_List.SetBkColor(RGB(255,255,255));
	m_List.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	

	m_List.InsertColumn(0,_T("会员代号"),LVCFMT_CENTER,80);
	m_List.InsertColumn(1,_T("姓名"),LVCFMT_CENTER,80);
	m_List.InsertColumn(2,_T("性别"),LVCFMT_CENTER,60);
	m_List.InsertColumn(3,_T("年龄"),LVCFMT_CENTER,60);
	m_List.InsertColumn(4,_T("身份证"),LVCFMT_CENTER,100);
	m_List.InsertColumn(5,_T("电话"),LVCFMT_CENTER,100);
	m_List.InsertColumn(6,_T("登记日期"),LVCFMT_CENTER,100);
	m_List.InsertColumn(7,_T("工作单位"),LVCFMT_CENTER,100);
	m_List.InsertColumn(8,_T("消费额"),LVCFMT_CENTER,100);

	OnRefresh();
	return TRUE;
}

void CManVip::OnRefresh()
{
	m_List.DeleteAllItems();
	vip.clear();
	CString _sql;
	vipin	vipinfor;
	_sql = "select * from vip";
	_bstr_t sql = _sql;
	try
	{
		pRst = pConn->Execute(sql,NULL,adCmdText);
		while(!pRst->End)
		{
			_variant_t vVIPNO = pRst->Fields->GetItem(long(0))->Value;
			_variant_t vVIPNAME = pRst->Fields->GetItem(long(1))->Value;
			_variant_t vGENDER = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vVIPAGE = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vVIPID = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vREGDATE = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vTELE = pRst->Fields->GetItem(long(6))->Value;
			_variant_t vCOM = pRst->Fields->GetItem(long(7))->Value;
			_variant_t vCONSUME = pRst->Fields->GetItem(long(8))->Value;

			vipinfor.vipno = (char *)_bstr_t(vVIPNO);

			vipinfor.vipname = (char *)_bstr_t(vVIPNAME);

			if(vGENDER.iVal == 0)
				vipinfor.vipgender = "男";
			else
				vipinfor.vipgender = "女";

			vipinfor.vipage = (char *)_bstr_t(vVIPAGE);

			vipinfor.vipid = (char *)_bstr_t(vVIPID);

			vipinfor.vipregdate = (char *)_bstr_t(vREGDATE);

			vipinfor.viptele = (char *)_bstr_t(vTELE);

			vipinfor.vipcom = (char *)_bstr_t(vCOM);

			if(vCONSUME.vt == VT_NULL)
				vipinfor.vipconsume = "0";
			else
				vipinfor.vipconsume = (char *)_bstr_t(vCONSUME);
			vip.push_back(vipinfor);

			pRst->MoveNext();
		}
		for(int i = 0;i < vip.size();i ++)
		{
			m_List.InsertItem(i,vip[i].vipno);
			m_List.SetItemText(i,1,vip[i].vipname);
			m_List.SetItemText(i,2,vip[i].vipgender);
			m_List.SetItemText(i,3,vip[i].vipage);
			m_List.SetItemText(i,4,vip[i].vipid);
			m_List.SetItemText(i,5,vip[i].vipregdate);
			m_List.SetItemText(i,6,vip[i].viptele);
			m_List.SetItemText(i,7,vip[i].vipcom);
			m_List.SetItemText(i,8,vip[i].vipconsume);
		}

		pRst->Close();
		pRst.Release();
	}
	catch(_com_error &e)
	{
		if(pConn == NULL)
			AfxMessageBox("未连接数据库");
		else
			AfxMessageBox(e.Description());
		CDialog::OnOK();
	}
}

void CManVip::OnDelVip()
{
	cursel = m_List.GetSelectionMark();
	if(cursel >= 0)
	{
		if(AfxMessageBox("确定删除吗?",1) == IDOK)
		{
			CString _sql;
			_sql.Format("delete from vip where vipno = \'%s\'",vip[cursel].vipno);
			_bstr_t sql = _sql;
			try
			{
				pConn->Execute(sql,NULL,adCmdText);
				m_List.DeleteItem(cursel);
			}
			catch(_com_error &e)
			{
				AfxMessageBox(e.Description());
			}
		}
	}
}