#include "StdAfx.h"
#include "MBFireClsAttrs.h"


CMBFireClsAttrs::CMBFireClsAttrs(void)
{
	m_nSize = 0;
}


CMBFireClsAttrs::~CMBFireClsAttrs(void)
{
}

CString CMBFireClsAttrs::GetFieldSql()
{
	CString strSql;
	 
	if( m_strType == _T("×Ö·û´®") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("¿É±ä³¤×Ö·û´®") )
	{
		strSql.Format( _T("%s varchar(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÕûÊý") )
	{
		strSql.Format( _T("%s int(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("¸¡µãÊý") )
	{
		strSql.Format( _T("%s float(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("²¼¶ûÖµ") )
	{
		strSql.Format( _T("%s bool"),m_strName );
	}
	else if( m_strType == _T("ÈÕÆÚ") )
	{
		strSql.Format( _T("%s datetime"),m_strName );
	}
	else if( m_strType == _T("ʱ¼ä") )
	{
		strSql.Format( _T("%s datetime"),m_strName );
	}
	else if( m_strType == _T("GUID") )
	{
		strSql.Format( _T("%s char(36)"),m_strName );
	}
	else if( m_strType == _T("¹¹³É¶ÔÏó") )
	{
		strSql.Format( _T("S_%s_CCLSID char(4),S_%s_COBJID char(36),%s char(%d)"),m_strName,m_strName,m_strName,m_nSize ); 
	}
	else if( m_strType == _T("×Öµä-×Ö·û´®") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("×Öµä-ÕûÊý") )
	{
		strSql.Format( _T("%s int"),m_strName );
	}
	else if( m_strType == _T("ÒýÓöÔÏó") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÈÕÆÚ·¶Î§") )
	{
		strSql.Format( _T("S_%s_MINDATE char(8),S_%s_MAXDATE char(8)"),m_strName,m_strName ); 
	}
	else if( m_strType == _T("ÉóºËÈ˱êʶ") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÉóºËÈËÐÕÃû") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÉóºËÒâ¼û") )
	{
		strSql.Format( _T("%s varchar(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÉóºËʱ¼ä") )
	{
		strSql.Format( _T("%s datetime"),m_strName);
	}
	else if( m_strType == _T("±àÂë") )
	{
		strSql.Format( _T("%s char(%d)"),m_strName,m_nSize );
	}
	else if( m_strType == _T("ÏîÄ¿½×¶Î") )
	{
		strSql.Format( _T("G_X_TASK_ID	char(36),\
		D_%s_PSTART					DateTime,	\
		D_%s_PDUE					DateTime,	\
		D_%s_RSTART					DateTime,	\
		D_%s_RDUE					DateTime,	\
		N_%s_STATE					smallint,	\
		D_%s_START					DateTime,	\
		D_%s_DUE					DateTime,	\
		N_%s_TASK_SUM				int,		\
		N_%s_TASK_FINISH			int,		\
		N_%s_TASK_DELAY				int			\
		"),m_strName,m_strName,m_strName,m_strName,m_strName,m_strName,m_strName,m_strName,m_strName,m_strName,m_strName);
	}
	else if( m_strType == _T("³¤ÕûÊý") )
	{
		strSql.Format( _T("%s interger(%d)"),m_strName,m_nSize );	
	}
	 

	return strSql;
}