//---------------------------------------------------------------------------

#pragma hdrstop

#include "CDSFontF.h"
#include "VmsCommonLibF.h"

//---------------------------------------------------------------------------

#pragma package(smart_init)


//---------------------------------------------------------------------------
TCDSFontName::TCDSFontName()
{
}
//---------------------------------------------------------------------------

TCDSFontName::~TCDSFontName()
{
}
//---------------------------------------------------------------------------


//---------------------------------------------------------------------------
TCDSFontColor::TCDSFontColor()
{
}
//---------------------------------------------------------------------------

TCDSFontColor::~TCDSFontColor()
{
}
//---------------------------------------------------------------------------


//---------------------------------------------------------------------------
TCDSBackColor::TCDSBackColor()
{
}
//---------------------------------------------------------------------------

TCDSBackColor::~TCDSBackColor()
{
}
//---------------------------------------------------------------------------


//---------------------------------------------------------------------------
TCDSFontManager *CDSFontManager = NULL;
//---------------------------------------------------------------------------

TCDSFontManager::TCDSFontManager()
{
}
//---------------------------------------------------------------------------
TCDSFontManager::~TCDSFontManager()
{
    FFontNames.RemoveAll();
    FFontColors.RemoveAll();
}
//---------------------------------------------------------------------------
String TCDSFontManager::GetFontColorCode(int AColor)
{
    FOR_STL(TCDSFontColor*, pObj, FFontColors)
    {
        if (AColor == pObj->VMS_FONT_COLR_VAL) return pObj->VMS_FONT_COLR_CD;
    }
    return "01";
}
//---------------------------------------------------------------------------
String TCDSFontManager::GetBackColorCode(int AColor)
{
    FOR_STL(TCDSBackColor*, pObj, FBackColors)
    {
        if (AColor == pObj->VMS_BACK_COLR_VAL) return pObj->VMS_BACK_COLR_CD;
    }
    return "00";
}
//---------------------------------------------------------------------------
int TCDSFontManager::GetFontColorIndex(int ACode)
{
    return GetFontColorIndex(String(ACode));
}
//---------------------------------------------------------------------------
int TCDSFontManager::GetFontColorIndex(String ACode)
{
    int nIdx = 0;
    FOR_STL(TCDSFontColor*, pObj, FFontColors)
    {
        if (ACode == pObj->VMS_FONT_COLR_CD) return nIdx;
        nIdx++;
    }
    return 0;
}
//---------------------------------------------------------------------------
int TCDSFontManager::GetBackColorIndex(int ACode)
{
    return GetBackColorIndex(String(ACode));
}
//---------------------------------------------------------------------------
int TCDSFontManager::GetBackColorIndex(String ACode)
{
    int nIdx = 0;
    FOR_STL(TCDSBackColor*, pObj, FBackColors)
    {
        if (ACode == pObj->VMS_BACK_COLR_CD) return nIdx;
        nIdx++;
    }
    return 0;
}
//---------------------------------------------------------------------------
TCDSFontName* TCDSFontManager::FindFontCodeByName(String AFontName)
{
    FOR_STL(TCDSFontName*, pObj, FFontNames) {
        if (pObj->VMS_FONT_NAME_NM == AFontName) {
            return pObj;
        }
    }
    return NULL;
}
//---------------------------------------------------------------------------

int TCDSFontManager::LoadFontInfo(TADOConnection *ADbConn)
{
    if(LoadFontNameInfo(ADbConn) < 0)
    {
        return -1;
    }

    LoadFontColorInfo(ADbConn);
    return LoadBackColorInfo(ADbConn);
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadFontNameInfo(TADOConnection *ADbConn)
{
    String     sQry;
    TADOQuery *pADO = NULL;
    int        nSelCnt = 0;

    sQry = "SELECT T.CODE_NO AS CODE_NO, T.CD_NM AS CD_NM, T.USE_YN \r\n"
           "  FROM TB_SYS_CD T                                      \r\n"
           " WHERE 1=1                                              \r\n"
           "   AND USE_YN = 'Y'                                     \r\n"
           "   AND T.CLSS_CD = 'FONT_KIND_CD'                       \r\n"
           " ORDER BY T.CODE_NO                                     \r\n";

    try
    {
        try
        {
            pADO = new TADOQuery(NULL);
            pADO->Connection = ADbConn;
			pADO->Close();
            pADO->Connection = (NULL != ADbConn) ? ADbConn : ITSDb_GetConnection();
			pADO->SQL->Clear();
			pADO->SQL->Text = sQry;

            pADO->Prepared = true;
			pADO->Open();
            for( ; !pADO->Eof; pADO->Next())
            {
                String VMS_FONT_NAME_CD = pADO->FieldByName("CODE_NO")->AsString;

				TCDSFontName *pObj = FFontNames.Find(VMS_FONT_NAME_CD);
                if (!pObj)
                {
                    pObj = new TCDSFontName();
                    pObj->VMS_FONT_NAME_CD = VMS_FONT_NAME_CD;
                    FFontNames.Push(pObj->VMS_FONT_NAME_CD, pObj);
                }

                pObj->VMS_FONT_NAME_NM = pADO->FieldByName("CD_NM")->AsString.Trim();
                pObj->USE_YN           = pADO->FieldByName("USE_YN")->AsString.Trim();
                nSelCnt++;
            }
        }
        catch(EDatabaseError &E)
        {
            DBERRORMSG("TCDSFontManager::LoadFontNameInfo", String(E.ClassName()), E.Message, sQry);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            DBERRORMSG("TCDSFontManager::LoadFontNameInfo", String(e.ClassName()), e.Message, sQry);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
    }
    return nSelCnt;
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadFontColorInfo(TADOConnection *ADbConn)
{
    String     sQry;
    TADOQuery *pADO = NULL;
    int        nSelCnt = 0;

    sQry = "SELECT T.CODE_NO AS CODE_NO, T.CD_NM AS CD_NM,                  \r\n"
           "       T.CD_VAL_1 AS COLOR_VAL, T.USE_YN,                       \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 2, 2), 'XX') AS R_VAL,      \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 4, 2), 'XX') AS G_VAL,      \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 6, 2), 'XX') AS B_VAL       \r\n"
           "  FROM TB_SYS_CD T                                              \r\n"
           " WHERE 1=1                                                      \r\n"
           "   AND USE_YN = 'Y'                                             \r\n"
           "   AND T.CLSS_CD = 'FONT_CLR_CD'                                \r\n"
           "   AND LENGTHB(T.CD_VAL_1) = 7                                  \r\n"
           " ORDER BY T.CODE_NO                                             \r\n";

    int VMS_FONT_COLR_IDX = 0;
    try
    {
        FFontColors.RemoveAll();
        FFontColorsIdx.RemoveAll();
        try
        {
            pADO = new TADOQuery(NULL);
            pADO->Connection = ADbConn;
			pADO->Close();
            pADO->Connection = (NULL != ADbConn) ? ADbConn : ITSDb_GetConnection();
			pADO->SQL->Clear();
			pADO->SQL->Text = sQry;

            pADO->Prepared = true;
			pADO->Open();
            for( ; !pADO->Eof; pADO->Next())
            {
                String VMS_FONT_COLR_CD = pADO->FieldByName("CODE_NO")->AsString;

				TCDSFontColor *pObj = FFontColors.Find(VMS_FONT_COLR_CD);
                if (!pObj)
                {
                    pObj = new TCDSFontColor();
                    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
                    pObj->VMS_FONT_COLR_CD = VMS_FONT_COLR_CD;
                    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
                    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);

                    VMS_FONT_COLR_IDX++;
                }

                int R_VAL = pADO->FieldByName("R_VAL")->AsInteger;
                int G_VAL = pADO->FieldByName("G_VAL")->AsInteger;
                int B_VAL = pADO->FieldByName("B_VAL")->AsInteger;

                pObj->VMS_FONT_COLR_NM  = pADO->FieldByName("CD_NM")->AsString.Trim();
                pObj->COLOR_VAL         = pADO->FieldByName("COLOR_VAL")->AsString.Trim();
                pObj->USE_YN            = pADO->FieldByName("USE_YN")->AsString.Trim();
                pObj->VMS_FONT_COLR_VAL = B_VAL << 16 | G_VAL << 8 | R_VAL;
                nSelCnt++;
            }
        }
        catch(EDatabaseError &E)
        {
            DBERRORMSG("TCDSFontManager::LoadFontColorInfo", String(E.ClassName()), E.Message, sQry);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            DBERRORMSG("TCDSFontManager::LoadFontColorInfo", String(e.ClassName()), e.Message, sQry);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
    }
    return nSelCnt;
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadBackColorInfo(TADOConnection *ADbConn)
{
    String     sQry;
    TADOQuery *pADO = NULL;
    int        nSelCnt = 0;

    sQry = "SELECT T.CODE_NO AS CODE_NO, T.CD_NM AS CD_NM,                  \r\n"
           "       T.CD_VAL_1 AS COLOR_VAL, T.USE_YN,                       \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 2, 2), 'XX') AS R_VAL,      \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 4, 2), 'XX') AS G_VAL,      \r\n"
           "       TO_NUMBER(SUBSTR(T.CD_VAL_1, 6, 2), 'XX') AS B_VAL       \r\n"
           "  FROM TB_SYS_CD T                                              \r\n"
           " WHERE 1=1                                                      \r\n"
           "   AND USE_YN = 'Y'                                             \r\n"
           "   AND T.CLSS_CD = 'BACK_CLR_CD'                                \r\n"
           "   AND LENGTHB(T.CD_VAL_1) = 7                                  \r\n"
           " ORDER BY T.CODE_NO                                             \r\n";

    int VMS_BACK_COLR_IDX = 0;
    try
    {
        FBackColors.RemoveAll();
        FBackColorsIdx.RemoveAll();
        try
        {
            pADO = new TADOQuery(NULL);
            pADO->Connection = ADbConn;
			pADO->Close();
            pADO->Connection = (NULL != ADbConn) ? ADbConn : ITSDb_GetConnection();
			pADO->SQL->Clear();
			pADO->SQL->Text = sQry;

            pADO->Prepared = true;
			pADO->Open();
            for( ; !pADO->Eof; pADO->Next())
            {
                String VMS_BACK_COLR_CD = pADO->FieldByName("CODE_NO")->AsString;

				TCDSBackColor *pObj = FBackColors.Find(VMS_BACK_COLR_CD);
                if (!pObj)
                {
                    pObj = new TCDSBackColor();
                    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
                    pObj->VMS_BACK_COLR_CD = VMS_BACK_COLR_CD;
                    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
                    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);

                    VMS_BACK_COLR_IDX++;
                }

                int R_VAL = pADO->FieldByName("R_VAL")->AsInteger;
                int G_VAL = pADO->FieldByName("G_VAL")->AsInteger;
                int B_VAL = pADO->FieldByName("B_VAL")->AsInteger;

                pObj->VMS_BACK_COLR_NM  = pADO->FieldByName("CD_NM")->AsString.Trim();
                pObj->COLOR_VAL         = pADO->FieldByName("COLOR_VAL")->AsString.Trim();
                pObj->USE_YN            = pADO->FieldByName("USE_YN")->AsString.Trim();
                pObj->VMS_BACK_COLR_VAL = B_VAL << 16 | G_VAL << 8 | R_VAL;
                nSelCnt++;
            }
        }
        catch(EDatabaseError &E)
        {
            DBERRORMSG("TCDSFontManager::LoadBackColorInfo", String(E.ClassName()), E.Message, sQry);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            DBERRORMSG("TCDSFontManager::LoadBackColorInfo", String(e.ClassName()), e.Message, sQry);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
    }
    return nSelCnt;
}
//---------------------------------------------------------------------------

int TCDSFontManager::LoadFontInfoOffline()
{
    if(LoadFontNameInfoOffline() < 0)
    {
        return -1;
    }

    LoadFontColorInfoOffline();
    return LoadBackColorInfoOffline();
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadFontNameInfoOffline()
{
    int nSelCnt = 0;

    TCDSFontName *pObj;
    pObj = new TCDSFontName();
    pObj->VMS_FONT_NAME_CD = "00";
    pObj->VMS_FONT_NAME_NM = "휴먼명조";
    pObj->USE_YN           = "Y";
    FFontNames.Push(pObj->VMS_FONT_NAME_CD, pObj);
    nSelCnt++;

    pObj = new TCDSFontName();
    pObj->VMS_FONT_NAME_CD = "01";
    pObj->VMS_FONT_NAME_NM = "맑은 고딕";
    pObj->USE_YN           = "Y";
    FFontNames.Push(pObj->VMS_FONT_NAME_CD, pObj);
    nSelCnt++;

    pObj = new TCDSFontName();
    pObj->VMS_FONT_NAME_CD = "02";
    pObj->VMS_FONT_NAME_NM = "굴림체";
    pObj->USE_YN           = "Y";
    FFontNames.Push(pObj->VMS_FONT_NAME_CD, pObj);
    nSelCnt++;

    return nSelCnt;
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadFontColorInfoOffline()
{
    int VMS_FONT_COLR_IDX = 0;
    TCDSFontColor *pObj;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "00";
    pObj->VMS_FONT_COLR_NM  = "흑색(Black)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 0;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "01";
    pObj->VMS_FONT_COLR_NM  = "적색(Red)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 255;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "02";
    pObj->VMS_FONT_COLR_NM  = "연녹색(Lime)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 65280;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "03";
    pObj->VMS_FONT_COLR_NM  = "황색(Amber)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 65535;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "04";
    pObj->VMS_FONT_COLR_NM  = "주황색(Orange)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 42495;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "05";
    pObj->VMS_FONT_COLR_NM  = "하늘색(Aqua)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 16776960;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "06";
    pObj->VMS_FONT_COLR_NM  = "청록색(Teal)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 8421376;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "07";
    pObj->VMS_FONT_COLR_NM  = "회색(Gray)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 8421504;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "08";
    pObj->VMS_FONT_COLR_NM  = "자홍색(Fuchsia)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 16711935;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "09";
    pObj->VMS_FONT_COLR_NM  = "청색(Blue)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 16711680;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "10";
    pObj->VMS_FONT_COLR_NM  = "백색(White)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 16777215;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "11";
    pObj->VMS_FONT_COLR_NM  = "남색(Navy)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 8388608;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "12";
    pObj->VMS_FONT_COLR_NM  = "고동색(Maroon)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 128;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "13";
    pObj->VMS_FONT_COLR_NM  = "녹색(Green)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 32768;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "14";
    pObj->VMS_FONT_COLR_NM  = "황록색(Olive)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 32896;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    pObj = new TCDSFontColor();
    pObj->VMS_FONT_COLR_IDX = VMS_FONT_COLR_IDX;
    pObj->VMS_FONT_COLR_CD  = "15";
    pObj->VMS_FONT_COLR_NM  = "자주색(Purple)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_FONT_COLR_VAL = 8388736;
    FFontColors.Push(pObj->VMS_FONT_COLR_CD, pObj);
    FFontColorsIdx.Push(pObj->VMS_FONT_COLR_IDX, pObj);
    VMS_FONT_COLR_IDX++;

    return VMS_FONT_COLR_IDX;
}
//---------------------------------------------------------------------------
int TCDSFontManager::LoadBackColorInfoOffline()
{
    int VMS_BACK_COLR_IDX = 0;
    TCDSBackColor *pObj;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "00";
    pObj->VMS_BACK_COLR_NM  = "흑색(Black)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 0;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "01";
    pObj->VMS_BACK_COLR_NM  = "적색(Red)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 255;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "02";
    pObj->VMS_BACK_COLR_NM  = "연녹색(Lime)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 65280;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "03";
    pObj->VMS_BACK_COLR_NM  = "황색(Amber)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 65535;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "04";
    pObj->VMS_BACK_COLR_NM  = "주황색(Orange)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 42495;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "05";
    pObj->VMS_BACK_COLR_NM  = "하늘색(Aqua)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 16776960;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "06";
    pObj->VMS_BACK_COLR_NM  = "청록색(Teal)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 8421376;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "07";
    pObj->VMS_BACK_COLR_NM  = "회색(Gray)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 8421504;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "08";
    pObj->VMS_BACK_COLR_NM  = "자홍색(Fuchsia)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 16711935;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "09";
    pObj->VMS_BACK_COLR_NM  = "청색(Blue)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 16711680;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "10";
    pObj->VMS_BACK_COLR_NM  = "백색(White)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 16777215;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "11";
    pObj->VMS_BACK_COLR_NM  = "남색(Navy)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 8388608;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "12";
    pObj->VMS_BACK_COLR_NM  = "고동색(Maroon)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 128;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "13";
    pObj->VMS_BACK_COLR_NM  = "녹색(Green)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 32768;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "14";
    pObj->VMS_BACK_COLR_NM  = "황록색(Olive)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 32896;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    pObj = new TCDSBackColor();
    pObj->VMS_BACK_COLR_IDX = VMS_BACK_COLR_IDX;
    pObj->VMS_BACK_COLR_CD  = "15";
    pObj->VMS_BACK_COLR_NM  = "자주색(Purple)";
    pObj->COLOR_VAL         = "";
    pObj->USE_YN            = "Y";
    pObj->VMS_BACK_COLR_VAL = 8388736;
    FBackColors.Push(pObj->VMS_BACK_COLR_CD, pObj);
    FBackColorsIdx.Push(pObj->VMS_BACK_COLR_IDX, pObj);
    VMS_BACK_COLR_IDX++;

    return VMS_BACK_COLR_IDX;
}
//---------------------------------------------------------------------------

int TCDSFontManager::LoadSysCode(TSysCodeManager *ASysCodeManager)
{
    TSysClssCode *pCode = new TSysClssCode();

    String sCodeClss = "FONT_KIND_CD";

    pCode = new TSysClssCode();
    pCode->CLSS_CD    = sCodeClss;
    pCode->CLSS_CD_NM = "글꼴종류코드";
    ASysCodeManager->FLists.Push(pCode->CLSS_CD, pCode);

    TSysClssCode *pClssCd = NULL;
    pClssCd = SysCodeManager->FLists.Find(sCodeClss);
    if (!pClssCd) {
        FOR_STL(TCDSFontName*, pObj, FFontNames) {
            TSysCode *pSysCode = new TSysCode();

            pSysCode->CLSS_CD  = sCodeClss;
            pSysCode->CODE_NO  = pObj->VMS_FONT_NAME_CD;
            pSysCode->CD_NM    = pObj->VMS_FONT_NAME_NM;
            pSysCode->USE_YN   = "Y";

            pClssCd->FLists.Push(pSysCode->CODE_NO, pSysCode);
        }
    }

    return 0;
}
//---------------------------------------------------------------------------