// Dblzfsx.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CDblzfsx dialog


CDblzfsx::CDblzfsx(CWnd* pParent /*=NULL*/)
	: CDialog(CDblzfsx::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDblzfsx)
	//}}AFX_DATA_INIT
}


void CDblzfsx::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDblzfsx)
	DDX_Control(pDX, IDC_COMHTBH, m_ComHTBH);
	DDX_Control(pDX, IDC_EDTYT, m_EdtYt);
	DDX_Control(pDX, IDC_EDTXMMC, m_EdtXmmc);
	DDX_Control(pDX, IDC_EDTWT, m_EdtWt);
	DDX_Control(pDX, IDC_EDTGZBM, m_EdtGzbm);
	DDX_Control(pDX, IDC_EDTD, m_EdtTd);
	DDX_Control(pDX, IDC_EDTBH, m_EdtBh);
	DDX_Control(pDX, IDC_DTZFRQ, m_DtZfrq);
	DDX_Control(pDX, IDC_CHESY, m_CheSy);
	DDX_Control(pDX, IDC_BUTSAVE1, m_ButSave);
	DDX_Control(pDX, IDC_BUTEXIT1, m_ButExit);
	DDX_Control(pDX, IDC_BUTDELE, m_ButDele);
	DDX_Control(pDX, IDC_BUTADD, m_ButAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDblzfsx, CDialog)
	//{{AFX_MSG_MAP(CDblzfsx)
	ON_BN_CLICKED(IDC_BUTADD, OnButadd)
	ON_CBN_KILLFOCUS(IDC_COMHTBH, OnKillfocusComhtbh)
	ON_BN_CLICKED(IDC_BUTSAVE1, OnButsave1)
	ON_BN_CLICKED(IDC_BUTDELE, OnButdele)
	ON_BN_CLICKED(IDC_BUTEXIT1, OnButexit1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDblzfsx message handlers

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

void CDblzfsx::Clear()
{
	m_EdtYt.SetWindowText("");
	m_EdtXmmc.SetWindowText("");
	m_EdtWt.SetWindowText("");
	m_ComHTBH.SetWindowText("");
	m_EdtGzbm.SetWindowText("");
	m_EdtTd.SetWindowText("");
	m_EdtBh.SetWindowText("");
	m_DtZfrq.SetWindowText("");
	this->m_CheSy.SetCheck(0);
}

void CDblzfsx::Display(CString sID)
{
	if(sID.IsEmpty())
		return;
	CString sSQL;
	RxRecordset drst;
	sSQL.Format("SELECT * FROM 支付手續(xù)視圖 WHERE 編號(hào)='%s'",sID);
	drst.Open(sSQL,adCmdText);
	if(drst.GetRecordCount()<1)
		return;
	CString sBH,sXMBH,sGZBM,sXMMC,sSY,sZFCS,sYT,sZFRQ,sWT;
	sBH=drst.GetFieldValue("編號(hào)");
	sXMBH=drst.GetFieldValue("合同編號(hào)");
	sGZBM=drst.GetFieldValue("工作部門");
	sXMMC=drst.GetFieldValue("項(xiàng)目名稱");
	sSY=drst.GetFieldValue("業(yè)務(wù)部經(jīng)理審閱");
	sZFCS=drst.GetFieldValue("支付次號(hào)");
	sYT=drst.GetFieldValue("用途");
	sZFRQ=drst.GetFieldValue("支付日期");
	sWT=drst.GetFieldValue("問(wèn)題及處理");

	m_EdtBh.SetWindowText(sBH);
	m_ComHTBH.SetWindowText(sXMBH);
	m_EdtGzbm.SetWindowText(sGZBM);
	m_EdtXmmc.SetWindowText(sXMMC);	
	m_CheSy.SetCheck(atoi(sSY));
	m_EdtTd.SetWindowText(sZFCS);
	m_EdtYt.SetWindowText(sYT);
	CTime time;
	time=CStringTOCTime(sZFRQ);
	m_DtZfrq.SetTime(&time);
}

void CDblzfsx::Enabled(bool bEnabled)
{
	m_ComHTBH.EnableWindow(bEnabled);
	m_CheSy.EnableWindow(bEnabled);
	m_EdtTd.EnableWindow(bEnabled);
	m_EdtWt.EnableWindow(bEnabled);
	m_DtZfrq.EnableWindow(bEnabled);
	m_EdtYt.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(bEnabled);
	m_ButExit.EnableWindow(!bEnabled);
	m_ButDele.EnableWindow(!bEnabled);
	m_ButAdd.EnableWindow(!bEnabled);
}

void CDblzfsx::OnButadd() 
{
	CString sNewID;
	sNewID=ado.AutoNumber("支付手續(xù)表","編號(hào)","ZF",3);
	this->Clear();
	this->Enabled(true);
	this->m_EdtBh.SetWindowText(sNewID);
	m_ComHTBH.SetFocus();
	CTime time;
	time=time.GetCurrentTime();
	this->m_DtZfrq.SetTime(&time);
}

BOOL CDblzfsx::OnInitDialog() 
{
	CDialog::OnInitDialog();	
	CDBaseQuery* ParentWnd=(CDBaseQuery*)FindWindow(NULL,"支付手續(xù)查詢");
	m_sID=ParentWnd->m_Grid.GetItemText(ParentWnd->m_Grid.GetRow(),0);
	rst.Open("合同簽訂記錄");
	m_ComHTBH.SetRecordset(rst,"編號(hào)");
	if(m_sID.IsEmpty())
		this->m_ButDele.EnableWindow(false);
	this->Display(m_sID);	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDblzfsx::OnKillfocusComhtbh() 
{
	CString shtbh,sSQL;
	m_ComHTBH.GetWindowText(shtbh);	
	if(shtbh.IsEmpty())
		return;
	sSQL.Format("SELECT * FROM 合同簽訂視圖 WHERE 編號(hào)='%s'",shtbh);
	rst.Open(sSQL,adCmdText);
	if(rst.GetRecordCount()<1)
	{
		MessageBox("您輸入的合同編號(hào)有問(wèn)題！請(qǐng)確定后重新輸入!","系統(tǒng)提示",MB_OK|MB_ICONSTOP);
		m_ComHTBH.SetFocus();
		return;
	}
	else
	{
		CString sXMMC,sQSR,sBM,sXMZG;
		sXMMC=rst.GetFieldValue("項(xiàng)目");
		sBM=rst.GetFieldValue("部門");
		this->m_EdtXmmc.SetWindowText(sXMMC);
		this->m_EdtGzbm.SetWindowText(sBM);
	}			
}

BOOL CDblzfsx::PreTranslateMessage(MSG* pMsg) 
{
	if(pMsg->hwnd==this->m_CheSy.GetSafeHwnd()&&pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
		m_CheSy.SetCheck(!m_CheSy.GetCheck());
	return CDialog::PreTranslateMessage(pMsg);
}

void CDblzfsx::OnButsave1() 
{
	if(MessageBox("確定要保存記錄嗎？","系統(tǒng)提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	CString sSQL;
	CString sBH,sHTBH,sZH,sYT,sZFRQ,sWT;
	int nSy;
	CTime tZFRQ;
	m_EdtBh.GetWindowText(sBH);
	m_ComHTBH.GetWindowText(sHTBH);
	nSy=m_CheSy.GetCheck();
	this->m_EdtTd.GetWindowText(sZH);
	m_EdtYt.GetWindowText(sYT);
	m_DtZfrq.GetTime(tZFRQ);
	sZFRQ=CTimeToCString(tZFRQ);
	m_EdtWt.GetWindowText(sWT);
	sSQL.Format("INSERT INTO 支付手續(xù)表 VALUES('%s','%s',%d,%s,'%s','%s','%s')",sBH,sHTBH,nSy,sZH,sYT,sZFRQ,sWT);
	RxRecordset srst;
	srst.Open(sSQL,adCmdText);
	this->Enabled(false);

}

void CDblzfsx::OnButdele() 
{
	CString sSQL,sID;
	m_EdtBh.GetWindowText(sID);

	if(MessageBox("確定要?jiǎng)h除記錄嗎？","系統(tǒng)提示",MB_OKCANCEL|MB_ICONQUESTION)!=1)
		return;
	sSQL.Format("DELETE 支付手續(xù)表 WHERE 編號(hào) ='%s'",sID);
	RxRecordset drst;
	drst.Open(sSQL,adCmdText);
	this->OnCancel();	
	
}

void CDblzfsx::OnButexit1() 
{
	this->OnCancel();	
}