ã¯ã©ã€ã¢ã³ãã¯ããŒã¿ããŒã¹ãšå¯Ÿè©±ããŸãã
ãµã€ããã
ç§ã¯ããã°ã©ã㌠(䞻㫠Delphi + ããŸããŸãª DBMSãæè¿ã§ã¯ ORACLEã+ å°ã PHP) ã§ããããšã«å ããŠãã¢ããŒãã®å£²è²·ãšãã趣å³ããããŸãã ç§ã¯å»ºèšæ®µéã§å€ããå°ãªããä¿¡é Œã§ããéçºæ¥è ããããããäŸ¡æ Œã§ã¢ããŒããè³Œå ¥ããŸãïŒããšãã°ãçŸåšãµã¢ã¬ããã¯ãã®ãããªéçºæ¥è ã§ãããå°äžéãã¯ã©ãœãã«é§ è¿ãã®ã¢ããŒãã売ãã«åºãŠããŸãïŒã家ã®åŒãæž¡ããåŸ ã¡ãŸãïŒå€ãã®å Žåã95幎åŸãå®äŸ¡ãªãªãã¡ãŒã§ãããèµ·ãããŸãïŒãç§ã¯ãããä¿®çãããã®åŸåžå ŽäŸ¡æ Œã®100ãXNUMXïŒ ã§è²©å£²ããŸãã
ããã§ãç§ãïŒä»ã®çãããšåãããã«ïŒRosReestr ã«ã¯ãã©ã³ã¶ã¯ã·ã§ã³æ§ããªããšããåé¡ã«ééããŸããã
ãã¹ãªãŒã¹ãã«ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ãã©ã³ã¶ã¯ã·ã§ã³çæ§è³ªã®æ¬ åŠã®åé¡
ããã°ã©ãã³ã°ã§ã¯ããã©ã³ã¶ã¯ã·ã§ã³ããäžåç£ã§ã¯ã代æ¿æ¡ãšã®ååŒãïŒããã³ãã®äžéšãšããŠã貞é庫å¥çŽãïŒããããç©äºã¯ããå°ãè€éã§ãã ç§ã¯èšã£ãŠããŸãã
Vasyaã¯Petyaã販売ããŠããã¢ããŒããèŠã«æ¥ãŸããã ãããŠãVasyaã¯äŸ¡æ Œãå«ããŠãã¹ãŠãéåžžã«æ°ã«å
¥ããŸããããVasyaã«ã¯ãéããããŸããã ãããç§ãã¡ã®ç©èªã®å§ãŸãã§ãã
ãŽã¡ã·ã£ã«ã¯èªåã®è²¡ç£ããããããã¯åœŒã«ãšã£ãŠç¹ã«å¿ èŠã§ã¯ãªãããã€ãã®äŸ¡å€èŠ³ãæã£ãŠããŸã - ãã¢ããœãã¯é£ã®å®¶ã«äœãã§ããŸããã倩äºã®é«ãã¯1ã¡ãŒãã«ã§ãè¿ãã«ã¯æç©ã®åºå°ãšãµããŽã©ãåžå ŽããããŸããã¢ãšããšã¯ã¹ãã¬ã¹ãŸã§æ©ããŠè¡ããŸããã¢ããŒãã®äžXNUMXã¡ãŒãã«ã«å°äžå®€ããããã¢ããŒãã®äžã«ã¯å€©äœèŠ³æž¬ã«äŸ¿å©ãªå±æ ¹è£éšå±ããããŸãã Vasya ã¯ããããã®æ©èœã«ããã¢ããŒãã®äŸ¡æ Œãäžæããããšãç解ããŠããŸãããããã¯èªåèªèº«ã®ããã§ã¯ãããŸããã ãããŠåœŒã¯ããã£ã¢ã®ã¢ããŒããè³Œå ¥ãã圌ã®ã¢ããŒãã売ãããšã«ããŸããã ããããããã£ã¢ã®ã¢ããŒããè²·ãããã«ããã売ãã ãã§ã¯ãããŸããã äžåç£æ¥è ã®èšèã§ã¯ããããã代æ¿æ¡ãéžæãããããšåŒã³ãŸãã
次ã«ããã®ç¶æ³ã Petya ã®åŽããèŠãŠã¿ãŸãããã å®éã®ãšãããããã£ã¢ãæžäŸ¡ååŽè²»ã«åº§ãããšã«èå³ããªãããšã«ãã®éœåžãŽã¡ãªããŒã«ã®ã¢ããŒããè³Œå ¥ããããã«ã¢ããŒãã売åŽããŠããŸããããŸã ã©ããæ¢ããŠããŸããã äžåç£æ¥è ã®èšèã§ã¯ããããã代æ¿æ¡ã«å¯ŸåŠããããšåŒã³ãŸãã
äžã€åœã®äºäººã®ãšã«ãããã°ããŒã«ãšããšããã¹ã¯ããŽã¡ãªããŒã«åžã«é©åãªïŒããã®åºæºã«ããïŒäžåç£ãææããŠãããã¡ã«ã³ãŒã«ã«ä»ããããã«æŽŸé£ãããŠãããããç·æ¥ã«å£²åŽãããããšã«ãªã£ãŠããã äžåç£æ¥è ã®èšèã§ã¯ãããããç¡æ販売ããšåŒã³ãŸãã
ããã§ããŽã¡ã·ã£ã¯ã¯ã©ã€ã¢ã³ãã®ã»ã¬ã¶ãèŠã€ããŸããã ããŠãããã£ã¢ã¯ãŽã¡ãªããŒã«åžã§èªåã«é©ããéžæè¢ã XNUMX ã€èŠã€ããŸããã ååŒãããã€ããã§ãã 話ãç°¡åã«ããããã«ãååŒã®åå è
ã¯èª°ãäœå®
ããŒã³ãå©çšããŠããããå°æ°æ ªäž»ãããªããšä»®å®ããŸãã ãããã£ãŠã次ã®ã¢ã¯ã·ã§ã³ãå®è¡ãããã¯ãã§ãã
1. ã»ãªã§ãŒã¶ã¯ããã£ã¢ã«ãéãæž¡ããŸãã
2. ãŽã¡ã·ã£ã¯èªåã®ã¢ããŒããã»ãªã§ãŒã¶ã«äžããŸãã
3. ããã£ã¢ã¯èªåã®ã¢ããŒãããŽã¡ã·ã£ã«äžããŸãã
4. ãã°ãã«ãããšããã¹ã®ã©ã¡ããããŽã¡ãªããŒã«ã®ã¢ããŒããããã£ã¢ã«åŒãæž¡ããã»ãªã§ãŒã¶ã®ãéãåãåããŸãã
5. ãã«ã³ãŒã«ãšãã€ããã¹ã¯ã¡ã«ã³ãŒã«ã«ä»ããããã«ã¢ã«ããŒã«ãžè¡ãã
次ã®ã¹ã¯ãªããã Rosreestr ã«è»¢éããŠå®è¡ããã®ãçæ³çã§ãã
ååŒãéå§ãã
ãŽã¡ã·ã£ã®ã¢ããŒããã»ãªã§ãŒã¶ã«æž¡ãã
ããã£ã®ã¢ããŒãããŽã¡ã·ã£ã«æž¡ãã
å§ãŸã
ãã«ã³ã®ã¢ããŒããããã£ã¢ã«æž¡ã
ã»ãªã§ãŒã¶ã®ãéããã«ã³ã«æž¡ã
IF_ãšã©ãŒ:
ããšããã¹ã®ã¢ããŒããããã£ã¢ã«æž¡ã
ã»ãªã§ãŒã¶ã®ãéãããšããã¹ã«æž¡ã
end
ãã©ã³ã¶ã¯ã·ã§ã³ã®ã³ããã
ããã¯ããã¹ãŠã®ã¢ããŒãã¡ã³ãã« XNUMX 人ã®æ人 (ããã³æèœãª) ææè ãããããšãäŸ¡æ Œãçããããšãããã³äžåç£æ¥è (ååšããå Žå) ãååŒã®æ®µéã«é¢ä¿ãªãæ¯æãããããšãåæãšããã代æ¿æ¡ãåããç°¡ç¥åãããååŒã¹ã¯ãªããã§ãã
ãã ããRosreestr ã¯ãã©ã³ã¶ã¯ã·ã§ã³æ§ããµããŒãããŠããŸããã ãã¹ãŠã®ã¢ã¯ã·ã§ã³ã¯ããããããå®äºããŠããªãå Žåã«ãã©ã³ã¶ã¯ã·ã§ã³å šäœãããŒã«ããã¯ããããšãªããé çªã«ç¬ç«ããŠå®è¡ãããŸãã Rosreestr ãš MFC ãçŸéã®ééã«å¯Ÿå¿ããŠããªãããšãèæ ®ãããšãéæã§ããæ倧éã®ããšã¯ãVasyaãPetyaãSerezha ãã¢ã¯ã»ã¹ã§ããæ¡ä»¶ä»ãã§éè¡ã®ã»ã«ã«ãéãå ¥ããããšã§ã (ååŒãç»é²ãããŠããªãå Žå)ãŸã£ãã)ãããã³ãã®ä»ã®é¢ä¿è ã¯ãRosreestr ã«ãã£ãŠç»é²ãããå¥çŽæžã®æ瀺ã«å¿ããŠã ïŒã¡ãªã¿ã«ãéè¡ã¯å¥çŽæžã®çæ£æ§ãç¬èªã«æ€èšŒããããšã¯ãããŸãããã€ãŸããååŒã®åå è ã®æžé¡ã®çæ£æ§ãä¿¡é ŒããŠããŸãïŒã
ååŒãå®å šã«å®äºããªããªã¹ã¯ã«å ããŠãå¥ã®åé¡ã¯ãä»ã®åå è ãå®å šãªç»é²ãåŸ ããã«æ°ããäœå® ã«å ¥å± ã§ããå ŽåïŒå ¬å ±æéã®éæãã®åé¡ã§ãïŒïŒããã®å ŽåãMaglor ãš Maedros ã¯ãããã«ã¡ã«ã³ãŒã«ã«ä»ãã«è¡ããŸãããããŠãããããã°ããŒã«ã¯ã·ã«ããªã«ãæã«æã€ããšãã§ããªãã§ãããã圌ã«ã¯åã«æéããªãã§ãããã äžåç£ååŒã¯é 次å®è¡ãããåååŒã®åŠçã«ã¯å°ãªããšã 9 å¶æ¥æ¥ããããŸãã
ããã«ããã¹ãªãŒã¹ãã«ã¯ DDU ã«åºã¥ã建èšäžã®äœå® ã®åŠšå®³ãæ¯æããŠããªãããããã¯åçŽãªå ç©ã«é¢é£ããåæ©çãªè¡çºã§ããããæ¯æããå¯èœæ§ãããã
ããã§ã¯ãDBMS ã®æ¬ ç¹ãšç§ã®æ¬²ãããã®ãªã¹ãã«ç§»ããŸãããã
1) XNUMX ã€ç®ã¯ãããŒãžã§ã³ç®¡çã·ã¹ãã ã®æ¬ åŠã§ãã Delphi åŽããèŠããšãç§ã¯ãµã³ãããã¯ã¹ã§éçºããŠãããç§ãè¡ã£ãå€æŽã¯ã³ãããããããŸã§ä»ã®ããã°ã©ããŒã«ã¯è¡šç€ºãããŸããããDBMS ã§ã¯ããã§ã¯ãããŸããã ãããŠãããšãç§ãæŠéããŒã¿ããŒã¹ãžã® (å°ãªããšãç§ã«å²ãåœãŠãããã¿ã¹ã¯ã®æ çµã¿å ã§) å®å šãªã¢ã¯ã»ã¹æš©ãæã£ãŠãããšä¿¡é ŒãããŠããŠããããèµ·ãã£ããšããŠããç§ã¯ããã䜿ã£ãŠéçºããããšã¯ã§ããŸããã ãããã°äžã«ãã¹ãŠã厩ããŠããŸããŸãã ãã®ç³åšæ代ãšã¯äœã§ããããïŒ éçºè åãã®ãµã³ãããã¯ã¹ãäœæããŸãã
2) XNUMX ã€ç®ã¯ãçŸå®äžçãèšè¿°ããæšæºåãããããŒãã«ãäºåã«ã€ã³ã¹ããŒã«ãããŠããªãããšã§ãã ç§ãåããããšã®ãããã¹ãŠã®äŒç€Ÿã«ã¯ãXNUMX ãæã®åå (ãã·ã¢èªãš (å°ãªããšã) è±èªããã·ã¢èªã®å Žåã¯ç°ãªã) ã説æããç¬èªã®è¡šåœ¢åŒããããŸãã
3) 第äžã«ãããã§ã¯ Oracle ã®çšèªã䜿çšããŸããReturning ã䜿çšããåçŽãª Insert ãŸã㯠Update ã¹ã¯ãªãããåŒã³åºãæ¹æ³ (Select ãåŒã³åºãæ¹æ³) ã¯ãããŸããã ãããããããã㯠Oracle ã®åé¡ã§ã¯ãªããDelphi + Oracle ã€ã³ã¿ãŒãã§ã€ã¹ã®åé¡ã§ãã
4) XNUMX çªç®ã«ãäœæããããã·ãŒãžã£ãé¢æ°ã«æš©éãå²ãåœãŠãããªãå Žåã«ãæš©éãå²ãåœãŠãå¿
èŠããããŸãã ããã·ãŒãžã£ãæ©èœã«å¯ŸãããŠãŒã¶ãŒã®æš©éãèšå®ããããå€æŽãããããããããŸããã Grants ãæ瀺çã«èšè¿°ããªãã£ãå Žåããªãã·ã¹ãã èªäœãé¢ä¿ãããªããžã§ã¯ãã調ã¹ããªããžã§ã¯ããæäœããæš©å©ã«åŸã£ãŠãç¹å®ã®ãŠãŒã¶ãŒã«é¢æ°ãåŒã³åºãæš©å©ãäžãããäžããªããã決ããããšãã§ããªãã£ãã®ã§ãããã? é¢æ°ãããã·ãŒãžã£ãæžããšãã«ãããã«é¢ããããŒã¯ãŒãã XNUMX ã€æžãæºåãã§ããŠããŸãã ãããã¯ãããã«è¯ãã®ã¯ããŠãŒã¶ãŒã«å®è¡ãéå§ãããã¢ã«ãŽãªãºã ã®åå²ã«ãã£ãŠãŠãŒã¶ãŒãæš©éãæããªããªã¯ãšã¹ãã«èªå°ãããå ŽåããŠãŒã¶ãŒã¯ãã®ãªã¯ãšã¹ãããšã©ãŒã§ç Žæ£ããããšã§ãã
åºæïŒ habr.com