// DelMemberDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SuperMarket.h"
#include "DelMemberDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDelMemberDlg dialog


CDelMemberDlg::CDelMemberDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDelMemberDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDelMemberDlg)
	m_date = _T("");
	m_discount = _T("");
	m_hynumber = _T("");
	m_hyname = _T("");
	m_momey = _T("");
	//}}AFX_DATA_INIT
}


void CDelMemberDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDelMemberDlg)
	DDX_Text(pDX, IDC_Date, m_date);
	DDX_Text(pDX, IDC_discount, m_discount);
	DDX_Text(pDX, IDC_HYNUMBER, m_hynumber);
	DDX_Text(pDX, IDC_hyname, m_hyname);
	DDX_Text(pDX, IDC_momey, m_momey);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDelMemberDlg, CDialog)
	//{{AFX_MSG_MAP(CDelMemberDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDelMemberDlg message handlers

void CDelMemberDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
		UpdateData(); 
	CDatabase dbTemp;
	CString str0,str1,str2,str3,str4;

	
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數(shù)據(jù)庫(kù).mdb;");
	CRecordset  rs( &dbTemp);
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會(huì)員信息表 where 會(huì)員編號(hào)='"+m_hynumber+"'");

	if(rs.IsEOF())  
	{
		MessageBox("輸入的會(huì)員編號(hào)不存在，請(qǐng)重新輸入!"); 		
	}
    else    
	{
 	   
		rs.GetFieldValue((short)1,str1);
		rs.GetFieldValue((short)2,str2);
		rs.GetFieldValue((short)3,str3);
		rs.GetFieldValue((short)4,str4);
		m_hyname=str1;
		m_momey=atof(str2);
		m_date=str3;
		m_discount=str4;
       UpdateData(false);
	}
}

void CDelMemberDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	CDatabase dbTemp;
  	CString strSQL;
	UpdateData();
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數(shù)據(jù)庫(kù).mdb;");

        strSQL="delete from 會(huì)員信息表  where 會(huì)員編號(hào)='"+m_hynumber+"'";
		dbTemp.ExecuteSQL(strSQL);
		MessageBox("刪除成功!");

	m_hynumber="";
    m_hyname="";
    m_momey="";
   	m_discount="";
   	m_date="";
	UpdateData(false);
	dbTemp.Close();
}