?? manvip.cpp
字號:
// 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());
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -