FRAME_VdsListF.cpp 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #include "ITSSkinF.h"
  4. #include "ITSUtilF.h"
  5. #include "FrmResourceF.h"
  6. #include "ITSLangTransF.h"
  7. #pragma hdrstop
  8. #include "FRAME_VdsListF.h"
  9. //---------------------------------------------------------------------------
  10. #pragma package(smart_init)
  11. #pragma link "cxButtons"
  12. #pragma link "cxCalc"
  13. #pragma link "cxCheckBox"
  14. #pragma link "cxClasses"
  15. #pragma link "cxControls"
  16. #pragma link "cxCustomData"
  17. #pragma link "cxData"
  18. #pragma link "cxDataStorage"
  19. #pragma link "cxEdit"
  20. #pragma link "cxFilter"
  21. #pragma link "cxGraphics"
  22. #pragma link "cxGrid"
  23. #pragma link "cxGridCustomTableView"
  24. #pragma link "cxGridCustomView"
  25. #pragma link "cxGridLevel"
  26. #pragma link "cxGridTableView"
  27. #pragma link "cxLookAndFeelPainters"
  28. #pragma link "cxLookAndFeels"
  29. #pragma link "cxStyles"
  30. #pragma link "cxTextEdit"
  31. #pragma link "dxSkinBlack"
  32. #pragma link "dxSkinBlue"
  33. #pragma link "dxSkinsCore"
  34. #pragma link "dxSkinscxPCPainter"
  35. #pragma link "cxContainer"
  36. #pragma link "cxLabel"
  37. #pragma resource "*.dfm"
  38. //TFRAMEVdsList *FRAMEVdsList;
  39. //---------------------------------------------------------------------------
  40. __fastcall TFRAMEVdsList::TFRAMEVdsList(TComponent* Owner)
  41. : TFrame(Owner)
  42. {
  43. LangTrans->Translate(this, ITSDb_GetConnection());
  44. ColumnSel->Options->Filtering = false;
  45. m_pGDC = TvList->DataController;
  46. TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<VDS 제어기 정보가 없습니다>";
  47. MyItsVdsManager = new TItsVdsManager();
  48. MyItsVdsManager->LoadFromDb();
  49. FCodeIFD = ItsCodeManager->FLists.Find("IFD"); //제어기유형
  50. }
  51. //---------------------------------------------------------------------------
  52. void __fastcall TFRAMEVdsList::UpdateList()
  53. {
  54. CMM_ClearGridTableView(TvList);
  55. int nRow = 0;
  56. try
  57. {
  58. TvList->BeginUpdate();
  59. try
  60. {
  61. MyItsVdsManager->FLists.Lock();
  62. FOR_STL(TItsVds*, pObj, MyItsVdsManager->FLists)
  63. {
  64. if (pObj->DEL_YN == "Y") continue;
  65. nRow = m_pGDC->AppendRecord();
  66. String VALD_YN; //CHAR(1) Y 'N' 유효 여부
  67. String X_CRDN; //NUMBER(11,8) Y X 좌표
  68. String Y_CRDN; //NUMBER(10,8) Y Y 좌표
  69. String TRMN_IP; //VARCHAR2(20) Y 단말기 아이피
  70. String TRMN_PORT; //VARCHAR2(5) Y 단말기 포트
  71. String CTLR_CLCT_CYCL; //NUMBER(3) Y 제어기 수집 주기
  72. String CTLR_STTS_CYCL; //NUMBER(3) Y 제어기 상태 주기
  73. String LOOP_BORD_NUM; //NUMBER(3) Y 0 루프 보드 개수
  74. String VDS_CTLR_ID; // 20141029-거제 현장 스키마가 변경되었음
  75. m_pGDC->Values[nRow][ColumnSel->Index] = false; //선택
  76. m_pGDC->Values[nRow][Column00->Index] = "-"; //편집
  77. m_pGDC->Values[nRow][Column01->Index] = pObj->CTLR_MNGM_NMBR; //관리번호
  78. m_pGDC->Values[nRow][Column02->Index] = pObj->CTLR_TYPE_CD; //제어기유형
  79. m_pGDC->Values[nRow][Column03->Index] = pObj->LCTN; //위치
  80. m_pGDC->Values[nRow][Column04->Index] = pObj->TRMN_IP; //위치
  81. m_pGDC->Values[nRow][Column05->Index] = pObj->TRMN_PORT; //위치
  82. m_pGDC->Values[nRow][Column06->Index] = pObj->CTLR_CLCT_CYCL; //위치
  83. m_pGDC->Values[nRow][Column07->Index] = pObj->CTLR_STTS_CYCL; //위치
  84. m_pGDC->Values[nRow][Column08->Index] = pObj->LOOP_BORD_NUM; //위치
  85. m_pGDC->Values[nRow][Column09->Index] = pObj->VDS_CTLR_ID; //위치
  86. m_pGDC->Values[nRow][Column99->Index] = (int)pObj;
  87. }
  88. }
  89. __finally
  90. {
  91. MyItsVdsManager->FLists.UnLock();
  92. }
  93. }
  94. __finally
  95. {
  96. LblRecords->Caption = "("+FormatFloat("##,##0", m_pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", m_pGDC->RecordCount) + ")";
  97. TvList->EndUpdate();
  98. TvList->DataController->GotoFirst();
  99. TvList->DataController->FocusedRecordIndex = 0;
  100. //CxList->SetFocus();
  101. }
  102. }
  103. //---------------------------------------------------------------------------
  104. void __fastcall TFRAMEVdsList::BtnAllSelectClick(TObject *Sender)
  105. {
  106. TcxButton *pBtn = (TcxButton*)Sender;
  107. CMM_CheckAllListItem(TvList, ColumnSel->Index, pBtn->Tag);
  108. }
  109. //---------------------------------------------------------------------------
  110. int __fastcall TFRAMEVdsList::GetSelIds(String &ALinkIds)
  111. {
  112. ALinkIds = "";
  113. if (TvList->ViewData->RecordCount <= 0) return 0;
  114. int nIndex = m_pGDC->FocusedRecordIndex;
  115. if( nIndex < 0 )
  116. return 0;
  117. String sLinkId = VarToStr(m_pGDC->Values[nIndex][Column01->Index]);
  118. ALinkIds = sLinkId;
  119. return 1;
  120. }
  121. //---------------------------------------------------------------------------
  122. int __fastcall TFRAMEVdsList::GetSelIds(TStringList *AStringList)
  123. {
  124. int nSelCnt = 0;
  125. try
  126. {
  127. TvList->BeginUpdate();
  128. #if 0
  129. int nRowCnt = m_pGDC->RecordCount;
  130. for (int ii = 0; ii < nRowCnt; ii++)
  131. {
  132. if (((bool)m_pGDC->Values[ii][ColumnSel->Index]))
  133. {
  134. AStringList->Add(m_pGDC->Values[ii][Column00->Index]);
  135. nSelIdx++;
  136. }
  137. }
  138. #else
  139. int nRowCnt = TvList->ViewData->RecordCount;
  140. for (int ii = 0; ii < nRowCnt; ii++)
  141. {
  142. TcxCustomGridRow* ARow = TvList->ViewData->Rows[ii];
  143. if (((bool)ARow->Values[ColumnSel->Index]))
  144. {
  145. AStringList->Add(ARow->Values[Column01->Index]);
  146. nSelCnt++;
  147. }
  148. }
  149. #endif
  150. }
  151. __finally
  152. {
  153. TvList->EndUpdate();
  154. }
  155. return nSelCnt;
  156. }
  157. //---------------------------------------------------------------------------
  158. void __fastcall TFRAMEVdsList::TvListDataControllerFilterChanged(TObject *Sender)
  159. {
  160. CMM_SetFilterLike(TvList);
  161. LblRecords->Caption = "("+FormatFloat("##,##0", m_pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", m_pGDC->RecordCount) + ")";
  162. }
  163. //---------------------------------------------------------------------------
  164. void __fastcall TFRAMEVdsList::BtnExlSaveClick(TObject *Sender)
  165. {
  166. TcxGrid *pGrid = CxList;
  167. TcxGridTableView *pView = TvList;
  168. String sTitle= lblFileName->Caption;//"VDS제어기정보";
  169. CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this);
  170. }
  171. //---------------------------------------------------------------------------
  172. void __fastcall TFRAMEVdsList::OnCloseQuery(bool &CanClose)
  173. {
  174. try {
  175. if (MyItsVdsManager)
  176. {
  177. delete MyItsVdsManager;
  178. MyItsVdsManager = NULL;
  179. }
  180. } catch(...) {}
  181. }
  182. //---------------------------------------------------------------------------