VMSM410MF.cpp 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461
  1. /****************************************************************************
  2. * @source :
  3. * @description :
  4. ****************************************************************************
  5. * DATE AUTHOR DESCRIPTION
  6. * --------------------------------------------------------------------------
  7. * 2016/07/10 shjung 최초작성
  8. *
  9. ****************************************************************************/
  10. //---------------------------------------------------------------------------
  11. #include <vcl.h>
  12. #include "ITSSkinF.h"
  13. #include "ITSUtilF.h"
  14. #include "AppGlobalF.h"
  15. #pragma hdrstop
  16. #include "VMSM410MF.h"
  17. //---------------------------------------------------------------------------
  18. #pragma package(smart_init)
  19. #pragma link "cxButtons"
  20. #pragma link "cxCalendar"
  21. #pragma link "cxContainer"
  22. #pragma link "cxControls"
  23. #pragma link "cxDropDownEdit"
  24. #pragma link "cxEdit"
  25. #pragma link "cxGraphics"
  26. #pragma link "cxGroupBox"
  27. #pragma link "cxLabel"
  28. #pragma link "cxLookAndFeelPainters"
  29. #pragma link "cxLookAndFeels"
  30. #pragma link "cxMaskEdit"
  31. #pragma link "cxPC"
  32. #pragma link "cxPCdxBarPopupMenu"
  33. #pragma link "cxSpinEdit"
  34. #pragma link "cxSplitter"
  35. #pragma link "cxTextEdit"
  36. #pragma link "cxTimeEdit"
  37. #pragma link "dxSkinBlack"
  38. #pragma link "dxSkinBlue"
  39. #pragma link "dxSkinCaramel"
  40. #pragma link "dxSkinCoffee"
  41. #pragma link "dxSkinDarkRoom"
  42. #pragma link "dxSkinDarkSide"
  43. #pragma link "dxSkinFoggy"
  44. #pragma link "dxSkinGlassOceans"
  45. #pragma link "dxSkiniMaginary"
  46. #pragma link "dxSkinLilian"
  47. #pragma link "dxSkinLiquidSky"
  48. #pragma link "dxSkinLondonLiquidSky"
  49. #pragma link "dxSkinMcSkin"
  50. #pragma link "dxSkinMoneyTwins"
  51. #pragma link "dxSkinOffice2007Black"
  52. #pragma link "dxSkinOffice2007Blue"
  53. #pragma link "dxSkinOffice2007Green"
  54. #pragma link "dxSkinOffice2007Pink"
  55. #pragma link "dxSkinOffice2007Silver"
  56. #pragma link "dxSkinOffice2010Black"
  57. #pragma link "dxSkinOffice2010Blue"
  58. #pragma link "dxSkinOffice2010Silver"
  59. #pragma link "dxSkinsCore"
  60. #pragma link "dxSkinscxPCPainter"
  61. #pragma link "dxSkinSeven"
  62. #pragma link "dxSkinSharp"
  63. #pragma link "dxSkinSilver"
  64. #pragma link "dxSkinStardust"
  65. #pragma link "cxRadioGroup"
  66. #pragma link "cxClasses"
  67. #pragma link "cxCustomData"
  68. #pragma link "cxData"
  69. #pragma link "cxDataStorage"
  70. #pragma link "cxDBData"
  71. #pragma link "cxFilter"
  72. #pragma link "cxGrid"
  73. #pragma link "cxGridCustomTableView"
  74. #pragma link "cxGridCustomView"
  75. #pragma link "cxGridDBTableView"
  76. #pragma link "cxGridLevel"
  77. #pragma link "cxGridTableView"
  78. #pragma link "cxStyles"
  79. #pragma link "cxCheckBox"
  80. #pragma link "cxImage"
  81. #pragma link "cxButtonEdit"
  82. #pragma link "cxBlobEdit"
  83. #pragma resource "*.dfm"
  84. TVMSM410M *VMSM410M = NULL;
  85. //---------------------------------------------------------------------------
  86. __fastcall TVMSM410M::TVMSM410M(TComponent* Owner)
  87. : TForm(Owner)
  88. {
  89. ITSSkin_Load(this);
  90. CMM_LoadForm(g_sFormsDir, this);
  91. FUpdate= false;
  92. FTitle = "VMS 소통정보 배경이미지관리";
  93. FListSymb = new TList;
  94. EditMode = false;
  95. APP_InitDisplayColor();
  96. TvList->OptionsView->DataRowHeight = 0;
  97. TvList->OptionsView->CellAutoHeight = true;
  98. TvList->OptionsView->Indicator = false;
  99. TvList->OptionsCustomize->ColumnMoving = false;
  100. TvList->OptionsCustomize->ColumnSorting = false;
  101. TvList->Columns[0]->Width = 60;
  102. TvList->Columns[0]->Options->HorzSizing = false;
  103. }
  104. //---------------------------------------------------------------------------
  105. /*
  106. * 닫기버튼 이나 x버튼 클릭시 공통으로 처리하는 로직이들어간다..
  107. * Form과 DataModule class를 delete시킨다.
  108. * arguments
  109. *
  110. * return
  111. * void
  112. */
  113. void __fastcall TVMSM410M::CommClose()
  114. {
  115. try
  116. {
  117. ClearSymbloList();
  118. SAFE_DELETE(FListSymb);
  119. CMM_SaveForm(g_sFormsDir, this);
  120. }
  121. catch(...)
  122. {
  123. }
  124. }
  125. //---------------------------------------------------------------------------
  126. /*
  127. * Form을 보여줄때 호출되는 event 메서드이다.
  128. * arguments
  129. * Sender : event handler 객체
  130. * return
  131. * void
  132. */
  133. void __fastcall TVMSM410M::FormShow(TObject *Sender)
  134. {
  135. Refresh();
  136. FormInit();
  137. ChangeEditMode(1);
  138. TmrShow->Enabled = true;
  139. }
  140. //---------------------------------------------------------------------------
  141. /*
  142. * form 초기화
  143. *
  144. * arguments
  145. *
  146. * return
  147. * void
  148. */
  149. void __fastcall TVMSM410M::FormInit()
  150. {
  151. EdNmbr->Text = "";
  152. EdExpl->Text = "";
  153. EdImageFileName->Text = "";
  154. ImgPreView->Picture->Bitmap->FreeImage();
  155. ImgPreView->Picture->Bitmap = NULL;
  156. ImgTemp->Picture->Bitmap->FreeImage();
  157. ImgTemp->Picture->Bitmap = NULL;
  158. SePosX->Value = 0;
  159. SePosY->Value = 0;
  160. SeCellId->Value = 1;
  161. CMM_ClearGridTableView(TvImageCell);
  162. FNewDb = false;
  163. }
  164. //---------------------------------------------------------------------------
  165. /*
  166. * Form이 Show되고 난 후 최초 1회 수행되는 타이머 이벤트
  167. * arguments
  168. * Sender : event handler 객체
  169. * return
  170. * void
  171. */
  172. void __fastcall TVMSM410M::TmrShowTimer(TObject *Sender)
  173. {
  174. TmrShow->Enabled = false;
  175. LoadVmsIfsc();
  176. LoadImageSymbol();
  177. }
  178. //---------------------------------------------------------------------------
  179. /*
  180. * Close 버튼 클릭 이벤트 핸들러
  181. * arguments
  182. * Sender : event handler 객체
  183. * return
  184. * void
  185. */
  186. void __fastcall TVMSM410M::BtnCloseClick(TObject *Sender)
  187. {
  188. Close();
  189. }
  190. //---------------------------------------------------------------------------
  191. void __fastcall TVMSM410M::FormClose(TObject *Sender, TCloseAction &Action)
  192. {
  193. CommClose();
  194. VMSM410M = NULL;
  195. Action = caFree;
  196. }
  197. //---------------------------------------------------------------------------
  198. void __fastcall TVMSM410M::FormCloseQuery(TObject *Sender, bool &CanClose)
  199. {
  200. if (FUpdate)
  201. {
  202. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_14, 0);
  203. }
  204. }
  205. //---------------------------------------------------------------------------
  206. void __fastcall TVMSM410M::DisplayInfo()
  207. {
  208. FormInit();
  209. int nRow = TvList->DataController->FocusedRecordIndex;
  210. if( nRow <= -1 )
  211. return;
  212. TcxGridDataController *pDc = TvList->DataController;
  213. nRow = pDc->FocusedRecordIndex;
  214. if (nRow < FListSymb->Count)
  215. {
  216. Graphics::TBitmap *bitmap = (Graphics::TBitmap*)FListSymb->Items[nRow];
  217. ImgPreView->Picture->Bitmap->Assign(bitmap);
  218. ImgTemp->Picture->Bitmap->Assign(bitmap);
  219. }
  220. EdNmbr->Text = VarToStr(pDc->Values[nRow][ColLink1->Index]);
  221. EdExpl->Text = VarToStr(pDc->Values[nRow][ColLink3->Index]);
  222. EdVmsCd->Text = VarToStr(pDc->Values[nRow][ColLink4->Index]);
  223. //셀정보 업데이트
  224. LoadImageSymbolCell(EdNmbr->Text);
  225. UpdateCellColor();
  226. ChangeEditMode(3);
  227. }
  228. //---------------------------------------------------------------------------
  229. void __fastcall TVMSM410M::BtnEditClick(TObject *Sender)
  230. {
  231. if (BtnEdit->Caption == MSG903)
  232. {
  233. ChangeEditMode(0);
  234. FNewDb = false;
  235. }
  236. else
  237. {
  238. String sId = EdNmbr->Text;
  239. ChangeEditMode(1);
  240. if (CMM_FindGridData(TvList->DataController, sId, ColLink1->Index) >= 0)
  241. {
  242. CMM_SetGridRow(CxList, TvList, sId, ColLink1->Index);
  243. DisplayInfo();
  244. }
  245. }
  246. }
  247. //---------------------------------------------------------------------------
  248. void __fastcall TVMSM410M::ChangeEditMode(int AEdit)
  249. {
  250. LblWarn->Visible = false;
  251. FImageUpdate = false;
  252. bool bEnabled = false;
  253. switch(AEdit)
  254. {
  255. case 0: //편집버튼클릭
  256. {
  257. BtnEdit->Enabled = true;
  258. BtnInsert->Enabled = false;
  259. BtnDelete->Enabled = false;
  260. BtnSave->Enabled = true;
  261. BtnEdit->Caption = MSG901;
  262. BtnEdit->Hint = MSG902;
  263. EditMode = true;
  264. //EdImageFileName->Enabled = false;
  265. EdImageFileName->Enabled = true;
  266. LblWarn->Visible = true;
  267. }
  268. break;
  269. case 1: //편집[취소]버튼클릭
  270. {
  271. FormInit(); //화면을 모두 지운다.
  272. BtnEdit->Enabled = false;
  273. BtnInsert->Enabled = true;
  274. BtnDelete->Enabled = false;
  275. BtnSave->Enabled = false;
  276. BtnEdit->Caption = MSG903;
  277. BtnEdit->Hint = MSG904;
  278. //bEnabled = true;
  279. EditMode = false;
  280. EdImageFileName->Enabled = false;
  281. }
  282. break;
  283. case 2: //추가
  284. {
  285. BtnEdit->Enabled = true;
  286. BtnInsert->Enabled = false;
  287. BtnDelete->Enabled = false;
  288. BtnSave->Enabled = true;
  289. BtnEdit->Caption = MSG901;
  290. BtnEdit->Hint = MSG902;
  291. EditMode = true;
  292. EdImageFileName->Enabled = true;
  293. }
  294. break;
  295. case 3: //수정모드
  296. {
  297. BtnEdit->Enabled = true;
  298. BtnInsert->Enabled = true;
  299. BtnDelete->Enabled = true;
  300. BtnSave->Enabled = false;
  301. BtnEdit->Caption = MSG903;
  302. BtnEdit->Hint = MSG904;
  303. bEnabled = true;
  304. EditMode = false;
  305. //EdImageFileName->Enabled = false;
  306. EdImageFileName->Enabled = true;
  307. }
  308. break;
  309. }
  310. BtnSaveImgFile->Enabled = false;
  311. if (ImgPreView->Picture->Bitmap != NULL)
  312. {
  313. if (ImgPreView->Picture->Bitmap->Height != 0)
  314. {
  315. BtnSaveImgFile->Enabled = true;
  316. }
  317. }
  318. if (AEdit == 0 || AEdit == 2)
  319. {
  320. PnlCmd->Enabled = true;
  321. GrpList->Enabled = false;
  322. }
  323. else
  324. {
  325. PnlCmd->Enabled = false;
  326. GrpList->Enabled = true;
  327. }
  328. //PnlEdit->Enabled = EditMode;
  329. }
  330. //---------------------------------------------------------------------------
  331. bool __fastcall TVMSM410M::UpdateVmsImage(String ANmbr, String AExpl)
  332. {
  333. String sQry;
  334. TADOQuery *pADO = NULL;
  335. sQry = "UPDATE TB_VMS_SYMB_LIB \r\n"
  336. " SET RGST_DT = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), \r\n"
  337. " SYMB_EXPL = :p02, \r\n"
  338. " IMAG_DATA = :p03 \r\n"
  339. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  340. TMemoryStream *dataStream = new TMemoryStream();
  341. //ImgPreView->Picture->Bitmap->SaveToStream(dataStream);
  342. ImgTemp->Picture->Bitmap->SaveToStream(dataStream);
  343. int nRowHeight = 0;
  344. try
  345. {
  346. try
  347. {
  348. pADO = new TADOQuery(NULL);
  349. pADO->Close();
  350. pADO->Connection = ITSDb_GetConnection();
  351. ITSDb_SQLText(pADO, sQry);
  352. ITSDb_SQLBind(pADO, "p01", ANmbr);
  353. ITSDb_SQLBind(pADO, "p02", AExpl);
  354. pADO->Parameters->ParamByName("p03")->LoadFromStream(dataStream, ftBlob);
  355. pADO->ExecSQL();
  356. if (FImageUpdate)
  357. {
  358. sQry = "UPDATE TB_VMS_FORM_OBJECT \r\n"
  359. " SET VMS_DSPL_FIGR = :p03 \r\n"
  360. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  361. ITSDb_SQLText(pADO, sQry);
  362. ITSDb_SQLBind(pADO, "p01", ANmbr);
  363. pADO->Parameters->ParamByName("p03")->LoadFromStream(dataStream, ftBlob);
  364. pADO->ExecSQL();
  365. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_14, 0);
  366. VComm_VmsFormUpdate();
  367. }
  368. return true;
  369. }
  370. catch(EDatabaseError &E)
  371. {
  372. DBERRORMSG("VMS이미지정보업데이트", String(E.ClassName()), E.Message, sQry);
  373. throw Exception(String(E.ClassName()) + E.Message);
  374. }
  375. catch(Exception &e)
  376. {
  377. DBERRORMSG("VMS이미지정보업데이트", String(e.ClassName()), e.Message, sQry);
  378. throw Exception(String(e.ClassName()) + e.Message);
  379. }
  380. }
  381. __finally
  382. {
  383. if (pADO)
  384. {
  385. pADO->Close();
  386. delete pADO;
  387. }
  388. if (dataStream) delete dataStream;
  389. dataStream = NULL;
  390. }
  391. return true;
  392. }
  393. //---------------------------------------------------------------------------
  394. bool __fastcall TVMSM410M::InsertVmsImage(String ANmbr, String AExpl, String ATypeCd)
  395. {
  396. String sQry;
  397. TADOQuery *pADO = NULL;
  398. sQry = "INSERT INTO TB_VMS_SYMB_LIB(SYMBLIB_NMBR, RGST_DT, SYMB_EXPL, IMAG_DATA, VMS_TYPE_CD) \r\n"
  399. " VALUES(:p01, :p02, :p03, :p04, :p05) \r\n";
  400. int nRowHeight = 0;
  401. TMemoryStream *dataStream = new TMemoryStream();
  402. //ImgPreView->Picture->Bitmap->SaveToStream(dataStream);
  403. ImgTemp->Picture->Bitmap->SaveToStream(dataStream);
  404. try
  405. {
  406. try
  407. {
  408. pADO = new TADOQuery(NULL);
  409. pADO->Close();
  410. pADO->Connection = ITSDb_GetConnection();
  411. ITSDb_SQLText(pADO, sQry);
  412. ITSDb_SQLBind(pADO, "p01", ANmbr);
  413. ITSDb_SQLBind(pADO, "p02", Now().FormatString("yyyymmddhhnnss"));
  414. ITSDb_SQLBind(pADO, "p03", AExpl);
  415. pADO->Parameters->ParamByName("p04")->LoadFromStream(dataStream, ftBlob);
  416. ITSDb_SQLBind(pADO, "p05", ATypeCd);
  417. pADO->ExecSQL();
  418. return true;
  419. }
  420. catch(EDatabaseError &E)
  421. {
  422. DBERRORMSG("VMS이미지정보업데이트", String(E.ClassName()), E.Message, sQry);
  423. throw Exception(String(E.ClassName()) + E.Message);
  424. }
  425. catch(Exception &e)
  426. {
  427. DBERRORMSG("VMS이미지정보업데이트", String(e.ClassName()), e.Message, sQry);
  428. throw Exception(String(e.ClassName()) + e.Message);
  429. }
  430. }
  431. __finally
  432. {
  433. if (pADO)
  434. {
  435. pADO->Close();
  436. delete pADO;
  437. }
  438. if (dataStream) delete dataStream;
  439. dataStream = NULL;
  440. }
  441. return true;
  442. }
  443. //---------------------------------------------------------------------------
  444. void __fastcall TVMSM410M::BtnSaveClick(TObject *Sender)
  445. {
  446. if (EdNmbr->Text.IsEmpty())
  447. {
  448. Application->MessageBox(L"VMS 이미지정보 저장\r\n이미지 번호를 입력하세요.",
  449. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  450. return;
  451. }
  452. if (EdExpl->Text.Trim().IsEmpty())
  453. {
  454. Application->MessageBox(L"VMS 이미지정보 저장\r\n이미지 설명을 입력하세요.",
  455. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  456. return;
  457. }
  458. String sNmbr = EdNmbr->Text;
  459. String sExpl = EdExpl->Text.Trim();
  460. if (TvImageCell->DataController->RecordCount == 0)
  461. {
  462. String sMsg;
  463. sMsg = "VMS이미지번호: " + sNmbr;
  464. sMsg+= "\r\n이미지 셀 정보가 없습니다.\r\n소통정보 배경이미지 정보를 저장하시겠습니까?";
  465. if (Application->MessageBox(sMsg.c_str(), FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  466. }
  467. bool bIfscSet = true;
  468. TcxGridDataController *pGDC = TvImageCell->DataController;
  469. int nRows = pGDC->RecordCount;
  470. for (int ii = 0; ii < nRows; ii++)
  471. {
  472. String sIfscId = VarToStr(pGDC->Values[ii][ColIfscId->Index]);
  473. if (sIfscId == "")
  474. {
  475. bIfscSet = false;
  476. break;
  477. }
  478. }
  479. if (!bIfscSet)
  480. {
  481. String sMsg;
  482. sMsg = "VMS이미지번호: " + sNmbr;
  483. sMsg+= "\r\n이미지 셀 정보에 VMS 정보제공구간이 설정되어 있지 않습니다.\r\n소통정보 배경이미지 정보를 저장하시겠습니까?";
  484. if (Application->MessageBox(sMsg.c_str(), FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  485. }
  486. bool bResult = false;
  487. if (!FNewDb)
  488. {
  489. bResult = UpdateVmsImage(sNmbr, sExpl);
  490. }
  491. else
  492. {
  493. if (EdImageFileName->Text.Trim().IsEmpty())
  494. {
  495. Application->MessageBox(L"VMS 이미지정보 저장\r\n이미지를 선택하셔야 합니다.",
  496. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  497. return;
  498. }
  499. bResult = InsertVmsImage(sNmbr, sExpl, "VMP1");
  500. }
  501. if (!bResult) return;
  502. String ANmbr = sNmbr;
  503. String sQry;
  504. TADOQuery *pADO = NULL;
  505. try
  506. {
  507. try
  508. {
  509. pADO = new TADOQuery(NULL);
  510. pADO->Close();
  511. pADO->Connection = ITSDb_GetConnection();
  512. sQry = "DELETE TB_VMS_SYMB_IFSC \r\n"
  513. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  514. ITSDb_SQLText(pADO, sQry);
  515. ITSDb_SQLBind(pADO, "p01", ANmbr);
  516. pADO->ExecSQL();
  517. sQry = "INSERT INTO TB_VMS_SYMB_IFSC ( \r\n"
  518. " SYMBLIB_NMBR, \r\n"
  519. " CELL_ID, \r\n"
  520. " POSX, \r\n"
  521. " POSY, \r\n"
  522. " VMS_IFSC_ID) \r\n"
  523. " VALUES ( \r\n"
  524. " :p01, \r\n"
  525. " :p02, \r\n"
  526. " :p03, \r\n"
  527. " :p04, \r\n"
  528. " :p05 ) \r\n";
  529. ITSDb_SQLText(pADO, sQry);
  530. ITSDb_GetConnection()->BeginTrans();
  531. TcxGridDataController *pGDC = TvImageCell->DataController;
  532. int nRows = pGDC->RecordCount;
  533. for (int ii = 0; ii < nRows; ii++)
  534. {
  535. String sCellId = VarToStr(pGDC->Values[ii][ColCellId->Index]);
  536. String sPosX = VarToStr(pGDC->Values[ii][ColCellPosX->Index]);
  537. String sPosY = VarToStr(pGDC->Values[ii][ColCellPosY->Index]);
  538. String sIfscId = VarToStr(pGDC->Values[ii][ColIfscId->Index]);
  539. ITSDb_SQLBind(pADO, "p01", ANmbr);
  540. ITSDb_SQLBind(pADO, "p02", sCellId);
  541. ITSDb_SQLBind(pADO, "p03", sPosX);
  542. ITSDb_SQLBind(pADO, "p04", sPosY);
  543. ITSDb_SQLBind(pADO, "p05", sIfscId);
  544. ITSDb_SQLExec(pADO);
  545. }
  546. ITSDb_GetConnection()->CommitTrans();
  547. bResult = true;
  548. }
  549. catch(EDatabaseError &E)
  550. {
  551. ITSDb_GetConnection()->RollbackTrans();
  552. DBERRORMSG("VMS이미지셀정보저장", String(E.ClassName()), E.Message, sQry);
  553. throw Exception(String(E.ClassName()) + E.Message);
  554. }
  555. catch(Exception &e)
  556. {
  557. ITSDb_GetConnection()->RollbackTrans();
  558. DBERRORMSG("VMS이미지셀정보저장", String(e.ClassName()), e.Message, sQry);
  559. throw Exception(String(e.ClassName()) + e.Message);
  560. }
  561. }
  562. __finally
  563. {
  564. if (pADO)
  565. {
  566. pADO->Close();
  567. delete pADO;
  568. }
  569. }
  570. if (bResult)
  571. {
  572. Application->MessageBox(L"VMS 소통정보 배경이미지정보 저장\r\nVMS 소통정보 배경이미지정보를 저장 하였습니다.",
  573. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  574. FUpdate = true;
  575. LoadImageSymbol();
  576. CMM_SetGridRow(CxList, TvList, sNmbr, ColLink1->Index);
  577. DisplayInfo();
  578. VComm_VmsImageTrafficUpdate(); // VMS서버로 이미지가 업데이트 되었음을 알린다.
  579. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_14, 0);
  580. }
  581. }
  582. //---------------------------------------------------------------------------
  583. void __fastcall TVMSM410M::BtnInsertClick(TObject *Sender)
  584. {
  585. FormInit();
  586. //신규아이디를 얻어와서 화면을 초기화한다.
  587. int nNmbr;
  588. if (!GetNextVmsImgeId(nNmbr))
  589. {
  590. Application->MessageBox(L"새로운 VMS 이미지정보를 생성하지 못하였습니다.\r\n프로그램 종료후에 다시 시도해 보세요.",
  591. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  592. return;
  593. }
  594. EdNmbr->Text = String(nNmbr);
  595. ChangeEditMode(2);
  596. FNewDb = true;
  597. }
  598. //---------------------------------------------------------------------------
  599. bool __fastcall TVMSM410M::GetNextVmsImgeId(int &ANmbr)
  600. {
  601. String sQry;
  602. TADOQuery *pADO = NULL;
  603. sQry = "SELECT NVL(MAX(SYMBLIB_NMBR), 6999)+1 AS NEWID FROM TB_VMS_SYMB_LIB WHERE SYMBLIB_NMBR BETWEEN 7000 AND 7999 \r\n";
  604. try
  605. {
  606. try
  607. {
  608. pADO = new TADOQuery(NULL);
  609. pADO->Close();
  610. pADO->Connection = ITSDb_GetConnection();
  611. pADO->SQL->Clear();
  612. pADO->SQL->Text = sQry;
  613. pADO->Open();
  614. ANmbr = pADO->FieldByName("NEWID")->AsInteger;
  615. return true;
  616. }
  617. catch(EDatabaseError &E)
  618. {
  619. DBERRORLOG("VMS이미지ID조회", String(E.ClassName()), E.Message, sQry);
  620. throw Exception(String(E.ClassName()) + E.Message);
  621. }
  622. catch(Exception &e)
  623. {
  624. DBERRORLOG("VMS이미지ID조회", String(e.ClassName()), e.Message, sQry);
  625. throw Exception(String(e.ClassName()) + e.Message);
  626. }
  627. }
  628. __finally
  629. {
  630. if (pADO)
  631. {
  632. pADO->Close();
  633. delete pADO;
  634. }
  635. }
  636. return false;
  637. }
  638. //---------------------------------------------------------------------------
  639. bool __fastcall TVMSM410M::CheckImageUse(String ANmbr)
  640. {
  641. String sQry;
  642. TADOQuery *pADO = NULL;
  643. sQry = "SELECT COUNT(1) AS CNT \r\n"
  644. " FROM TB_VMS_FORM_OBJECT \r\n"
  645. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  646. int nRowHeight = 0;
  647. try
  648. {
  649. try
  650. {
  651. pADO = new TADOQuery(NULL);
  652. pADO->Close();
  653. pADO->Connection = ITSDb_GetConnection();
  654. ITSDb_SQLText(pADO, sQry);
  655. ITSDb_SQLBind(pADO, "p01", ANmbr);
  656. ITSDb_SQLOpen(pADO);
  657. if (pADO->FieldByName("CNT")->AsInteger > 0)
  658. {
  659. Application->MessageBox(L"삭제할 이미지가 VMS 폼에서 사용되고 있습니다.\r\n먼저 해당 폼에서 삭제해주시기 바랍니다.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  660. return false;
  661. }
  662. }
  663. catch(EDatabaseError &E)
  664. {
  665. DBERRORMSG("VMS이미지사용정보조회", String(E.ClassName()), E.Message, sQry);
  666. throw Exception(String(E.ClassName()) + E.Message);
  667. }
  668. catch(Exception &e)
  669. {
  670. DBERRORMSG("VMS이미지사용정보조회", String(e.ClassName()), e.Message, sQry);
  671. throw Exception(String(e.ClassName()) + e.Message);
  672. }
  673. }
  674. __finally
  675. {
  676. if (pADO)
  677. {
  678. pADO->Close();
  679. delete pADO;
  680. }
  681. }
  682. return true;
  683. }
  684. //---------------------------------------------------------------------------
  685. bool __fastcall TVMSM410M::DelVmsImage(String ANmbr)
  686. {
  687. String sQry;
  688. TADOQuery *pADO = NULL;
  689. int nRowHeight = 0;
  690. try
  691. {
  692. try
  693. {
  694. pADO = new TADOQuery(NULL);
  695. pADO->Close();
  696. pADO->Connection = ITSDb_GetConnection();
  697. sQry = "DELETE TB_VMS_SYMB_IFSC \r\n"
  698. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  699. ITSDb_SQLText(pADO, sQry);
  700. ITSDb_SQLBind(pADO, "p01", ANmbr);
  701. pADO->ExecSQL();
  702. sQry = "DELETE TB_VMS_SYMB_LIB \r\n"
  703. " WHERE SYMBLIB_NMBR = :p01 \r\n";
  704. ITSDb_SQLText(pADO, sQry);
  705. ITSDb_SQLBind(pADO, "p01", ANmbr);
  706. pADO->ExecSQL();
  707. return true;
  708. }
  709. catch(EDatabaseError &E)
  710. {
  711. DBERRORMSG("VMS이미지정보삭제", String(E.ClassName()), E.Message, sQry);
  712. throw Exception(String(E.ClassName()) + E.Message);
  713. }
  714. catch(Exception &e)
  715. {
  716. DBERRORMSG("VMS이미지정보삭제", String(e.ClassName()), e.Message, sQry);
  717. throw Exception(String(e.ClassName()) + e.Message);
  718. }
  719. }
  720. __finally
  721. {
  722. if (pADO)
  723. {
  724. pADO->Close();
  725. delete pADO;
  726. }
  727. }
  728. return true;
  729. }
  730. //---------------------------------------------------------------------------
  731. void __fastcall TVMSM410M::BtnDeleteClick(TObject *Sender)
  732. {
  733. int nIdx = TvList->DataController->FocusedRecordIndex;
  734. if (nIdx < 0) return;
  735. String sId = EdNmbr->Text;
  736. if (sId.IsEmpty())
  737. {
  738. Application->MessageBox(L"삭제할 VMS 이미지를 목록에서 선택하세요.\r\n목록에서 더블클릭하여 선택합니다.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  739. return;
  740. }
  741. if (!CheckImageUse(sId)) return;
  742. String sMsg;
  743. sMsg = "VMS이미지번호: " + sId;
  744. sMsg+= "\r\n선택하신 VMS 이미지 정보를 삭제하시겠습니까?";
  745. if (Application->MessageBox(sMsg.c_str(), FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  746. if (DelVmsImage(sId))
  747. {
  748. FUpdate = true;
  749. Application->MessageBox(L"VMS 이미지정보삭제\r\nVMS 이미지정보를 삭제 하였습니다.",
  750. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  751. FormInit();
  752. ChangeEditMode(1);
  753. LoadImageSymbol();
  754. VComm_VmsImageTrafficUpdate(); // VMS서버로 이미지가 업데이트 되었음을 알린다.
  755. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_14, 0);
  756. }
  757. }
  758. //---------------------------------------------------------------------------
  759. void __fastcall TVMSM410M::BtnSaveImgFileClick(TObject *Sender)
  760. {
  761. SaveDialog->Title = FTitle;
  762. SaveDialog->InitialDir = ExtractFilePath(Application->ExeName);
  763. SaveDialog->Filter = "Bitmap image Files (*.bmp)|*.bmp";
  764. SaveDialog->FileName = EdNmbr->Text + ".bmp";
  765. if (SaveDialog->Execute())
  766. {
  767. try {
  768. String sFileName = SaveDialog->FileName;
  769. int iRet = sFileName.Pos(".bmp");
  770. if (iRet == 0)
  771. {
  772. sFileName = SaveDialog->FileName + ".bmp";
  773. }
  774. //ImgPreView->Picture->SaveToFile(sFileName);
  775. ImgTemp->Picture->SaveToFile(sFileName);
  776. }
  777. catch (Exception &exception)
  778. {
  779. Application->ShowException(&exception);
  780. }
  781. }
  782. }
  783. //---------------------------------------------------------------------------
  784. void __fastcall TVMSM410M::EdImageFileNameClick(TObject *Sender)
  785. {
  786. OpenBmp->Title = FTitle;
  787. OpenBmp->FileName = "";
  788. OpenBmp->Execute();
  789. }
  790. //---------------------------------------------------------------------------
  791. void __fastcall TVMSM410M::OpenBmpCanClose(TObject *Sender, bool &CanClose)
  792. {
  793. String sFName = OpenBmp->FileName;
  794. sFName = sFName.UpperCase();
  795. String sMsgTitle, sMsgString;
  796. sMsgTitle = "VMS 이미지 선택";
  797. if (sFName.SubString(sFName.Length()-2, 3) != "BMP")
  798. {
  799. sMsgString = "BMP 파일만 적용 가능합니다.";
  800. Application->MessageBox(sMsgString.c_str(), sMsgTitle.c_str(), MB_OK|MB_ICONWARNING|MB_APPLMODAL);
  801. return;
  802. }
  803. try
  804. {
  805. DWORD dwFileSize = ITSUtil_GetFileSize(sFName);
  806. if (dwFileSize <= 0)
  807. {
  808. sMsgString = "이미지 파일을 읽어 오는데 실패하였습니다.";
  809. Application->MessageBox(sMsgString.c_str(), sMsgTitle.c_str(), MB_OK|MB_ICONWARNING|MB_APPLMODAL);
  810. return;
  811. }
  812. if (dwFileSize > (1024 * 32)) // Max 32Kbytes
  813. {
  814. sMsgString = "이미지 파일의 최대 크기는 32KBytes를 넘을 수 없습니다.\r\n이미지 파일의 용량을 줄여 주세요.";
  815. Application->MessageBox(sMsgString.c_str(), sMsgTitle.c_str(), MB_OK|MB_ICONWARNING|MB_APPLMODAL);
  816. return;
  817. }
  818. //EdImageSize->Text = String(dwFileSize);//GetFileSize(sFName));
  819. EdImageFileName->Text = sFName;
  820. ImgPreView->Picture->Bitmap->FreeImage();
  821. ImgPreView->Picture->Bitmap = NULL;
  822. ImgPreView->Picture->Bitmap->LoadFromFile(sFName);
  823. ImgTemp->Picture->Bitmap->FreeImage();
  824. ImgTemp->Picture->Bitmap = NULL;
  825. ImgTemp->Picture->Bitmap->LoadFromFile(sFName);
  826. FImageUpdate = true;
  827. }
  828. catch(...)
  829. {
  830. }
  831. }
  832. //---------------------------------------------------------------------------
  833. void __fastcall TVMSM410M::ClearSymbloList()
  834. {
  835. for(int ii = 0; ii < FListSymb->Count; ii++)
  836. {
  837. Graphics::TBitmap *bitmap = (Graphics::TBitmap *)FListSymb->Items[ii];
  838. delete bitmap;
  839. }
  840. FListSymb->Clear();
  841. }
  842. //---------------------------------------------------------------------------
  843. void __fastcall TVMSM410M::LoadImageSymbol()
  844. {
  845. FormInit();
  846. CMM_ClearGridTableView(TvList);
  847. ClearSymbloList();
  848. String sQry;
  849. TADOQuery *pADO = NULL;
  850. sQry = "SELECT SYMBLIB_NMBR, \r\n"
  851. " IMAG_DATA, \r\n"
  852. " SYMB_EXPL, VMS_TYPE_CD \r\n"
  853. " FROM TB_VMS_SYMB_LIB \r\n"
  854. " WHERE SYMBLIB_NMBR BETWEEN 7000 AND 7999 \r\n"
  855. " ORDER BY SYMBLIB_NMBR \r\n";
  856. int nRowHeight = 0;
  857. try
  858. {
  859. int nRow;
  860. TcxDataController *pGDC = TvList->DataController;
  861. TvList->BeginUpdate();
  862. try
  863. {
  864. pADO = new TADOQuery(NULL);
  865. pADO->Close();
  866. pADO->Connection = ITSDb_GetConnection();
  867. ITSDb_SQLText(pADO, sQry);
  868. ITSDb_SQLOpen(pADO);
  869. for( ; !pADO->Eof; pADO->Next())
  870. {
  871. nRow = pGDC->AppendRecord();
  872. pGDC->Values[nRow][ColLink1->Index] = pADO->FieldByName("SYMBLIB_NMBR")->AsString;
  873. pGDC->Values[nRow][ColLink2->Index] = pADO->FieldByName("IMAG_DATA")->AsVariant;
  874. pGDC->Values[nRow][ColLink3->Index] = pADO->FieldByName("SYMB_EXPL")->AsString;
  875. pGDC->Values[nRow][ColLink4->Index] = pADO->FieldByName("VMS_TYPE_CD")->AsString;
  876. Graphics::TBitmap *bitmap = new Graphics::TBitmap;
  877. bitmap->LoadFromStream(pADO->CreateBlobStream(pADO->FieldByName("IMAG_DATA"), bmRead));
  878. FListSymb->Add(bitmap);
  879. if (bitmap->Height+2 > nRowHeight) nRowHeight = bitmap->Height+3;
  880. }
  881. }
  882. catch(EDatabaseError &E)
  883. {
  884. DBERRORMSG("VMS이미지정보조회", String(E.ClassName()), E.Message, sQry);
  885. throw Exception(String(E.ClassName()) + E.Message);
  886. }
  887. catch(Exception &e)
  888. {
  889. DBERRORMSG("VMS이미지정보조회", String(e.ClassName()), e.Message, sQry);
  890. throw Exception(String(e.ClassName()) + e.Message);
  891. }
  892. }
  893. __finally
  894. {
  895. if (pADO)
  896. {
  897. pADO->Close();
  898. delete pADO;
  899. }
  900. TvList->OptionsView->DataRowHeight = nRowHeight;
  901. TvList->EndUpdate();
  902. }
  903. }
  904. //---------------------------------------------------------------------------
  905. void __fastcall TVMSM410M::LoadVmsIfsc()
  906. {
  907. CMM_ClearGridTableView(TvAxis);
  908. String sQry;
  909. TADOQuery *pADO = NULL;
  910. sQry = "SELECT C.VMS_CTLR_NMBR, C.VMS_CTLR_ID, C.VMS_NM, \r\n"
  911. " A.VMS_IFSC_ID, A.VMS_IFSC_NM, \r\n"
  912. " A.DSPL_STRT_NODE_NM, A.DSPL_END_NODE_NM, \r\n"
  913. " A.AXIS_YN \r\n"
  914. " FROM TB_VMS_IFSC A, \r\n"
  915. " TB_VMS_IFSC_RLTN B, \r\n"
  916. " (SELECT VMS_CTLR_NMBR, \r\n"
  917. " VMS_CTLR_ID, \r\n"
  918. " VMS_NM \r\n"
  919. " FROM TB_VMS_CTLR \r\n"
  920. " WHERE VMS_TYPE_CD = 'VMP1') C \r\n"
  921. " WHERE A.EDTN_CD != 'EDI2' \r\n"
  922. " AND A.VMS_IFSC_ID = B.VMS_IFSC_ID \r\n"
  923. " AND B.VMS_CTLR_NMBR = C.VMS_CTLR_NMBR \r\n";
  924. try
  925. {
  926. int nRow;
  927. TcxDataController *pGDC = TvAxis->DataController;
  928. TvAxis->BeginUpdate();
  929. try
  930. {
  931. pADO = new TADOQuery(NULL);
  932. pADO->Close();
  933. pADO->Connection = ITSDb_GetConnection();
  934. ITSDb_SQLText(pADO, sQry);
  935. ITSDb_SQLOpen(pADO);
  936. for( ; !pADO->Eof; pADO->Next())
  937. {
  938. nRow = pGDC->AppendRecord();
  939. pGDC->Values[nRow][Col00->Index] = pADO->FieldByName("VMS_CTLR_ID")->AsString;
  940. pGDC->Values[nRow][Col01->Index] = pADO->FieldByName("VMS_IFSC_ID")->AsString;
  941. pGDC->Values[nRow][Col02->Index] = pADO->FieldByName("VMS_IFSC_NM")->AsString;
  942. pGDC->Values[nRow][Col03->Index] = pADO->FieldByName("DSPL_STRT_NODE_NM")->AsString;
  943. pGDC->Values[nRow][Col04->Index] = pADO->FieldByName("DSPL_END_NODE_NM")->AsString;
  944. pGDC->Values[nRow][Col05->Index] = pADO->FieldByName("AXIS_YN")->AsString;
  945. }
  946. }
  947. catch(EDatabaseError &E)
  948. {
  949. DBERRORMSG("VMS제공구간정보조회", String(E.ClassName()), E.Message, sQry);
  950. throw Exception(String(E.ClassName()) + E.Message);
  951. }
  952. catch(Exception &e)
  953. {
  954. DBERRORMSG("VMS제공구간정보조회", String(e.ClassName()), e.Message, sQry);
  955. throw Exception(String(e.ClassName()) + e.Message);
  956. }
  957. }
  958. __finally
  959. {
  960. if (pADO)
  961. {
  962. pADO->Close();
  963. delete pADO;
  964. }
  965. TvAxis->EndUpdate();
  966. CMM_ExpandCollapseChk(TvAxis, ChkExpand->Checked);
  967. }
  968. }
  969. //---------------------------------------------------------------------------
  970. void __fastcall TVMSM410M::LoadImageSymbolCell(String ANmbr)
  971. {
  972. CMM_ClearGridTableView(TvImageCell);
  973. String sQry;
  974. TADOQuery *pADO = NULL;
  975. sQry = "SELECT A.SYMBLIB_NMBR, \r\n"
  976. " A.CELL_ID, \r\n"
  977. " A.POSX, POSY, \r\n"
  978. " A.VMS_IFSC_ID, \r\n"
  979. " B.VMS_IFSC_NM, \r\n"
  980. " B.DSPL_STRT_NODE_NM, \r\n"
  981. " B.DSPL_END_NODE_NM \r\n"
  982. " FROM TB_VMS_SYMB_IFSC A, \r\n"
  983. " TB_VMS_IFSC B \r\n"
  984. " WHERE A.SYMBLIB_NMBR = :p01 \r\n"
  985. " AND A.VMS_IFSC_ID = B.VMS_IFSC_ID(+) \r\n"
  986. " ORDER BY CELL_ID \r\n";
  987. try
  988. {
  989. int nRow;
  990. TcxDataController *pGDC = TvImageCell->DataController;
  991. TvImageCell->BeginUpdate();
  992. try
  993. {
  994. pADO = new TADOQuery(NULL);
  995. pADO->Close();
  996. pADO->Connection = ITSDb_GetConnection();
  997. ITSDb_SQLText(pADO, sQry);
  998. ITSDb_SQLBind(pADO, "p01", ANmbr);
  999. ITSDb_SQLOpen(pADO);
  1000. for( ; !pADO->Eof; pADO->Next())
  1001. {
  1002. nRow = pGDC->AppendRecord();
  1003. pGDC->Values[nRow][ColCellId->Index] = pADO->FieldByName("CELL_ID")->AsString;
  1004. pGDC->Values[nRow][ColCellPosX->Index] = pADO->FieldByName("POSX")->AsString;
  1005. pGDC->Values[nRow][ColCellPosY->Index] = pADO->FieldByName("POSY")->AsString;
  1006. pGDC->Values[nRow][ColIfscId->Index] = pADO->FieldByName("VMS_IFSC_ID")->AsString;
  1007. pGDC->Values[nRow][ColIfscNm->Index] = pADO->FieldByName("VMS_IFSC_NM")->AsString;
  1008. pGDC->Values[nRow][ColStrNm->Index] = pADO->FieldByName("DSPL_STRT_NODE_NM")->AsString;
  1009. pGDC->Values[nRow][ColEndNm->Index] = pADO->FieldByName("DSPL_END_NODE_NM")->AsString;
  1010. }
  1011. }
  1012. catch(EDatabaseError &E)
  1013. {
  1014. DBERRORMSG("VMS이미지정보조회", String(E.ClassName()), E.Message, sQry);
  1015. throw Exception(String(E.ClassName()) + E.Message);
  1016. }
  1017. catch(Exception &e)
  1018. {
  1019. DBERRORMSG("VMS이미지정보조회", String(e.ClassName()), e.Message, sQry);
  1020. throw Exception(String(e.ClassName()) + e.Message);
  1021. }
  1022. }
  1023. __finally
  1024. {
  1025. if (pADO)
  1026. {
  1027. pADO->Close();
  1028. delete pADO;
  1029. }
  1030. TvImageCell->EndUpdate();
  1031. }
  1032. }
  1033. //---------------------------------------------------------------------------
  1034. void __fastcall TVMSM410M::TvListCellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo,
  1035. TMouseButton AButton, TShiftState AShift,
  1036. bool &AHandled)
  1037. {
  1038. if (!ACellViewInfo) return;
  1039. DisplayInfo();
  1040. }
  1041. //---------------------------------------------------------------------------
  1042. void __fastcall TVMSM410M::ColLink2CustomDrawCell(TcxCustomGridTableView *Sender,
  1043. TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
  1044. bool &ADone)
  1045. {
  1046. #if 0
  1047. int nRow = AViewInfo->GridRecord->RecordIndex;
  1048. if (nRow < 0) return;
  1049. if (nRow >= FListSymb->Count)
  1050. {
  1051. return;
  1052. }
  1053. try
  1054. {
  1055. Graphics::TBitmap *pBmp = (Graphics::TBitmap*)FListSymb->Items[nRow];
  1056. TRect rc;
  1057. TRect rcOrg = AViewInfo->Bounds;
  1058. int nH = ( (rcOrg.Bottom - rcOrg.Top) - pBmp->Height ) / 2;
  1059. rc.Top = rcOrg.Top + nH+1;
  1060. rc.Bottom = rcOrg.Bottom - nH+1;
  1061. rc.Left = rcOrg.Left + 1;
  1062. rc.Right = rc.Left + pBmp->Width;
  1063. ACanvas->Canvas->StretchDraw(rc, pBmp);
  1064. ADone = true;
  1065. }
  1066. catch(Exception &e)
  1067. {
  1068. }
  1069. #endif
  1070. }
  1071. //---------------------------------------------------------------------------
  1072. void __fastcall TVMSM410M::BtnCellDeleteClick(TObject *Sender)
  1073. {
  1074. TcxGridDataController *pGDC = TvImageCell->DataController;
  1075. int nSelIdx = pGDC->FocusedRecordIndex;
  1076. if (nSelIdx < 0) return;
  1077. pGDC->BeginUpdate();
  1078. pGDC->DeleteRecord(nSelIdx);
  1079. pGDC->EndUpdate();
  1080. UpdateCellColor();
  1081. }
  1082. //---------------------------------------------------------------------------
  1083. void __fastcall TVMSM410M::BtnCellApplyClick(TObject *Sender)
  1084. {
  1085. TcxGridDataController *pGDC = TvImageCell->DataController;
  1086. String sCellId;
  1087. String sPosX;
  1088. String sPosY;
  1089. int nCellId = SeCellId->Value;
  1090. int nPosX = SePosX->Value;
  1091. int nPosY = SePosY->Value;
  1092. int nMaxCellId = 0;
  1093. bool bFound = false;
  1094. sCellId = String(nCellId);
  1095. sPosX = String(nPosX);
  1096. sPosY = String(nPosY);
  1097. int nFocusedIndex = 0;
  1098. try
  1099. {
  1100. int nRows = pGDC->RecordCount;
  1101. TvImageCell->BeginUpdate();
  1102. pGDC->BeginUpdate();
  1103. for (int ii = 0; ii < nRows; ii++)
  1104. {
  1105. String sTmpId = pGDC->Values[ii][ColCellId->Index];
  1106. if (sTmpId == sCellId)
  1107. {
  1108. nFocusedIndex = ii;
  1109. bFound = true;
  1110. }
  1111. }
  1112. if (!bFound)
  1113. {
  1114. nFocusedIndex = pGDC->AppendRecord();
  1115. //SeCellId->Value = nRows+1;
  1116. pGDC->Values[nFocusedIndex][ColCellId->Index] = String(nRows+1);
  1117. }
  1118. pGDC->Values[nFocusedIndex][ColCellPosX->Index] = sPosX;
  1119. pGDC->Values[nFocusedIndex][ColCellPosY->Index] = sPosY;
  1120. }
  1121. __finally
  1122. {
  1123. pGDC->EndUpdate();
  1124. TvImageCell->EndUpdate();
  1125. //if (pGDC->RecordCount > 0) pGDC->FocusedRecordIndex = nFocusedIndex;
  1126. SeCellId->Value = pGDC->RecordCount+1;
  1127. }
  1128. UpdateCellColor();
  1129. }
  1130. //---------------------------------------------------------------------------
  1131. void __fastcall TVMSM410M::ImgPreViewMouseDown(TObject *Sender, TMouseButton Button,
  1132. TShiftState Shift, int X, int Y)
  1133. {
  1134. try {
  1135. SePosX->Value = X;
  1136. SePosY->Value = Y;
  1137. UpdateCellColor();
  1138. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[SePosX->Value][SePosY->Value];
  1139. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = clWhite;
  1140. ImgPreView->Picture->Bitmap->Canvas->FloodFill(SePosX->Value, SePosY->Value, FOldColor, fsSurface);
  1141. } catch(...) {}
  1142. }
  1143. //---------------------------------------------------------------------------
  1144. void __fastcall TVMSM410M::ColAreaCustomDrawCell(TcxCustomGridTableView *Sender,
  1145. TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
  1146. bool &ADone)
  1147. {
  1148. int nIdx = AViewInfo->GridRecord->RecordIndex;
  1149. if (nIdx < 0)
  1150. return;
  1151. try
  1152. {
  1153. String sCellId = VarToStr(TvImageCell->DataController->Values[nIdx][ColCellId->Index]);
  1154. nIdx = sCellId.ToIntDef(0);
  1155. ACanvas->Brush->Color = APP_GetDisplayColor(nIdx);
  1156. ACanvas->Font->Color = ACanvas->Brush->Color;
  1157. }
  1158. catch(...)
  1159. {
  1160. }
  1161. }
  1162. //---------------------------------------------------------------------------
  1163. void __fastcall TVMSM410M::TvImageCellFocusedRecordChanged(TcxCustomGridTableView *Sender,
  1164. TcxCustomGridRecord *APrevFocusedRecord, TcxCustomGridRecord *AFocusedRecord,
  1165. bool ANewItemRecordFocusingChanged)
  1166. {
  1167. TcxGridDataController *pGDC = TvImageCell->DataController;
  1168. int nSelIdx = pGDC->FocusedRecordIndex;
  1169. if (nSelIdx < 0) return;
  1170. String sCellId = VarToStr(pGDC->Values[nSelIdx][ColCellId->Index]);
  1171. String sPosX = VarToStr(pGDC->Values[nSelIdx][ColCellPosX->Index]);
  1172. String sPosY = VarToStr(pGDC->Values[nSelIdx][ColCellPosY->Index]);
  1173. SeCellId->Value = sCellId.ToIntDef(0);
  1174. SePosX->Value = sPosX.ToIntDef(0);
  1175. SePosY->Value = sPosY.ToIntDef(0);
  1176. #if 0
  1177. try {
  1178. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[SePosX->Value][SePosY->Value];
  1179. if (FOldColor == clYellow) return;
  1180. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = clYellow;
  1181. ImgPreView->Picture->Bitmap->Canvas->FloodFill(SePosX->Value, SePosY->Value, FOldColor, fsSurface);
  1182. } catch(...) {}
  1183. #endif
  1184. }
  1185. //---------------------------------------------------------------------------
  1186. void __fastcall TVMSM410M::UpdateCellColor()
  1187. {
  1188. ImgPreView->Picture->Bitmap->FreeImage();
  1189. ImgPreView->Picture->Bitmap = NULL;
  1190. ImgPreView->Picture->Bitmap->Assign(ImgTemp->Picture->Bitmap);
  1191. ImgPreView->Width = ImgPreView->Picture->Bitmap->Width;
  1192. ImgPreView->Height = ImgPreView->Picture->Bitmap->Height;
  1193. TcxGridDataController *pGDC = TvImageCell->DataController;
  1194. int nRows = pGDC->RecordCount;
  1195. try
  1196. {
  1197. TvImageCell->BeginUpdate();
  1198. pGDC->BeginUpdate();
  1199. for (int ii = 0; ii < nRows; ii++)
  1200. {
  1201. String sCellId = VarToStr(pGDC->Values[ii][ColCellId->Index]);
  1202. String sPosX = VarToStr(pGDC->Values[ii][ColCellPosX->Index]);
  1203. String sPosY = VarToStr(pGDC->Values[ii][ColCellPosY->Index]);
  1204. int X = sPosX.ToIntDef(0);
  1205. int Y = sPosY.ToIntDef(0);
  1206. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[X][Y];
  1207. int nIdx = sCellId.ToIntDef(0);
  1208. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = APP_GetDisplayColor(nIdx);
  1209. ImgPreView->Picture->Bitmap->Canvas->FloodFill(X, Y, FOldColor, fsSurface);
  1210. }
  1211. }
  1212. __finally
  1213. {
  1214. pGDC->EndUpdate();
  1215. TvImageCell->EndUpdate();
  1216. }
  1217. }
  1218. //---------------------------------------------------------------------------
  1219. void __fastcall TVMSM410M::SeCellIdPropertiesChange(TObject *Sender)
  1220. {
  1221. if (((TcxSpinEdit*)Sender)->Value < ((TcxSpinEdit*)Sender)->Properties->MinValue)
  1222. ((TcxSpinEdit*)Sender)->Value = ((TcxSpinEdit*)Sender)->Properties->MinValue;
  1223. else if(((TcxSpinEdit*)Sender)->Value > ((TcxSpinEdit*)Sender)->Properties->MaxValue &&
  1224. ((TcxSpinEdit*)Sender)->Properties->MaxValue)
  1225. ((TcxSpinEdit*)Sender)->Value = ((TcxSpinEdit*)Sender)->Properties->MaxValue;
  1226. }
  1227. //---------------------------------------------------------------------------
  1228. void __fastcall TVMSM410M::TvListFocusedRecordChanged(TcxCustomGridTableView *Sender,
  1229. TcxCustomGridRecord *APrevFocusedRecord, TcxCustomGridRecord *AFocusedRecord,
  1230. bool ANewItemRecordFocusingChanged)
  1231. {
  1232. if (!AFocusedRecord) return;
  1233. DisplayInfo();
  1234. }
  1235. //---------------------------------------------------------------------------
  1236. void __fastcall TVMSM410M::BtnListAddClick(TObject *Sender)
  1237. {
  1238. int nCellIdx = CMM_GetRecordIndex(TvImageCell);
  1239. if (nCellIdx < 0) return;
  1240. int nIfscIdx = CMM_GetRecordIndex(TvAxis);
  1241. if (nIfscIdx < 0) return;
  1242. TcxGridDataController *pDcCell = TvImageCell->DataController;
  1243. TcxGridDataController *pDcIfsc = TvAxis->DataController;
  1244. pDcCell->Values[nCellIdx][ColIfscId->Index] = pDcIfsc->Values[nIfscIdx][Col01->Index];
  1245. pDcCell->Values[nCellIdx][ColIfscNm->Index] = pDcIfsc->Values[nIfscIdx][Col02->Index];
  1246. pDcCell->Values[nCellIdx][ColStrNm->Index] = pDcIfsc->Values[nIfscIdx][Col03->Index];
  1247. pDcCell->Values[nCellIdx][ColEndNm->Index] = pDcIfsc->Values[nIfscIdx][Col04->Index];
  1248. }
  1249. //---------------------------------------------------------------------------
  1250. void __fastcall TVMSM410M::BtnListDeleteClick(TObject *Sender)
  1251. {
  1252. int nCellIdx = CMM_GetRecordIndex(TvImageCell);
  1253. if (nCellIdx < 0) return;
  1254. TcxGridDataController *pDcCell = TvImageCell->DataController;
  1255. pDcCell->Values[nCellIdx][ColIfscId->Index] = "";
  1256. pDcCell->Values[nCellIdx][ColIfscNm->Index] = "";
  1257. pDcCell->Values[nCellIdx][ColStrNm->Index] = "";
  1258. pDcCell->Values[nCellIdx][ColEndNm->Index] = "";
  1259. }
  1260. //---------------------------------------------------------------------------
  1261. void __fastcall TVMSM410M::ChkExpandClick(TObject *Sender)
  1262. {
  1263. CMM_ExpandCollapseChk(TvAxis, ChkExpand->Checked);
  1264. }
  1265. //---------------------------------------------------------------------------