?? usersearchdlg.cpp
字號:
// UserSearchDlg.cpp : implementation file
//
#include "stdafx.h"
#include "SuperMarket.h"
#include "UserSearchDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CUserSearchDlg dialog
CUserSearchDlg::CUserSearchDlg(CWnd* pParent /*=NULL*/)
: CDialog(CUserSearchDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CUserSearchDlg)
m_name = _T("");
//}}AFX_DATA_INIT
}
void CUserSearchDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CUserSearchDlg)
DDX_Control(pDX, IDC_LIST1, m_list);
DDX_Text(pDX, IDC_nama, m_name);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CUserSearchDlg, CDialog)
//{{AFX_MSG_MAP(CUserSearchDlg)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CUserSearchDlg message handlers
void CUserSearchDlg::OnOK()
{
m_list.DeleteAllItems();
UpdateData();
CDatabase dbTemp;
CString str0,str1,str2,str3,name;
int a=0,times=0;
dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
CRecordset rs( &dbTemp); //查詢
rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 用戶表");
while(!rs.IsEOF())
{
rs.GetFieldValue((short)0,str0);
rs.GetFieldValue((short)1,str1);
rs.GetFieldValue((short)2,str2);
rs.GetFieldValue((short)3,str3);
if(str0==m_name||str1==m_name)
{
a=1;
m_list.InsertItem (times,str0);//寫第一列;
m_list.SetItemText (times,1,str1);//第二列;
m_list.SetItemText (times,2,str2);//第三列;
m_list.SetItemText (times,3,str3);//第四列;
times = times + 1;
}
rs.MoveNext();
}
if(a==0)
{
MessageBox("你所查詢的用戶不存在,請重新輸入");
m_name="";
UpdateData(FALSE);
}
}
BOOL CUserSearchDlg::OnInitDialog()
{
CDialog::OnInitDialog();
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE);
m_list.InsertColumn(0,"用戶編號",LVCFMT_LEFT,80);
m_list.InsertColumn(1,"用戶名稱",LVCFMT_LEFT,110);
m_list.InsertColumn(2,"用戶密碼",LVCFMT_LEFT,80);
m_list.InsertColumn(3,"用戶類型",LVCFMT_LEFT,120);
// TODO: Add extra initialization here
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -