// DOp.cpp : implementation file
//

#include "stdafx.h"
#include "htglxt.h"
#include "DOp.h"
#include "DBaseQuery.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDOp dialog


CDOp::CDOp(CWnd* pParent /*=NULL*/)
	: CDialog(CDOp::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDOp)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDOp::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDOp)
	DDX_Control(pDX, IDC_EDTSPWD, m_EdtSpwd);
	DDX_Control(pDX, IDC_EDTPWD, m_EdtPwd);
	DDX_Control(pDX, IDC_EDTNAME, m_EdtName);
	DDX_Control(pDX, IDC_EDTID, m_EdtID);
	DDX_Control(pDX, IDC_BUTUNDO, m_ButUndo);
	DDX_Control(pDX, IDC_BUTSAVE, m_ButSave);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_BUTDELE, m_ButDele);
	DDX_Control(pDX, IDC_BUTCHANGE1, m_ButChange);
	DDX_Control(pDX, IDC_BUTADD, m_ButAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDOp, CDialog)
	//{{AFX_MSG_MAP(CDOp)
	ON_BN_CLICKED(IDC_BUTADD, OnButadd)
	ON_BN_CLICKED(IDC_BUTCHANGE1, OnButchange1)
	ON_BN_CLICKED(IDC_BUTDELE, OnButdele)
	ON_BN_CLICKED(IDC_BUTSAVE, OnButsave)
	ON_BN_CLICKED(IDC_BUTUNDO, OnButundo)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDOp message handlers

void CDOp::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDOp::Clear()
{
	m_EdtSpwd.SetWindowText("");
	m_EdtPwd.SetWindowText("");
	m_EdtName.SetWindowText("");
	m_EdtID.SetWindowText("");

}

void CDOp::Display(CString sID)
{
	if(sID.IsEmpty())
		return;
	CString sSQL;
	RxRecordset drst;
	sSQL.Format("SELECT * FROM 用戶信息表 WHERE 編號='%s'",sID);
	drst.Open(sSQL,adCmdText);
	if(drst.GetRecordCount()<1)
		return;
	CString sName,sPwd;
	sName=drst.GetFieldValue("用戶名");
	sPwd=drst.GetFieldValue("密碼");	
	
	m_EdtID.SetWindowText(sID);
	m_EdtName.SetWindowText(sName);
	m_EdtPwd.SetWindowText(sPwd);
	m_EdtSpwd.SetWindowText(sPwd);
}

void CDOp::Enabled(bool bEnabled)
{
	m_EdtSpwd.EnableWindow(bEnabled);
	m_EdtPwd.EnableWindow(bEnabled);
	m_EdtName.EnableWindow(bEnabled);
	m_ButUndo.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(bEnabled);
	m_ButExit.EnableWindow(!bEnabled);
	m_ButDele.EnableWindow(!bEnabled);
	m_ButChange.EnableWindow(!bEnabled);
	m_ButAdd.EnableWindow(!bEnabled);

}

BOOL CDOp::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	
	CDBaseQuery* ParentWnd=(CDBaseQuery*)FindWindow(NULL,"用戶信息查詢");
	m_sID=ParentWnd->m_Grid.GetItemText(ParentWnd->m_Grid.GetRow(),0);
	this->Display(m_sID);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDOp::OnButadd() 
{
	AddOrChange=1;
	this->Enabled(true);
	this->Clear();
	CString NewID=ado.AutoNumber("用戶信息表","編號","",1);
	m_EdtID.SetWindowText(NewID);
	m_EdtName.SetFocus();
	
}

void CDOp::OnButchange1() 
{
	AddOrChange=2;
	this->Enabled(true);
	m_EdtName.SetFocus();
	
}

void CDOp::OnButdele() 
{
	if(MessageBox("確定要刪除此條記錄嗎？","系統提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	CString sSQL;
	sSQL.Format("DELETE FROM 用戶信息表 WHERE 編號=%s",m_sID);
	RxRecordset Drst;
	Drst.Open(sSQL,adCmdText);
	this->OnCancel();
	
}

void CDOp::OnButsave() 
{
	if(MessageBox("確定要保存記錄嗎？","系統提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	CString sSQL,sID,sName,sPwd,sSpwd;
	m_EdtID.GetWindowText(sID);
	m_EdtName.GetWindowText(sName);
	m_EdtPwd.GetWindowText(sPwd);
	m_EdtSpwd.GetWindowText(sSpwd);
	if (sPwd!=sSpwd)
	{
		MessageBox("您兩次輸入的密碼不一致，請確認后重新輸入！","系統提示",MB_OK);
		m_EdtPwd.SetWindowText("");
		m_EdtSpwd.SetWindowText("");
		m_EdtPwd.SetFocus();
		return;
	}
	OP=sName;
	if(AddOrChange==1)//添加操作
		sSQL.Format("Insert Into 用戶信息表 Values(%s,'%s','%s')",sID,sName,sPwd);
	else
		sSQL.Format("Update 用戶信息表 set 用戶名='%s',密碼='%s' WHERE 編號=%s",sName,sPwd,sID);
	RxRecordset arst;
	arst.Open(sSQL,adCmdText);
	this->Enabled(false);
	this->m_ButAdd.SetFocus();

}

void CDOp::OnButundo() 
{
	if(MessageBox("確定要撤消操作嗎？","系統提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	this->Enabled(false);
	this->Clear();
	this->Display(m_sID);
	this->m_ButAdd.SetFocus();

}

void CDOp::OnButexit() 
{
this->OnCancel();	
}