// 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
}