Example #1
0
CString CTableBase::GetValueList(BOOL bUseNULL, BOOL bExport)
{
	CString s = _T("");

	// Recuperar a lista de campos pela ordenacao de
	// importacao/Exportacao
	POSITION p = m_fieldOrdered.GetHeadPosition();
	CField *pField = NULL;
	int counter = 0;

	while(p != NULL)
	{
		CString sKey = m_fieldOrdered.GetNext(p);
		VERIFY(m_mapFields.Lookup(sKey, pField));

		if(counter++ > 0)
			s += _T(",");

		if(!pField->IsNull())
			s += pField->GetQueryFormatValue();
		else
		{
			// Se puder usar NULL ...
			if(bUseNULL)
				s += _T("NULL");
			else
			{
				if(bExport)
				{
					if(pField->GetType() == CField::FIELD_TYPE_CURRENCY)
						s += _T("");
					else if(pField->GetType() == CField::FIELD_TYPE_NUMBER)
						s += _T("");
					else
						s += _T("\"\"");
				}
				else
				{
					// Caso contrario, mandamos Zero para os numericos ...
					if(pField->GetType() == CField::FIELD_TYPE_CURRENCY ||
						pField->GetType() == CField::FIELD_TYPE_NUMBER)
					{
						s += _T("");
					}
					else // e vazio para os outros ...
						s += _T("");
				}
			}
		}
	}

	s += _T("\r\n");

	return s;
}
Example #2
0
long CTableBase::GetLongValue(LPCTSTR _szLabel)
{
	CField *pField;
	if(m_mapFields.Lookup(_szLabel, pField))
	{
		ASSERT(pField->GetType() == CField::FIELD_TYPE_NUMBER);
		return pField->GetLongValue();
	}

	ASSERT(FALSE); // NAo encontrou o campo !
	return 0L;
}