VMSM660MF.cpp 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #include "ITSSkinF.h"
  4. #include "ITSUtilF.h"
  5. #include "AppGlobalF.h"
  6. #include "CDSVmsIfscF.h"
  7. #include "ITSLangTransF.h"
  8. #include "CDSFontF.h"
  9. #pragma hdrstop
  10. #include "VMSM660MF.h"
  11. //---------------------------------------------------------------------------
  12. #pragma package(smart_init)
  13. #pragma link "cxButtons"
  14. #pragma link "cxCalendar"
  15. #pragma link "cxContainer"
  16. #pragma link "cxControls"
  17. #pragma link "cxDropDownEdit"
  18. #pragma link "cxEdit"
  19. #pragma link "cxGraphics"
  20. #pragma link "cxGroupBox"
  21. #pragma link "cxLabel"
  22. #pragma link "cxLookAndFeelPainters"
  23. #pragma link "cxLookAndFeels"
  24. #pragma link "cxMaskEdit"
  25. #pragma link "cxPC"
  26. #pragma link "cxPCdxBarPopupMenu"
  27. #pragma link "cxSpinEdit"
  28. #pragma link "cxSplitter"
  29. #pragma link "cxTextEdit"
  30. #pragma link "cxTimeEdit"
  31. #pragma link "dxSkinBlack"
  32. #pragma link "dxSkinBlue"
  33. #pragma link "dxSkinCaramel"
  34. #pragma link "dxSkinCoffee"
  35. #pragma link "dxSkinDarkRoom"
  36. #pragma link "dxSkinDarkSide"
  37. #pragma link "dxSkinFoggy"
  38. #pragma link "dxSkinGlassOceans"
  39. #pragma link "dxSkiniMaginary"
  40. #pragma link "dxSkinLilian"
  41. #pragma link "dxSkinLiquidSky"
  42. #pragma link "dxSkinLondonLiquidSky"
  43. #pragma link "dxSkinMcSkin"
  44. #pragma link "dxSkinMoneyTwins"
  45. #pragma link "dxSkinOffice2007Black"
  46. #pragma link "dxSkinOffice2007Blue"
  47. #pragma link "dxSkinOffice2007Green"
  48. #pragma link "dxSkinOffice2007Pink"
  49. #pragma link "dxSkinOffice2007Silver"
  50. #pragma link "dxSkinOffice2010Black"
  51. #pragma link "dxSkinOffice2010Blue"
  52. #pragma link "dxSkinOffice2010Silver"
  53. #pragma link "dxSkinsCore"
  54. #pragma link "dxSkinscxPCPainter"
  55. #pragma link "dxSkinSeven"
  56. #pragma link "dxSkinSharp"
  57. #pragma link "dxSkinSilver"
  58. #pragma link "dxSkinStardust"
  59. #pragma link "cxRadioGroup"
  60. #pragma link "cxClasses"
  61. #pragma link "cxCustomData"
  62. #pragma link "cxData"
  63. #pragma link "cxDataStorage"
  64. #pragma link "cxDBData"
  65. #pragma link "cxFilter"
  66. #pragma link "cxGrid"
  67. #pragma link "cxGridCustomTableView"
  68. #pragma link "cxGridCustomView"
  69. #pragma link "cxGridDBTableView"
  70. #pragma link "cxGridLevel"
  71. #pragma link "cxGridTableView"
  72. #pragma link "cxStyles"
  73. #pragma link "cxCheckBox"
  74. #pragma link "cxImage"
  75. #pragma link "cxButtonEdit"
  76. #pragma link "cxBlobEdit"
  77. #pragma link "VmsDesignerF"
  78. #pragma link "cxColorComboBox"
  79. #pragma link "cxCalc"
  80. #pragma resource "*.dfm"
  81. TVMSM660M *VMSM660M = NULL;
  82. //---------------------------------------------------------------------------
  83. __fastcall TVMSM660M::TVMSM660M(TComponent* Owner)
  84. : TForm(Owner)
  85. {
  86. LangTrans->Translate(this, ITSDb_GetConnection());
  87. ITSSkin_Load(this);
  88. //CMM_LoadForm(g_sFormsDir, this);
  89. FSelected = false;
  90. FUpdate= false;
  91. FTitle = Caption;//"VMS 교통상황 폼 관리";
  92. }
  93. //---------------------------------------------------------------------------
  94. void __fastcall TVMSM660M::CommClose()
  95. {
  96. try
  97. {
  98. if (m_pEdtDesigner)
  99. {
  100. delete m_pEdtDesigner;
  101. m_pEdtDesigner = NULL;
  102. }
  103. //CMM_SaveForm(g_sFormsDir, this);
  104. }
  105. catch(...)
  106. {
  107. }
  108. }
  109. //---------------------------------------------------------------------------
  110. void __fastcall TVMSM660M::FormCreate(TObject *Sender)
  111. {
  112. m_pEdtDesigner = new TVmsFormDesigner(PnlEditForm);
  113. FOR_STL(TCDSFontColor*, pObj, CDSFontManager->FColors)
  114. {
  115. m_pEdtDesigner->InitFontColor(pObj->VMS_FONT_COLR_CD, (TColor)pObj->VMS_FONT_COLR_VAL);
  116. }
  117. }
  118. //---------------------------------------------------------------------------
  119. void __fastcall TVMSM660M::FormShow(TObject *Sender)
  120. {
  121. Refresh();
  122. FormInit();
  123. PnlEdtBack->Width = FVmsWidth+4;
  124. PnlEdtBack->Height= FVmsHeight+4;
  125. LoadVmsIfsc(FVmsNmbr);
  126. TmrShow->Enabled = true;
  127. }
  128. //---------------------------------------------------------------------------
  129. void __fastcall TVMSM660M::FormInit()
  130. {
  131. //TvObjList->OptionsView->NoDataToDisplayInfoText = "<등록되어 있는 객체 정보가 없습니다>";
  132. m_pEdtDesigner->ApplicationHandle = (long)Handle;
  133. FNewDb = false;
  134. }
  135. //---------------------------------------------------------------------------
  136. void __fastcall TVMSM660M::LoadVmsIfsc(String AVmsNmbr)
  137. {
  138. CMM_ClearGridTableView(TvAxis);
  139. String sQry;
  140. TADOQuery *pADO = NULL;
  141. sQry = "SELECT C.VMS_CTLR_NMBR, C.VMS_CTLR_ID, C.VMS_NM, \r\n"
  142. " A.VMS_IFSC_ID, A.VMS_IFSC_NM, \r\n"
  143. " A.DSPL_STRT_NODE_NM, A.DSPL_END_NODE_NM, \r\n"
  144. " A.AXIS_YN, A.ROAD_NM, A.SPOT_NM \r\n"
  145. " FROM TB_VMS_IFSC A, \r\n"
  146. " TB_VMS_RLTN_IFSC B, \r\n"
  147. " (SELECT VMS_CTLR_NMBR, \r\n"
  148. " VMS_CTLR_ID, \r\n"
  149. " VMS_NM \r\n"
  150. " FROM TB_VMS_CTLR \r\n"
  151. " WHERE VMS_CTLR_NMBR = :p01) C \r\n"
  152. " WHERE A.USE_YN = 'Y' \r\n"
  153. " AND A.VMS_IFSC_ID = B.VMS_IFSC_ID \r\n"
  154. " AND B.VMS_CTLR_NMBR = C.VMS_CTLR_NMBR \r\n";
  155. try
  156. {
  157. int nRow;
  158. TcxDataController *pGDC = TvAxis->DataController;
  159. TvAxis->BeginUpdate();
  160. try
  161. {
  162. pADO = new TADOQuery(NULL);
  163. pADO->Close();
  164. pADO->Connection = ITSDb_GetConnection();
  165. ITSDb_SQLText(pADO, sQry);
  166. ITSDb_SQLBind(pADO, "p01", AVmsNmbr);
  167. ITSDb_SQLOpen(pADO);
  168. for( ; !pADO->Eof; pADO->Next())
  169. {
  170. nRow = pGDC->AppendRecord();
  171. pGDC->Values[nRow][Col00->Index] = pADO->FieldByName("VMS_CTLR_ID")->AsString;
  172. pGDC->Values[nRow][Col01->Index] = pADO->FieldByName("VMS_IFSC_ID")->AsString;
  173. pGDC->Values[nRow][Col02->Index] = pADO->FieldByName("VMS_IFSC_NM")->AsString;
  174. pGDC->Values[nRow][Col03->Index] = pADO->FieldByName("DSPL_STRT_NODE_NM")->AsString;
  175. pGDC->Values[nRow][Col04->Index] = pADO->FieldByName("DSPL_END_NODE_NM")->AsString;
  176. pGDC->Values[nRow][Col05->Index] = pADO->FieldByName("AXIS_YN")->AsString;
  177. pGDC->Values[nRow][Col06->Index] = pADO->FieldByName("ROAD_NM")->AsString;
  178. pGDC->Values[nRow][Col07->Index] = pADO->FieldByName("SPOT_NM")->AsString;
  179. }
  180. }
  181. catch(EDatabaseError &E)
  182. {
  183. DBERRORMSG("VMS Sect Query", String(E.ClassName()), E.Message, sQry);
  184. throw Exception(String(E.ClassName()) + E.Message);
  185. }
  186. catch(Exception &e)
  187. {
  188. DBERRORMSG("VMS Sect Query", String(e.ClassName()), e.Message, sQry);
  189. throw Exception(String(e.ClassName()) + e.Message);
  190. }
  191. }
  192. __finally
  193. {
  194. if (pADO)
  195. {
  196. pADO->Close();
  197. delete pADO;
  198. }
  199. TvAxis->EndUpdate();
  200. CMM_ExpandCollapseChk(TvAxis, true);
  201. }
  202. }
  203. //---------------------------------------------------------------------------
  204. void __fastcall TVMSM660M::TmrShowTimer(TObject *Sender)
  205. {
  206. TmrShow->Enabled = false;
  207. BtnSearchClick(NULL);
  208. }
  209. //---------------------------------------------------------------------------
  210. void __fastcall TVMSM660M::BtnSearchClick(TObject *Sender)
  211. {
  212. RefreshData();
  213. EdFocus->SetFocus();
  214. }
  215. //---------------------------------------------------------------------------
  216. void __fastcall TVMSM660M::RefreshData()
  217. {
  218. // 검색조건에 의한 링크 데이터 조회
  219. FormClear();
  220. m_pEdtDesigner->Clear();
  221. m_pEdtDesigner->SizeType = FVmsTypeCd;
  222. m_pEdtDesigner->SetSize(FVmsWidth, FVmsHeight);
  223. m_pEdtDesigner->SetPos(0, 0);
  224. m_pEdtDesigner->BkColorCode = FFormColor;
  225. m_pEdtDesigner->EditMode = true;
  226. m_pEdtDesigner->Show();
  227. InitObjectList();
  228. LoadFormObjectInfo(FFormId, m_pEdtDesigner);
  229. DispObjectListData();
  230. }
  231. //---------------------------------------------------------------------------
  232. void __fastcall TVMSM660M::AddTrafficTypeObject(int ARow, String AIfscId)
  233. {
  234. TVmsIfsc *pObj;
  235. TcxGridDataController *pGDC = TvObjList->DataController;
  236. pGDC->Values[ARow][ColIfscId->Index] = AIfscId;
  237. //pObj = VmsIfscManager->FLists.Find(FIfscId[0].ToIntDef(0));
  238. pObj = VmsIfscManager->FLists.Find(AIfscId.ToIntDef(0));
  239. if (!pObj) return;
  240. pGDC->Values[ARow][ColIfscNm->Index] = pObj->VMS_IFSC_NM;
  241. pGDC->Values[ARow][ColIfscStr->Index] = pObj->DSPL_STRT_NODE_NM;
  242. pGDC->Values[ARow][ColIfscEnd->Index] = pObj->DSPL_END_NODE_NM;
  243. }
  244. //---------------------------------------------------------------------------
  245. void __fastcall TVMSM660M::InitObjectList()
  246. {
  247. CMM_ClearGridTableView(TvObjList);
  248. TcxGridDataController *pGDC = TvObjList->DataController;
  249. try
  250. {
  251. TvObjList->BeginUpdate();
  252. pGDC->BeginUpdate();
  253. int nRow;
  254. switch(FFormType)
  255. {
  256. case 16:// ' 정체정보
  257. nRow = pGDC->AppendRecord();
  258. pGDC->Values[nRow][ColObj01->Index] = "11";
  259. pGDC->Values[nRow][ColObj02->Index] = "대상구간";
  260. pGDC->Values[nRow][ColObjType->Index] = "Form";
  261. AddTrafficTypeObject(nRow, FIfscId[0]);
  262. nRow = pGDC->AppendRecord();
  263. pGDC->Values[nRow][ColObj01->Index] = "12";
  264. pGDC->Values[nRow][ColObj02->Index] = "우회구간";
  265. pGDC->Values[nRow][ColObjType->Index] = "Form";
  266. AddTrafficTypeObject(nRow, FIfscId[1]);
  267. break;
  268. default:
  269. break;
  270. }
  271. }
  272. __finally
  273. {
  274. pGDC->EndUpdate();
  275. TvObjList->EndUpdate();
  276. }
  277. }
  278. //---------------------------------------------------------------------------
  279. void __fastcall TVMSM660M::DispObjectListData()
  280. {
  281. TcxGridDataController *pGDC = TvObjList->DataController;
  282. int nRow;
  283. return;
  284. TVmsFormObject *pObj;
  285. int nObjCnt = m_pEdtDesigner->GetObjectCount();
  286. for(int ii = 0; ii < nObjCnt; ii++)
  287. {
  288. pObj = m_pEdtDesigner->GetObject(ii);
  289. if (pObj)
  290. {
  291. switch(pObj->ObjType.ToIntDef(0))
  292. {
  293. case 91: //@축통행시간(고정)
  294. nRow = pGDC->AppendRecord();
  295. pGDC->Values[nRow][ColObj01->Index] = "15";
  296. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill91->Caption;//"AxisTravelTime";//"축통행시간(고정)";
  297. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  298. pGDC->Values[nRow][ColObjType->Index] = "x";
  299. AddTrafficTypeObject(nRow, pObj->Tag);
  300. break;
  301. case 92: //@축소통상황(고정)
  302. nRow = pGDC->AppendRecord();
  303. pGDC->Values[nRow][ColObj01->Index] = "15";
  304. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill92->Caption;//"Traffic(Fix)";//"소통상황(고정)";
  305. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  306. pGDC->Values[nRow][ColObjType->Index] = "x";
  307. AddTrafficTypeObject(nRow, pObj->Tag);
  308. break;
  309. case 17: //@소통정보이미지1
  310. nRow = pGDC->AppendRecord();
  311. pGDC->Values[nRow][ColObj01->Index] = String(FFormType);//"17";
  312. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill17->Caption;//"TrafficImage";//"소통정보이미지";
  313. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  314. pGDC->Values[nRow][ColObjType->Index] = "17";
  315. AddTrafficTypeObject(nRow, FIfscId[4]);
  316. break;
  317. case 27: //@소통정보이미지2
  318. nRow = pGDC->AppendRecord();
  319. pGDC->Values[nRow][ColObj01->Index] = String(FFormType);//"27";
  320. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill27->Caption;//"TrafficImage2";//"소통정보이미지2";
  321. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  322. pGDC->Values[nRow][ColObjType->Index] = "27";
  323. AddTrafficTypeObject(nRow, FIfscId[5]);
  324. break;
  325. case 37: //@소통정보이미지3
  326. nRow = pGDC->AppendRecord();
  327. pGDC->Values[nRow][ColObj01->Index] = String(FFormType);//"37";
  328. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill37->Caption;//"TrafficImage3";//"소통정보이미지3";
  329. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  330. pGDC->Values[nRow][ColObjType->Index] = "37";
  331. AddTrafficTypeObject(nRow, FIfscId[6]);
  332. break;
  333. case 47: //@소통정보이미지4
  334. nRow = pGDC->AppendRecord();
  335. pGDC->Values[nRow][ColObj01->Index] = String(FFormType);//"47";
  336. pGDC->Values[nRow][ColObj02->Index] = FrmLang->lblFill47->Caption;//"TrafficImage4";//"소통정보이미지4";
  337. pGDC->Values[nRow][ColObj03->Index] = String(pObj->ObjSeq);
  338. pGDC->Values[nRow][ColObjType->Index] = "47";
  339. AddTrafficTypeObject(nRow, FIfscId[7]);
  340. break;
  341. }
  342. }
  343. }
  344. }
  345. //---------------------------------------------------------------------------
  346. void __fastcall TVMSM660M::BtnClosexClick(TObject *Sender)
  347. {
  348. FSelected = false;
  349. Close();
  350. }
  351. //---------------------------------------------------------------------------
  352. void __fastcall TVMSM660M::FormClose(TObject *Sender, TCloseAction &Action)
  353. {
  354. CommClose();
  355. VMSM660M = NULL;
  356. //Action = caFree;
  357. }
  358. //---------------------------------------------------------------------------
  359. void __fastcall TVMSM660M::LoadFormObjectInfo(String AFormId, TVmsFormDesigner *ADesigner)
  360. {
  361. ADesigner->Clear();
  362. String sQry;
  363. TADOQuery *pADO = NULL;
  364. sQry = "SELECT A.*, \r\n"
  365. " C.VMS_FONT_NAME_NM, \r\n"
  366. " B.IMAG_DATA AS SYMB_IMG, \r\n"
  367. " B.SYMB_EXPL AS SYMB_IMG_NM \r\n"
  368. " FROM TB_VMS_FORM_OBJECT A, \r\n"
  369. " TB_VMS_SYMB_LIB B, \r\n"
  370. " TB_VMS_FONT_NAME C, \r\n"
  371. " TB_VMS_FORM D \r\n"
  372. " WHERE D.VMS_FORM_ID = :p01 \r\n"
  373. " AND D.VMS_FORM_ID = A.VMS_FORM_ID \r\n"
  374. " AND A.SYMB_LIB_NMBR = B.SYMB_LIB_NMBR(+) \r\n"
  375. " AND A.VMS_FONT_NAME_CD = C.VMS_FONT_NAME_CD(+) \r\n"
  376. " ORDER BY A.VMS_FORM_OBJECT_ID ASC \r\n";
  377. try
  378. {
  379. try
  380. {
  381. pADO = new TADOQuery(NULL);
  382. pADO->Close();
  383. pADO->Connection = ITSDb_GetConnection();
  384. ITSDb_SQLText(pADO, sQry);
  385. ITSDb_SQLBind(pADO, "p01", AFormId);
  386. ITSDb_SQLOpen(pADO);
  387. int nDrawType;
  388. String sObjKind;
  389. for( ; !pADO->Eof; pADO->Next())
  390. {
  391. int nFormId = pADO->FieldByName("VMS_FORM_ID")->AsInteger;
  392. int nObjId = pADO->FieldByName("VMS_FORM_OBJECT_ID")->AsInteger;
  393. int nObjType = pADO->FieldByName("VMS_FORM_OBJECT_TYPE_CD")->AsInteger;
  394. if (nObjType == 1 || //심볼
  395. nObjType == 2 || //이미지
  396. nObjType == 3 || //배경이미지
  397. nObjType == 17 || //@소통정보이미지 (1열)
  398. nObjType == 27 || //@소통정보이미지2(2열)
  399. nObjType == 37 || //@소통정보이미지3(3열)
  400. nObjType == 47 || //소통이미지4
  401. nObjType == 200 || //동영상
  402. nObjType == 300 || //스트리밍영상
  403. nObjType == 406 || //@통합대기등급 이미지
  404. nObjType == 407 || //@미세먼지등급 이미지
  405. nObjType == 408 || //@초미세먼지등급 이미지
  406. nObjType == 413 //@오존등급이미지
  407. )
  408. {
  409. if (nObjType == 1) sObjKind = OBJKIND_IMAGEID; //Image Id
  410. else sObjKind = OBJKIND_IMAGE; //Image
  411. nDrawType = 1; //이미지그리기
  412. }
  413. else
  414. {
  415. sObjKind = OBJKIND_TEXT; //문자열
  416. nDrawType = 0; //문자열그리기
  417. }
  418. //실재 맵핑된 구간의 정보를 표출하도록 한다.
  419. int nBlinking = pADO->FieldByName("VMS_DSPL_BLINKING")->AsInteger;
  420. int nPosX = pADO->FieldByName("VMS_DSPL_XCRDN")->AsInteger;
  421. int nPosY = pADO->FieldByName("VMS_DSPL_YCRDN")->AsInteger;
  422. TVmsFormObject *pObj = ADesigner->AddObject((VmsObjectDrawType)nDrawType);
  423. if (!pObj) continue;
  424. //11 , ' @구간명
  425. //12 , ' @시점명
  426. //13 , ' @종점명
  427. //14 , ' @소통상황
  428. //15 , ' @통행시간
  429. //16 , ' @통행속도
  430. //17 , ' @방향
  431. pObj->Text = pADO->FieldByName("VMS_DSPL_TXT")->AsString.Trim();
  432. pObj->RunText = pObj->Text;
  433. String sIfscId = "";
  434. if (nObjType >= 11 && nObjType < 17)
  435. sIfscId = FIfscId[0];
  436. else
  437. if (nObjType >= 161 && nObjType < 167)
  438. sIfscId = FIfscId[1];
  439. else
  440. if (nObjType >= 31 && nObjType < 37)
  441. sIfscId = FIfscId[2];
  442. else
  443. if (nObjType >= 41 && nObjType < 47)
  444. sIfscId = FIfscId[3];
  445. switch(nObjType)
  446. {
  447. case 17: sIfscId = FIfscId[4]; break;
  448. case 27: sIfscId = FIfscId[5]; break;
  449. case 37: sIfscId = FIfscId[6]; break;
  450. case 47: sIfscId = FIfscId[7]; break;
  451. }
  452. if (sIfscId != "")
  453. {
  454. TVmsIfsc *pIfscObj;
  455. pIfscObj = VmsIfscManager->FLists.Find(sIfscId.ToIntDef(0));
  456. if (pIfscObj)
  457. {
  458. switch(nObjType)
  459. {
  460. case 11: case 21: case 31: case 41: case 161:
  461. pObj->RunText = pIfscObj->ROAD_NM;
  462. break;
  463. case 12: case 22: case 32: case 42: case 162:
  464. pObj->RunText = pIfscObj->DSPL_STRT_NODE_NM;
  465. break;
  466. case 13: case 23: case 33: case 43: case 163:
  467. pObj->RunText = pIfscObj->DSPL_END_NODE_NM;
  468. break;
  469. case 18: case 168:
  470. pObj->RunText = pIfscObj->SPOT_NM;
  471. break;
  472. }
  473. }
  474. }
  475. if (nObjType == 200 || nObjType == 300)
  476. {
  477. pObj->EditMode = false;
  478. }
  479. pObj->ObjSeq = nObjId;
  480. pObj->ObjId = nObjId;
  481. pObj->ObjKind = sObjKind;
  482. pObj->Tag = pADO->FieldByName("VMS_IFSC_ID")->AsString;
  483. pObj->ObjType = pADO->FieldByName("VMS_FORM_OBJECT_TYPE_CD")->AsString;
  484. pObj->ObjSize = pADO->FieldByName("VMS_DSPL_SIZE")->AsInteger;
  485. pObj->BkColorCode = pADO->FieldByName("VMS_DSPL_BKCOLOR")->AsString;
  486. pObj->Blink = nBlinking == 1 ? true : false;
  487. pObj->ImageId = pADO->FieldByName("SYMB_LIB_NMBR")->AsString;
  488. if (pObj->ObjKind == OBJKIND_TEXT) // 문자열
  489. {
  490. int nFontBold = pADO->FieldByName("VMS_FONT_BOLD")->AsInteger;
  491. pObj->FontName = pADO->FieldByName("VMS_FONT_NAME_NM")->AsString;
  492. pObj->FontNameCode = pADO->FieldByName("VMS_FONT_NAME_CD")->AsString;
  493. pObj->FontColorCode = pADO->FieldByName("VMS_FONT_COLR_CD")->AsString;
  494. pObj->FontSize = pADO->FieldByName("VMS_FONT_SIZE")->AsInteger;
  495. pObj->FontBold = nFontBold == 1 ? true : false;
  496. pObj->TextAlign = pADO->FieldByName("VMS_FONT_ALIGN")->AsInteger;
  497. pObj->SetSize(pADO->FieldByName("VMS_DSPL_WIDTH")->AsInteger, pADO->FieldByName("VMS_DSPL_HEIGHT")->AsInteger);
  498. pObj->SetRuntimeText(pObj->RunText);
  499. }
  500. else //if (sObjKind == "1" || sObjKind == "2") // 이미지(1), 이미지 ID(2)
  501. {
  502. if (pObj->ObjKind == OBJKIND_IMAGEID)
  503. {
  504. pObj->Text = pADO->FieldByName("SYMB_LIB_NMBR")->AsString;
  505. }
  506. TStream *pStream = NULL;
  507. pStream = pADO->CreateBlobStream(pADO->FieldByName("VMS_DSPL_FIGR"), bmRead);
  508. try
  509. {
  510. if (pStream && pStream->Size > 0)
  511. {
  512. Graphics::TBitmap *Bitmap = pObj->GetBitmap();
  513. pStream->Position = 0;
  514. Bitmap->LoadFromStream(pStream);
  515. pObj->SetSize(Bitmap->Width, Bitmap->Height);
  516. }
  517. }
  518. __finally
  519. {
  520. SAFE_DELETE(pStream);
  521. }
  522. }
  523. pObj->SetPos(nPosX, nPosY);
  524. pObj->Show();
  525. pObj->BringToFront();
  526. }
  527. }
  528. catch(EDatabaseError &E)
  529. {
  530. DBERRORMSG("TVMSM660M::LoadFormObjectInfo", String(E.ClassName()), E.Message, sQry);
  531. throw Exception(String(E.ClassName()) + E.Message);
  532. }
  533. catch(Exception &exception)
  534. {
  535. DBERRORMSG("TVMSM660M::LoadFormObjectInfo", String(exception.ClassName()), exception.Message, sQry);
  536. throw Exception(String(exception.ClassName()) + exception.Message);
  537. }
  538. }
  539. __finally
  540. {
  541. if (pADO)
  542. {
  543. pADO->Close();
  544. delete pADO;
  545. }
  546. }
  547. }
  548. //---------------------------------------------------------------------------
  549. void __fastcall TVMSM660M::FormClear()
  550. {
  551. FSelIdx = -1;
  552. EdFormId->Clear();
  553. EdObjId->Clear();
  554. FNewDb = false;
  555. }
  556. //---------------------------------------------------------------------------
  557. void __fastcall TVMSM660M::TvObjListFocusedRecordChanged(TcxCustomGridTableView *Sender,
  558. TcxCustomGridRecord *APrevFocusedRecord, TcxCustomGridRecord *AFocusedRecord,
  559. bool ANewItemRecordFocusingChanged)
  560. {
  561. if (TvObjList->ViewData->RecordCount <= 0) return;
  562. if (TvObjList->DataController->FocusedRowIndex < 0) return;
  563. m_pEdtDesigner->SelectedObjectAll(false);
  564. TcxDataController *pGDC = TvObjList->DataController;
  565. int nIndex = pGDC->FocusedRecordIndex;
  566. String sObjType = pGDC->Values[nIndex][ColObjType->Index];
  567. String sFormType = pGDC->Values[nIndex][ColObj01->Index];
  568. int nFormType = sFormType.ToIntDef(0);
  569. if (nFormType == 11 || nFormType == 12 || nFormType == 13 || nFormType == 14)
  570. {
  571. BtnListAdd->Enabled = true;
  572. BtnListDelete->Enabled = true;
  573. }
  574. else
  575. {
  576. BtnListAdd->Enabled = true;
  577. BtnListDelete->Enabled = true;
  578. }
  579. if (nFormType == 15)
  580. {
  581. int nObjSeq = VarToStr(pGDC->Values[nIndex][ColObj03->Index]).ToIntDef(0);
  582. m_pEdtDesigner->SelectObject(nObjSeq);
  583. return;
  584. }
  585. TVmsFormObject *pObj;
  586. int nObjCnt = m_pEdtDesigner->GetObjectCount();
  587. for(int ii = 0; ii < nObjCnt; ii++)
  588. {
  589. pObj = m_pEdtDesigner->GetObject(ii);
  590. if (!pObj) continue;
  591. int nObjType = pObj->ObjType.ToIntDef(0);
  592. switch(nFormType)
  593. {
  594. case 11:// ' 소통상황(1단)
  595. switch(nObjType)
  596. {
  597. case 11: //도로명
  598. case 12: //시점명
  599. case 13: //종점명
  600. case 18: //지점명
  601. m_pEdtDesigner->SelectObject(pObj->ObjSeq, true);
  602. }
  603. break;
  604. case 12:
  605. switch(nObjType)
  606. {
  607. case 161:
  608. case 162:
  609. case 163:
  610. case 168:
  611. m_pEdtDesigner->SelectObject(pObj->ObjSeq, true);
  612. }
  613. break;
  614. }
  615. }
  616. }
  617. //---------------------------------------------------------------------------
  618. void __fastcall TVMSM660M::BtnListAddClick(TObject *Sender)
  619. {
  620. int nCellIdx = CMM_GetRecordIndex(TvObjList);
  621. if (nCellIdx < 0) return;
  622. int nIfscIdx = CMM_GetRecordIndex(TvAxis);
  623. if (nIfscIdx < 0) return;
  624. TcxGridDataController *pDcCell = TvObjList->DataController;
  625. TcxGridDataController *pDcIfsc = TvAxis->DataController;
  626. pDcCell->Values[nCellIdx][ColIfscId->Index] = pDcIfsc->Values[nIfscIdx][Col01->Index];
  627. pDcCell->Values[nCellIdx][ColIfscNm->Index] = pDcIfsc->Values[nIfscIdx][Col02->Index];
  628. pDcCell->Values[nCellIdx][ColIfscStr->Index] = pDcIfsc->Values[nIfscIdx][Col03->Index];
  629. pDcCell->Values[nCellIdx][ColIfscEnd->Index] = pDcIfsc->Values[nIfscIdx][Col04->Index];
  630. pDcCell->Values[nCellIdx][ColObj06->Index] = pDcIfsc->Values[nIfscIdx][Col06->Index];
  631. pDcCell->Values[nCellIdx][ColObj07->Index] = pDcIfsc->Values[nIfscIdx][Col07->Index];
  632. TVmsFormObject *pObj;
  633. int nObjCnt = m_pEdtDesigner->GetObjectCount();
  634. for(int ii = 0; ii < nObjCnt; ii++)
  635. {
  636. pObj = m_pEdtDesigner->GetObject(ii);
  637. if (!pObj) continue;
  638. //if (!pObj->Selected) continue;
  639. String sText = "";
  640. int nObjType = pObj->ObjType.ToIntDef(0);
  641. if (nCellIdx == 0)
  642. {
  643. switch(nObjType)
  644. {
  645. case 11: //도로명
  646. sText = VarToStr(pDcCell->Values[nCellIdx][ColObj06->Index]); break;
  647. case 12: //시점명
  648. sText = VarToStr(pDcCell->Values[nCellIdx][ColIfscStr->Index]); break;
  649. case 13: //종점명
  650. sText = VarToStr(pDcCell->Values[nCellIdx][ColIfscEnd->Index]); break;
  651. case 18: //지점명
  652. sText = VarToStr(pDcCell->Values[nCellIdx][ColObj07->Index]); break;
  653. }
  654. if (sText != "")
  655. {
  656. pObj->RunText = sText;
  657. pObj->SetRuntimeText(pObj->RunText);
  658. }
  659. }
  660. else
  661. if (nCellIdx == 1)
  662. {
  663. switch(nObjType)
  664. {
  665. case 161:
  666. sText = VarToStr(pDcCell->Values[nCellIdx][ColObj06->Index]); break;
  667. case 162:
  668. sText = VarToStr(pDcCell->Values[nCellIdx][ColIfscStr->Index]); break;
  669. case 163:
  670. sText = VarToStr(pDcCell->Values[nCellIdx][ColIfscEnd->Index]); break;
  671. case 168:
  672. sText = VarToStr(pDcCell->Values[nCellIdx][ColObj07->Index]); break;
  673. }
  674. if (sText != "")
  675. {
  676. pObj->RunText = sText;
  677. pObj->SetRuntimeText(pObj->RunText);
  678. }
  679. }
  680. }
  681. }
  682. //---------------------------------------------------------------------------
  683. void __fastcall TVMSM660M::BtnListDeleteClick(TObject *Sender)
  684. {
  685. int nCellIdx = CMM_GetRecordIndex(TvObjList);
  686. if (nCellIdx < 0) return;
  687. TcxGridDataController *pDcCell = TvObjList->DataController;
  688. pDcCell->Values[nCellIdx][ColIfscId->Index] = "";
  689. pDcCell->Values[nCellIdx][ColIfscNm->Index] = "";
  690. pDcCell->Values[nCellIdx][ColIfscStr->Index] = "";
  691. pDcCell->Values[nCellIdx][ColIfscEnd->Index] = "";
  692. TVmsFormObject *pObj;
  693. int nObjCnt = m_pEdtDesigner->GetObjectCount();
  694. for(int ii = 0; ii < nObjCnt; ii++)
  695. {
  696. pObj = m_pEdtDesigner->GetObject(ii);
  697. if (!pObj) continue;
  698. if (!pObj->Selected) continue;
  699. int nObjType = pObj->ObjType.ToIntDef(0);
  700. switch(nObjType)
  701. {
  702. case 11: //도로명
  703. case 161:
  704. case 12: //시점명
  705. case 162:
  706. case 13: //종점명
  707. case 163:
  708. case 18: //지점명
  709. case 168:
  710. pObj->SetRuntimeText(pObj->Text); break;
  711. }
  712. }
  713. }
  714. //---------------------------------------------------------------------------
  715. void __fastcall TVMSM660M::BtnSaveClick(TObject *Sender)
  716. {
  717. TcxDataController *pGDC = TvObjList->DataController;
  718. try
  719. {
  720. TvObjList->BeginUpdate();
  721. pGDC->BeginUpdate();
  722. int nRows = pGDC->RecordCount;
  723. try
  724. {
  725. for (int ii = 0; ii < nRows; ii++)
  726. {
  727. int nObjType = VarToStr(pGDC->Values[ii][ColObjType->Index]).ToIntDef(-1);
  728. int nFormType = VarToStr(pGDC->Values[ii][ColObj01->Index]).ToIntDef(0);
  729. String sIfscId = VarToStr(pGDC->Values[ii][ColIfscId->Index]);
  730. switch(nObjType)
  731. {
  732. case 17: FIfscId[4] = sIfscId; break;
  733. case 27: FIfscId[5] = sIfscId; break;
  734. case 37: FIfscId[6] = sIfscId; break;
  735. case 47: FIfscId[7] = sIfscId; break;
  736. default:
  737. switch(nFormType)
  738. {
  739. case 11: FIfscId[0] = sIfscId;
  740. FIfscId[4] = sIfscId;
  741. break; // ' 소통상황(1단)
  742. case 12: FIfscId[1] = sIfscId;
  743. FIfscId[5] = sIfscId;
  744. break; // ' 소통상황(2단)
  745. case 13: FIfscId[2] = sIfscId; break; // ' 소통상황(3단)
  746. case 14: FIfscId[3] = sIfscId; break; // ' 소통상황(4단)
  747. }
  748. break;
  749. }
  750. }
  751. }
  752. catch(Exception &e)
  753. {
  754. }
  755. }
  756. __finally
  757. {
  758. pGDC->EndUpdate();
  759. TvObjList->EndUpdate();
  760. }
  761. m_pEdtDesigner->GetVmsFormImage(ImgForm);
  762. FSelected = true;
  763. Close();
  764. }
  765. //---------------------------------------------------------------------------
  766. void __fastcall TVMSM660M::Col05CustomDrawCell(TcxCustomGridTableView *Sender, TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
  767. bool &ADone)
  768. {
  769. int nRecordIdx = AViewInfo->GridRecord->RecordIndex;
  770. if (nRecordIdx < 0)
  771. {
  772. return;
  773. }
  774. try
  775. {
  776. int nItemIdx = AViewInfo->Item->Index;
  777. if (VarIsNull(AViewInfo->GridRecord->DisplayTexts[nItemIdx])) return;
  778. String sData = AViewInfo->GridRecord->DisplayTexts[nItemIdx];
  779. if (sData == "Y")
  780. {
  781. ACanvas->Canvas->Brush->Color = clLime;
  782. }
  783. }
  784. catch(Exception &e)
  785. {
  786. }
  787. }
  788. //---------------------------------------------------------------------------