// ChangeMemberDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CChangeMemberDlg dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// CChangeMemberDlg message handlers

void CChangeMemberDlg::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=超市管理數據庫.mdb;");
	CRecordset  rs( &dbTemp);
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會員信息表 where 會員編號='"+m_hynumber+"'");

	if(rs.IsEOF())  
	{
		MessageBox("輸入的會員編號不存在，請重新輸入!"); 		
	}
    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 CChangeMemberDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	    UpdateData(); 
        CString strSQL;
       CDatabase dbTemp;
	   CString str0,str1,str2,str3,str4,str5;
       dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
	   CRecordset  rs( &dbTemp);
	   rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會員信息表 where 會員編號='"+m_hynumber+"'");
     	rs.GetFieldValue((short)1,str1);
		rs.GetFieldValue((short)2,str2);
		rs.GetFieldValue((short)3,str3);
		rs.GetFieldValue((short)4,str4);
		
       
		if(m_hyname==str1&&m_momey==str2&&m_date==str3&&m_discount==str4)
		{
				MessageBox("會員信息沒修改!"); 
		}
		else
		{
	
        UpdateData(); 
      
	    strSQL="update 會員信息表 set 會員名稱='"+m_hyname+"' where 會員編號='"+m_hynumber+"'"; 
	    strSQL="update 會員信息表 set 累積消費金額='"+m_momey+"' where 會員編號='"+m_hynumber+"'"; 
	    strSQL="update 會員信息表 set 注冊時間='"+m_date+"' where 會員編號='"+m_hynumber+"'"; 
		strSQL="update 會員信息表 set 折扣='"+m_discount+"' where 會員編號='"+m_hynumber+"'"; 
	    dbTemp.ExecuteSQL(strSQL);
	   MessageBox("會員信息修改成功!"); 
		}
}