VMSM660MF.cpp 30 KB

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