// Project.cpp: implementation of the CProject class.
//
//////////////////////////////////////////////////////////////////////

#include "geomative.h"
#include "Project.h"
#include "DataMngStruct.h"

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

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

CProject::CProject(DWORD dwID, _ConnectionPtr& pConnection)
{
	ASSERT(NULL != pConnection);
	m_pConnection = pConnection;
	CString szSql;
	_RecordsetPtr pRecPro = NULL;

	pRecPro.CreateInstance(_uuidof(Recordset));

	szSql.Empty();
	
	szSql.Format(_T("select CN,PRname,PRdesc,location,Format(PRdate,'YYYY-MM-DD') as PRdate,duration,PS,CS,PM,QAS,standard from project where ID = %u"), dwID);
	pRecPro->Open(szSql.AllocSysString(), _variant_t((IDispatch*)m_pConnection, true), adOpenStatic, adLockOptimistic, adCmdText);

	if ((long)VAL_ZERO != pRecPro->GetRecordCount())
	{
		m_szCN = pRecPro->GetCollect(_T("CN")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("CN"));
		m_szPRname = pRecPro->GetCollect(_T("PRname")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRname"));
		m_szDesc = pRecPro->GetCollect(_T("PRdesc")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRdesc"));
		m_szLocation = pRecPro->GetCollect(_T("location")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("location"));
		m_szPRdate = pRecPro->GetCollect(_T("PRdate")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PRdate"));
		m_szDuration = pRecPro->GetCollect(_T("duration")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("duration"));
		m_szPS = pRecPro->GetCollect(_T("PS")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PS"));
		m_szCS = pRecPro->GetCollect(_T("CS")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("CS"));
		m_szPM = pRecPro->GetCollect(_T("PM")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("PM"));
		m_szQAS = pRecPro->GetCollect(_T("QAS")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("QAS"));
		m_szStandard = pRecPro->GetCollect(_T("standard")).vt == VT_NULL ? _T("") : (LPCTSTR)(_bstr_t)pRecPro->GetCollect(_T("standard"));
	}
	pRecPro->Close();

	m_dwID = m_dwID;
}

CProject::~CProject()
{

}

bool CProject::ShowDetailInfo(CListCtrl& proDetailList)
{
	int iRowIndex = (int)VAL_ZERO;

	while (proDetailList.GetItemCount() != iRowIndex)
	{
		proDetailList.SetItemText(iRowIndex, 1, _T(""));
		iRowIndex++;
	}
	
	proDetailList.SetItemText(0, 1, m_szCN);
	proDetailList.SetItemText(1, 1, m_szPRname);
	proDetailList.SetItemText(2, 1, m_szDesc);
	proDetailList.SetItemText(3, 1, m_szLocation);
	proDetailList.SetItemText(4, 1, m_szPRdate);
	proDetailList.SetItemText(5, 1, m_szDuration);
	proDetailList.SetItemText(6, 1, m_szPS);
	proDetailList.SetItemText(7, 1, m_szCS);
	proDetailList.SetItemText(8, 1, m_szPM);
//	proDetailList.SetItemText(9, 1, m_szQAS);
	proDetailList.SetItemText(9, 1, m_szStandard);

	return true;
}