untitled

Transcription

1 1

2 OZ Application Designer User's Guide 2

3 3

4 OZ Application Designer User's Guide 4

5 5

6 OZ Application Designer User's Guide Application 'OZ Application Designer', 'OZ Application Designer' 'OZ Application Designer', OZC, OZS, OZF.. OZ Application Designer OZ Application Designer. OZ Application Designer,,, OZ Application Designer. 6

7 OZ Application Designer Document, Board OZ Application Designer. OZ Application Designer,, OZC, EventHook.,,,. OZ Application Designer. OZ Function Editor OZF, OZ Function Editor, OZF. 7

8 OZ Application Designer User's Guide OZ Style Editor OZS, OZ Style Editor, OZS. OZ Application Designer. 8

9 OZ Application Designer. Manual Getting Started Description.....,,.. 9

10 OZ Application Designer User's Guide 10

11 11

12 OZ Application Designer User's Guide OZ Application Designer. OS Windows NT 4.0, Windows XP, Windows 2000, Windows 2003 JRE 1.3 Windows 95/98/ME Unicode. CPU Pentium 500MHz Main Memory 256MB (512MB ) HDD 100MB XGA (1024 x 768 ) 12

13 OZ Application Designer. Folder File Name Description %OZA_HOME% %OZA_HOME% bin Console.txt dbconfig.xml dbconfig.xsd msado15.dll OZApplicationDesigner.exe OZApplicationFunctionEditor.exe OZApplicationStyleEditor.ex e ozatransparent.dll OZAViewer.exe OZAViewerDll.dll OZAViewerOCX.ocx ozexcel.dll OZForVista.dll OZLabelPtnWiz_vc71.dll OZOptWiz_vc71.dll OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll ScriptDebugger.dll unicows.dll user.cif OZ Application Designer DB ADORecordSet OZ Application Designer OZ Function Edtior OZ Style Editor Board OZ Application Viewer OZ Application Viewer OZ Application Viewer ActiveX United Control Excel Export Windows Vista OZ Report Viewer USL Microsoft Layer of Unicode 13

14 OZ Application Designer User's Guide ad.dll ad_error_msg.xml af.dll af_error_msg.xml as.dll as_error_msg.xml OZ Application Designer ) ad_ko_kr.dll OZ Application Designer ) ad_error_msg_ko_kr.xml Function Editor ) af_ko_kr.dll Function Editor ) af_error_msg_ko_kr.xml Style Editor ) as_ko_kr.dll Style Editor ) as_error_msg_ko_kr.xml %OZA_HOME% bin/res av_error_msg.xml chartres.xml label_pattern.xml MultiLanguageList.xml rm.dll rm_error_msg.xml sd.dll server_error_msg.xml viewer_parameter.xml OZ Application Viewer ) av_error_msg_ko_kr.xml Label ) label_pattern_ko_kr.xml ) rm_ko_kr.dll ) rm_error_msg_ko_kr.xml ex)sd_ko_kr.dll ) server_error_msg_ko_kr.xml OZ Report Viewer ) viewer_parameter_ko_kr.xml %OZA_HOME% assembly.properties 14

15 config %OZA_HOME% doc launch.cfg OZApplicationDesigner.ini OZApplicationDesignerLayo ut.xml OZApplicationFucntionEditor.ini OZApplicationFunctionEdito rlayout.xml OZApplicationStyleEditor.ini OZApplicationStyleEditorLa yout.xml OZOpenHistory.xml OZServerList.xml CFFunc_4.0.xml codehelp_4.0.xml comphelp_4.0.xml OZAPPAPI.ch m OZAPPCHILD.chm OZ Application Designer OZ Application Designer OZ Application Designer Layout OZ Application Fucntion Editor OZ Application Fucntion Editor Layout OZ Application Style Editor OZ Application Style Editor Layout OZ Repository Server OZ Application Designer API OZ Application Designer API ( ) %OZA_HOME% images OZ Application Designer %OZA_HOME% lib crimson.jar dtdparser120.jar jcert.jar jnet.jar jsee.jar jsr173_api.jar stax jar log4j.jar ozsfw40.jar parser.jar xerces.jar XML DTD J2EE (HTTPS/SSL ) JRE 1.3.X /HTTP XML Log XML 15

16 OZ Application Designer User's Guide xalan.jar xercesimpl.jar XML XPath %OZA_HOME% license %OZA_HOME% UniversalDriver xml-apis.jar ozlicense.xml classes12.jar classes12.zip db2java.jar db2java.zip db2jcc.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar ijava.jar jconn2.jar jkjdbc.jar jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar librfc32.dll sapjco.jar sapjcorfc.dll unisqljdbc10.jar unsqljdbc205.zip Oracle 8i, 9i JDBC Driver IBM DB2 JDBC IBM DB2 JDBC Type 8 (DB2 8 ) Infomix JDBC Oracle 7i JDBC Sybase ASE JDBC MSSQL 97 JDBC IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC SAP UniSQL JDBC : 'UniversalDriver' JDBC, RDB JDBC. RDB JDBC. 16

17 OZ Application Designer. [] [OZ XStudio] [OZ Application Designer 4.0] 'OZ Application Designer 4.0'. OZ Application Designer. 17

18 OZ Application Designer User's Guide 18

19 19

20 OZ Application Designer User's Guide,,,, OZ Application Designer. OZ Application Designer,. / Board 20

21 Window / Board Description OZ Application Designer,. OZ Application Designer (pull down),,,,,,,. OZ Application Designer,,,,., ' ',,, ' ', Button, Label, Table ' ', ' ',, ' ', ' ', ActiveX 'ActiveX '. OZ Application Designer, ODI, OZF, OZS. Document, Board, Board,, - ' ', ODI,,, ' ', Invisibles, OZF, OZS, EventHook 'Invisibles ', ''.. '', ''. Board. Board Board,. Document, Board,. 21

22 OZ Application Designer User's Guide OZ Application Designer,.. // //. // New Project. Board. - /Project TitleBar.oza "MainBoard". - "Board1". 22

23 OZ Application Designer (pull down),,,,,,,. (File) [File]. New (Ctrl+N). Board. Open (Ctrl+O). Close. 23

24 OZ Application Designer User's Guide Save (Ctrl+S). OZ Application Designer oza. Save As. Add New Board Board. Remove Board Board. Board Board. Insert New ODI ODI. ODI. Insert New Style OZ Style (OZS). OZS Invisibles. Insert New Function OZ Function (OZF). OZF Invisibles. Preview (Ctrl+P).. : SDM "SDM " SDM. 24

25 - <Shift> <Ctrl + Shift> [Preview] "SDM ". - <Shift> ODI SDM. SDM ODI SDM. - <Ctrl + Shift> ODI SDM. : SDM - "SDM " ODI. - SDM SDM. - SDM ODI FetchUnit DM_PER_DATAMODULE. - SDM SDM SDM ODI. "A.odi B.odi C.odi", SDM "C.sdm B.sdm A.sdm". Start Debug (Ctrl+F5). [Start Debug], ". OZ Application Designer ". Recent Project (OZA). OZA 4. Exit OZ Application Designer. 25

26 OZ Application Designer User's Guide (Edit) [Edit]. Undo (Ctrl+Z). Board [Undo] Board, [Undo] Redo (Ctrl+Y),. Cut (Ctrl+X) Board. Board Board Board, ' '. Copy (Ctrl+C). Board 26

27 Board Board. Paste (Ctrl+V). Delete (Delete). [Undo]. Copy Property. Paste Property.,. Select All (Ctrl+A) Board Board,. Find (Ctrl+F). Board, ODI, OZS, ODI, OZS ' ', ' '. - 27

28 OZ Application Designer User's Guide 'Find What', 'Find Form'. [Find Next]... 'Find From',. (,)., "Type" "Name" "Text" 'Button' [Find Next]. 28

29 . Option Find From Script Match Case Match Whole Word Search Up Show All Include All Groups Description. /...., ODI, OZS.. Set Search Group Control Invisibles Controls, Container Controls, Complex Controls, Drawings Invisibles DataAccesses ODI Styles OZS - [Find Next].. Option Match Whole World Only Match Case Description.. 29

30 OZ Application Designer User's Guide Direction,. Relpace (Ctrl+H). Board, ODI, OZS ' ', ' '. - 'Find What' 'Replace To', 'Find Form'. [Find Next], [Replace] [Replace All]. - [Find Next], [Replace] [Replace All]. Go To (Ctrl+G). 30

31 . [Ok]. Export Script. Import Script. Preview Script. [Preview Script] ' ', ' ',,. ' ' [File] [Edit], [Move To ScriptEditor]. - File 31

32 OZ Application Designer User's Guide Menu Save Script Export Script Import Script Exit Description Edit Menu Undo (Ctrl+Z) Redo (Ctrl+Y) Cut (Ctrl+X) Copy (Ctrl+C) Paste (Ctrl+V) Delete (Del) Select All (Ctrl+A) Description

33 Find (Ctrl+F) Replace (Ctrl+H) Go to.. [Go to Line] [Go to Event]. [Go to] [Go to Line].. [Ok]. [Go to] [Go to Event] ' '. 'Board1' [Go to Event]. 33

34 OZ Application Designer User's Guide ' '., 'Board1' Board, Board 'Button1', 'Button2' Button 'TextBox1', 'TextBox2' TextBox [Go to Event] ' '. 'Button1' 'OnClick', 'Button1' ' '. 34

35 'OnClick' ( ),. 'OnClick' [OK] 'Button1' 'OnClick'. - Menu Move To ScriptEditor Description. [Move To ScriptEditor]. [Move To ScriptEditor] ' '. 35

36 OZ Application Designer User's Guide ' ' ' '. [] ' '. (View) [View],,,. 36

37 Component Explorer Board, Controls, Container Controls, Complex Controls, Drawings,, - OZ Application Designer. Invisible Explorer Invisibles OZFunction, OZStyle, EventHook Invisibles OZ Application Designer. DataInfo Explorer ODI,,, OZ Application Designer. Repository Explorer OZ Application Designer. Property Grid OZ Application Designer. Event Grid OZ Application Designer. Script Editor 37

38 OZ Application Designer User's Guide OZ Application Designer. (Insert) [Insert]. Controls Controls Button

39 Controls. Component Button CheckBox RadioButton ReportButton ComboBox ListBox CheckListBox TreeView ListView TextBox NumericUpDown MaskTextBox RichTextBox Label PictureBox ProgressBar HTML View ActiveX Control Custom Control Description,,, OZ Report Designer Export, [ ] DropDown TextBox Up/Down, Up/Down Bar ActiveX Custom 39

40 OZ Application Designer User's Guide Report Control DateTimePicker MonthCalendar Splitter Horizontal Navigator Vertical Navigator OZ Report Designer Table Table Row, /// Button TextBox Table Table Row, /// Button / VScrollBar Invisibles Invisibles Timer 5. Invisibles. Component Timer Context Menu Main Menu Tooltip Image List Description Context Menu, MainMenu, TreeView 40

41 Container Controls Container Controls Panel 6. Container Controls. Component Panel VBox HBox GroupBox TabControl BoardView Description, TabPanel, Board Complex Controls Complex Controls Table 4. 41

42 OZ Application Designer User's Guide Complex Controls. Component Table Grid CrossTab Chart Description 2 3 Drawings Drawings Line 7. Drawings. 42

43 Component Line ArrowLine Ellipse Rectangle Parallelogram Diamond Triangle Description,, (Layout) [Layout]. Style [Style] 4. [Style]. Menu Bold Description. 43

44 OZ Application Designer User's Guide Italic Underline StrikeOut... Align [Align] 4, 2. [Align]. Menu Lefts Rights Tops Bottoms Description.... Make Size Equal [Make Size Equal] 2, 2. 44

45 [Make Size Equal]. Menu Width Height Description.. [Distribute Spacing Evenly] [Distribute Spacing Evenly] 2, 3. [Distribute Spacing Evenly]. Menu Horizontal Vertical Description.. Order [Order] 4. [Order]. 45

46 OZ Application Designer User's Guide Menu Bring to Front Send to Back Bring Up Send Down Description,.,., '1'., '1'. (Tools) [Tools]. Default Value Editor ' '. Board [Default Value Editor]. 46

47 ' '., Board, Button, Table, TextBox [Default Value Editor] ' '. 47

48 OZ Application Designer User's Guide [Ok].. [Ok], [Apply to create new file]. OZ Application Designer [Restore] [Ok] [Apply to create new file]. Style Editor OZS OZ Style Editor. OZS OZ Style Editor.. Function Editor OZF OZ Function Editor. OZF OZ Function Editor.. 48

49 Customize. - Toolbars. : OZ Application Designer,. - Commands. "Categories" "Commands" &. 49

50 OZ Application Designer User's Guide &. Options,,,, OZ Application Designer,. [Ok] OZ Application Designer [Restore]. - Option General,,. 50

51 Show Tooltip(Component) OZ Application Designer Board. Apply style in design time OZ Style OZS. Docking help OZ Application Designer. When select the component, the ScriptEditor synchronize,. When create a new file or open a file, execute as a new designer OZ Application Designer. Show Tracker. Use Clipboard for Component Copy_Paste OZ Application Designer. Highlight properties which is applied style in property grid (OZS ). OZS. Highlight properties which is different with default values 51

52 OZ Application Designer User's Guide. Layout OZ Application Designer. Save layout when exit OZ Application Designer,,,,,, OZ Application Designer. OZ Application Designer [Reset window layout] [Save current layout]. International Setting. 52

53 Save. Encrypt the file while saving. Verify form when saving.. Document ODI ODIKey, DataSet, Field, ValueField ODI Document Style OZS Document ContextMenu, MainMenu, ToolTip, ImageList ContextMenu, MainMenu, ToolTip, ImageList Document Navigator LinkComponentName Document Server Setting OZ Application Designer. 53

54 OZ Application Designer User's Guide Local Server Type.. - Editor Environment : Script Editor / Preview Script / Calculated Field Editor,,,,. : OZ Application Designer 54

55 ... : [Edit] [Preview Script],. [Edit]. : [Insert New CalculatedField]... Font and Color : Script Editor / Preview Script / Calculated Field Editor,,,,,. (Help) [Help]. 55

56 OZ Application Designer User's Guide Help OZ Application Designer,, General Script,.. Drag & Drop. - (Script Help ) Drag & Drop. 56

57 -.. [Index].. 57

58 OZ Application Designer User's Guide [Search]. [List Topics] [Enter]. [Display]. About OZ Application OZ Application Designer. 58

59 OZ Application Designer,,,,,,, ActiveX. (Standard),. Icon Description,,,,,, OZ Application Designer (Format),,,,. 59

60 OZ Application Designer User's Guide Icon Description,,,,,,,,, (Component) Controls, Invisibles, Container Controls, Complex Controls, Drawings. Icon Description Button, CheckBox, RadioButton, ReportButton ComboBox, ListBox, CheckListBox TreeView, ListView TextBox, NumericUpDown, MaskTextBox, RichText Box Label, Picture, ProgressBar HTMLView, ActiveXControl, CustomControl, Report Control DateTimePicker, MonthCalendar 60

61 Splitter, HorizontalNavigator, VerticalNavigator Timer, ContextMenu, MainMenu, Tooltip, ImageList Panel, VBox, HBox, GroupBox, TabControl, BoardView Table, Grid, CrossTab, Chart Line, ArrowLine, Ellipse, Rectangle, Parallelogram, Diamond, Triangle (Layout),,,. Icon Description,,,,,,,, (View),. 61

62 OZ Application Designer User's Guide Icon Description Invisibles (Repository). Icon Description,,,,,, ActiveX (ActiveX Controls) 62

63 ActiveX. ActiveX OZ Application Designer, ActiveX. ActiveX. ActiveX [Add or remove components]. [Add or remove components] PC ActiveX. ActiveX [Ok] ActiveX OZ 63

64 OZ Application Designer User's Guide Applicaton Designer, ActiveX ActiveX. ActiveX ActiveX, 10 ActiveX. :.,. [Customize]. 64

65 , ODI, Invisibles,,,, Invisibles,.,, -.. Board, Board Button, CheckBox, RadioButton, TextBox, Label, ComboBox. Button1, CheckBox1, RadioButton1, TextBox1, Label1, ComboBox1, Button1 TextBox1 Lable1 Manage Type Auto Manual. : Manage Type None Auto Manual 65

66 OZ Application Designer User's Guide "i"( ).. :,. Document Edit Script Preview Script Show Property Show Event Add New Board Paste Insert Import Component Expand All Collapse All Document,,. Document Document Document, Document. Document, Document. Document Board. Board. Invisible, ODI, OZS, OZF. OZC... 66

67 Board Copy Property Paste Property Open Board Close Board Set As Startup Board Edit TabIndex.., Board. Board. Board Board. Board. 67

68 OZ Application Designer User's Guide Align Order Wizard, 2. OZ Application Designer [] [].. OZ Application Designer [] []... ODI FXData,,,. 68

69 sample.odi FXData. ODI "sample", "Customer", "customer_id", "lname",..., "birthdate", "MemberCard", "Gender". FXData "_OZGlabl_" "Product", "ProductName", "Price", "_OZData_" "Foodmart" "Region","TotalAmout". : FXData OZA (_OZGlobal_) OZA (_OZData_). FXData ". - FXData ".. :,. Document 69

70 OZ Application Designer User's Guide Expand All Collapse All.. Data Accesses Insert New ODI ODI. ODI 70

71 Edit ODI Save As SDM ODI. [Edit ODI] ODI. : [Edit ODI] ODI. ODI SDM. Insert New CalculatedField. _OZGlobal_ Insert New FXDataSet _OZGlobal_. 71

72 OZ Application Designer User's Guide Insert Schema Insert Schema(Prefix) Save to XML _OZGlobal_ ODI, SDM, XML, Framework., ODI, SDM, XML, Framework. _OZGlobal_ ODI, SDM, XML, Framework.. _OZGlobal_ XML. FX DataSet Insert New Detail DataSet Field Setting Insert Data... FX ParameterSet 72

73 Parameter Setting _OZGlobal_. Invisibles Invisibles OZF, OZS, EventHook. Invisibles ContextMenu1, MainMenu1, ToolTip1, ImageList1, Timer1, OZ Style Sample.ozs, OZ Function Main.ozf. EventHook Document,. EventHook. Invisbles. :,. 73

74 OZ Application Designer User's Guide Styles Insert New Style Document. OZS Edit StyleList OZS. [Edit StyleList] OZS. Functions Insert New Function Document. OZF 74

75 Edit Function OZF. [Edit Function] OZF... :,. 75

76 OZ Application Designer User's Guide RepositoryServer Open Repository Close Repository ServerList. OZ Repository Manager User's Guide " ".. Repository New Category Download Check In Check Out Undo Check Out Refresh

77 Delete Rename /. /. Working Folder Upload to Repository New Folder... Set Working Folder. 77

78 OZ Application Designer User's Guide,., Invisibles. ( ). 78

79 , Invisibles OnClick. ( ). 79

80 OZ Application Designer User's Guide,, OZ Application Designer. Board Drag & Drop. ( ) [Tools] [Options] [Reset Window Layout]. 80

81 Board Board Board, Board,. Board Board Board [Close] Board Board. Board, Board Board [Open] Board. Document, Board,... 81

82 OZ Application Designer User's Guide 82

83 83

84 OZ Application Designer User's Guide Document, Board OZ Application Designer. Document Document, ODI, OZF, OZS OZ Application Designer, Document. OZ Application Designer Timer, Context Menu, Main Menu, Tooptip, Image List Invisibles Board Document. Board Board User Interface, Button, TextBox, Table OZ Application Designer OZC OZC Document. OZ Application Designer Controls, Container Controls, Complex Controls, Drawings Board. 84

85 ODI, OZC, OZF, OZS. ODI, OZC, OZF, OZS.. OZ Application Designer OZ Application Designer Repository. Repository OZ Application Designer., OZ Application Designer, C:\Program Files\FORCS\OZ XStudio\OZ Application Designer 4.0. C:\Program Files\FORCS\OZ XStudio\Repository. 'C:\Repository'.. 85

86 OZ Application Designer User's Guide [Set Working Folder]. OZA, ODI OZF ODI OZF. OZA. 86

87 Button Description. " "... 87

88 OZ Application Designer User's Guide Board Board, Board. Board Board Board [Set As Startup Board] Board Board. Document Board Document StartupBoard Board Board. 88

89 Document Board. Document Board Invisibles Document. Board [File] [Add New Board] Document Board. Board Board. 89

90 OZ Application Designer User's Guide Invisibles [Insert] [Invisibles] Document Invisibles. 'Invisibles ' 'Invisibles' Invisibles. 90

91 Board Controls, Container Controls, Complex Controls, Drawings Board. [Insert] Board Drag & Drop. TextBox. TextBox TextBox Board OZ Application Designer Board [Insert] -> [Controls] -> [TextBox] TextBox ( ) TextBox. Board Drag & Drop. 91

92 OZ Application Designer User's Guide ' ' 'Board1' 'TextBox1'. <Shift> Drag & Drop. 92

93 ,.. 'OZ Application Designer',,.. 'FrameLineSize'. OZURL HTTP. : OZURL OZURL, OZ Application. 93

94 OZ Application Designer User's Guide ozp:/// ozp:/// ex) ozp:///main.jpg ex) ozp://images/main.jpg file:/// ex) file://c:/title.gif. 'BackgroundImageAlign'. (. ) Alignment, 'TextAlign', 'CheckAlign' 94

95 .,. - Label TextAlign 'MiddleLeft' () TextAlign = TopLeft () TextAlign = MiddleLeft Anchor,,,, 'Anchor'. Top, Bottom, Left, Right 4,. 'Anchor' Anchor. - Panel Button Anchor 'Top, Left' (Panel ) (Panel ) 95

96 OZ Application Designer User's Guide - Panel Button Anchor 'Bottom, Right' (Panel ) (Panel ) Color -,,, 'TextColor', 'BackColor', 'LineColor'. [Define Custom Colors]. [Add to Custom Colors]. - "ChartColors" "ChartGridLineColors", "RowColors". 96

97 [More Colors] "Colors". Standard Custom. Date MonthCalendar, DateTimePicker 'TodayDate', 'MinDate', 'MaxDate'. 97

98 OZ Application Designer User's Guide. Dock Docking, 'Dock'. Docking [NONE], Docking,,,,. File 'BackgroundImage', 'ImageListUrl'. [OK]. Font,,. 98

99 ,, [OK]. Pattern, 'Pattern'. 'Category' [OK] 'Pattern'. Shortcut, 'Shortcut'. - 99

100 OZ Application Designer User's Guide ' '. 'Ctrl + C' [Ctrl]. 'None' 'Ctrl + ', [C] 'Ctrl + C'. [OK] 'Ctrl + C'. - ' ' [Delete]. Text. 'Multiline' 'True'. TextDirection, 'TextDirection'. 100

101 (LeftToRight, RightToLeft) (TopToBottom, BottomToTop). 'LeftToRight, TopToBottom', [OK]. 'RightToLeft, BottomToTop'. TextStretch, 'TextStretch'.. No Option Description Horizontal CountClockWise Vertical Vertical2 1Byte 101

102 OZ Application Designer User's Guide ClockWise Horizontal2 2Byte 102

103 ,,,,,. Board. Board, - Board Board 'Ctrl' 'Shift'. 103

104 OZ Application Designer User's Guide - 'Ctrl' 'Shift'. Board Board. Drag & Drop. 'SnapToGrid' 'True', 'GridSize'. ( ). 'SnapToGrid' 'True', 'GridSize'. 104

105 Drag. 'SnapToGrid' 'True', 'GridSize'. 'Shift'. 'SnapToGrid' 'True', 'GridSize'. Key Description Shift + Shift + Shift + Shift 'Ctrl + C'. 'Ctrl + X'. 'Ctrl + V' 105

106 OZ Application Designer User's Guide. 'Delete'. 'Ctrl + Z'. 'Ctrl + Y'. [Layout] [Align],,,. - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1' 106

107 . ( ) ( ) - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1'. ( ) ( ) 107

108 OZ Application Designer User's Guide. - ( ). 'Button1'. ( ) ( ) - ( ). 'Button1'. ( ) ( ) [Layout] [Distribute Spacing Evenly],. - ( ).. 108

109 ( ) ( ) - ( ). ( ) ( ) 109

110 OZ Application Designer User's Guide,. Board [Edit Script],,.. 110

111 . "Board1" "btninsertnewrow" "OnClick"...,...,. 111

112 OZ Application Designer User's Guide. :,,, [Tool] [Option]. 112

113 Board [Preview Script]., [Edit] [Preview Script]. [Preview Script] [Edit] [Preview Script]., 113

114 OZ Application Designer User's Guide. GroupBox1 [Preview Script] GroupBox1 GroupBox1 RadioButton1, RadioButton2, RadioButton3. 114

115 [Edit] [Preview Script]. Document, Document 115

116 OZ Application Designer User's Guide [Preview Script] [Edit] [Preview Script]. :,,, [Tool] [Option].. 116

117 . Menu Mone To ScriptEditor Description.. - '//', '//'. 117

118 OZ Application Designer User's Guide - '/*' '*/'. 'Ctrl + K + C', 'Ctrl + K + U'. [Ctrl +K + C] [Ctrl +K + U] 118

119 OZ Application Designer,,,,. 'Ctrl + Space'. OZ Application Designer,,,.,,,, 'Tab'... Icon Description 119

120 OZ Application Designer User's Guide Document Board, '.',. '.'. 120

121 .. Menu Undo(Ctrl+Z) Redo(Ctrl+Y) Cut(Ctrl+X) Copy(Ctrl+C) Paste(Ctrl+V) Delete(Delete) Select All(Ctrl+A) Description

122 OZ Application Designer User's Guide BreakPoint. OZA [File] [Start Debug] (. ) OZ Application,. Auto Watch Out CallStack 122

123 Icon Menu Description Continue Stop Debugging Step Into Step Over Step Out Function Resume BreakPoint Resume Auto Watch Out,..... "Step Over"...., BreakPoint. BreakPoint. BreakPoint, BreakPoint,., BreakPoint. Auto. Auto. Watch. Watch. Out. Out. Trace, Out. 123

124 OZ Application Designer User's Guide CallStack CallStack. CallStack., ( )., ( ), Out. 124

125 .. Step Into.., OZF,. 125

126 OZ Application Designer User's Guide. Auto Auto. Watch Watch. Watch Name. 126

127 <Enter>. Out Out. Out User. 127

128 OZ Application Designer User's Guide _Trace() _TraceLn() Trace Trace, Out User. Out Info, Debug, Error OZ Application,. CallStack CallStack. CallStack.,. 128

129 CallStack ( )., CallStack. BreakPoint OZ Application BreakPoint. BreakPoint <F9> BreakPoint, BrerakPoint <F9> BreakPoint. BreakPoint OZ Application Designer, 129

130 OZ Application Designer User's Guide. BreakPoint, BreakPoint,. BreakPoint. BreakPoint,. : BreakPoint BreakPoint 130

131 Function Resume, BreakPoint Resume ( ). Document "GlobalFunctionOnceInit" "False",., "GlobalFunctionOnceInit" "True", OZF. 131

132 OZ Application Designer User's Guide.,., OZ Application Designer. Document._SetGlobal("", ); //Document Document. _SetGlobal("", ); var myvar = _GetGlobal("");,., 'Document' 'GlobalFunction'. 132

133 function (Argument1, Argument2,... ) { //Script // return ; }. // (Argument1, Argument2,... ); // var result = (Argument1, Argument2,... ); Example. 133

134 OZ Application Designer User's Guide [Change Backcolor] Label. RadioButton. [Change Backcolor].. 134

135 Step 1, Board Label, RadioButton, Button,. Step 2 Label., RGB. 'Document' 'GlobalFunction'. function changebackcolor(compname) { var Comp = _GetCurrentBoard().GetChild(CompName); Comp.BackColor = _GetGlobal("Color"); } 'RadioButton1', RGB '255, 0, 0'. 'RadioButton1' 'OnClick'. _SetGlobal("Color", "255, 0, 0"); 'RadioButton1' 'RadioButton2', ''RadioButton3', 'RadioButton4' 'OnClick',, RGB. RadioButton2 OnClick 135

136 OZ Application Designer User's Guide _SetGlobal("Color", "0, 255, 0"); RadioButton3 OnClick _SetGlobal("Color", "0, 0, 255"); RadioButton4 OnClick _SetGlobal("Color", "0, 0, 0"); 'Button1', Label. 'Button1' 'OnClick'. changebackcolor("label1"); Step 3 [File] [Preview] (. ) 136

137 137

138 OZ Application Designer User's Guide OZ Application Designer,, OZC, EventHook. :,,, "_",.. Button,. Property Button. Property Text FlatStyle Description Button Button Standard : 3 Flat : Example - 3 [OK]. - Board Button. Property Value Property Value Text OK FlatStyle Standard 138

139 - Label. Property Label. Property FrameLineSize WordWrap InternalMargin Description,,,,,, Example - Label. - Board Label. Property Value Property Value Text Hello World FrameLineSiz e 0, 0, 0, 0 WordWrap True InternalMargi n 4, 4, 4, 4 139

140 OZ Application Designer User's Guide - TextBox. Property TextBox. Property BorderStyle ScrollBars Multiline Description Fixed3D : 3 FixedSingle : None : Horizontal :, 'Multiline' 'True' 'WordWrap' 'False'. Vertical : 'Multiline' 'True' 'WordWrap' 'False'. Both :,, 'Multiline' 'True' 'WordWrap' 'False'. None : 140

141 PasswordChar WordWrap, '*' TextBox 'AAA' '***' Example -, TextBox. - Board TextBox. Property Value Property Value ScrollBars Both Multiline True WordWrap False CheckBox. Property CheckBox. 141

142 OZ Application Designer User's Guide Property Checked CheckState Appearance ThreeState Description True :, CheckState 'Checked' False :, CheckState 'Unchecked' CheckBox Checked : Appearance 'Normal', 'Button', Checked 'True' Unchecked : Appearance 'Normal', 'Button', Checked 'False' Indeterminate : Appearance 'Normal', 'Button' CheckBox Normal : Button : CheckState Check, Uncheck, Indeterminate Example - CheckBox Checked, Check, Uncheck CheckBox CheckBox Indeterminate, Check, Uncheck, Indeterminate CheckBox. - Board CheckBox. Property Value Property Value Checked True CheckState Checked ThreeState False - - Board CheckBox. 142

143 Property Value Property Value Checked True CheckState Indeterminate ThreeState True RadioButton. Property RadioButton. Property Description Checked Example - Board RadioButton 2 RadioButton. - Board RadioButton

144 OZ Application Designer User's Guide ComboBox,. ComboBox, ComboBoxItem,. Property ComboBox. Property DropDownStyle AutoSelect SelectedIndex SelectedText Description DropDown DropDown : TextBox DropDownList : ComboBox. DropDownStyle 'DropDown'. 0. DropDownStyle DropDownList Method ComboBox. - AddItem 144

145 ComboBox,. Format object AddItem(string ItemText); ItemText : Example var objitem = ComboBox1.AddItem("a new item label"); - InsertItem ComboBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = ComboBox1.InsertItem(5, "a new item label"); - RemoveItem. Format void RemoveItem(integer ItemIndex); ItemIndex : Example ComboBox1.RemoveItem(5); - GetItemObject ComboBox. Format object GetItemObject(integer ItemIndex); ItemIndex : Example 145

146 OZ Application Designer User's Guide var objitem = ComboBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; Example - ComboBox. - Board ComboBox. Property Value Property Value DropDownSty le DropDown AutoSelect True ComboBox(Name=ComboBox1) 'OnInitialize'. var objitem; objitem = ComboBox1.AddItem("Golden"); objitem.itemvalue = 1; objitem = ComboBox1.AddItem("Silver"); objitem.itemvalue = 2; objitem = ComboBox1.AddItem("Bronze"); objitem.itemvalue = 3; ComboBox1.SelectedIndex = 0; Button 'Text' 'Get ComboBoxItem' Button 'OnClick'. var objitem = ComboBox1.GetItemObject(ComboBox1.SelectedIndex); _MessageBox(objItem.Text + " " + objitem.itemvalue); - ComboBox [Get ComboBoxItem] (Text) (ItemValue). 146

147 ListBox. ListBox, ListBoxItem,. Property ListBox. Property ItemSelectionMode FocusedIndex FocusedText Description One : MultiSimple : MultiExtended : Shift, Ctrl None: Method ListBox. - AddItem ListBox,. 147

148 OZ Application Designer User's Guide Format object AddItem(string ItemText); ItemText : Example var objitem = ListBox1.AddItem("a new item label"); - InsertItem ListBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = ListBox1.InsertItem(5, "a new item label"); - RemoveItem. Format void RemoveItem(integer ItemIndex); ItemIndex : Example ListBox1.RemoveItem(5); - GetItemObject ListBox. Format object GetItemObject(integer ItemIndex); ItemIndex : Example var objitem = ListBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; 148

149 - GetSelectedIndexes ListBox. Format void GetSelectedIndexes(Array SelectedIndexArray); SelectedIndexArray : Example var SelectedIndexs = new Array(); ListBox1.GetSelectedIndexes(SelectedIndexs); Example - ListBox. - Board ListBox. Property Value Property Value ItemSelectio nmode MultiExtended - - ListBox(Name=ListBox1) 'OnInitialize'. ListBox1.AddItem("Golden"); ListBox1.AddItem("Silver"); ListBox1.AddItem("Bronze"); ListBox1.AddItem("Normal"); Button 'Text' 'Get SelectedItem' Button 'OnClick'. var SelectedIndexs = new Array(); ListBox1.GetSelectedIndexes(SelectedIndexs); for(i=0;i<selectedindexs.length;i++) { _MessageBox(ListBox1.GetItemObject(SelectedIndexs[i]).Text) ; } 149

150 OZ Application Designer User's Guide - ListBox Shift, Ctrl [Get SelectedItem] (Text). CheckListBox. CheckListBox, CheckListBoxItem,. Property CheckListBox. Property ItemSelectionMode FocusedIndex FocusedText Description One : MultiSimple : MultiExtended : Shift, Ctrl None: 150

151 Method CheckListBox. - AddItem CheckListBox,. Format object AddItem(string ItemText); ItemText : Example var objitem = CheckListBox1.AddItem("a new item label"); - InsertItem CheckListBox,. Format object InsertItem(integer ItemIndex, string ItemText); ItemIndex : ItemText : Example var objitem = CheckListBox1.InsertItem(5, "a new item label"); - GetItemObject CheckListBox. Format object GetItemObject(integer ItemIndex); ItemIndex : Example var objitem = CheckListBox1.GetItemObject(5); objitem.itemvalue = "CODE0123"; - AddCheck Checked. 151

152 OZ Application Designer User's Guide Format void AddCheck(integer ItemIndex); ItemIndex : Example CheckListBox1.AddCheck(5); - RemoveCheck Unchecked. Format void RemoveCheck(integer ItemIndex); ItemIndex : Example CheckListBox1.RemoveCheck(5); - GetCheckedIndexes CheckListBox Checked. Format void GetCheckedIndexes(Array CheckedIndexArray); CheckedIndexArray : Checked Example var CheckedIndexs = new Array(); CheckListBox1.GetCheckedIndexes(CheckedIndexs); Example - CheckListBox. - Board CheckListBox(Name=CheckListBox1), CheckListBox 'OnInitialize'. 152

153 CheckListBox1.AddItem("Golden"); CheckListBox1.AddItem("Silver"); CheckListBox1.AddItem("Bronze"); CheckListBox1.AddItem("Normal"); Button 'Text' 'Get CheckedItem' Button 'OnClick'. var CheckedIndexs = new Array(); CheckListBox1.GetCheckedIndexes(CheckedIndexs); for(i=0;i<checkedindexs.length;i++) { _MessageBox(CheckListBox1.GetItemObject(CheckedIndexs[i]).T ext); } - CheckListBox [Get CheckedItem] Checked (Text). PictureBox BMP, JPG, GIF. Property PictureBox. 153

154 OZ Application Designer User's Guide Property Image ImageAlign SizeToImage Description PictureBox None : Fit : PictureBox Tile : TopLeft/TopCenter/TopRight : // MiddleLeft/MiddleCenter/MiddleRight : / / BottomLeft/BottomCenter/BottomRight : // PictureBox Example PictureBox. - PictureBox 'Image1.gif'. - Board PictureBox. Property Value Property Value Image ozp:///image1.gif ImageAlign None - 154

155 NumericUpDown TextBox Up/Down, TextBox Up/Down. Property NumericUpDown. Property DecimalPlaces Hexadecimal Increment MaxVal MinVal ThousandsSeparator Value Description 16 Up/Down Example NumericUpDown. 155

156 OZ Application Designer User's Guide -,,, 5. - Board NumericUpDown. Property Value Property Value Increment 1000 MaxVal MinVal ThousandsSe parator True Value MaskTextBox. Property MaskTextBox. Property Description 156

157 CharacterCasing Mask Literal Default PromptChar Normal: Upper: Lower: Method MaskTextBox. - SetEditMask MaskTextBox,,. Format void SetEditMask(string Mask, string Literal, string Default); Mask :. Mask Description #, Space, +, - L?, Space A a & H X,,, Space, Space > ( ) < ( ) Literal : PromptChar Default : Example MaskTextBox1.SetEditMask("####/##/##", " / / ", "2005/01/01"); 157

158 OZ Application Designer User's Guide MaskTextBox1.SetEditMask(">>.##:##", ". : ", "AM.09:00"); MaskTextBox1.SetEditMask("######-#######", " - ", " ") MaskTextBox1.SetEditMask("###)####-####", " ) - ", "010) "); Example MaskTextBox. - '--'. - Board MaskTextBox. Property Value Property Value Mask >>>-####-### Literal - - Default ABC PromptChar _ - 158

159 RichTextBox. RichTextBox,. Property RichTextBox. Property RichEditText Description,, GetSel() GetSelText(). Method RichTextBox. - GetDefCharFormat RichTextBox. Format object GetDefCharFormat(); - GetSelectCharFormat RichTextBox. Format object GetSelectCharFormat([integer StartIndex, integer EndIndex]); StartIndex : EndIndex : - SetDefCharFormat RichTextBox. Format void SetDefCharFormat(object RichCharFormat); 159

160 OZ Application Designer User's Guide - SetSelectCharFormat. Format void SetSelectCharFormat(object RichCharFormat, [integer StartIndex, integer EndIndex]); StartIndex : EndIndex : Example RichTextBox1 RichTextBox2. - RichTextBox1 RichTextBox2. RichTextBox1 RichTextBox1 RichTextBox2. - Board RichTextBox. Board Button, Button 'OnClick'. var SelText = RichTextBox1.GetSelText(); if(seltext == "") { RichTextBox2.RichEditText = RichTextBox1.RichEditText; } else { var Pos = RichTextBox1.GetSel(); var objcharformat = RichTextBox1.GetSelectCharFormat(Pos.x, Pos.x + SelText.length); RichTextBox2.SetDefCharFormat(objCharFormat); } 160

161 - RichTextBox1 "GOOD" [Ok]. TreeView. TreeView, TreeNode,. Property TreeView. Property CheckBoxes ShowPlusMinus ShowRootLines Description TreeNode PlusMinus Method TreeView, TreeNode. - AddRootString (TreeView ) RootNode RootNode. Format object AddRootString(string NodeText, [string NodeID,] [integer ImageIndex,] [integer SelectedImageIndex]); 161

162 OZ Application Designer User's Guide NodeText : RootNode NodeID : RootNode ID ImageIndex : RootNode TreeView ImageList. SelectedImageIndex : RootNode TreeView ImageList Example var objroot1 = TreeView1.AddRootString("Root1", "Node1", 1, 2); var objroot2 = TreeView1.AddRootString("Root2"); - AddNodeString (TreeNode ) Node Node. Node RootNode RootNode. Format object AddNodeString(string NodeText, [string NodeID,] [integer ImageIndex,] [integer SelectedImageIndex]); NodeText : Node NodeID : Node ID ImageIndex : Node TreeView ImageList. SelectedImageIndex : Node TreeView ImageList Example var objroot = TreeView1.AddRootString("Root", "Node1", 1, 2); var objnode = objroot.addnodestring("node"); - ExpandAll (TreeView, TreeNode ) Node. Format void ExpandAll(bool ExpandFlag); 162

163 ExpandFlag : Node Example TreeView1.ExpandAll(true); Example - TreeView. - Board TreeView(Name=TreeView1), TreeView 'OnInitialize'. var objroot; var objnode; objroot = TreeView1.AddRootString("A"); objnode = objroot.addnodestring("a01"); objnode.addnodestring("a01-001"); objnode.addnodestring("a01-002"); objnode = objroot.addnodestring("a02"); objnode.addnodestring("a02-001"); objnode.addnodestring("a02-002"); objroot = TreeView1.AddRootString("B"); objroot.addnodestring("b01"); objroot.addnodestring("b02"); TreeView1.ExpandAll(true); - 163

164 OZ Application Designer User's Guide ListView. ListView (ListViewItem), (ListViewColumnItem), (ListViewSubItem),. Property ListView. Property FullRowSelect AllowColumnReorder HeaderStyle Description Drag & Drop None : Clickable : Method ListView. - AddItem (ListView ). Format object AddItem(string ItemText, [integer ImageListIndex]); ItemText : ImageListIndex : - InsertItem (ListView ). Format object InsertItem(integer ItemIndex, string ItemText, [integer ImageListIndex]); ItemIndex : ItemText : ImageListIndex : 164

165 - InsertColumn (ListView ). Format object InsertColumn(integer ColumnIndex, [string ColumnText], [string ColumnAlignment], [integer ColumnWidth]); ColumnIndex : ColumnText : ColumnAlignment : ColumnWidth : - AddSubItem (ListViewItem ). Format object AddSubItem(string SubItemText); SubItemText : Example - ListView. - Board ListView(Name=ListView1), ListView 'OnInitialize'. var objcolumn; objcolumn = ListView1.InsertColumn(1, "Column1"); objcolumn = ListView1.InsertColumn(2, "Column2"); objcolumn = ListView1.InsertColumn(3, "Column3"); var objitem; objitem = ListView1.AddItem("Item1"); objitem.addsubitem("subitem1"); objitem.addsubitem("subitem2"); for(i=2;i<11;i++) { ListView1.InsertItem(i, "Item" + i); } 165

166 OZ Application Designer User's Guide - ProgressBar Bar. Property ProgressBar. Property BarColor Pos Maximum Minimum Step Text Description ProgressBar Bar Bar Bar Bar ProgressBar Method ProgressBar. - IsFullPos Bar Maximum. Format bool IsFullPos(); 166

167 Example if( ProgressBar1.IsFullPos() ) { return; } - OffsetPos Bar Bar. Format void OffsetPos(OffsetValue); OffsetValue : Example // Bar 50. ProgressBar1.OffsetPos(50); // Bar 20 Bar StepIt Bar Step. Format void StepIt(); Example // ProgressBar if(!progressbar1.isfullpos() ) { ProgressBar1.StepIt(); } Example ProgressBar Bar. - ProgressBar,, ProgressBar. 167

168 OZ Application Designer User's Guide - Board ProgressBar Property Value Property Value TextColor 255, 255, 255 Font Arial, 14pt, Bold TextAlign MiddleCenter Pos 0 Maximum 100 Minimum 0 Step Board Button 'Text' '>>', Button 'OnClick'. if(!progressbar1.isfullpos() ) { ProgressBar1.StepIt(); } else { ProgressBar1.Pos = ProgressBar1.Minimum; } ProgressBar1.Text = ProgressBar1.Pos; - MonthCalendar. Property MonthCalendar. 168

169 Property SelectionStart SelectionEnd MaxSelectionCount ShowToday ShowTodayCircle ShowWeekNumbers TodayDate Description (Week) Example MonthCalendar. - MonthCalendar. - Board MonthCalendar Property Value Property Value ShowWeekNu mbers True - - MonthCalendar MonthCalendar 'OnPostInitialize'. var systime = _GetSystemTime(); var date = systime.getdate(); MonthCalendar1.TodayDate = date; MonthCalendar1.SelectionStart = date; MonthCalendar1.SelectionEnd = date; - 169

170 OZ Application Designer User's Guide DateTimePicker ComboBox MonthCalender,. Property DataTimePicker. Property Format Description Long : Window Long (32Bit Integer) Short : Window Short (16Bit Integer) Time : Window Time Custom : DataTimePicker 'CustomFormat' 'Format' 'Custom' CustomFormat h(12), H(24), m(), s(), t(,), y(), M(), d(), dddd(), 'hh, mm, ss' 0 'h, m, s' 0 ValueDate 170

171 Method DataTimePicker. - GetCurDateTime DateTime. DateTime OZ Application Designer 'General Script' 'DateTime'. Format object GetCurDateTime(); Example var SelectedDateTime = DateTimePicker1.GetCurDateTime(); _MessageBox(SelectedDateTime.GetYear()); // _MessageBox(SelectedDateTime.GetMonth()); // _MessageBox(SelectedDateTime.GetDay()); // _MessageBox(SelectedDateTime.GetHour()); // _MessageBox(SelectedDateTime.GetMinute()); // _MessageBox(SelectedDateTime.GetSecond()); // Example DataTimePicker. - DataTimePicker. - Board DataTimePicker Property Value Property Value Format Custom CustomForma t yyyy'/'mm'/'dd hh':'mm tt dddd - 171

172 OZ Application Designer User's Guide HTML View. Property HTML View. Property URL URL Description Example HTML View. - HTML View. - Board HTML View Property Value Property Value URL /index.asp

173 - Splitter. Example Splitter. - Splitter Docking Panel. - Board Panel Property Value Property Value BackColor 128, 128, 255 Dock Left 173

174 OZ Application Designer User's Guide Board Splitter Property Value Property Value BackColor 128, 128, 128 Cursor HSplit Dock Left - - Board Panel Property Value Property Value BackColor 128, 255, 128 Dock Fill - Splitter.. Horizontal Navigator Table Table Row 174

175 , /// Button TextBox. Property Horizontal Navigator. Property LinkComponentName Description Horizontal Navigato Table Example Horizontal Navigator Table. - Horizontal Navigator Table 10 Row. - 'Foodmart.odi' Board Table Table 'ODIKey' ''Foodmart' 'DataSet' 'ProductSales' Table. Board Table(Name=Table1). Property Value Property Value RowAutosize FixCount RowCount 10 Board Horizontal Navigator Property Value Property Value LinkCompone ntname Table

176 OZ Application Designer User's Guide Vertical Navigator Table Table Row, /// Button / VScrollBar. Property Vertical Navigator. Property LinkComponentName Description Horizontal Navigato Table Example Vertical Navigator Table. - Vertical Navigator Table 10 Row. 176

177 - 'Foodmart.odi' Board Table Table 'ODIKey' ''Foodmart' 'DataSet' 'ProductSales' Table. Board Table(Name=Table1). Property Value Property Value RowAutosize FixCount RowCount 10 Board Vertical Navigator Property Value Property Value LinkCompone ntname Table

178 OZ Application Designer User's Guide ActiveX Control OZ Application Designer. Board ActiveX, 'ActiveXControl'. Method ActiveX Control. - GetOCX ActiveX Control OCX. Format object GetOCX(); Example var objocx = ActiveXControl1.GetOCX(); Example ActiveX Control ActiveX. - ActiveX Control Microsoft Office Spreedsheet. - Board ActiveX Control ActiveX. 178

179 License Key : ActiveX, ClassID ActiveX. ActiveX 'Microsoft Office Spreedsheet 10.0', License Key [Ok]. 179

180 OZ Application Designer User's Guide 'ActiveXControl' 'Microsoft Office Spreedsheet 10.0'. Board Button, Button 'OnClick'. var activex_excel = ActiveXControl1.GetOCX(); activex_excel.cells(1,2).value = "1"; activex_excel.cells(2,2).value = "2"; activex_excel.cells(3,2).value = "3"; activex_excel.cells(4,1).value = "Sum"; activex_excel.cells(4,2).value = "=SUM(B1:B3)"; - 'Microsoft Office Spreedsheet',. 180

181 Custom Control OZ Application Designer., 'CustomDll' pdf417.dll Drawing Dll. Drawing Drawing Dll Custom Control. Custom Control CustomDll 'ozc_', Custom Control CustomDll 'API Developer's Guide'. Custom Control CustomDll OZ Application Designer. Custom Contro 'CustomControl'. Method Custom Control. - GetCustomProperty CustomDll. Format string GetCustomProperty(string PropertyName); - SetCustomProperty CustomDll. Format void SetCustomProperty(string PropertyName, string PropertyValue); Example Custom Control CustomDll. - TIFF. Custom Control TIFF (.tif ), Custom Control. 'ozc_tiff.dll' CustomDll, 'ozc_tiff.dll'. 181

182 OZ Application Designer User's Guide - Board Custom Control(Name=CustomControl1) CustomDll. ozc_tiff.dll [Ok], 'CustomControl'. Board Button, Text 'Select File'. Board CheckBox(Name=CheckBox1), 'Text' 'Fit To Size' Custom Control 182

183 CheckBox 'OnClick'. if(checkbox1.checked == true) { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "true"); } else { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "false"); } [Select File] TIFF Button 'OnClick'. var SelectedFile = _FileDialog(true, "", "", "","TIF Files (*.tif) *.tif"); if(checkbox1.checked == true) { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "true"); } else { CustomControl1.SetCustomProperty("TIFF_FITTOSIZE", "false"); } CustomControl1.Value = SelectedFile; - [Select File] TIFF, 'Fit To Size'. 183

184 OZ Application Designer User's Guide Report Control Report Control OZ Report Designer (.ozr). 'ReportViewerOption' Report Control 'OnPreApplyReport' 'ApplyReport', 'OZ Report Viewer Guide'. Report Control, 'OZ Report Viewer Guide'. Property Property ReportViewerOption Description, Method Report Control. - AddReportParameter Report Control, Parameter. Format void AddReportParameter(string ParameterName, string ParameterValue); ParameterName : ParameterValue : Example // ReportControl1.AddReportParameter("toolbar.all","false"); // ProgressBar ReportControl1.AddReportParameter("print.mode","showprogress"); - InitUserParameter, AddReportParameter(). 184

185 Format void InitUserParameter(); Example ReportControl1.InitUserParameter(); - ApplyReport Report Control 'OnPreApplyReport'. Format bool ApplyReport(bool RecreateReportFlag); RecreateReportFlag :, Parameter User Interface RecreateReportFlag true. Example ReportControl1.ApplyReport(); Example Report Control. - Report Control. - Board Report Control 'OnPreApplyReport'. ReportControl1.InitUserParameter(); ReportControl1.AddReportParameter("connection.servlet", " ReportControl1.AddReportParameter("connection.reportname", "/ozdemo30/kr/a/08note.ozr"); Board Report Control Board 'OnAttached'. ReportControl1.ApplyReport(); 185

186 OZ Application Designer User's Guide - ReportButton ReportButton OZ Report Designer (.ozr) Export. 'ReportViewerOption' Export ReportButtonl 'OnPreApplyReport' 'ApplyReport', 'OZ Report Viewer Guide'. ReportButton, 'OZ Report Viewer Guide'. Property Property ReportViewerOption Description Export, Export 186

187 ReportViewerMode (Print) Export Method ReportButton. - AddReportParameter ReportButton, Parameter. 'OZ Report Viewer Guide'. Format void AddReportParameter(string ParameterName, string ParameterValue); ParameterName : ParameterValue : Example // ProgressBar ReportButton1.AddReportParameter("print.mode","showprogress"); - InitUserParameter, AddReportParameter(). Format void InitUserParameter(); Example ReportButton1.InitUserParameter(); - ApplyReport ReportButton 'OnPreApplyReport'. Format bool ApplyReport(); Example ReportButton1.ApplyReport(); 187

188 OZ Application Designer User's Guide Example ReportButton Export. - ReportButton Export. - Board ReportButton 'Text' 'Export' 'ReportViewerMode' 'Export'. ReportButton 'OnPreApplyReport'. ReportButton1.InitUserParameter(); ReportButton1.AddReportParameter("connection.servlet", " ReportButton1.AddReportParameter("connection.reportname", "/ozdemo30/kr/a/08note.ozr"); ReportButton 'OnClick'. ReportButton1.ApplyReport(); - Export Export Export. 188

189 Timer. Timer Timer 'OnTimer'. Property Timer. Property Description Enabled Interval Timer Timer (ms), Method Timer. - Start Timer. Timer 'Enabled' 'True'. Format void Start(); Example Timer1.Start(); - Stop Timer. Timer 'Enabled' 'False'. Format void Stop(); Example Timer1.Stop(); Example Timer ProgressBar. 189

190 OZ Application Designer User's Guide - Timer 0.5 ProgressBar. - Document Timer 'Interval' '500'. Board Button, 'Text' 'Start' 'OnClick'. var objtimer = _GetInvisible("Timer1"); objtimer.start(); Board Button, 'Text' 'Stop' 'OnClick'. var objtimer = _GetInvisible("Timer1"); objtimer.stop(); Board ProgressBar. Timer 'OnTimer'. var objprogressbar=_getcurrentboard().getchild("progressbar1"); if(!objprogressbar.isfullpos() ) { objprogressbar.stepit(); } else { objprogressbar.pos = objprogressbar.minimum; } - [Start], [Stop] Timer. 190

191 ContextMenu.,.. ContextMenu, 'ContextMenu' ContextMenu. ContextMenu 'OnCommand'. Example ContextMenu Board. - ContextMenu Board. - Document ContextMenu(Name=ContextMenu1). Board 'ContextMenu' 'ContextMenu1'. - Board. 191

192 OZ Application Designer User's Guide MainMenu Board.,.. MainMenu Board 'MainMenu' MainMenu. MainMenu 'OnCommand'. Example MainMenu Board. - MainMenu Board. - Document MainMenu(Name=MainMenu1). 192

193 Board 'MainMenu' 'MainMenu1'. - Tooltip,. 'ToolTip' Tooltip, 'ToolTipText'. Example Tooltip Button. - Tooltip Button. - Document Tooltip(Name=ToolTip1). Board Button 'ToolTip' 'ToolTip1' 'ToolTipText' '_MessageBox("Hello","Title");'

194 OZ Application Designer User's Guide ImageList ContextMenu, MainMenu, TreeView, CheckBox. 'ImageSize'. ImageList 'ImageList' ImageList, 'MenuIconImageIndex' 'MenuIconDisableImageIndex'. Property ImageList. Property Description ImageSize ImageListUrl Example ImageList MainMenu. - ImageList MainMenu. - Document ImageList(Name=ImageList1) 'ImageSize' '20, 20', 'ImageListUrl' 'ozp:///complexcontrols.gif'. 194

195 Document MainMenu(Name=MainMenu2). MainMenu2 'ImageList' 'ImageList1'. Invisibles MainMenu2 Table 'MenuIconImageIndex' '0'. 195

196 OZ Application Designer User's Guide Grid 'MenuIconImageIndex' '1', CrossTab 'MenuIconImageIndex' '2', Chart 'MenuIconImageIndex' '3'. Board 'MainMenu' 'MainMenu2'

197 Panel, GroupBox. Board Panel Panel Panel. GroupBox Panel, Panel. Method Panel. - DeleteAllChild Panel. Format void DeleteAllChild(); Example Panel1.DeleteAllChild(); - GetChild. Format object GetChild(string ComponentName); Example var objlabel = Panel1.GetChild("Label1"); - GetChildAt. Format object GetChildAt(integer ComponentIndex); Example var objcomp = Panel1.GetChildAt(5); 197

198 OZ Application Designer User's Guide - GetChildCount Panel. Format integer GetChildCount(); Example var ChildCount = Panel1.GetChildCount(); Example - Panel Label, CheckBox, RadioButton, Button Panel (Name) (Text).. - Board Panel, Panel Label, CheckBox, RadioButton. Board Button, 'Text' 'Get ChildComponent' 'OnClick'. var objcomp; var ChildCount = Panel1.GetChildCount(); for(i=0;i<childcount;i++) { objcomp = Panel1.GetChildAt(i); _MessageBox("Name: "+ objcomp.name + " Text: " + objcomp.text); } - 198

199 VBox, HBox. Board VBox VBox. HBox, VBox. Property VBox. Property VerticalGap Description VBox HBox. Property HorizontalGap Description HBox Example - VBox TextBox, Button, VBox. - Board VBox 'VerticalGap' '20'. 199

200 OZ Application Designer User's Guide VBox TextBox, Button. - TabControl Panel, Panel. Board TabControl TabPanel TabControl TabPanel,. Property TabControl. Property SelectedIndex Description Tab, 0 Example - 4 TabPanel TabControl Tab. - Board TabControl(Name=TabControl1), TabControl TabPanel

201 Board 'OnPostInitialize'. TabControl1.SelectedIndex = 1; - BoardView Board. OZA Board OZA Board, BoardView Board BoardView. Property BoardView. Property Description BoardName Board OZA Board BoardName, OZA Board "//OZA/". - OZA Board BoardView1.BoardName = "Board2"; - OZA Board BoardView1.BoardName = "/oza/test.oza/board1"; 201

202 OZ Application Designer User's Guide Example - TextBox Board Button BoardView Board. - Board Board TextBox(Name=TextBox1), Button(Name=Button1), BoardView(Name=BoardView1). Button 'OnClick'. BoardView1.BoardName = TextBox1.Text; - 202

203 Table. Table.,.. Grid. Grid.. CrossTab. CrossTab.. Chart 2 3. Chart.. 203

204 OZ Application Designer User's Guide Line,. Property Line. Property LineDash LineGap LineType PenThickness Description 0. Horizontal : Vertical : Slash : BackSlash : : Line LineType Line LineType. LineType Horizontal Vertical Slash BackSlash Example 204

205 - Line. - Board Line. Property Value Property Value LineDash 10 LineGap 5 LineType Horizontal PenThickness 2 - ArrowLine. Property ArrowLine. Property Description 205

206 OZ Application Designer User's Guide ArrowShape ArrowSize ArrowType LineType Circle : Diamond : OpenTriangle : SemiCircle : SharpTriangle : Triangle : Normal : Reverse : Both : Horizontal : Vertical : Slash : BackSlash : : ArrowLine LineType ArrowLine LineType, LineType Line. : ArrowLine ArrowType ArrowLine ArrowType. ArrowType Normal Reverse Example - 206

207 ArrowLine. - Board ArrowLine. Property Value Property Value ArrowShape Triangle ArrowSize 10 ArrowType Normal LineType Horizontal - Ellipse,. Property Ellipse. Property BrushStyle Description Solid : Hatch : 207

208 OZ Application Designer User's Guide PatternStyle PenThickness, BrushStyle Hatch Horizontal : Vertical : FDiagonal : BDiagonal : Cross : Horizontal Vertical Diacross : FDiagonal BDiagonal Example - Ellipse. - Board Ellipse. Property Value Property Value BrushStyle Hatch PatternStyle Diacross - 208

209 Rectangle. Property Rectangle. Property BrushStyle PatternStyle PenThickness Description Solid : Hatch :, BrushStyle Hatch Horizontal : Vertical : FDiagonal : BDiagonal : Cross : Horizontal Vertical Diacross : FDiagonal BDiagonal Example - Rectangle. - Board Rectangle. Property Value Property Value BrushStyle Hatch PatternStyle Horizontal - 209

210 OZ Application Designer User's Guide Parallelogram. Property Parallelogram. Property Description ( : 75) Slope : Slope VSlash ParallelogramType HBackSlash VBackSlash HSlash ) ( 210

211 Example - Parallelogram Board Parallelogram. Property Value Property Value Slope 60 ParallelogramT ype VBackSlash - Diamond. Property Diamond. Property BrushStyle Description Solid : Hatch : 211

212 OZ Application Designer User's Guide PatternStyle PenThickness, BrushStyle Hatch Horizontal : Vertical : FDiagonal : BDiagonal : Cross : Horizontal Vertical Diacross : FDiagonal BDiagonal Example - Diamond. - Board Diamond. Property Value Property Value BrushStyle Hatch PatternStyle Cross - Triangle. Property 212

213 Triangle. Property Description ( : 50) Slope : Slope HNormal( ) TriangleType HReverse VNormal VReverse Example - Triangle Board Triangle. Property Value Property Value Slope 90 TriangleType VReverse 213

214 OZ Application Designer User's Guide - 214

215 OZC OZ Application Designer OZ Component. Label, TextBox OZ Application Designer OZC Container Controls Board OZC. OZC [Export Component], [Import Component]. Container Controls Board OZC. Container Controls Container Controls GroupBox GroupBox OZC. OZC 215

216 OZ Application Designer User's Guide Step 1 OZC OZC OZC. Board GroupBox, RadioButton. GroupBox RadioButton 'Name' 'gbcolor', 'rbred', 'rbgreen', 'rbblue', 'rbblack', GroupBox 'Text' 'Select Color', RadioButton 4 'Text' 'Red', 'Green', 'Blue', 'Black'. OZC Board OZC, '' + ''. OZC, 'Name'. RadioButton, RadioButton1, RadioButton2,... rbred, rbgreen,.... GroupBox [Export Component]. 216

217 ' ' 'OZC_GroupBox.ozc'. 'C:\Repository'. Step 2 OZC OZC., OZC Board Label, Button. Board [Import Component]. 217

218 OZ Application Designer User's Guide [Import Component],. Menu None Auto Include Manual Include Description OZC. OZC. "SaveType" OZC OZC. 'Auto Include' OZC OZC. 'Auto Include' OZC, 'Manual Include' OZC OZC ImportNewChild() OZC. [Manual Include] OZC. [Import Component] [Manual Include] OZC Board. 218

219 [Auto Include] [Manual Include] OZC "i"(. ) OZC, 'Manage Type'. 'Manage Type'. Property Type Description OZC. 219

220 OZ Application Designer User's Guide SaveType Category Item OZC. OZC. OZC. Step 3 'Manual Include' OZC Board Board Label. 'Manual Include' OZC Board. 'Board1' 'OnPostInitialize'. Board1.ImportNewChild("ozp:///OZC_GroupBox.ozc"); Label. 'Document' GlobalFunction'. function changebackcolor(color) { var mylabel = _GetBoard("Board1").GetChild("Label1"); switch(color) { case "Red": mylabel.backcolor = "255, 0, 0"; break; case "Green": mylabel.backcolor = "0, 255, 0"; break; case "Blue": mylabel.backcolor = "0, 0, 255"; break; case "Black": mylabel.backcolor = "0, 0, 0"; break; default: break; } } [Change the Backcolor of the Label] Label 220

221 . 'Button1' 'OnClick'. if(gbcolor.getcheckedradio()!= null) { var selectedcolor = gbcolor.getcheckedradio().text; changebackcolor(selectedcolor); } else { _MessageBox("Select Color", "Error"); } Step 4 [File] [Preview] (. ) [Change the Backcolor of the Label] Label. Board Board OZC. 221

222 OZ Application Designer User's Guide OZC Step 1 OZC OZC Board OZC. Board Button, GroupBox, RadioButton. Button, GroupBox RadioButton 'Name', 'Text'. 222

223 Label. 'btnchangebackcolor' 'OnClick'. if(gbcolor.getcheckedradio()!= null) { var selectedcolor = gbcolor.getcheckedradio().text; changebackcolor(selectedcolor); } else { _MessageBox("Select Color", "Error"); } Board [Export Component]. ' ' 'OZC_Board.ozc'. 'C:\Repository'. Step 2 Board Board, Board OZC Label., Board. 223

224 OZ Application Designer User's Guide [Show Color Dialog] Board OZC. 'Button1' 'OnClick'. var objboard = _ImportNewBoard("ozp:///OZC_Board.ozc"); Board1.ShowDialog(objBoard.Name, "Change BackColor", true, 300, 0); Label. 'Document' GlobalFunction'. function changebackcolor(color) { var mylabel = _GetBoard("Board1").GetChild("Label1"); switch(color) { case "Red": mylabel.backcolor = "255, 0, 0"; break; case "Green": mylabel.backcolor = "0, 255, 0"; break; case "Blue": mylabel.backcolor = "0, 0, 255"; break; case "Black": mylabel.backcolor = "0, 0, 0"; break; default: break; } } 224

225 Step 3 [File] [Preview] (. ) [Show Color Dialog] ' ' [Change the Backcolor of the Label] Label. 225

226 OZ Application Designer User's Guide EventHook Document, PreEventHook PostEventHook. EventHook 'EnableEventHook' 'True',., 'EnableEventHook' 'True' Button1 'OnClick'. PreEventHook 'OnClick' Button1 'OnClick' PostEventHook 'OnClick' EventHook 'EnableEventHook' ( :True) 'False'. PreEventHook PostEventHook PreEventHook PostEventHook. PreEventHook 226

227 (OnClick ) Example EventHook Board Button Label 'EnableEventHook' PreEventHook PostEventHook. PreEventHook PostEventHook 'OnClick'. Board Button, Label 'EnableEventHook', Button Label 'OnClick' 'EnableEventHook' EventHook. - PreEventHook 'OnClick'. _MessageBox("PreEventHook_OnClick"); - PostEventHook OnClick. _MessageBox("PostEventHook_OnClick"); - Board Button(Name=Button1), 'EnableEventHook' 'True' Button 'OnClick'. 227

228 OZ Application Designer User's Guide _MessageBox("Button1_OnClick"); - Board Button(Name=Button2), 'EnableEventHook' 'False' Button 'OnClick'. _MessageBox("Button2_OnClick"); - Board Label(Name=Label1), 'EnableEventHook' 'True' Label 'OnClick'. _MessageBox("Label1_OnClick"); - Board Label(Name=Label2), 'EnableEventHook' 'False' Label 'OnClick'. _MessageBox("Label2_OnClick"); - [File] [Preview] ( ). - 'EnableEventHook' 'True' [Button1] PreEventHook OnClick -> Button1 OnClick -> PostEventHook OnClick. 228

229 - 'EnableEventHook' 'False' [Button2] PreEventHook PostEventHook Button2 OnClick. - 'EnableEventHook' 'True' [Label1] [Button1] PreEventHook OnClick -> Label1 OnClick -> PostEventHook OnClick. - 'EnableEventHook' 'False' [Label2] [Button2] PreEventHook PostEventHook Label2 OnClick. 229

230 OZ Application Designer User's Guide 230

231 231

232 OZ Application Designer User's Guide,,,. Controls Controls ODIKey, DataSet, Field DataSource. ODIKey, DataSet, Field. Component CheckBox RadioButton ComboBox ListBox CheckListBox TextBox NumericUpDown MaskTextBox RichTextBox Label PictureBox ProgressBar HTML View ActiveX Control Custom Control Description,, DropDown Bar ActiveX Custom 232

233 DateTimePicker MonthCalendar Complex Controls Complex Controls Table, Chart, CrossTab. Component Table CrossTab Chart Description 2 3 ODIKey, DataSet,. 233

234 OZ Application Designer User's Guide ODI. ODI OZ Application Designer Database Foodmart.mdb ODBC. OZ Query Designer ODI. OZ Query Designer 'OZ Query Designer User's Guide'. Step 1 ODBC OZ Application Designer Database Foodmart.mdb ODBC. [] [ ] [ (ODBC)] ODBC. [System DSN] [Add] ' ' 'Microsoft Access Driver(*.mdb)' [Finish]. 234

235 'Foodmart'. [Select] Database 'Foodmart.mdb' [OK], Database. 235

236 OZ Application Designer User's Guide [OK] ODBC. Step 2 ODI OZ Query Designer ODI. Database ODI. Database 'Foodmart'. OZ Query Designer 'OZ Data Tree' 'DATABASE' [Add Database Info]. Database [OK]. 236

237 . 'OZ Data Tree' 'Foodmart' [Add Query Dataset]. ' ' 'ProductSales' [OK]. [Query] [Change Design Mode] [Manual Mode],. 237

238 OZ Application Designer User's Guide 'OZ Data Tree' 'ProductSales'.. select product.brand_name, store.store_name, sales_fact.store_sales, sales_fact.store_cost from sales_fact, product, store where sales_fact.product_id = product.product_id and sales_fact.store_id = store.store_id ( ).. [File] [Save] ( ) 'Foodmart.odi'. 'C:\Repository'. 238

239 Step 3 ODI ODI. [File] [Insert New ODI] ODI [OK]. ODI. 239

240 OZ Application Designer User's Guide Table. ComboBox, Table.. - Table. 240

241 ODI Database ODBC 'Foodmart', 'MemberGrade', 'Customer'. 'Customer' 'Master Dataset' 'MemberGrade'

242 OZ Application Designer User's Guide Step 1 ODI ODI. ODI 'ODI, '. OZ Query Designer 'OZ Data Tree' 'DATABASE' [Add Database Info]. Database 'Foodmart'. 'Foodmart' [Add Query Dataset], 'MemberGrade'. ( ). select distinct member_card from customer 'Foodmart' [Add Query Dataset], 'Customer'., ( ). select customer.customer_id, 242

243 customer.fname, customer.lname, customer.gender, customer.phone1, customer.phone2, customer.birthdate, customer.occupation, customer.city, customer.country from customer where customer.member_card = '#MemberGrade.member_card#' 'Customer' 'Master Dataset' 'MemberGrade' -. ODI ODI, 'Table.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. OZ Application Designer [File] [New] ( ). [File] [Insert New ODI] ODI 'Table.odi'. ODI 243

244 OZ Application Designer User's Guide. Step 3,, Board Label, ComboBox, Table,. Label, Label. Property Value Property Value BackColor 212, 208, 200 TextColor 0, 0, 160 LineColor 212, 208, 200 Font Arial, 14pt, Bold Text > Customer Grade : Location 16, 18 Size 136, ComboBox,, ComboBox, ComboBox. Property Value Property Value Font Arial, 12pt DropDownSty le DropDownList Location 160,16 Size 168, 24 ODIKey Table DataSet MemberGrade 244

245 Field member_card FireRowCurs orchange True Table,, Table, Table. Property Value Property Value IndicatorStar tindex 1 Location 16, 48 Size 776, 536 ODIKey Table DataSet Customer - - Table [Wizard]. 'SortType' 'Numeric' 'Text' [Ok] Table CellHeader, CellIndicator. 245

246 OZ Application Designer User's Guide Property Value Property Value BackColor 128, 128, 255 TextColor 255, 255, 255 Font Arial, 12pt, Bold TextAlign MiddleRight CellFrameCol or 192, 192, 192 Size 40, 24 Table CellTitle1,..., CellTitle10. Property Value Property Value BackColor 128, 128, 255 TextColor 255, 255, 255 Font Arial, 12pt, Bold TextAlign MiddleCenter CellFrameCol or 192, 192, Table CellTitle1,..., CellTitle10 'Text' 'Customer ID, First Name, Last Name, Gender, Phone1, Phone2, Birthdate, Occupation, City, Country'. Table CellLabel1,..., CellLabel10. Property Value Property Value Font Arial, 12pt InternalMargi n 4, 4, 4, 4 Table CellLabel4 'TextAlign' 'MiddleCenter', CellLabel7 'TextAlign' 'MiddleCenter' 'Pattern' 'date_mm-dd-yyyy', CellLabel 'TextAlign' 'MiddleLeft'. Step 4 [File] [Preview] (. ) 246

247 ComboBox. 247

248 OZ Application Designer User's Guide Grid. ComboBox, Grid. 248

249 ODI Database ODBC 'Foodmart', 'ProductDepartment', 'Product'. 'ProductDept'. 249

250 OZ Application Designer User's Guide Step 1 ODI ODI. OZ Query Designer Database 'Foodmart'. [Add Query Dataset]. 'ProductDepartment', ( ). select distinct product_department from product_class. 'OZ Data Window' 'USER PARAMETER' [Add Parameter Field]. ' ' 'ProductDept' 'VARCHAR'. 250

251 [OK], 'OZ Data Window'. [Add Query Dataset]. 'Product', ( ). select product.product_id, product.brand_name, product.product_name, product.gross_weight, product.net_weight, product.low_fat, product.units_per_case, product.cases_per_pallet 251

252 OZ Application Designer User's Guide from product, product_class where product.product_class_id = product_class.product_class_id and product_class.product_department ='#OZParam.ProductDept#' order by brand_name, product_name, product_id ODI ODI, 'Grid.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. OZ Application Designer [File] [Create New Project] ( ). [File] [Insert New ODI] ODI 'Grid.odi'. ODI. Step 3,, Board Label, ComboBox, Grid 252

253 ,. Label, Label, (Font), (TextColor), (Location), (Size), (Text). ComboBox,, ComboBox, (TextColor), (Location), (Size). Property Value Property Value DropDownSty le DropDownList ODIKey Grid DataSet ProductDepartment Field product_departmen t Grid, Grid, (Location), (Size). Property Value Property Value IndicatorStar tindex 1 FixedColCoun t 3 Grid CellHeader, CellIndicator, CellTitle, (BackColor), (CellFrameColor), (Font), (TextColor), (Size). Grid CellHeader, CellIndicator, (TextAlign = MiddleRight), CellTitle (TextAlign=MiddleCenter). Grid CellLabel, (Font) (InternalMargin = '4,4,4,4'). 253

254 OZ Application Designer User's Guide Step 4 ComboBox Grid. Grid Grid Title, Label. 'Document' 'GlobalFunction'. function displayproduct(productdeptvalue) { //ODI, DataSet var DataManager = _GetDataManager(); var DataModule = DataManager.GetDataModule("Grid"); DataModule.UpdateOZParam("ProductDept", ProductDeptValue); var DataSet = DataModule.GetDataSet("Product", null, true); var DataCount = DataSet.GetRowCount(); var grdproduct = _GetBoard("Board1").GetChild("Grid1"); //Reset Grid if(grdproduct.getrowcount() > 0) { grdproduct.selectcellrange(-1, -1, -1, -1); grdproduct.deletecellinrange(); } grdproduct.addcolumn(8); grdproduct.addrow(datacount); grdproduct.selectcellrange(0, 5, DataCount, 5); if(datacount < 1) { return; } grdproduct.changecelltypeinrange( CellComponentTypeConst.CheckBox); //Display Data for(i=0; i<datacount; i++) { grdproduct.getcell(i,0).text = DataSet.GetStringData(i, "product_id"); grdproduct.getcell(i,1).text = DataSet.GetStringData(i, "brand_name"); grdproduct.getcell(i,2).text = DataSet.GetStringData(i, "product_name"); grdproduct.getcell(i,3).text = DataSet.GetStringData(i, "gross_weight"); grdproduct.getcell(i,4).text = DataSet.GetStringData(i, "net_weight"); grdproduct.getcell(i,5).checked = DataSet.GetStringData(i, "low_fat"); grdproduct.getcell(i,6).text = DataSet.GetStringData(i, "units_per_case"); 254

255 } grdproduct.getcell(i,7).text = DataSet.GetStringData(i, "cases_per_pallet"); } function formatgrid(gridrowcount) { var grdproduct = _GetBoard("Board1").GetChild("Grid1"); //Grid Title grdproduct.gettitle(0).text = "Product ID"; grdproduct.gettitle(1).text = "Brand Name"; grdproduct.gettitle(2).text = "Product Name"; grdproduct.gettitle(3).text = "Gross Weight"; grdproduct.gettitle(4).text = "Net Weight"; grdproduct.gettitle(5).text = "Low Fat"; grdproduct.gettitle(6).text = "Units Per Case"; grdproduct.gettitle(7).text = "Cases Per Pallet"; grdproduct.gettitle(0).setsize(80,24); grdproduct.gettitle(1).setsize(80,24); grdproduct.gettitle(2).setsize(160,24); grdproduct.gettitle(3).setsize(80,24); grdproduct.gettitle(4).setsize(80,24); grdproduct.gettitle(5).setsize(60,24); grdproduct.gettitle(6).setsize(100,24); grdproduct.gettitle(7).setsize(100,24); //Grid Label for(i=0; i<gridrowcount; i++) { grdproduct.getcell(i,0).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,1).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,2).textalign = AlignmentConst.MiddleLeft; grdproduct.getcell(i,3).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,4).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,5).checkalign = AlignmentConst.BottomCenter; grdproduct.getcell(i,6).textalign = AlignmentConst.BottomRight; grdproduct.getcell(i,7).textalign = AlignmentConst.BottomRight; } //Refresh ScrollBars grdproduct.refreshscrollbars(); } ComboBox Grid Grid 255

256 OZ Application Designer User's Guide. ComboBox 'OnSelectedIndexChanged'. displayproduct(combobox1.value); formatgrid(grid1.getrowcount()); Step 5 [File] [Preview] (. ) ComboBox. 256

257 ,,. Table. [Insert] Table. [Update]. Table [Delete]. 257

258 OZ Application Designer User's Guide ODI Database ODBC 'Foodmart', 'Customer2'.,, 'Customer2',,. Step 1 ODI,, ODI.,, 'OZ Query Designer User's Guide'. OZ Query Designer Database 'Foodmart'. [Add Query Dataset]. 'Customer2', 258

259 ( ). select customer_id, fname, lname, member_card, gender, phone1, city, country from customer2,, 'Customer2',,. 'OZ Data Tree' 'Customer2' [Insert Query]. [OK]. INSERT INTO customer2 VALUES 'OZ Data Tree' 'Customer2' [Delete Query]. [OK]. DELETE FROM customer2 WHERE = 'OZ Data Tree' 'Customer2' [Update Query]. [OK]. UPDATE customer2 SET = #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', 259

260 OZ Application Designer User's Guide = #@ARG_SF8# = '#@ARG_SV8#' WHERE #@ARG_DF1# = '#@ARG_DV1#' ODI ODI, 'DataAction.odi'. 'C:\Repository'. Step 2 ODI OZ Application Designer ODI. OZ Application Designer [File] [Create New Project] ( ). [File] [Insert New ODI] ODI 'DataAction.odi'. ODI. Step 3,, Board Label, Panel, TextBox, Button, Table 260

261 ,. Label, Label, (Font), (TextColor), (Location), (Size), (Text). Panel, Panel, (Location), (Size). Button, Button 3, (Font), (Location), (Size), (Text). TextBox,, TextBox, (Location), (Size) TextBox. Property Value Property Value ODIKey DataAction DataSet Customer2 Field customer_id, fname,lname, member_card, gender, phone1, city, county - - Table,, Table, (Location), (Size) Table. Property Value Property Value IndicatorStar tindex 1 ODIKey DataAction DataSet Customer2 FireRowCurs orchange True Table 261

262 OZ Application Designer User's Guide [Wizard]. 'SortType' 'Text' [Ok] Table CellHeader, CellIndicator, CellTitle, CellLabel (BackColor), (CellFrameColor), (Font), (TextColor), (Size), (Text), (TextAlign). Step 4,,. [Insert] 'OnClick'. //Create DataSet Object var DataModule = _GetDataManager().GetDataModule("DataAction"); var DataSet = DataModule.GetDataSet("Customer2"); var DataAction = new Array(); DataAction[0] = DataSet.MakeDefaultDataAction(); //Create Insert Action DataAction[0].DataActionType = DataActionTypeConst.Insert; DataModule.CleanUpQueuedActions(); 262

263 var arrfield = new Array(); var arrvalue = new Array(); arrfield[0] = "customer_id"; arrvalue[0] = TextBox_ID.Text; arrfield[1] = "fname"; arrvalue[1] = TextBox_FirstName.Text; arrfield[2] = "lname"; arrvalue[2] = TextBox_LastName.Text; arrfield[3] = "member_card"; arrvalue[3] = TextBox_MemberCard.Text; arrfield[4] = "gender"; arrvalue[4] = TextBox_Gender.Text; arrfield[5] = "phone1"; arrvalue[5] = TextBox_Phone.Text; arrfield[6] = "city"; arrvalue[6] = TextBox_City.Text; arrfield[7] = "country"; arrvalue[7] = TextBox_Country.Text; //Create & Commit Queue DataAction DataAction[0].SetSourceNames(arrField); DataAction[0].SetSourceValues(arrValue); DataSet.QueueActionObjects(DataAction); var Result = DataModule.CommitQueuedActions();//Commit if(result == "") { DataSet = DataModule.GetDataSet("Customer2", null, true); Table1.RefreshDataSet(); } else { _MessageBox(Result, "DataActionError"); } [Update] 'OnClick'. //Create DataSet Object var DataModule = _GetDataManager().GetDataModule("DataAction"); var DataSet = DataModule.GetDataSet("Customer2"); var DataAction = new Array(); DataAction[0] = DataSet.MakeDefaultDataAction(); //Create Update Action DataAction[0].DataActionType = DataActionTypeConst.RowUpdate; var arrfield = new Array(); var arrvalue = new Array(); arrfield[0] = "customer_id"; arrvalue[0] = TextBox_ID.Text; arrfield[1] = "fname"; arrvalue[1] = TextBox_FirstName.Text; arrfield[2] = "lname"; arrvalue[2] = TextBox_LastName.Text; arrfield[3] = "member_card"; arrvalue[3] = TextBox_MemberCard.Text; arrfield[4] = "gender"; arrvalue[4] = TextBox_Gender.Text; arrfield[5] = "phone1"; arrvalue[5] = TextBox_Phone.Text; arrfield[6] = "city"; arrvalue[6] = TextBox_City.Text; 263

264 OZ Application Designer User's Guide arrfield[7] = "country"; arrvalue[7] = TextBox_Country.Text; //Create & Commit Queue DataAction DataAction[0].SetSourceNames(arrField); DataAction[0].SetSourceValues(arrValue); DataAction[0].SetTargetValue("customer_id", Table1.GetCellInPage(Table1.GetFocusRowIndex,0).Value); DataSet.QueueActionObjects(DataAction); var Result = DataModule.CommitQueuedActions();//Commit if(result == "") { DataSet = DataModule.GetDataSet("Customer2", null, true); Table1.RefreshDataSet(); } else { _MessageBox(Result, "DataActionError"); } [Delete] 'OnClick' Table. //Create DataSet Object var DataModule = _GetDataManager().GetDataModule("DataAction"); var DataSet = DataModule.GetDataSet("Customer2"); var DataAction = new Array(); DataAction[0] = DataSet.MakeDefaultDataAction(); //Create Update Action DataAction[0].DataActionType = DataActionTypeConst.Delete; //Create & Commit Queue DataAction DataAction[0].SetTargetValue("customer_id", Table1.GetCellInPage(Table1.GetFocusRowIndex,0).Value); DataSet.QueueActionObjects(DataAction); var Result = DataModule.CommitQueuedActions();//Commit if(result == "") { DataSet = DataModule.GetDataSet("Customer2", null, true); Table1.RefreshDataSet(); } else { _MessageBox(Result, "DataActionError"); } Step 5 [File] [Preview] (. ). 264

265 (ID:AA113). 265

266 OZ Application Designer User's Guide (ID:AA113). (ID:AA113). 266

267 . DataBase. 'OZ Script Guide'. ODI. 'Grid.odi'. -, 'Grid.odi'. - ' ' 'Grid.odi' 'Product' [Insert New CalculatedField]. - [Insert New CalculatedField] ' '. 267

268 OZ Application Designer User's Guide '' '' ''.. 268

269 Database,. 'Grid.odi' 'Product' 'ProductDepartment' [Database], 'Product'. 269

270 OZ Application Designer User's Guide [Product] [#Product.product_id#]. Parameter ODI Parameter. 'Grid.odi' Parameter 'ProductDept'. 270

271 Functions (Mathematics), (Sting Opr.), (Database I/O), (Date Opr.), (Miscellaneous). 'OZ Script Guide'.,. 'substr'. 271

272 OZ Application Designer User's Guide - [Ok] [Edit CalculatedField] ' ' [Ok]. 272

273 Example. Step 1 'Foodmart.odi'. ' ' 'Foodmart.odi' 'ProductSales' [Insert New CalculatedField]. [Ok]. 'store_cost' '3.0' 'Bad', '3.0' 'Good'. 273

274 OZ Application Designer User's Guide ' ' 'Foodmart.odi' 'ProductSales'. Step 2 Table. Board Table 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales' Table [Ok]. CellTitle, CellLabel,. 'Remark' 'store_cost' 'Good' 'Bad'. 274

275 275

276 OZ Application Designer User's Guide FXData - Table. Step 1 FX Data Accesses "_OZGlobal_" [Insert New FXDataSet]. [Ok]. [Insert New Field]. 276

277 [Ok]. 277

278 OZ Application Designer User's Guide Step 2 [Insert New Detail DataSet]. [Ok]. [Insert New Field]. 278

279 [Ok]. Step 3,.. [Insert Data]. 279

280 OZ Application Designer User's Guide.. "M" [DetailSet] ["Detail"]. 280

281 [Ok].. 281

282 OZ Application Designer User's Guide [Ok]. Step 4 FXData ComboBox Table. Board ComboBox ComboBox. 282

283 Property Value Property Value ODIKey _OZGlobal_ DataSet Master Field Gender FireRowCurs orchange True Board Table Table. Property Value Property Value ODIKey _OZGlobal_ DataSet Detail Table [Wizard]. [Ok].,. 283

284 OZ Application Designer User's Guide. 284

285 285

286 OZ Application Designer User's Guide OZ Application Designer. Chart Chart. Chart Board Chart, Chart ODI. Chart Chart.. 'Foodmart.odi' Chart, Chart 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. Chart [Wizard] Chart.. [Apply]. 286

287 Type Chart. OZ Application Designer,,,,,,,,,,, Chart, Chart Chart. Data Chart X, Y. 287

288 OZ Application Designer User's Guide ' ' Chart DataSet. X, Y, Y, ' ' Drag & Drop. / ( ). ' ' Drag & Drop [Delete]. Option [Option ]. 288

289 - Dimension Option [Dimension Option] X., /. : Chart "ChartExpansionType" "Tree Type". - Level Option [Level Option] X Y. Default, Sum, Max, Min, Avg, Cnt, Default Chart "DefaultSummaryType". 289

290 OZ Application Designer User's Guide X Axis X,,,. Show Axis X,. Major Gridlines X, [Line Style],. [Line Style] 'Gridline Style Dialog'. Minor Gridlines X, [Line Style],. [Line Style] 'Gridline Style Dialog'. Show Label X, X, [Format]. [Format] 'Format Dialog'. 290

291 Label Word Wrap X. Reverse Order X.. Label Interval X. '1', '2',,,.... Gap Between Bars. - Gap Between Bars In X Axis : X. - Gap Between Collected Bars :. Advanced X.. Option Description. Major/Minor Gridlines None 291

292 OZ Application Designer User's Guide. Outside. Inside. Cross Default ( "Ok" "Canel".) Y X. Value(Y) axis Ok crosses between category(x) Y X. Cancel 292

293 Y Axis Y, Y,,,,,. Show Axis Y,. Major Gridlines Y, [Line Style],. [Line Style] 'Gridline Style Dialog'. Minor Gridlines Y, [Line Style],. [Line Style] 'Gridline Style Dialog'. Show Label(Left) Y, Y, [Format]. [Format] 'Format Dialog'. 293

294 OZ Application Designer User's Guide Show Label(Right) Y, Y, [Format]. [Format] 'Format Dialog'. Draw Label On Origin X. X X. - Draw Label On Origin X - Draw Label On Origin Reverse Order(Left) Y. Y. Reverse Order(Right) Y. Y. 294

295 - "Reverse Order(Right)". - "Reverse Order(Left)". Label Interval Y. '1', '2',,,.... Advanced Y Y, Y,,,,,,.. Option Description Major/Minor Gridlines None Outside Inside Cross

296 OZ Application Designer User's Guide # of Ticks Unit of Ticks Origin Line Style Min Round Off Max Round Up Y, Y. Auto.. Y, Y. X Y. Y (MIN) (MAX). [Line Style],. [Line Style] 'Gridline Style Dialog' Y. Auto... Y. Auto... /, / /. Y

297 Y Z Axis Z,,,. Show Axis Z,. Major Gridlines Z, [Line Style],. [Line Style] 'Gridline Style Dialog'. 297

298 OZ Application Designer User's Guide Minor Gridlines Z, [Line Style],. [Line Style] 'Gridline Style Dialog'. Show Label Z, Z, [Format]. [Format] 'Format Dialog'. Label Word Wrap Z. Label Interval Z. '1', '2',,,.... Advanced Z. : X. Legend Chart,,,,. 298

299 Show. [By Series], [Format]. [Format] 'Format Dialog'. [By Series]. ' ' 'Visible' 'Invisible' ' ' Drag & Drop (,,, ). 299

300 OZ Application Designer User's Guide / ( ). 'Visible',., 10, 'Invisible',,, 'Visible',,. 'Visible'. :. 'Visible', 'Invisible'. Chart '', ''. Chart X 'Month' Y 'Sales' 'Department' 'Origin'. 300

301 'Origin' [By Series]., Chart. 301

302 OZ Application Designer User's Guide Title,. [Format], [Format] 'Format Dialog'. Frame, [Style]. [Style] 'Rectangle Style Dialog'.. Option Color Fill Thickness Round Description.. 'None'... Reverse.,. Gap from chart to legend. Position Chart (Top), (Bottom), (Left), (Rignt). 302

303 Title Chart. Chart,, X, Y [Format]. [Format] 'Format Dialog'. Chart Title Chart. X Axis Title X 'End of Axis', X 'Next of Axis'. Y Axis Title Y 'End of Axis' Y Axis Left( ) Y, Y Axis Right( ) Y. Y 'Next of Axis' Y Axis Left( ) Y, Y Axis Right( ) Y. Bottom Title Chart. 303

304 OZ Application Designer User's Guide Display Chart,,. BackGround Chart. - Fill :.. - Margin... : Chart Chart,,,. [Margin] 'Margin Dialog'.,,,. 3D Thickness 3D Chart. 304

305 3D Rotational Axis Thickness Chart. Fill Type. No Fill. Frame. Frame Brightness. Brightness,. Gradient. Gradient Gradient Style, Brightness. 305

306 OZ Application Designer User's Guide Data Label. Data Label,,,. 'Show'. [By Series], 'Position'. [Format], [Format] 'Format Dialog'. [By Series]. Legend 'By Series'. 306

307 Tooltip. 'Show', 'Boundary Radius'.,. Color. ' ' ' ' Drag & Drop (,,, ). / ( ). [User Defined]. 307

308 OZ Application Designer User's Guide Misc,,,. Pie Type Chart Chart,, 'Vertical Interval' 'Horizontal Interval'. User-Defined Chart Option Chart 2, 'Clustered Bar' 2 'Stacked Bar'. Internal Interval Chart,. Spot Size. Line Thickness. 308

309 Bar Max Thickness. Apply Pattern,,. 'Apply Pattern',, Chart,, 'Mark Pattern', 'Fill Pattern', 'Line Pattern' 3. - Mark Pattern Chart. 309

310 OZ Application Designer User's Guide ' ' ' ' Drag & Drop (,,, ). / ( ). - Fill Pattern ' ' ' ' Drag & Drop (,,, ). / ( ). - Line Pattern. 310

311 ' ' ' ' Drag & Drop (,,, ). / ( ). [User Defined], [User Defined]. 'Dash Line' 'Gap Size' [OK]. 'Gap Size' '0', 'Gap Size' '0'. Smoth Line Chart. 311

312 OZ Application Designer User's Guide Gauge Chart,,,. Start Angle. Length Angle Chart. Axis Thick Y. Bar Thick Chart. Legend Label Pos X. DataLabel Position. Axis Label Y. 312

313 Bar Pos. Arrange Chart Chart. Reverse Chart. 'Reverse'. Radiant Chart X, Y,. X Axis Direction X. Y Axis Max Value Y. 313

314 OZ Application Designer User's Guide Radiant Axis Label Position,,. Pie Chart,,,. Start Angle. Length Angle Chart. Axis Thick.. Pie XY Ratio Chart. 314

315 Legend Label. Axis Label Z Z. Arrange Chart Chart. Reverse Chart. 'Reverse'. Format Dialog,,. Format.,,,,,. 315

316 OZ Application Designer User's Guide. : Mask. Mask_[PromptChar]_[User define mask] PromptChar. Mask. ) mask_#_(###)####-#### -> : : (011) ) : 123 : ()-123 2) : : ( ) Paragraph,,,. Font,,,,. 316

317 Line Color. Gridline Style Dialog. 317

318 OZ Application Designer User's Guide Color. Use Dashes. 'Use Dashes', 'Dash Length', 'Gap Length', 'Dash Length' 'Gap Length'. Thickness. 318

319 CheckListBox CheckListBox. CheckListBox Board CheckListBox, CheckListBox [Wizard] CheckListBox. CheckListBox CheckListBox 'Member' ''. Member CheckListBox,. Property, CheckListBoxItem. 319

320 OZ Application Designer User's Guide Property Type Text Selected Checked CheckState ItemValue Enabled Description. CheckListBox CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. 'True' CheckListBoxItem. CheckListBox. CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. CheckListBoxItem. 'False'. 320

321 ComboBox ComboBox. ComboBox Board ComboBox, ComboBox [Wizard] ComboBox. ComboBox ComboBox 'Member' ''. Member ComboBox,. Property, ComboBoxItem. 321

322 OZ Application Designer User's Guide Property Type Text ItemValue ImageIndex SelectedImageInd ex ItemIndent Description. ComboBox ComboBoxItem. ComboBoxItem. ComboBoxItem.. ComboBox ImageList.. ComboBox ImageList. ComboBoxItem

323 ContextMenu MainMenu ContextMenu. ContextMenu ContextMenu. ContextMenu Document ContextMenu, 'Invisibles ' ContextMenu [Wizard] ContextMenu. ContextMenu ContextMenu 'Member' ''. Member ContextMenu,. [Tab]. 323

324 OZ Application Designer User's Guide Property, MenuItem. Property Type Name Text Enabled Visible Checked MenuIconImage MenuIconDisableImage MenuIconImageIndex MenuIconDisableImageIndex Description. ContextMenu MenuItem. MenuItem. MenuItem. MenuItem. 'False'. MenuItem. MenuItem. MenuItem MenuItem. MenuItem MenuItem. MenuItem MenuItem ImageList. ContextMenu ImageList, 'MenuIconImage'. MenuItem MenuItem ImageList. ContextMenu ImageList, 'MenuIconImage'. 324

325 IsSeparator Style Shortcut EnableEventHook MenuItem. 'True'. MenuItem OZ Style. MenuItem. EventHook. 325

326 OZ Application Designer User's Guide CrossTab CrossTab. CrossTab Board CrossTab, CrossTab ODI.. 'Foodmart.odi' CrossTab CrossTab 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. CrossTab [Wizard] CrossTab. CrossTab CrossTab DataSet ' ', ' ', ' ', ' '.,, ' ' Drag & Drop, Drag & Drop [Delete]. 326

327 Option [Option ] CrossTab,. - Dimension Option [Dimension Option] CrossTab,,.. Option Expansion Level Fixed Level Description CrossTab. Expansion Level. 3 Expansion Level 3, 2 CrossTab 2... Fixed Level. 3 Fixed Level 3, 2 CrossTab

328 OZ Application Designer User's Guide Drill Show [+/-] Show Pivot Show Sum.. (+) (-)... - Level Option [Level Option] ' ',.. Option SortState SortType Description Pivot. None(), Ascending(), Descending(), "None". Pivot. None(), Text(), Numeric(). "None". 328

329 Summary Type Pivot. Default(), Sum(), Max(), Min(), Avg(), Cnt(). "Default ". - Common Option [Common Option] ' '. Option Show Title Value Pivot Description ' ',., 'Add Previous', 'Add Next'. 329

330 OZ Application Designer User's Guide ListBox ListBox. ListBox Board ListBox, ListBox [Wizard] ListBox. ListBox ListBox 'Member' ''. Member ListBox,. Property, ListBoxItem. 330

331 Property Type Text Selected ItemValue Description. ListBox ListBoxItem. ListBoxItem. ListBoxItem. 'True' ListBoxItem. ListBox. ListBoxItem. 331

332 OZ Application Designer User's Guide ListView,, ListView. ListView Board ListView, ListView [Wizard] ListView. ListView ListView 'Member' ''. [Add] ListView, [Columns] ListView. [Remove]. [SubItems]. Member ListView. 332

333 Property. Property Type Text Selected Checked ItemValue ImageIndex ItemIndent Description. ListView ListViewItem... 'True'. ListView 'HideSelection' 'False'.. ListView, ListView 'CheckBoxes' 'True'... ListView ImageList [Columns] ListView. 333

334 OZ Application Designer User's Guide Member ListView. Property. Property Type Text TextHAlign ColumnWidth Description. ListViewColumnItem.... [SubItems] ListView. Member ListView.. 334

335 Property. Property Type Text ItemValue Description. ListViewSubItem

336 OZ Application Designer User's Guide RichTextBox RichTextBox. RichTextBox Board RichTextBox, RichTextBox [Wizard] RichTextBox. RichTextBox '' ''.,,,,,. Icon Description,.,,,.,,..,.,. 336

337 TabControl TabPanel TabControl. TabControl Board TabControl, TabControl [Wizard] TabControl. TabControl TabPanel 'Member' TabPanel ''. TabControl 4. Button Add Remove TabPanel. Description TabPanel. TabPanel. TabPanel. 337

338 OZ Application Designer User's Guide Table Table. Table Board Table, Table ODI.. 'Foodmart.odi' Table Table 'ODIKey' 'Foodmart' 'DataSet' 'ProductSales'. Table [Wizard] Table. Table Table "Select Field" Table "Design". Select Field Table DataSet,. Select Field Table DataSet '' '', Table " ", ''. 338

339 ' '' '#OZDeleteFlag#' Table DataSet Table, Row. Table 6. Button Description ' ' ' ' Table. ' ' ' ' Table. ' '., Table. ' '., Table. ' '., Table. ' '., Table. Table ' ' Drag & Drop. ' ' ''. 339

340 OZ Application Designer User's Guide. Property Type ColumnType ColumnName SortType TableSortMode ColumnEditable Description. Table TableItem., Label, PictureBox, Button, CheckBox, RadioButton, ComboBox,... 'None', 'Text' 'Numeric'.. 'CellData' Table Cell Page, 'DataSet' Table DataSet. : 'DataSet' Table 'ApplyToDataSet' 'SynchronizeToDataSet' "True".. 340

341 ColumnMerge ColumnAutosize.. 'None', 'FixWidth', 'Auto', 'FixWidthNotShrink'. Design /, /. Design Select Field '' '', Table. 341

342 OZ Application Designer User's Guide ' ' Drag & Drop / /. Split Cells [Split Cells].. [Split Cells]. [OK]. Merge Cells [Merge Cells].. Insert [Insert] ///. 342

343 Delete [Delete]. 343

344 OZ Application Designer User's Guide TreeView TreeView. TreeView Board TreeView, TreeView [Wizard] TreeView. TreeView TreeView 'Member' ''. Member TreeView,. [Tab] Property, TreeNode. 344

345 Property Type Text Checked Bold ImageIndex SelectedImageIndex LabelEditable NodeID Description. TreeView TreeNode. TreeNode. TreeNode. TreeView, TreeView 'CheckBoxes' 'True'. TreeNode. TreeNode. TreeView ImageList. TreeNode. TreeView ImageList. TreeNode. TreeView 'LabelEdit' 'True'. TreeNode ID. 345

346 OZ Application Designer User's Guide 346

347 347

348 OZ Application Designer User's Guide OZF, OZ Function Editor, OZF. OZF OZ Function. OZF OZ Application Designer, OZF OZ Application Designer. OZF 'OZ Function Editor'. : OZF OZF. 348

349 OZ Function Editor OZ Application Designer. OZ Application Designer 'OZ Application Designer' [Tools] -> [Function Editor] 'OZ Function Editor'. 349

350 OZ Application Designer User's Guide OZ Function Editor,. Window Description OZ Function Editor (pull down),,,,,. OZ Function Editor,,,,,,,. 350

351 . OZF

352 OZ Application Designer User's Guide OZ Function Editor (pull down),,,,,. (File) [File]. New Function (Ctrl+N) OZF. [New Function]. Open Function (Ctrl+O) OZF. Close Function OZF.. Save Function (Ctrl+S) OZF. XML 352

353 XML. OZF XML. : OZ Function Editor. XML OZ Function Editor "(XML type)", "(Text type)". Save Function (XML Type) OZF XML. Save Function (Text Type) OZF OZF. XML. Save Function As OZF. XML XML. OZF XML. Save Functin As (XML Type) OZF XML. Save Functin As (Text Type) OZF. XML. Recent Function OZF. OZF 4 OZF. Exit 353

354 OZ Application Designer User's Guide OZ Function Editor. (Edit) [Edit]. Undo (Ctrl+Z). Redo (Ctrl+Y),. Cut (Ctrl+X). Copy (Ctrl+C). Paste (Ctrl+V). Delete (Delete). [Undo]. 354

355 Find (Ctrl+F). [Find Next].. Option Match Whole World Only Match Case Direction Description..,. Relpace (Ctrl+H). [Find Next] [Replace] [Replace All]. Go To (Ctrl+G).. [Ok]. 355

356 OZ Application Designer User's Guide (View) [View]. Repository Explorer OZ Function Editor. (Tools) [Tools]. Options ' ' OZ Function Editor,,,. 356

357 [Ok] OZ Function Editor [Restore]. - Option General OZ Function Editor. Layout OZ Function Editor. 357

358 OZ Application Designer User's Guide Save layout when exit OZ Function Editor OZ Function Editor. OZ Function Editor [Reset window layout] [Save current layout]. International Setting. Save OZF. 358

359 - Editor Environment : Function Editor,,. Font and Color : Function Editor,,,. 359

360 OZ Application Designer User's Guide (Help) [Help]. About OZ Application Function Editor OZ Function Editor. 360

361 OZ Function Editor,,,,,,,,. (Standard),. Icon Description New Function, Open Function, Save Function Undo, Redo, Cut, Copy, Paste About OZ Application Function Editor (View). Icon Description View Repository 361

362 OZ Application Designer User's Guide OZ Function Editor [File] [New Function] (. ) OZF,,. function (Argument1, Argument2,... ) { //Script // return ; } OZF.. function changebackcolor(componentname, RGBColor) { //Script } function changetextcolor(componentname, RGBColor) { //Script } 362

363 OZ Function Editor OZF OZ Application Designer. Step 1 OZF 'OZ Function Editor' RGB OZF. 'OZ Function Editor' [File] [New Function] ( )... function changebackcolor(componentname, RGBColor) { var objcomp = _GetCurrentBoard().GetChild(ComponentName); objcomp.backcolor = RGBColor; } 363

364 OZ Application Designer User's Guide [File] [Save Function] ( ) OZF. ' ' 'OZF_ChangeBackColor.ozf'. 'C:\Repository'. Step 2 OZF OZF. Board Label, GroupBox, RadioButton. [File] [Insert New Function] OZF. 364

365 OZF Invisibles., OZF OZF. OZF Invisibles OZF [Show Script]. OZF Invisibles OZF [Edit Function] 'OZ Function Editor'.. 365

366 OZ Application Designer User's Guide OZF Invisibles OZF [Delete Function] [Delete] OZF. Step 3 RadioButton Label OZF. 'Red', 'Green', 'Blue', 'Black' RadioButton 'OnClick' OZF. rbred OnClick changebackcolor("label1", "255, 0, 0"); rbgreen OnClick changebackcolor("label1", "0, 255, 0"); rbblue OnClick changebackcolor("label1", "0, 0, 255"); rbblack OnClick changebackcolor("label1", "0, 0, 0"); Step 4 [File] [Preview] (. ) RadioButton Label. 366

367 367

368 OZ Application Designer User's Guide OZS, OZ Style Editor, OZS. OZS OZ Style, OZS,.,,, OZS,. OZS 'OZ Style Editor'. 368

369 OZ Style Editor OZ Application Designer. OZ Application Designer 'OZ Application Designer' [Tools] [Style Editor] 'OZ Style Editor'. 369

370 OZ Application Designer User's Guide OZ Style Editor,. Window Description OZ Style Editor (pull down),,,,,,. 370

371 OZ Style Editor,,,,.. OZS

372 OZ Application Designer User's Guide OZ Style Editor (pull down),,,,,,. (File) [File]. New Stylelist (Ctrl+N) OZS. [New Stylelist], OZS. Open Stylelist (Ctrl+O) OZS. Close Stylelist OZS.. Save Stylelist (Ctrl+S) OZS. Save Stylelist As OZS. 372

373 Recent Stylelist OZS. OZS 4 OZS. Exit OZ Style Editor. (Edit) [Edit]. Undo (Ctrl+Z). Redo (Ctrl+Y),. Cut (Ctrl+X). Copy (Ctrl+C). Paste (Ctrl+V). 373

374 OZ Application Designer User's Guide Delete (Delete). [Undo]. (Style) [Style]. Insert New Style. [Insert New Style]. [OK]. Remove Style. Insert New Properties. [Insert New Properties]. 374

375 Component Type [Insert]. Component Type "All". Remove Properties. [Remove Properties]. 'BackColor', 'Multiline', 'TextAlign', 'TextColor', 'WordWrap' 'Style1'. 375

376 OZ Application Designer User's Guide [Remove]. (View) [View]. Repository OZ Style Editor. Properties OZ Style Editor. Icons OZS. List OZS. 376

377 Details OZS. (Tools) [Tools]. Options ' ' OZ Style Editor,,. 377

378 OZ Application Designer User's Guide [Ok] OZ Style Editor [Restore]. - Option General OZ Style Editor. When create a new file or open a file, execute as a new style editor OZ Style Editor. Highlight properties which is different with default values. 378

379 Layout OZ Style Editor. Save layout when exit OZ Style Editor OZ Style Editor. OZ Style Editor [Reset window layout] [Save current layout]. International Setting. Save OZS. 379

380 OZ Application Designer User's Guide (Help) [Help]. About OZ Application Style Editor OZ Style Editor. 380

381 OZ Style Editor,,,,,,,,,,,,,. (Standard),. Icon Description New Stylelist, Open Stylelist, Save Stylelist Undo, Redo, Cut, Copy, Paste Insert New Style, Remove Style Insert New Propeties, Remove Properties About OZ Application Style Editor (View). Icon Description View Repository, View Properties 381

382 OZ Application Designer User's Guide OZ Style Editor [File] [New Stylelist] ( ), OZS. [File] [New Stylelist] (. ) - [Style] [Insert New Style] ( ). - [OK]. 'Name'. 'Style2' 'TextBox_Single'. 382

383 . - [Insert New Properties] ( ). -. [Insert]. 383

384 OZ Application Designer User's Guide -. 'TextBox_Single' 'BackColor', 'TextAlign', 'Multiline', 'WordWrap'. -. 'BackColor' '255,255,255', 'TextAlign' 'MiddleCenter', 'Multiline' 'True', 'WordWrap' 'False'. 384

385 . - [Remove Properties] (. ) -. [Remove] 385

386 OZ Application Designer User's Guide OZS [File] [Save Stylelist] ( ) OZS. 386

387 OZ Style Editor OZF OZ Application Designer. 387

388 OZ Application Designer User's Guide Step 1 OZS OZ Style Editor Label, TextBox, MaskTextBox OZS. Label,,,,. OZ Style Editor [File] [New Stylelist] OZS. 'Style1' 'Label'. Label [Insert New Properties]. ' ' BackColor, TextColor, LineColor, Font, TextAlign,. TextBox 'Customer Name' TextBox. [Style] [Insert New Style] 388

389 ( ). 'TextBox_Single' [OK]. 'TextBox_Single' 'Font', 'BoardStyle'. TextBox 'Customer Info.' TextBox,,,. [Style] [Insert New Style] ( ), 'TextBox_Multi' [OK]. 'TextBox_Multi' 'Font', 'BoardStyle', 'Multiline', 'ScrollBars', 'WordWrap'. 389

390 OZ Application Designer User's Guide MaskTextBox,,,,. [Style] [Insert New Style] ( ), 'MaskTextBox_Date' [OK]. 'MaskTextBox_Date' 'Font', 'BoardStyle', 'Mask', 'Literal', 'Default'. [File] [Save Stylelist] ( ) OZS. ' ' 390

391 'OZS.ozs'. 'C:\Repository'. Step 2 OZS Board OZS. Board 'OZ Application Designer', Board Label, TextBox, MaskTextBox. OZS [File] [Insert New Style] OZS. OZS Invisibles. 391

392 OZ Application Designer User's Guide Step 3. Label1, Label2, Label3 'Style' 'OZS.Label'. TextBox1 'Style' 'OZS.TextBox_Single'. TextBox2 'Style' 'OZS.TextBox_Multi'. MaskTextBox1 'Style' 'OZS.MaskTextBox_Date' Step 4 [File] [Preview] (. ) 392

393 393

394 OZ Application Designer User's Guide 394

395 395

396 OZ Application Designer User's Guide OZ Application Designer. OZA, OZC, OZF, OZS, ODI,,,.. OZ Application Designer. OZ Application Designer. Step 1 OZ Application Designer 'RepositoryServer' [Open Repository]. 396

397 Step 2 ' '. ' '. Button Import Export Add Category Add Server Delete Save Connect after save Exit Description XML. XML... [ ]..... Option Server name Description. 397

398 OZ Application Designer User's Guide Type IP Port URL Name Password Save Password Max history count OZ Server. Daemon TCP, Servlet HTTP. Daemon OZ Server IP. Daemon OZ Server Port. Servlet OZ Server URL..... Step 3. Daemon OZ Server [Connect after save]. 'admin'. 398

399 Step 4 OZ Application Designer. OZ Application Designer. OZ Application Designer [Close Repository]. 399

400 OZ Application Designer User's Guide, OZC, OZF, OZS. [File] [Open] ( ). [File] [Open] (. ) Button Description

401 Option Description.. "ozp://", "ozpserver://". / 10, 20. :. "Max history count" conf/ozserverlist.xml. "MaxHistoryCount", "<SERVER Name=..." " MaxHistoryCount", "<LOCAL MaxHistoryCount="... [File] [Save Project] ( ) 401

402 OZ Application Designer User's Guide.. 402

403 . OZ Application Designer Drag & Drop [Upload to Repository] ' '. [Upload]. [Download]. 403

404 OZ Application Designer User's Guide ' ' [Download]. :. 404

405 ,,. Admin 'None',, BuiltIn RDB. 'OZ Enterprise Server Administrator's Guide'.,.,.,.. [Check In]. 405

406 OZ Application Designer User's Guide ' ' [Check In]. 'Keep checked out' [Check In].. : Admin 'None' Admin,. 406