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