// DataTable.cpp: implementation of the CDataTable class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "a1.h"
#include "DataTable.h"

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

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

CDataTable::CDataTable()
{
}
CDataTable::~CDataTable()
{
}
void CDataTable::SelectListCtrl(CListCtrl *list)
{
this->m_list=list;
}
bool CDataTable::RefreshListView(CString sql)
{
	m_list->DeleteAllItems();
	int n=this->m_pstrlistFields_Names[0].GetCount();	
	if(!m_runsql.CheckSQLResult(sql))
	{
		for(int i=0; i<n; i++ )
		{
			m_list->SetColumnWidth( i, LVSCW_AUTOSIZE_USEHEADER);
		}
		return false;
	}
	m_list->SetRedraw(false);	
	_variant_t value,field;
	int i=0;
	POSITION pos=m_pstrlistFields_Names[0].GetHeadPosition();

	while(!m_runsql.m_recordset->adoEOF)
	{
		for(int j=0;j<n;j++)
		{
		field=this->m_pstrlistFields_Names[0].GetNext(pos);
		value=m_runsql.m_recordset->GetCollect(field);
		if(value.vt!=VT_NULL)
			if(j==0)
			m_list->InsertItem(i,(char*)(_bstr_t)value);
			else
			m_list->SetItemText(i,j,(char*)(_bstr_t)value);
		}
		m_runsql.m_recordset->MoveNext();
		pos=m_pstrlistFields_Names[0].GetHeadPosition();
		i++;
	}
	for( i=0; i<n; i++ )
	{
			m_list->SetColumnWidth( i, LVSCW_AUTOSIZE);
			m_list->SetColumnWidth( i, LVSCW_AUTOSIZE_USEHEADER);	
	}
	m_list->SetSelectionMark(0);
	m_list->SetRedraw(true);
	m_list->Invalidate();

	return true;
}
CString CDataTable::GetNameFromField(CString field)
{	
	POSITION pos=NULL;int i;
	for(pos=this->m_pstrlistFields_Names[0].GetHeadPosition(),i=0;pos!=NULL;i++)
	{
		if(field==this->m_pstrlistFields_Names[0].GetNext(pos))
		{
			return this->m_pstrlistFields_Names[1].GetAt(this->m_pstrlistFields_Names[1].FindIndex(i));
		}
	}
	return CString("");
}
CString CDataTable::GetFieldFromName(CString name)
{	
	POSITION pos=NULL;int i;
	for(pos=this->m_pstrlistFields_Names[1].GetHeadPosition(),i=0;pos!=NULL;i++)
	{
		if(name==this->m_pstrlistFields_Names[1].GetNext(pos))
		{
			return this->m_pstrlistFields_Names[0].GetAt(this->m_pstrlistFields_Names[0].FindIndex(i));
		}
	}
	return CString("");
}