// AddMemberDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CAddMemberDlg dialog


CAddMemberDlg::CAddMemberDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddMemberDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddMemberDlg)
	m_date = 0;
	m_discount = _T("");
	m_hyname = _T("");
	m_hynumber = _T("");
	m_memey = 0.0f;
	//}}AFX_DATA_INIT
}


void CAddMemberDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddMemberDlg)
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER, m_date);
	DDX_Text(pDX, IDC_discount, m_discount);
	DDX_Text(pDX, IDC_hyname, m_hyname);
	DDX_Text(pDX, IDC_HYNUMBER, m_hynumber);
	DDX_Text(pDX, IDC_memey, m_memey);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddMemberDlg, CDialog)
	//{{AFX_MSG_MAP(CAddMemberDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddMemberDlg message handlers

void CAddMemberDlg::OnOK() 
{
	// TODO: Add extra validation here
		CString str0,str1,str2;

    CString strSQL;
	CDatabase dbTemp;

	UpdateData();
	if(m_hynumber=="")
	{
     MessageBox("請輸入會員編號!"); 
	}
	else
		if(m_hyname=="")
		{
			 MessageBox("請輸入會員名稱!"); 
		}
	else
		if(m_discount=="")
		{
			 MessageBox("請輸入優惠折扣!"); 
		}
		
	else	
	{
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
	CRecordset  rs( &dbTemp);
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會員信息表 where 會員編號='"+m_hynumber+"'");

	if(!rs.IsEOF())  //如果是舊產品，更新庫存 
	{
		MessageBox("會員編號已存在，請輸入另外一個會員編號!"); 	
		m_date = 0;
	m_discount = _T("");
	m_hyname = _T("");
	m_hynumber = _T("");
	m_memey = 0.0f;
	UpdateData(false);
	}
    else    //如果是新產品，添加商品信息  
	{
		
		str0.Format("%d-%d-%d",m_date.GetYear(),m_date.GetMonth(),m_date.GetDay());
		str1.Format("%f",m_memey);				
		strSQL="insert into 會員信息表 values('"+m_hynumber+"','"+m_hyname+"','"+str1+"','"+str0+"','"+m_discount+"')";  
	    dbTemp.ExecuteSQL(strSQL);
		MessageBox("添加成功!"); //初始化窗口
		m_date = 0;


	m_hynumber = _T("");

	UpdateData(false);
	}

	
	}

}