// SetParaDlg.cpp : implementation file
//

#include "stdafx.h"
#include "alarm.h"
#include "ASPDlg.h"
#include "SetPara2Dlg.h"
#include "FubDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// SetParaDlg dialog


CASPDlg::CASPDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CASPDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CASPDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	m_nSel=0;
	m_nAct=0;
}


void CASPDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CASPDlg)
	DDX_Control(pDX, IDC_LIST1, m_bfList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CASPDlg, CDialog)
	//{{AFX_MSG_MAP(CASPDlg)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDFINISH, OnFinish)
	ON_BN_CLICKED(IDNEXT, OnNext)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CASPDlg message handlers

BOOL CASPDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//初始化
	m_bfList.InsertColumn(0,"布控名稱");
	m_bfList.InsertColumn(1,"事件編碼");
	m_bfList.InsertColumn(2,"端口屬性");
	m_bfList.InsertColumn(3,"端口編號");
	m_bfList.InsertColumn(4,"是否啟用");

	CRect rect;
	m_bfList.GetClientRect(&rect);
	m_bfList.SetColumnWidth(0,rect.Width()/5);
	m_bfList.SetColumnWidth(1,rect.Width()/5);
	m_bfList.SetColumnWidth(2,rect.Width()/5);
	m_bfList.SetColumnWidth(3,rect.Width()/5);
	m_bfList.SetColumnWidth(4,rect.Width()/5);

	_RecordsetPtr r;
	r.CreateInstance(_uuidof(Recordset));
	CString s="select * from BufangSet";
	_bstr_t bs=s.AllocSysString();
	CalarmApp* pApp=(CalarmApp*)::AfxGetApp();
	r->Open(bs,(IDispatch*)pApp->m_dConnTd,adOpenDynamic,adLockOptimistic,adCmdText);

	m_bfList.DeleteAllItems();
	if(addListItem(r))
		m_nSel=0;
//		m_bfList.SetSelectionMark(m_nSel);

	r->Close();
	r=NULL;

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE    
}

//將打開的表r加入listview的item中，如果r不為空集的話，則返回true，反之為false
BOOL CASPDlg::addListItem(_RecordsetPtr r)
{
	//如果r為空集，則不用加入list control中
	if(r->adoEOF || r->BOF)
		return FALSE;

	r->MoveFirst();
	while(!r->adoEOF)
	{
		//將bfname、bfcode、property、Number、promote賦成打開的記錄集的字段值（按順序)
		CString bfname,property,Number,promote,temp;
		CString bfcode;
		BOOL sf;

		bfname = LPTSTR(_bstr_t(r->GetCollect("bfname")));
		if(!bfname)
		{
			::AfxMessageBox("此紀錄無主鍵");
			continue;
		}

		temp= LPTSTR(_bstr_t(r->GetCollect("bfcode")));
		if(!temp)
			bfcode="-";
		else
		{
			BYTE code= r->GetCollect("bfcode");
			itoa(code,bfcode.GetBuffer(50),2);
			bfcode.ReleaseBuffer();
			while(bfcode.GetLength()<8)
				bfcode.Insert(0,'0');
		}
		
		property=LPTSTR(_bstr_t(r->GetCollect("property")));
		if(!property)
			property="-";

		Number=LPTSTR(_bstr_t(r->GetCollect("Number")));
		if(!Number)
			Number="-";

		temp= LPTSTR(_bstr_t(r->GetCollect("promote")));
		if(!temp)
			promote="-";
		else
		{
			sf= (BYTE)r->GetCollect("promote");
			if(sf)
				promote="啟用";
			else
				promote="禁用";
		}

		int nItem = m_bfList.InsertItem(m_bfList.GetItemCount(),bfname);
		m_bfList.SetItemText(nItem,1,bfcode);
		m_bfList.SetItemText(nItem,2,property);
		m_bfList.SetItemText(nItem,3,Number);
		m_bfList.SetItemText(nItem,4,promote);

		r->MoveNext();
	}
	return TRUE;
}

void CASPDlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	m_nSel=-1;
	m_nAct=0;
	CFubDlg dlg(this);
	dlg.DoModal();
}

void CASPDlg::OnEdit() 
{
	// TODO: Add your control notification handler code here
	m_nSel= m_bfList.GetNextItem( -1, LVNI_ALL | LVNI_SELECTED);
	if(m_nSel==-1)
	{
		::AfxMessageBox("請選擇一條記錄");
		return;
	}
	m_nAct=1;
	CFubDlg dlg(this);
	dlg.DoModal();
}

void CASPDlg::OnDelete() 
{
	m_nSel= m_bfList.GetNextItem( -1, LVNI_ALL | LVNI_SELECTED);
	if(m_nSel==-1)
	{
		::AfxMessageBox("請選擇一條記錄");
		return;
	}
	int res=::AfxMessageBox("確定刪除該條記錄?",MB_YESNO);
	if(res==IDNO)
		return;

	_RecordsetPtr r;
	r.CreateInstance(_uuidof(Recordset));
	CString tempbfName;
	m_bfList.GetItemText(m_nSel,0,tempbfName.GetBuffer(100),100);
	tempbfName.ReleaseBuffer();
	CString s="select * from BufangSet where bfname = '" +tempbfName + "'";
	_bstr_t bs=s.AllocSysString();
	TRY
	{
		CalarmApp* pApp=(CalarmApp*)::AfxGetApp();
		r->Open(bs,(IDispatch*)pApp->m_dConnTd,adOpenDynamic,adLockOptimistic,adCmdText);
		if(!r->adoEOF && !r->BOF)
		{
			r->Delete(adAffectCurrent);
			r->Update();
		}
	}
	CATCH(CException,e)
	{
		::AfxMessageBox("請再次檢查數據");
		e->ReportError();
	}
	END_CATCH
	
	m_bfList.DeleteItem(m_nSel);	//從listctrl中刪除該條記錄

	r->Close();
	r=NULL;

	// TODO: Add your control notification handler code here
}

void CASPDlg::OnFinish() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}

void CASPDlg::OnNext() 
{
	// TODO: Add your control notification handler code here
	ShowWindow(SW_HIDE);
	CBSPDlg dlg(this);
	dlg.DoModal();
}