{{ message }}
-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathdatatbl_lv.pls
More file actions
223 lines (195 loc) · 7.75 KB
/
Copy pathdatatbl_lv.pls
File metadata and controls
223 lines (195 loc) · 7.75 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
*---------------------------------------------------------------
.
. Program Name: datatbl_lv
. Description: Test DataTable ListView
.
. Revision History:
.
. <date> <programmer>
. Original code
.
INCLUDE plbequ.inc
INCLUDE plbmeth.inc
INCLUDE plbstdlib.inc
*---------------------------------------------------------------
Table1 DATATABLE
OrderRec RECORD
Id DIM 4
CustomerId DIM 5
ProductId DIM 3
OrderDate DIM 8
OrderTime DIM 8
Quantity DIM 5
RECORDEND
MainForm PLFORM datatbl_lvf.pwf
*................................................................
.
. Code start
.
CALL Main
LOOP
EVENTWAIT
REPEAT
STOP
*................................................................
.
. $ITEMACTIVATE Event
.
Do_Item LFUNCTION
ENTRY
EventResult FORM 10
Item FORM 5
SubItem FORM 5
InfoLine DIM 80
EVENTINFO 0,RESULT=EventResult
CALC Item = ( EventResult / 100 )
CALC SubItem = ( EventResult - ( Item * 100 ) )
PACK InfoLine with "Item Activate: ",Item, " Col: ", Subitem
DataList1.InsertString Using InfoLine,0
FUNCTIONEND
*................................................................
.
. $UPDATED Event
.
Do_Update LFUNCTION
ENTRY
EventResult FORM 10
Item FORM 5
SubItem FORM 5
InfoLine DIM 80
EVENTINFO 0,RESULT=EventResult
CALC Item = ( EventResult / 100 )
CALC SubItem = ( EventResult - ( Item * 100 ) )
PACK InfoLine with "Updated Row: ",Item, " Col: ", Subitem
DataList1.InsertString Using InfoLine,0
FUNCTIONEND
*................................................................
.
. $UPDATED Event
.
Do_ColClick LFUNCTION
ENTRY
ColumnNumber FORM 10
InfoLine DIM 80
EVENTINFO 0,RESULT=ColumnNumber
PACK InfoLine with "ColClick ", ColumnNumber
DataList1.InsertString Using InfoLine,0
CALL SortTable Using ColumnNumber
FUNCTIONEND
*................................................................
.
. $DBLCLICK Event
.
Do_DblClick LFUNCTION
ENTRY
EventResult FORM 10
InfoLine DIM 80
EVENTINFO 0,RESULT=EventResult
PACK InfoLine with "Double click on Row: ",EventResult
DataList1.InsertString Using InfoLine,0
FUNCTIONEND
*................................................................
.
. $CHANGE Event
.
Do_Change LFUNCTION
ENTRY
EventResult FORM 10
InfoLine DIM 80
EVENTINFO 0,RESULT=EventResult
PACK InfoLine with "Changed Row: ",EventResult
DataList1.InsertString Using InfoLine,0
FUNCTIONEND
*................................................................
.
. SetupTable
.
SetupTable LFUNCTION
ENTRY
SETPROP Table1, *Pagesize=10, *Context=$OC_PRIMARY
SETPROP TABLE1,*MULTISELECT=$OFF,*GRIDLINE=$ON,*CHECKBOX=$ON
Table1.AddColumn Using 0
Table1.AddColumn Using 1
Table1.AddColumn Using 2
Table1.AddColumn Using 3
Table1.AddColumn Using 4
Table1.AddColumn Using 5
SETPROP Table1.columns(0),*Title="Order Id", *WebWidth="40px", *ALIGNMENT=$LEFT
SETPROP Table1.columns(1),*Title="Customer Id", *WebWidth="80px", *ALIGNMENT=$CENTER
SETPROP Table1.columns(2),*Title="Product Id", *WebWidth="40px", *ALIGNMENT=$LEFT
SETPROP Table1.columns(3),*Title="Order Date", *WebWidth="80px", *ALIGNMENT=$CENTER
SETPROP Table1.columns(4),*Title="Order Time", *WebWidth="120px", *ALIGNMENT=$CENTER:
*DataType=$CDT_TIME, *ContentType=$TC_EDITABLE,COMPUTE="CURTIME"
SETPROP Table1.columns(5),*Title="Quantity", *WebWidth="80px", *ALIGNMENT=$RIGHT:
*DataType=$CDT_DECIMAL, *ContentType=$TC_EDITABLE
EVENTREG Table1,$ITEMACTIVATE,Do_Item
EVENTREG Table1,$DBLCLICK,Do_DblClick
EVENTREG Table1,$UPDATED,Do_Update
EVENTREG Table1,$COLCLICK,Do_ColClick
EVENTREG Table1,$CHANGE,Do_Change
FUNCTIONEND
*................................................................
.
. LoadTable
.
LoadTable LFUNCTION
ENTRY
Orders FILE
Seq FORM "-1"
Table1.DeleteAllRows
OPEN Orders,"orders.txt"
LOOP
READ Orders,Seq;OrderRec
UNTIL OVER
REPLACE " 0" IN OrderRec.OrderTime
IF (OrderRec.Id == " 1")
Table1.AddRow USING OrderRec.Id:
*subitem1=OrderRec.CustomerId:
*subitem2=OrderRec.ProductId:
*subitem3=OrderRec.OrderDate:
*subitem4=OrderRec.OrderTime:
*subitem5=OrderRec.Quantity, *Context=$OC_DANGER
ELSE
Table1.AddRow USING OrderRec.Id:
*subitem1=OrderRec.CustomerId:
*subitem2=OrderRec.ProductId:
*subitem3=OrderRec.OrderDate:
*subitem4=OrderRec.OrderTime:
*subitem5=OrderRec.Quantity
ENDIF
REPEAT
CLOSE Orders
CALL SortTable Using "0"
FUNCTIONEND
*................................................................
.
. SortTable
.
SortTable LFUNCTION
ColumnNumber FORM 2
ENTRY
IF ( ColumnNumber = 0 )
Table1.Sort USING ColumnNumber,1,*COL1=2
ELSEIF ( ColumnNumber = 1 )
Table1.Sort USING ColumnNumber,1,*COL1=0:
*COL2=2
ELSEIF ( ColumnNumber = 3 )
Table1.Sort USING ColumnNumber,5,"mm/dd/yy":
*Col1=2,*Type1=3
ELSE
Table1.Sort USING ColumnNumber,1,*Col1=0
ENDIF
FUNCTIONEND
*................................................................
.
. Main - Main program entry point
.
Main LFUNCTION
ENTRY
WINHIDE
CREATE Table1, *Striped=$ON,*Transaction=$OFF
FORMLOAD MainForm
CALL SetupTable
CALL LoadTable
Table1.HtmlBind Using HtmlTable, $HTML_STYLE_LISTVIEW
FUNCTIONEND
You can’t perform that action at this time.