// DStore.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CDStore dialog


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


void CDStore::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDStore)
	DDX_Control(pDX, IDC_SPXX_BUTUNDO, m_ButUndo);
	DDX_Control(pDX, IDC_SPXX_BUTSAVE, m_ButSave);
	DDX_Control(pDX, IDC_SPXX_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_SPXX_BUTDELE, m_ButDele);
	DDX_Control(pDX, IDC_SPXX_BUTCHANGE, m_ButChange);
	DDX_Control(pDX, IDC_SPXX_BUTADD, m_ButAdd);
	DDX_Control(pDX, IDC_EDTTEL, m_EdtTel);
	DDX_Control(pDX, IDC_EDTMEM, m_EdtMem);
	DDX_Control(pDX, IDC_EDT_ADDR, m_EdtAddr);
	DDX_Control(pDX, IDC_CK_EDTNAME, m_EdtName);
	DDX_Control(pDX, IDC_CK_EDTID, m_EdtID);
	DDX_Control(pDX, IDC_CK_COMADMIN, m_ComAdmin);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDStore, CDialog)
	//{{AFX_MSG_MAP(CDStore)
	ON_BN_CLICKED(IDC_SPXX_BUTADD, OnSpxxButadd)
	ON_BN_CLICKED(IDC_SPXX_BUTCHANGE, OnSpxxButchange)
	ON_BN_CLICKED(IDC_SPXX_BUTDELE, OnSpxxButdele)
	ON_BN_CLICKED(IDC_SPXX_BUTSAVE, OnSpxxButsave)
	ON_BN_CLICKED(IDC_SPXX_BUTUNDO, OnSpxxButundo)
	ON_BN_CLICKED(IDC_SPXX_BUTEXIT, OnSpxxButexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDStore message handlers

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

void CDStore::Clear()
{
	m_EdtTel.SetWindowText("");
	m_EdtMem.SetWindowText("");
	m_EdtAddr.SetWindowText("");
	m_EdtName.SetWindowText("");
	m_EdtID.SetWindowText("");
	m_ComAdmin.SetWindowText("");
}

void CDStore::Display(CString ID)
{
	RxRecordset Drxt;
	CString sSQL;
	if(ID.IsEmpty())
		return;

	sSQL.Format("SELECT * FROM 倉庫信息查詢 WHERE 編號 =%s",ID);
	Drxt.Open(sSQL,adCmdText);

	CString sID,sName,sAddr,sTel,sAdmin,sMem;
	sID=Drxt.GetFieldValue("編號");
	sName=Drxt.GetFieldValue("名稱");
	sAddr=Drxt.GetFieldValue("地址");
	sTel=Drxt.GetFieldValue("電話");
	sAdmin=Drxt.GetFieldValue("管理員");
	sMem=Drxt.GetFieldValue("備注");

	m_EdtTel.SetWindowText(sTel);
	m_EdtMem.SetWindowText(sMem);
	m_EdtAddr.SetWindowText(sAddr);
	m_EdtName.SetWindowText(sName);
	m_EdtID.SetWindowText(sID);
	m_ComAdmin.SetWindowText(sAdmin);
}

void CDStore::Enabled(bool bEnabled)
{
	m_EdtTel.EnableWindow(bEnabled);
	m_EdtMem.EnableWindow(bEnabled);
	m_EdtAddr.EnableWindow(bEnabled);
	m_EdtName.EnableWindow(bEnabled);
	m_ComAdmin.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 CDStore::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CDBaseQuery* Parent =(CDBaseQuery*)this->FindWindow(NULL,"倉庫信息查詢");
	CString sSQL,sID;
	sID=Parent->m_Grid.GetItemText(Parent->m_CurrentRow,0);
	m_sID=sID;
	this->Display(sID);
	rst.Open("員工信息表");
	this->m_ComAdmin.SetRecordset(rst,"姓名");
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


void CDStore::OnSpxxButadd() 
{
	AddOrChange=1;
	CString sNewID;
	sNewID=ado.AutoNumber("倉庫信息表","編號","",1);
	this->Clear();
	m_EdtID.SetWindowText(sNewID);
	this->Enabled(true);
	this->m_EdtName.SetFocus();		
}

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

void CDStore::OnSpxxButdele() 
{
	if(MessageBox("確定要刪除記錄嗎？"," 系統提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	CString cID,sSQL;
	this->m_EdtID.GetWindowText(cID);
	sSQL.Format("DELETE FROM 倉庫信息表 WHERE 編號=%s",cID);
	rst.Open(sSQL,adCmdText);
	this->OnCancel();	
	
}

void CDStore::OnSpxxButsave() 
{
	if(MessageBox("確定要保存記錄嗎？"," 系統提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	CString sSQL,sID,sName,sAddr,sTel,sAdmin,sMem,sAdminID;
	m_EdtTel.GetWindowText(sTel);
	m_EdtMem.GetWindowText(sMem);
	m_EdtAddr.GetWindowText(sAddr);
	m_EdtName.GetWindowText(sName);
	m_EdtID.GetWindowText(sID);
	m_ComAdmin.GetWindowText(sAdmin);
	sAdminID=ado.FieldToOtherField("員工信息表","姓名",sAdmin,"編號",1);
	if(this->AddOrChange==1)//添加
		sSQL.Format("INSERT INTO 倉庫信息表 VALUES(%s,'%s','%s','%s',%s,'%s')",sID,sName,sAddr,sTel,sAdminID,sMem);
	else//修改
		sSQL.Format("UPDATE 倉庫信息表 SET 名稱='%s',地址='%s',電話='%s',管理員=%s,備注='%s' WHERE 編號=%s",sName,sAddr,sTel,sAdminID,sMem,sID);
	rst.Open(sSQL,adCmdText);
	this->Enabled(false);
	this->AddOrChange=0;		
}

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

void CDStore::OnSpxxButexit() 
{
	this->OnCancel();	
}