// DeleteStoreDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CDeleteStoreDlg dialog


CDeleteStoreDlg::CDeleteStoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDeleteStoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDeleteStoreDlg)
	m_spaddress = _T("");
	m_spname = _T("");
	m_spnumber = _T("");
	m_spcount = _T("");
	m_spprice = _T("");
	//}}AFX_DATA_INIT
}


void CDeleteStoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDeleteStoreDlg)
	DDX_Text(pDX, IDC_SPADDRESS, m_spaddress);
	DDX_Text(pDX, IDC_SPNAME, m_spname);
	DDX_Text(pDX, IDC_SPNUMBER, m_spnumber);
	DDX_Text(pDX, IDC_SPCOUNT, m_spcount);
	DDX_Text(pDX, IDC_SPPRICE, m_spprice);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDeleteStoreDlg, CDialog)
	//{{AFX_MSG_MAP(CDeleteStoreDlg)
	ON_BN_CLICKED(IDC_XSSTORE, OnXsstore)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDeleteStoreDlg message handlers

void CDeleteStoreDlg::OnXsstore() 
{
	// TODO: Add your control notification handler code here
	CDatabase dbTemp;
    CRecordset  rs( &dbTemp);
	UpdateData();
	if(m_spnumber=="")
	{
		MessageBox("請輸入商品編號");
	}
	else
	{
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
    rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 商品信息表 where 商品編號='"+m_spnumber+"'");
	if (!rs.IsEOF())	
	{
		rs.GetFieldValue((short)1,m_spname);
        rs.GetFieldValue((short)2,m_spprice);
		rs.GetFieldValue((short)3,m_spaddress);
		rs.GetFieldValue((short)4,m_spcount);
		m_flag=true;
	}
	else
	{
	    MessageBox("商品不存在,請確認后從新輸入!");
		m_spnumber="";
		m_flag=false;
	}
	UpdateData(false);
	rs.Close();
	dbTemp.Close();
	}
}

void CDeleteStoreDlg::OnOK() 
{
	// TODO: Add extra validation here
		CDatabase dbTemp;
  	CString strSQL;
	UpdateData();
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
	if (m_flag == true)
	{
        strSQL="delete from 商品信息表  where 商品編號='"+m_spnumber+"'";
		dbTemp.ExecuteSQL(strSQL);
		MessageBox("刪除成功!");
	m_spnumber="";
    m_spname="";
    m_spprice="";
   	m_spcount="";
   	m_spaddress="";
	UpdateData(false);
	} 
	

	dbTemp.Close();

}