PRK0050MF.cpp 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #include <jpeg.hpp>
  4. #include "ITSSkinF.h"
  5. #include "ITSUtilF.h"
  6. #include "ITSDbF.h"
  7. #include "AppGlobalF.h"
  8. #include "WindowMsgF.h"
  9. #include "ITSLangTransF.h"
  10. #include "ITS_OPLibF.h"
  11. #pragma hdrstop
  12. #include "PRK0050MF.h"
  13. //---------------------------------------------------------------------------
  14. #pragma package(smart_init)
  15. #pragma link "cxButtons"
  16. #pragma link "cxCalendar"
  17. #pragma link "cxContainer"
  18. #pragma link "cxControls"
  19. #pragma link "cxDropDownEdit"
  20. #pragma link "cxEdit"
  21. #pragma link "cxGraphics"
  22. #pragma link "cxGroupBox"
  23. #pragma link "cxLabel"
  24. #pragma link "cxLookAndFeelPainters"
  25. #pragma link "cxLookAndFeels"
  26. #pragma link "cxMaskEdit"
  27. #pragma link "cxPC"
  28. #pragma link "cxPCdxBarPopupMenu"
  29. #pragma link "cxSpinEdit"
  30. #pragma link "cxSplitter"
  31. #pragma link "cxTextEdit"
  32. #pragma link "cxTimeEdit"
  33. #pragma link "dxSkinBlack"
  34. #pragma link "dxSkinBlue"
  35. #pragma link "dxSkinCaramel"
  36. #pragma link "dxSkinCoffee"
  37. #pragma link "dxSkinDarkRoom"
  38. #pragma link "dxSkinDarkSide"
  39. #pragma link "dxSkinFoggy"
  40. #pragma link "dxSkinGlassOceans"
  41. #pragma link "dxSkiniMaginary"
  42. #pragma link "dxSkinLilian"
  43. #pragma link "dxSkinLiquidSky"
  44. #pragma link "dxSkinLondonLiquidSky"
  45. #pragma link "dxSkinMcSkin"
  46. #pragma link "dxSkinMoneyTwins"
  47. #pragma link "dxSkinOffice2007Black"
  48. #pragma link "dxSkinOffice2007Blue"
  49. #pragma link "dxSkinOffice2007Green"
  50. #pragma link "dxSkinOffice2007Pink"
  51. #pragma link "dxSkinOffice2007Silver"
  52. #pragma link "dxSkinOffice2010Black"
  53. #pragma link "dxSkinOffice2010Blue"
  54. #pragma link "dxSkinOffice2010Silver"
  55. #pragma link "dxSkinsCore"
  56. #pragma link "dxSkinscxPCPainter"
  57. #pragma link "dxSkinSeven"
  58. #pragma link "dxSkinSharp"
  59. #pragma link "dxSkinSilver"
  60. #pragma link "dxSkinStardust"
  61. #pragma link "cxRadioGroup"
  62. #pragma link "cxClasses"
  63. #pragma link "cxCustomData"
  64. #pragma link "cxData"
  65. #pragma link "cxDataStorage"
  66. #pragma link "cxDBData"
  67. #pragma link "cxFilter"
  68. #pragma link "cxGrid"
  69. #pragma link "cxGridCustomTableView"
  70. #pragma link "cxGridCustomView"
  71. #pragma link "cxGridDBTableView"
  72. #pragma link "cxGridLevel"
  73. #pragma link "cxGridTableView"
  74. #pragma link "cxStyles"
  75. #pragma link "cxCheckBox"
  76. #pragma link "cxImage"
  77. #pragma link "cxButtonEdit"
  78. #pragma link "cxBlobEdit"
  79. #pragma resource "*.dfm"
  80. TPRK0050M *PRK0050M = NULL;
  81. //---------------------------------------------------------------------------
  82. __fastcall TPRK0050M::TPRK0050M(TComponent* Owner)
  83. : TForm(Owner)
  84. {
  85. LangTrans->Translate(this, ITSDb_GetConnection());
  86. ITSSkin_Load(this);
  87. CMM_LoadForm(g_sFormsDir, this);
  88. FUpdate= false;
  89. FTitle = Caption;//"VMS 소통정보 배경이미지관리";
  90. FListSymb = new TList;
  91. EditMode = false;
  92. #if 0
  93. TvList->OptionsView->DataRowHeight = 0;
  94. TvList->OptionsView->CellAutoHeight = true;
  95. TvList->OptionsView->Indicator = false;
  96. TvList->OptionsCustomize->ColumnMoving = false;
  97. TvList->OptionsCustomize->ColumnSorting = false;
  98. TvList->Columns[0]->Width = 60;
  99. TvList->Columns[0]->Options->HorzSizing = false;
  100. #endif
  101. //http://docwiki.embarcadero.com/RADStudio/Rio/en/Colors_in_the_VCL
  102. m_Color[ 0] = Graphics::clLime;
  103. m_Color[ 1] = (TColor)RGB(0xFF, 0x00, 0x00);
  104. m_Color[ 2] = (TColor)RGB(0x00, 0x00, 0xFF);
  105. m_Color[ 3] = (TColor)RGB(0xFF, 0x82, 0x00);
  106. m_Color[ 4] = (TColor)RGB(0x94, 0x00, 0xD3);
  107. m_Color[ 5] = Graphics::clPurple;//(TColor)RGB(0x00, 0x00, 0x00);
  108. m_Color[ 6] = (TColor)RGB(0x82, 0x82, 0x82);
  109. m_Color[ 7] = (TColor)RGB(0x1E, 0x90, 0xFF);
  110. m_Color[ 8] = (TColor)RGB(0xB9, 0x06, 0x2F);
  111. m_Color[ 9] = (TColor)RGB(0x8c, 0x00, 0x8c);
  112. m_Color[10] = (TColor)RGB(0xFF, 0x82, 0x00);
  113. m_Color[11] = (TColor)RGB(0x94, 0x00, 0xD3);
  114. m_Color[12] = (TColor)RGB(0xB0, 0xC4, 0xDE);
  115. m_Color[13] = (TColor)RGB(0x00, 0xBF, 0xFF);
  116. m_Color[14] = (TColor)RGB(0x87, 0xCE, 0xEB);
  117. m_Color[15] = (TColor)RGB(0x87, 0xCE, 0xFA);
  118. m_Color[16] = (TColor)RGB(0xAD, 0xD8, 0xE6);
  119. m_Color[17] = (TColor)RGB(0xB0, 0xE0, 0xE6);
  120. m_Color[18] = (TColor)RGB(0xE6, 0xE6, 0xFA);
  121. m_Color[19] = (TColor)RGB(0xF0, 0xF8, 0xFF);
  122. ScrollBox1->Color = Color;
  123. }
  124. //---------------------------------------------------------------------------
  125. TColor TPRK0050M::GetDisplayColor(int ASeq)
  126. {
  127. //return g_DispColor[ASeq % MAX_DISPCOLOR];
  128. return m_Color[ASeq % MAX_PARK_CELL_COLOR];
  129. }
  130. //---------------------------------------------------------------------------
  131. void __fastcall TPRK0050M::CommClose()
  132. {
  133. try
  134. {
  135. CMM_SaveForm(g_sFormsDir, this);
  136. }
  137. catch(...)
  138. {
  139. }
  140. }
  141. //---------------------------------------------------------------------------
  142. void __fastcall TPRK0050M::FormShow(TObject *Sender)
  143. {
  144. Refresh();
  145. LoadPrkPlce();
  146. FormInit();
  147. ChangeEditMode(1);
  148. TmrShow->Enabled = true;
  149. }
  150. //---------------------------------------------------------------------------
  151. void __fastcall TPRK0050M::LoadPrkPlce()
  152. {
  153. CbPrk->Properties->Items->Clear();
  154. FOR_STL(TPrkPlce*, pObj, PrkPlceManager->FLists)
  155. {
  156. if (pObj->DEL_YN != "N") continue;
  157. CbPrk->Properties->Items->AddObject(" [" + pObj->CTLR_NMBR + "] " + pObj->NAME, (TObject*)pObj);
  158. }
  159. CbPrk->ItemIndex = 0;
  160. //LoadPrkFlr();
  161. }
  162. //---------------------------------------------------------------------------
  163. void __fastcall TPRK0050M::CbPrkPropertiesChange(TObject *Sender)
  164. {
  165. LoadPrkFlr();
  166. ChangeEditMode(1);
  167. }
  168. //---------------------------------------------------------------------------
  169. void __fastcall TPRK0050M::LoadPrkFlr()
  170. {
  171. try {
  172. CbFlr->Properties->OnChange = NULL;
  173. CbFlr->Properties->Items->Clear();
  174. FormInit();
  175. TPrkPlce *pObj = (TPrkPlce*)CbPrk->Properties->Items->Objects[CbPrk->ItemIndex];
  176. if (pObj == NULL) {
  177. return;
  178. }
  179. //if (pObj->FDevs.Size() == 0) {
  180. PrkPlceManager->LoadFromDbDev(pObj);
  181. //}
  182. //if (pObj->FFlrs.Size() == 0) {
  183. PrkPlceManager->LoadFromDbFlr(pObj);
  184. PrkPlceManager->LoadFromDbFlrDev(pObj);
  185. //}
  186. FOR_STL(TPrkPlceFlr*, pFlr, pObj->FFlrs)
  187. {
  188. CbFlr->Properties->Items->AddObject(" " + pFlr->FLR_NO + " ", (TObject*)pFlr);
  189. }
  190. CbFlr->ItemIndex = -1;
  191. }
  192. __finally {
  193. CbFlr->Properties->OnChange = CbFlrPropertiesChange;
  194. }
  195. }
  196. //---------------------------------------------------------------------------
  197. void __fastcall TPRK0050M::CbFlrPropertiesChange(TObject *Sender)
  198. {
  199. Application->ProcessMessages();
  200. LoadPrkDetailInfo();
  201. Application->ProcessMessages();
  202. ChangeEditMode(3);
  203. EdFocus->SetFocus();
  204. }
  205. //---------------------------------------------------------------------------
  206. void __fastcall TPRK0050M::LoadPrkDetailInfo()
  207. {
  208. FormInit();
  209. TPrkPlce *pObj = (TPrkPlce*)CbPrk->Properties->Items->Objects[CbPrk->ItemIndex];
  210. if (pObj == NULL) {
  211. return;
  212. }
  213. TPrkPlceFlr *pFlr = (TPrkPlceFlr*)CbFlr->Properties->Items->Objects[CbFlr->ItemIndex];
  214. if (pFlr == NULL) {
  215. return;
  216. }
  217. SeCmprtCo->Value = pFlr->FLR_PRK_CMPRT_CO;
  218. LoadPrkFlrImage(pObj->CTLR_NMBR, pFlr->FLR_NO);
  219. LoadPrkFlrDevInfo();
  220. }
  221. //---------------------------------------------------------------------------
  222. void __fastcall TPRK0050M::FormInit()
  223. {
  224. SeCmprtCo->Value = 1;
  225. EdImageFileName->Text = "";
  226. ImgPreView->Picture->Bitmap->FreeImage();
  227. ImgPreView->Picture->Bitmap = NULL;
  228. ImgTemp->Picture->Bitmap->FreeImage();
  229. ImgTemp->Picture->Bitmap = NULL;
  230. SePosX->Value = 0;
  231. SePosY->Value = 0;
  232. SeDevId->Value = 1;
  233. CMM_ClearGridTableView(TvImageCell);
  234. FNewDb = false;
  235. }
  236. //---------------------------------------------------------------------------
  237. void __fastcall TPRK0050M::TmrShowTimer(TObject *Sender)
  238. {
  239. TmrShow->Enabled = false;
  240. }
  241. //---------------------------------------------------------------------------
  242. void __fastcall TPRK0050M::BtnCloseClick(TObject *Sender)
  243. {
  244. Close();
  245. }
  246. //---------------------------------------------------------------------------
  247. void __fastcall TPRK0050M::FormClose(TObject *Sender, TCloseAction &Action)
  248. {
  249. CommClose();
  250. PRK0050M = NULL;
  251. Action = caFree;
  252. }
  253. //---------------------------------------------------------------------------
  254. bool __fastcall TPRK0050M::UpdatePrkFlrInfo(String APrkNmbr, String AFlrNo)
  255. {
  256. if (!FImageUpdate) {
  257. return true;
  258. }
  259. String sQry;
  260. TADOQuery *pADO = NULL;
  261. TMemoryStream *dataStream = new TMemoryStream();
  262. ImgTemp->Picture->Bitmap->SaveToStream(dataStream);
  263. sQry = "UPDATE TB_PRK_PLCE_FLR \r\n"
  264. " SET FLR_IMAGE_TYPE = :p03 \r\n"
  265. " ,FLR_IMAGE_DATA = :p04 \r\n"
  266. " WHERE PRK_PLCE_NMBR = :p01 \r\n"
  267. " AND FLR_NO = :p02 \r\n";
  268. try
  269. {
  270. try
  271. {
  272. pADO = new TADOQuery(NULL);
  273. pADO->Close();
  274. pADO->Connection = ITSDb_GetConnection();
  275. ITSDb_SQLText(pADO, sQry);
  276. ITSDb_SQLBind(pADO, "p01", APrkNmbr);
  277. ITSDb_SQLBind(pADO, "p02", AFlrNo);
  278. ITSDb_SQLBind(pADO, "p03", FImageExt);
  279. pADO->Parameters->ParamByName("p04")->LoadFromStream(dataStream, ftBlob);
  280. pADO->ExecSQL();
  281. }
  282. catch(EDatabaseError &E)
  283. {
  284. DBERRORMSG("TPRK0050M::UpdatePrkFlrInfo", String(E.ClassName()), E.Message, sQry);
  285. throw Exception(String(E.ClassName()) + E.Message);
  286. }
  287. catch(Exception &e)
  288. {
  289. DBERRORMSG("TPRK0050M::UpdatePrkFlrInfo", String(e.ClassName()), e.Message, sQry);
  290. throw Exception(String(e.ClassName()) + e.Message);
  291. }
  292. }
  293. __finally
  294. {
  295. if (pADO)
  296. {
  297. pADO->Close();
  298. delete pADO;
  299. }
  300. if (dataStream) delete dataStream;
  301. dataStream = NULL;
  302. }
  303. FImageUpdate = false;
  304. return true;
  305. }
  306. //---------------------------------------------------------------------------
  307. void __fastcall TPRK0050M::BtnSaveClick(TObject *Sender)
  308. {
  309. TPrkPlce *pObj = (TPrkPlce*)CbPrk->Properties->Items->Objects[CbPrk->ItemIndex];
  310. if (pObj == NULL) {
  311. return;
  312. }
  313. TPrkPlceFlr *pFlr = (TPrkPlceFlr*)CbFlr->Properties->Items->Objects[CbFlr->ItemIndex];
  314. if (pFlr == NULL) {
  315. return;
  316. }
  317. UpdatePrkFlrInfo(pObj->CTLR_NMBR, pFlr->FLR_NO);
  318. String sQry;
  319. TADOQuery *pADO = NULL;
  320. bool bResult = false;
  321. try
  322. {
  323. try
  324. {
  325. pADO = new TADOQuery(NULL);
  326. pADO->Close();
  327. pADO->Connection = ITSDb_GetConnection();
  328. sQry = "UPDATE TB_PRK_PLCE_FLR_DEV \r\n"
  329. " SET X_POS = :p01 \r\n"
  330. " ,Y_POS = :p02 \r\n"
  331. " WHERE PRK_PLCE_NMBR = :p03 \r\n"
  332. " AND FLR_NO = :p04 \r\n"
  333. " AND DEVICE_ID = :p05 \r\n";
  334. ITSDb_SQLText(pADO, sQry);
  335. ITSDb_GetConnection()->BeginTrans();
  336. TcxGridDataController *pGDC = TvImageCell->DataController;
  337. int nRows = pGDC->RecordCount;
  338. for (int ii = 0; ii < nRows; ii++)
  339. {
  340. String sDevId = VarToStr(pGDC->Values[ii][ColDevId->Index]);
  341. String sPosX = VarToStr(pGDC->Values[ii][ColCellPosX->Index]);
  342. String sPosY = VarToStr(pGDC->Values[ii][ColCellPosY->Index]);
  343. TPrkPlceFlrDev *pDev = pFlr->FFlrDevs.Find(sDevId.ToIntDef(0));
  344. if (pDev != NULL) {
  345. try {
  346. ITSDb_SQLBind(pADO, "p01", sPosX);
  347. ITSDb_SQLBind(pADO, "p02", sPosY);
  348. ITSDb_SQLBind(pADO, "p03", pObj->CTLR_NMBR);
  349. ITSDb_SQLBind(pADO, "p04", pFlr->FLR_NO);
  350. ITSDb_SQLBind(pADO, "p05", sDevId);
  351. ITSDb_SQLExec(pADO);
  352. pDev->X_POS = sPosX.ToIntDef(0);
  353. pDev->Y_POS = sPosY.ToIntDef(0);
  354. }
  355. catch(Exception &e)
  356. {
  357. ITSDb_GetConnection()->RollbackTrans();
  358. DBERRORMSG("TPRK0050M::BtnSaveClick", String(e.ClassName()), e.Message, sQry);
  359. throw Exception(String(e.ClassName()) + e.Message);
  360. }
  361. }
  362. }
  363. ITSDb_GetConnection()->CommitTrans();
  364. bResult = true;
  365. }
  366. catch(EDatabaseError &E)
  367. {
  368. ITSDb_GetConnection()->RollbackTrans();
  369. DBERRORMSG("TPRK0050M::BtnSaveClick", String(E.ClassName()), E.Message, sQry);
  370. throw Exception(String(E.ClassName()) + E.Message);
  371. }
  372. catch(Exception &e)
  373. {
  374. ITSDb_GetConnection()->RollbackTrans();
  375. DBERRORMSG("TPRK0050M::BtnSaveClick", String(e.ClassName()), e.Message, sQry);
  376. throw Exception(String(e.ClassName()) + e.Message);
  377. }
  378. }
  379. __finally
  380. {
  381. if (pADO)
  382. {
  383. pADO->Close();
  384. delete pADO;
  385. }
  386. }
  387. if (bResult)
  388. {
  389. Application->MessageBox(L"주차장 층별 DEVICE 영역정보 저장\r\n주차장 층별 DEVICE 영역정보를 저장 하였습니다.",
  390. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  391. FUpdate = true;
  392. ChangeEditMode(3);
  393. }
  394. }
  395. //---------------------------------------------------------------------------
  396. void __fastcall TPRK0050M::EdImageFileNameClick(TObject *Sender)
  397. {
  398. OpenBmp->Title = FTitle;
  399. OpenBmp->FileName = "";
  400. OpenBmp->Execute();
  401. }
  402. //---------------------------------------------------------------------------
  403. void __fastcall TPRK0050M::OpenBmpCanClose(TObject *Sender, bool &CanClose)
  404. {
  405. String sFName = OpenBmp->FileName;
  406. try
  407. {
  408. ClearImage();
  409. EdImageFileName->Text = sFName;
  410. TMemoryStream *pImgStream = new TMemoryStream();
  411. pImgStream->LoadFromFile(sFName);
  412. if (AssignPrkFlrImage(sFName.SubString(sFName.Length()-2, 3), pImgStream)) {
  413. FImageUpdate = true;
  414. }
  415. }
  416. catch(...)
  417. {
  418. }
  419. }
  420. //---------------------------------------------------------------------------
  421. void __fastcall TPRK0050M::ClearImage() {
  422. try {
  423. ImgPreView->Picture->Bitmap->FreeImage();
  424. ImgPreView->Picture->Bitmap = NULL;
  425. } catch(Exception &e) {}
  426. try {
  427. ImgTemp->Picture->Bitmap->FreeImage();
  428. ImgTemp->Picture->Bitmap = NULL;
  429. } catch(Exception &e) {}
  430. }
  431. //---------------------------------------------------------------------------
  432. bool __fastcall TPRK0050M::AssignPrkFlrImage(String AExt, TMemoryStream *AImgStream)
  433. {
  434. if (AImgStream == NULL || AImgStream->Size <= 32) {
  435. return false;
  436. }
  437. AExt = AExt.UpperCase();
  438. FImageExt = AExt;
  439. try {
  440. try {
  441. if (AExt == "PNG") {
  442. TdxPNGImage *img = new TdxPNGImage;
  443. img->LoadFromStream(AImgStream);
  444. ImgPreView->Picture->Bitmap->Assign(img);
  445. ImgPreView->Picture->Bitmap->PixelFormat = pf24bit;
  446. ImgTemp->Picture->Bitmap->Assign(img);
  447. ImgTemp->Picture->Bitmap->PixelFormat = pf24bit;
  448. SAFE_DELETE(img);
  449. }
  450. else
  451. if (AExt == "JPG" || AExt == "JPEG") {
  452. TJPEGImage *img = new TJPEGImage();
  453. img->LoadFromStream(AImgStream);
  454. ImgPreView->Picture->Bitmap->Assign(img);
  455. ImgPreView->Picture->Bitmap->PixelFormat = pf24bit;
  456. ImgTemp->Picture->Bitmap->Assign(img);
  457. ImgTemp->Picture->Bitmap->PixelFormat = pf24bit;
  458. SAFE_DELETE(img);
  459. }
  460. else
  461. if (AExt == "BMP") {
  462. Graphics::TBitmap *img = new Graphics::TBitmap;
  463. img->LoadFromStream(AImgStream);
  464. ImgPreView->Picture->Bitmap->Assign(img);
  465. ImgTemp->Picture->Bitmap->Assign(img);
  466. SAFE_DELETE(img);
  467. }
  468. else {
  469. return false;
  470. }
  471. } catch(Exception &e) {
  472. return false;
  473. }
  474. } __finally {
  475. SAFE_DELETE(AImgStream);
  476. }
  477. return true;
  478. }
  479. //---------------------------------------------------------------------------
  480. void __fastcall TPRK0050M::LoadPrkFlrDevInfo()
  481. {
  482. CMM_ClearGridTableView(TvImageCell);
  483. TPrkPlceFlr *pFlr = (TPrkPlceFlr*)CbFlr->Properties->Items->Objects[CbFlr->ItemIndex];
  484. if (pFlr == NULL) {
  485. return;
  486. }
  487. try
  488. {
  489. int nRow;
  490. TcxDataController *pGDC = TvImageCell->DataController;
  491. TvImageCell->BeginUpdate();
  492. FOR_STL(TPrkPlceFlrDev*, pDev, pFlr->FFlrDevs)
  493. {
  494. nRow = pGDC->AppendRecord();
  495. pGDC->Values[nRow][ColDevId->Index] = pDev->DEVICE_ID;
  496. pGDC->Values[nRow][ColCellPosX->Index] = pDev->X_POS;
  497. pGDC->Values[nRow][ColCellPosY->Index] = pDev->Y_POS;
  498. }
  499. }
  500. __finally
  501. {
  502. TvImageCell->EndUpdate();
  503. TvImageCell->DataController->GotoFirst();
  504. TvImageCell->DataController->FocusedRecordIndex = 0;
  505. }
  506. }
  507. //---------------------------------------------------------------------------
  508. void __fastcall TPRK0050M::LoadPrkFlrImage(String APrkNmbr, String AFlrNo)
  509. {
  510. String sQry;
  511. TADOQuery *pADO = NULL;
  512. ClearImage();
  513. sQry = "SELECT FLR_NM, \r\n"
  514. " FLR_IMAGE_TYPE, \r\n"
  515. " FLR_IMAGE_DATA \r\n"
  516. " FROM TB_PRK_PLCE_FLR \r\n"
  517. " WHERE PRK_PLCE_NMBR = :p01 \r\n"
  518. " AND FLR_NO = :p02 \r\n";
  519. try
  520. {
  521. try
  522. {
  523. pADO = new TADOQuery(NULL);
  524. pADO->Close();
  525. pADO->Connection = ITSDb_GetConnection();
  526. ITSDb_SQLText(pADO, sQry);
  527. ITSDb_SQLBind(pADO, "p01", APrkNmbr);
  528. ITSDb_SQLBind(pADO, "p02", AFlrNo);
  529. ITSDb_SQLOpen(pADO);
  530. for( ; !pADO->Eof; pADO->Next())
  531. {
  532. String FLR_NM = pADO->FieldByName("FLR_NM")->AsString;
  533. String FLR_IMAGE_TYPE = pADO->FieldByName("FLR_IMAGE_TYPE")->AsString;
  534. //Variant varImage = pADO->FieldByName("FLR_IMAGE_DATA")->AsVariant;
  535. if (FLR_IMAGE_TYPE.Trim() != "") {
  536. TMemoryStream *pImgStream = new TMemoryStream();
  537. pImgStream->LoadFromStream(pADO->CreateBlobStream(pADO->FieldByName("FLR_IMAGE_DATA"), bmRead));
  538. AssignPrkFlrImage(FLR_IMAGE_TYPE, pImgStream);
  539. }
  540. }
  541. }
  542. catch(EDatabaseError &E)
  543. {
  544. DBERRORMSG("TPRK0050M::LoadPrkFlrImage", String(E.ClassName()), E.Message, sQry);
  545. throw Exception(String(E.ClassName()) + E.Message);
  546. }
  547. catch(Exception &e)
  548. {
  549. DBERRORMSG("TPRK0050M::LoadPrkFlrImage", String(e.ClassName()), e.Message, sQry);
  550. throw Exception(String(e.ClassName()) + e.Message);
  551. }
  552. }
  553. __finally
  554. {
  555. if (pADO)
  556. {
  557. pADO->Close();
  558. delete pADO;
  559. }
  560. }
  561. }
  562. //---------------------------------------------------------------------------
  563. void __fastcall TPRK0050M::BtnCellApplyClick(TObject *Sender)
  564. {
  565. TcxGridDataController *pGDC = TvImageCell->DataController;
  566. String sDevId;
  567. String sPosX;
  568. String sPosY;
  569. int nDevId = SeDevId->Value;
  570. int nPosX = SePosX->Value;
  571. int nPosY = SePosY->Value;
  572. if (nPosX == 0 || nPosY == 0) {
  573. return;
  574. }
  575. sDevId = String(nDevId);
  576. sPosX = String(nPosX);
  577. sPosY = String(nPosY);
  578. try
  579. {
  580. int nRows = pGDC->RecordCount;
  581. TvImageCell->BeginUpdate();
  582. pGDC->BeginUpdate();
  583. for (int ii = 0; ii < nRows; ii++)
  584. {
  585. String sTmpId = pGDC->Values[ii][ColDevId->Index];
  586. if (sTmpId == sDevId)
  587. {
  588. pGDC->Values[ii][ColCellPosX->Index] = sPosX;
  589. pGDC->Values[ii][ColCellPosY->Index] = sPosY;
  590. break;
  591. }
  592. }
  593. }
  594. __finally
  595. {
  596. pGDC->EndUpdate();
  597. TvImageCell->EndUpdate();
  598. }
  599. UpdateCellColor();
  600. }
  601. //---------------------------------------------------------------------------
  602. void __fastcall TPRK0050M::ImgPreViewMouseDown(TObject *Sender, TMouseButton Button,
  603. TShiftState Shift, int X, int Y)
  604. {
  605. try {
  606. SePosX->Value = X;
  607. SePosY->Value = Y;
  608. if (ChkAuto->Checked) {
  609. BtnCellApplyClick(NULL);
  610. int nIndex = TvImageCell->DataController->FocusedRecordIndex;
  611. if (nIndex < TvImageCell->DataController->RecordCount-1) {
  612. //TvImageCell->DataController->GotoNext();
  613. TvImageCell->DataController->FocusedRecordIndex = TvImageCell->DataController->FocusedRecordIndex+1;
  614. }
  615. }
  616. else {
  617. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[SePosX->Value][SePosY->Value];
  618. ImgPreView->Picture->Bitmap->Canvas->Brush->Style = bsSolid;
  619. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = clRed;//clWhite;
  620. ImgPreView->Picture->Bitmap->Canvas->FloodFill(SePosX->Value, SePosY->Value, FOldColor, fsSurface);
  621. }
  622. } catch(...) {}
  623. }
  624. //---------------------------------------------------------------------------
  625. void __fastcall TPRK0050M::ColAreaCustomDrawCell(TcxCustomGridTableView *Sender,
  626. TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
  627. bool &ADone)
  628. {
  629. int nIdx = AViewInfo->GridRecord->RecordIndex;
  630. if (nIdx < 0)
  631. return;
  632. try
  633. {
  634. String sDevId = VarToStr(TvImageCell->DataController->Values[nIdx][ColDevId->Index]);
  635. nIdx = sDevId.ToIntDef(0);
  636. ACanvas->Brush->Color = GetDisplayColor(nIdx-1);
  637. ACanvas->Font->Color = ACanvas->Brush->Color;
  638. }
  639. catch(...)
  640. {
  641. }
  642. }
  643. //---------------------------------------------------------------------------
  644. void __fastcall TPRK0050M::TvImageCellFocusedRecordChanged(TcxCustomGridTableView *Sender,
  645. TcxCustomGridRecord *APrevFocusedRecord, TcxCustomGridRecord *AFocusedRecord,
  646. bool ANewItemRecordFocusingChanged)
  647. {
  648. TcxGridDataController *pGDC = TvImageCell->DataController;
  649. int nSelIdx = pGDC->FocusedRecordIndex;
  650. if (nSelIdx < 0) return;
  651. String sDevId = VarToStr(pGDC->Values[nSelIdx][ColDevId->Index]);
  652. String sPosX = VarToStr(pGDC->Values[nSelIdx][ColCellPosX->Index]);
  653. String sPosY = VarToStr(pGDC->Values[nSelIdx][ColCellPosY->Index]);
  654. SeDevId->Value = sDevId.ToIntDef(0);
  655. SePosX->Value = sPosX.ToIntDef(0);
  656. SePosY->Value = sPosY.ToIntDef(0);
  657. UpdateCellColor();
  658. #if 1
  659. try {
  660. if (SePosX->Value != 0 && SePosY->Value != 0) {
  661. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[SePosX->Value][SePosY->Value];
  662. if (FOldColor == clYellow) return;
  663. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = clYellow;
  664. ImgPreView->Picture->Bitmap->Canvas->FloodFill(SePosX->Value, SePosY->Value, FOldColor, fsSurface);
  665. }
  666. } catch(...) {}
  667. #endif
  668. }
  669. //---------------------------------------------------------------------------
  670. void __fastcall TPRK0050M::UpdateCellColor()
  671. {
  672. ImgPreView->Picture->Bitmap->FreeImage();
  673. ImgPreView->Picture->Bitmap = NULL;
  674. ImgPreView->Picture->Bitmap->Assign(ImgTemp->Picture->Bitmap);
  675. ImgPreView->Width = ImgPreView->Picture->Bitmap->Width;
  676. ImgPreView->Height = ImgPreView->Picture->Bitmap->Height;
  677. TcxGridDataController *pGDC = TvImageCell->DataController;
  678. int nRows = pGDC->RecordCount;
  679. try
  680. {
  681. TvImageCell->BeginUpdate();
  682. pGDC->BeginUpdate();
  683. for (int ii = 0; ii < nRows; ii++)
  684. {
  685. String sDevId = VarToStr(pGDC->Values[ii][ColDevId->Index]);
  686. String sPosX = VarToStr(pGDC->Values[ii][ColCellPosX->Index]);
  687. String sPosY = VarToStr(pGDC->Values[ii][ColCellPosY->Index]);
  688. int X = sPosX.ToIntDef(0);
  689. int Y = sPosY.ToIntDef(0);
  690. if (X == 0 || Y == 0) {
  691. continue;
  692. }
  693. TColor FOldColor = ImgPreView->Picture->Bitmap->Canvas->Pixels[X][Y];
  694. int nIdx = sDevId.ToIntDef(0);
  695. ImgPreView->Picture->Bitmap->Canvas->Brush->Style = bsSolid;
  696. ImgPreView->Picture->Bitmap->Canvas->Brush->Color = GetDisplayColor(nIdx-1);
  697. ImgPreView->Picture->Bitmap->Canvas->FloodFill(X, Y, FOldColor, fsSurface);
  698. }
  699. }
  700. __finally
  701. {
  702. pGDC->EndUpdate();
  703. TvImageCell->EndUpdate();
  704. }
  705. }
  706. //---------------------------------------------------------------------------
  707. void __fastcall TPRK0050M::BtnEditClick(TObject *Sender)
  708. {
  709. if (BtnEdit->Caption == FrmLang->lblEdit->Caption)//"편집")
  710. {
  711. ChangeEditMode(0);
  712. FNewDb = false;
  713. }
  714. else
  715. {
  716. ChangeEditMode(1);
  717. }
  718. }
  719. //---------------------------------------------------------------------------
  720. void __fastcall TPRK0050M::BtnSaveImgFileClick(TObject *Sender)
  721. {
  722. SaveDialog->Title = FTitle;
  723. SaveDialog->InitialDir = ExtractFilePath(Application->ExeName);
  724. SaveDialog->Filter = "Bitmap image Files (*.bmp)|*.bmp";
  725. if (SaveDialog->Execute())
  726. {
  727. try {
  728. String sFileName = SaveDialog->FileName;
  729. int iRet = sFileName.Pos(".bmp");
  730. if (iRet == 0)
  731. {
  732. sFileName = SaveDialog->FileName + ".bmp";
  733. }
  734. //ImgPreView->Picture->SaveToFile(sFileName);
  735. ImgTemp->Picture->SaveToFile(sFileName);
  736. }
  737. catch (Exception &exception)
  738. {
  739. Application->ShowException(&exception);
  740. }
  741. }
  742. }
  743. //---------------------------------------------------------------------------
  744. void __fastcall TPRK0050M::ChangeEditMode(int AEdit)
  745. {
  746. //LblWarn->Visible = false;
  747. FImageUpdate = false;
  748. bool bEnabled = false;
  749. switch(AEdit)
  750. {
  751. case 0: //편집버튼클릭
  752. {
  753. BtnEdit->Enabled = true;
  754. BtnInsert->Enabled = false;
  755. BtnDelete->Enabled = false;
  756. BtnSave->Enabled = true;
  757. BtnEdit->Caption = FrmLang->lblCancel->Caption;//"취소";
  758. BtnEdit->Hint = FrmLang->lblCancel->Hint;//데이터 편집 취소";
  759. EditMode = true;
  760. //EdImageFileName->Enabled = false;
  761. EdImageFileName->Enabled = true;
  762. //LblWarn->Visible = true;
  763. }
  764. break;
  765. case 1: //편집[취소]버튼클릭
  766. {
  767. FormInit(); //화면을 모두 지운다.
  768. BtnEdit->Enabled = false;
  769. BtnInsert->Enabled = true;
  770. BtnDelete->Enabled = false;
  771. BtnSave->Enabled = false;
  772. BtnEdit->Caption = FrmLang->lblEdit->Caption;//"편집";
  773. BtnEdit->Hint = FrmLang->lblEdit->Hint;//데이터 편집";
  774. //bEnabled = true;
  775. EditMode = false;
  776. EdImageFileName->Enabled = false;
  777. }
  778. break;
  779. case 2: //추가
  780. {
  781. BtnEdit->Enabled = true;
  782. BtnInsert->Enabled = false;
  783. BtnDelete->Enabled = false;
  784. BtnSave->Enabled = true;
  785. BtnEdit->Caption = FrmLang->lblCancel->Caption;//"취소";
  786. BtnEdit->Hint = FrmLang->lblCancel->Hint;//데이터 편집 취소";
  787. EditMode = true;
  788. EdImageFileName->Enabled = true;
  789. }
  790. break;
  791. case 3: //수정모드
  792. {
  793. BtnEdit->Enabled = true;
  794. BtnInsert->Enabled = true;
  795. BtnDelete->Enabled = true;
  796. BtnSave->Enabled = false;
  797. BtnEdit->Caption = FrmLang->lblEdit->Caption;//"편집";
  798. BtnEdit->Hint = FrmLang->lblEdit->Hint;//데이터 편집";
  799. bEnabled = true;
  800. EditMode = false;
  801. //EdImageFileName->Enabled = false;
  802. EdImageFileName->Enabled = true;
  803. }
  804. break;
  805. }
  806. BtnSaveImgFile->Enabled = false;
  807. if (ImgPreView->Picture->Bitmap != NULL)
  808. {
  809. if (ImgPreView->Picture->Bitmap->Height != 0)
  810. {
  811. //BtnSaveImgFile->Enabled = true;
  812. }
  813. }
  814. if (AEdit == 0 || AEdit == 2)
  815. {
  816. PnlCmd->Enabled = true;
  817. PnlHead->Enabled = false;
  818. }
  819. else
  820. {
  821. PnlCmd->Enabled = false;
  822. PnlHead->Enabled = true;
  823. }
  824. }
  825. //---------------------------------------------------------------------------