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

#pragma hdrstop

#include "CDSColtSysF.h"
#include "ITS_OPLibF.h"

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

#pragma package(smart_init)

TItsColtSys::TItsColtSys()
{
	FCompleted = false;
    FEditMode  = DB_INIT;
	FGridIndex = -1;
	MEM_DEL    = "N";
    //Clear();
}
//---------------------------------------------------------------------------
void TItsColtSys::Clear()
{
    ColtSys_ID   = "";  //VARCHAR2(20)	N			»ç¿ëÀÚID
    PWD          = "";  //VARCHAR2(64)	Y			¾ÏÈ£
    NAME         = "";  //VARCHAR2(30)	Y			¼º¸í
    COMP         = "";  //VARCHAR2(50)	Y			ȸ»ç
    TEL          = "";  //VARCHAR2(128)	Y			ÀüÈ­¹øÈ£
    ADDR         = "";  //VARCHAR2(200)	Y			ÁÖ¼Ò
    RESD_NMBR    = "";  //VARCHAR2(14)	Y			ÁֹιøÈ£
    MOBILE       = "";  //VARCHAR2(128)	Y			À̵¿ÀüÈ­
    EMAL         = "";  //VARCHAR2(128)	Y			À̸ÞÀÏ
    DEL_YN       = "";  //CHAR(1)	Y	'N'		»èÁ¦ ¿©ºÎ
    RGSTYMD      = "";  //VARCHAR2(14)	Y			µî·ÏÀÏÀÚ
    CRCTYMD      = "";  //VARCHAR2(14)	Y			¼öÁ¤ÀÏÀÚ
    HINT_QUES    = "";  //VARCHAR2(7)	Y			ÈùÆ®Áú¹®
    HINT_ANS     = "";  //VARCHAR2(100)	Y			ÈùÆ®Áú¹®´ä
    GROP_ID      = "";  //VARCHAR2(30)	Y			±×·ìID
    OPER_SYST_ID = "";  //VARCHAR2(30)	Y			¿î¿µ½Ã½ºÅÛID
}
//---------------------------------------------------------------------------
TItsColtSys::~TItsColtSys()
{
}
//---------------------------------------------------------------------------

//---------------------------------------------------------------------------
TItsColtSysManager *ItsColtSysManager = NULL;
//---------------------------------------------------------------------------

/*
* ColtSys Manager
*/
TItsColtSysManager::TItsColtSysManager()
{
}
//---------------------------------------------------------------------------
TItsColtSysManager::~TItsColtSysManager()
{
    FLists.RemoveAll();
}
//---------------------------------------------------------------------------
bool TItsColtSysManager::LoadFromDb(TADOConnection *ADbConn/*=NULL*/)
{
    String sQry;
    TADOQuery *pADO = NULL;

    sQry = "SELECT ROWNUM AS ORDSEQ, \r\n"
           "       CLCT_SYST_CD,     \r\n"
           "       CLCT_SYST_NM,     \r\n"
           "       USE_YN            \r\n"
           "  FROM TB_CLCT_SYST_STUP \r\n"
           " WHERE USE_YN = 'Y'      \r\n";
    try
    {
        FLists.Lock();
        FLists.RemoveAll();
        try
        {
            pADO = new TADOQuery(NULL);
			pADO->Close();
            pADO->Connection = (NULL != ADbConn) ? ADbConn : ITSDb_GetConnection();
			pADO->SQL->Clear();
			pADO->SQL->Text = sQry;

			pADO->Open();
            for( ; !pADO->Eof; pADO->Next())
            {
				TItsColtSys *pObj = new TItsColtSys();

                pObj->ORDSEQ        = pADO->FieldByName("ORDSEQ")->AsString;
                pObj->CLCT_SYST_CD  = pADO->FieldByName("CLCT_SYST_CD")->AsString;
                pObj->CLCT_SYST_NM  = pADO->FieldByName("CLCT_SYST_NM")->AsString;
                pObj->USE_YN        = pADO->FieldByName("USE_YN")->AsString;

				FLists.Push(pObj->ORDSEQ, pObj);

                pObj->Completed = true;
                pObj->MEM_DEL   = "N";
            }
        }
        catch(EDatabaseError &E)
        {
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &exception)
        {
            throw Exception(String(exception.ClassName()) + exception.Message);
        }
        catch(...)
        {
            throw Exception("[ItsColtSysManager] ¾Ë¼ö¾ø´Â DB ¿À·ù°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù.");
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
        FLists.UnLock();
    }

    return true;
}
//---------------------------------------------------------------------------