// TestingZone.cpp: implementation of the CTestingZone class.
//
//////////////////////////////////////////////////////////////////////

#include "geomative.h"
#include "TestingZone.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CTestingZone::CTestingZone(DWORD dwID, _ConnectionPtr& pConnection)
{
	ASSERT(NULL != pConnection);
	m_pConnection = pConnection;

	CString szSql = _T("");
	_RecordsetPtr pRecTz = NULL;

	pRecTz.CreateInstance(_uuidof(Recordset));

	szSql.Empty();
	
	szSql.Format(_T("select TZname,TZtype,CN,Format(Cdate,'YYYY-MM-DD') as Cdate,TZdesc,location from tz where ID = %u"), dwID);
	pRecTz->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText);

	if ((long)VAL_ZERO != pRecTz->GetRecordCount())
	{
		m_szTZname = pRecTz->GetCollect(_T("TZname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZname"));
		m_szTZtype = pRecTz->GetCollect(_T("TZtype")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZtype"));
		m_szCDate = pRecTz->GetCollect(_T("Cdate")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("Cdate"));
		m_szDesc = pRecTz->GetCollect(_T("TZdesc")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("TZdesc"));
		m_szLocation = pRecTz->GetCollect(_T("location")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("location"));
		m_szCN = pRecTz->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecTz->GetCollect(_T("CN"));
	}
	pRecTz->Close();
	m_dwID = dwID;
}

CTestingZone::~CTestingZone()
{

}

bool CTestingZone::ShowDetailInfo(CListCtrl &tzDetailList)
{
	int iRowIndex = (int)VAL_ZERO;

	while (tzDetailList.GetItemCount() != iRowIndex)
	{
		tzDetailList.SetItemText(iRowIndex, 1, _T(""));
		iRowIndex++;
	}
	
	CString szTzType;
	if (m_szTZtype == "1" || m_szTZtype == "0")
	{
		szTzType = "1D VES | 2D ERI";
	}
	else if (m_szTZtype == "2")
	{
		szTzType = "3D ERT";
	}
	else
	{
		szTzType = "All Type";
	}
	tzDetailList.SetItemText(0, 1, m_szTZname);
	tzDetailList.SetItemText(1, 1, szTzType);
	tzDetailList.SetItemText(2, 1, m_szCDate);
	tzDetailList.SetItemText(3, 1, m_szDesc);
	tzDetailList.SetItemText(4, 1, m_szLocation);

	return true;
}