?? guestinfolookup.cpp
字號:
// GuestInfoLookup.cpp : implementation file
//
#include "stdafx.h"
#include "qq.h"
#include "GuestInfoLookup.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CGuestInfoLookup dialog
CString CGuestInfoLookup::STRINGS[100]={""};
CGuestInfoLookup::CGuestInfoLookup(CWnd* pParent /*=NULL*/)
: CDialog(CGuestInfoLookup::IDD, pParent)
{
//{{AFX_DATA_INIT(CGuestInfoLookup)
//}}AFX_DATA_INIT
HandCode = _T("");//初始化數據成員
Name = _T("");
GuestType = _T("");
Sex = _T("");
Certificate = _T("");
CertifyCode = _T("");
IsMember = FALSE;
IsMaster = FALSE;
GroupID = _T("");
GuestNum = 0;
RoomNum = _T("");
RoomCode = _T("");
bSuccess=false;
}
void CGuestInfoLookup::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CGuestInfoLookup)
DDX_Control(pDX, IDC_COMBO1, m_InfoLookup_HandCode);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CGuestInfoLookup, CDialog)
//{{AFX_MSG_MAP(CGuestInfoLookup)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CGuestInfoLookup message handlers
void CGuestInfoLookup::OnOK()
{
// TODO: Add extra validation here
CString str;
m_InfoLookup_HandCode.GetWindowText(str);
if(str=="")
{
MessageBox("請輸入手牌號!","數據為空錯誤",MB_OK);
return ;
}
//查詢數據庫,保存查詢得到的結果用來顯示
/////連接數據庫,SQLstr
if(!m_GuestInfoSet.Open(AFX_DB_USE_DEFAULT_TYPE))
{
MessageBox("打開數據庫失敗!","數據庫錯誤",MB_OK);
bSuccess=false;
return ;
}
bool bInSQL=false;//是否存在這個數據記錄
m_GuestInfoSet.MoveFirst();
while(!m_GuestInfoSet.IsEOF())
{
if(m_GuestInfoSet.m_HandCode==str)
{
bInSQL=true;
break;
}
else bInSQL=false;
m_GuestInfoSet.MoveNext();
}
///////////////////////////////////////////////////////////
// 查詢成功的話保存得到的數據
if(bInSQL)
{
HandCode=m_GuestInfoSet.m_HandCode;
Name=m_GuestInfoSet.m_Name;
GuestType=m_GuestInfoSet.m_GuestType;
Sex=m_GuestInfoSet.m_Sex;
Certificate=m_GuestInfoSet.m_Certificate;
CertifyCode=m_GuestInfoSet.m_CertifyCode;
IsMember=m_GuestInfoSet.m_IsMember;
IsMaster=m_GuestInfoSet.m_IsMaster;
GroupID=m_GuestInfoSet.m_GroupID;
GuestNum=m_GuestInfoSet.m_GuestNum;
RoomNum=m_GuestInfoSet.m_RoomNum;
RoomCode=m_GuestInfoSet.m_RoomCode;
bSuccess=true;
}
else
{
MessageBox("該記錄不存在!","記錄錯誤",MB_OK);
bSuccess=false;
m_GuestInfoSet.Close();
return ;
}
////保存數據完成關閉數據庫
m_GuestInfoSet.Close();
CDialog::OnOK();
}
BOOL CGuestInfoLookup::OnInitDialog()
{
CDialog::OnInitDialog();
HICON m_hIcon=AfxGetApp()->LoadIcon(IDR_MAINFRAME2);
this->SetIcon(m_hIcon,true);//設置對話框圖標
// TODO: Add extra initialization here
m_acCombo.Init(GetDlgItem(IDC_COMBO1));
if(!m_GuestInfoSet.Open(AFX_DB_USE_DEFAULT_TYPE))
{
MessageBox("打開數據庫失敗!","數據庫錯誤",MB_OK);
return false;
}
InitDate();//初始化數組
m_GuestInfoSet.MoveFirst();//move to the first record
int i=0;
while(!m_GuestInfoSet.IsEOF())
{
STRINGS[i]=m_GuestInfoSet.m_HandCode;
m_GuestInfoSet.MoveNext();
i++;
}
m_GuestInfoSet.Close();//關閉數據庫
for (int j=0;(!STRINGS[j].IsEmpty()); j++)
{
m_acCombo.GetStringList().Add(STRINGS[j].GetBuffer(STRINGS[j].GetLength()));
}
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CGuestInfoLookup::InitDate()
{
for(int i=0;i<100;i++)
{
STRINGS[i]="";
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -