| 1 |
|
|---|
| 2 | {ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 3 | º º
|
|---|
| 4 | º Sibyl Portable Component Classes º
|
|---|
| 5 | º º
|
|---|
| 6 | º Copyright (C) 1995,97 SpeedSoft Germany, All rights reserved. º
|
|---|
| 7 | º º
|
|---|
| 8 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ}
|
|---|
| 9 |
|
|---|
| 10 | Unit DBCtrls;
|
|---|
| 11 |
|
|---|
| 12 |
|
|---|
| 13 | Interface
|
|---|
| 14 |
|
|---|
| 15 | {$R DBCtrls}
|
|---|
| 16 |
|
|---|
| 17 | Uses SysUtils,Classes,Forms,Grids,DBBase,Buttons,StdCtrls,Dialogs,ExtCtrls,Mask;
|
|---|
| 18 |
|
|---|
| 19 | Type
|
|---|
| 20 | {$M+}
|
|---|
| 21 | TDBGridOptions = Set Of
|
|---|
| 22 | (dgBorder,dgRowResize,dgColumnResize,dgEditing,dgAlwaysShowEditor,
|
|---|
| 23 | dgShowSelection,dgAlwaysShowSelection,dgConfirmDelete,
|
|---|
| 24 | dgCancelOnExit,dgIndicator,dgTitles,dgMouseSelect,dgLineNumbers,
|
|---|
| 25 | dgEnableMaskEdit);
|
|---|
| 26 | {$M-}
|
|---|
| 27 |
|
|---|
| 28 | TDBGrid=Class;
|
|---|
| 29 | TDBGridColumn=Class;
|
|---|
| 30 | TDBGridColumns=Class;
|
|---|
| 31 |
|
|---|
| 32 | TDBColumnTitle=Class
|
|---|
| 33 | Private
|
|---|
| 34 | FCaption:^String;
|
|---|
| 35 | FAlignment:TAlignment;
|
|---|
| 36 | FFont:TFont;
|
|---|
| 37 | FColor:TColor;
|
|---|
| 38 | FGrid:TDBGrid;
|
|---|
| 39 | FColumn:TDBGridColumn;
|
|---|
| 40 | FPenColor:TColor;
|
|---|
| 41 | Private
|
|---|
| 42 | Function GetFont:TFont;
|
|---|
| 43 | Procedure SetFont(NewFont:TFont);
|
|---|
| 44 | Procedure SetColor(NewColor:TColor);
|
|---|
| 45 | Procedure SetPenColor(NewColor:TColor);
|
|---|
| 46 | Procedure SetAlignment(NewValue:TAlignment);
|
|---|
| 47 | Function GetCaption:String;
|
|---|
| 48 | Procedure SetCaption(Const NewValue:String);
|
|---|
| 49 | Public
|
|---|
| 50 | Constructor Create(DBGrid:TDBGrid;Column:TDBGridColumn);
|
|---|
| 51 | Destructor Destroy;Override;
|
|---|
| 52 | Public
|
|---|
| 53 | Property Font:TFont Read GetFont Write SetFont;
|
|---|
| 54 | Property Color:TColor Read FColor Write SetColor;
|
|---|
| 55 | Property PenColor:TColor Read FPenColor Write SetPenColor;
|
|---|
| 56 | Property Alignment:TAlignment Read FAlignment Write SetAlignment;
|
|---|
| 57 | Property Caption:String Read GetCaption Write SetCaption;
|
|---|
| 58 | End;
|
|---|
| 59 |
|
|---|
| 60 | TDBGridColumn=Class
|
|---|
| 61 | Private
|
|---|
| 62 | FFieldName:^String;
|
|---|
| 63 | FTitle:TDBColumnTitle;
|
|---|
| 64 | FColor:TColor;
|
|---|
| 65 | FGrid:TDBGrid;
|
|---|
| 66 | FColumns:TDBGridColumns;
|
|---|
| 67 | FWidth:LongInt;
|
|---|
| 68 | FAlignment:TAlignment;
|
|---|
| 69 | FReadOnly:Boolean;
|
|---|
| 70 | FFont:TFont;
|
|---|
| 71 | FPenColor:TColor;
|
|---|
| 72 | Private
|
|---|
| 73 | Function GetFieldName:String;
|
|---|
| 74 | Procedure SetFieldName(Const NewValue:String);
|
|---|
| 75 | Procedure SetTitle(NewTitle:TDBColumnTitle);
|
|---|
| 76 | Procedure SetColor(NewColor:TColor);
|
|---|
| 77 | Procedure SetPenColor(NewColor:TColor);
|
|---|
| 78 | Function GetWidth:LongInt;
|
|---|
| 79 | Procedure SetWidth(NewWidth:LongInt);
|
|---|
| 80 | Procedure SetAlignment(NewValue:TAlignment);
|
|---|
| 81 | Function GetFont:TFont;
|
|---|
| 82 | Procedure SetFont(NewFont:TFont);
|
|---|
| 83 | Public
|
|---|
| 84 | Constructor Create(DBGrid:TDBGrid;Columns:TDBGridColumns);
|
|---|
| 85 | Destructor Destroy;Override;
|
|---|
| 86 | Public
|
|---|
| 87 | Property FieldName:String Read GetFieldName Write SetFieldName;
|
|---|
| 88 | Property Title:TDBColumnTitle Read FTitle Write SetTitle;
|
|---|
| 89 | Property Color:TColor Read FColor Write SetColor;
|
|---|
| 90 | Property PenColor:TColor Read FPenColor Write SetPenColor;
|
|---|
| 91 | Property Width:LongInt Read GetWidth Write SetWidth;
|
|---|
| 92 | Property Alignment:TAlignment Read FAlignment Write SetAlignment;
|
|---|
| 93 | Property ReadOnly:Boolean Read FReadOnly Write FReadOnly;
|
|---|
| 94 | Property Font:TFont Read GetFont Write SetFont;
|
|---|
| 95 | End;
|
|---|
| 96 |
|
|---|
| 97 | {$HINTS OFF}
|
|---|
| 98 | TDBGridColumns=Class(TList)
|
|---|
| 99 | Private
|
|---|
| 100 | FAutoCreated:Boolean;
|
|---|
| 101 | FGrid:TDBGrid;
|
|---|
| 102 | FUpdateLocked:Boolean;
|
|---|
| 103 | Private
|
|---|
| 104 | Function GetColumn(Index:LongInt):TDBGridColumn;
|
|---|
| 105 | Procedure SetColumn(Index:LongInt;Column:TDBGridColumn);
|
|---|
| 106 | Protected
|
|---|
| 107 | Procedure FreeItem(Item:Pointer);Override;
|
|---|
| 108 | Public
|
|---|
| 109 | Constructor Create(DBGrid:TDBGrid);
|
|---|
| 110 | Destructor Destroy;Override;
|
|---|
| 111 | Function Add:TDBGridColumn;
|
|---|
| 112 | Procedure Delete(Index:LongInt);
|
|---|
| 113 | Procedure BeginUpdate;
|
|---|
| 114 | Procedure EndUpdate;
|
|---|
| 115 | Public
|
|---|
| 116 | Property AutoCreated:Boolean Read FAutoCreated;
|
|---|
| 117 | Property Items[Index:LongInt]:TDBGridColumn Read GetColumn Write SetColumn;Default;
|
|---|
| 118 | Property Grid:TDBGrid Read FGrid;
|
|---|
| 119 | End;
|
|---|
| 120 | {$HINTS ON}
|
|---|
| 121 |
|
|---|
| 122 | TDBGrid=Class(TStringGrid)
|
|---|
| 123 | Private
|
|---|
| 124 | FDataLink:TTableDataLink;
|
|---|
| 125 | FGridOptions:TDBGridOptions;
|
|---|
| 126 | FColumns:TDBGridColumns;
|
|---|
| 127 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 128 | Function GetDataSource:TDataSource;
|
|---|
| 129 | Procedure SetGridOptions(NewValue:TDBGridOptions);
|
|---|
| 130 | Procedure SetColumns(NewColumns:TDBGridColumns);
|
|---|
| 131 | Protected
|
|---|
| 132 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 133 | Procedure SetFont(NewFont:TFont);Override;
|
|---|
| 134 | Procedure Scroll(ScrollBar:TScrollBar;ScrollCode:TScrollCode;Var ScrollPos:LongInt);Override;
|
|---|
| 135 | Procedure SetupComponent;Override;
|
|---|
| 136 | Function GetCell(Col,Row:LongInt):String;Override;
|
|---|
| 137 | Procedure SetCell(Col,Row:LongInt;Const NewContent:String);Override;
|
|---|
| 138 | Function SelectCell(Col,Row:LongInt):Boolean;Override;
|
|---|
| 139 | Procedure SetupCellDrawing(Col,Row:LongInt;AState:TGridDrawState;
|
|---|
| 140 | Var Alignment:TAlignment;Var DrawFont:TFont);Override;
|
|---|
| 141 | Procedure SetupCellColors(Col,Row:LongInt;AState:TGridDrawState;Var background,ForeGround:TColor);Override;
|
|---|
| 142 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 143 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 144 | Procedure RowHeightChanged(Row:LongInt);Override;
|
|---|
| 145 | Procedure ColWidthChanged(Col:LongInt);Override;
|
|---|
| 146 | Function ShowEditor(Col,Row:LongInt):TInplaceEditClass;Override;
|
|---|
| 147 | Protected
|
|---|
| 148 | Property FixedCols;
|
|---|
| 149 | Property FixedRows;
|
|---|
| 150 | Property ColCount;
|
|---|
| 151 | Property RowCount;
|
|---|
| 152 | Property Options;
|
|---|
| 153 | Public
|
|---|
| 154 | Destructor Destroy;Override;
|
|---|
| 155 | Procedure DrawCell(Col,Row:LongInt;rec:TRect;AState:TGridDrawState);Override;
|
|---|
| 156 | Published
|
|---|
| 157 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 158 | Property GridOptions:TDBGridOptions Read FGridOptions Write SetGridOptions;
|
|---|
| 159 | Property Columns:TDBGridColumns Read FColumns Write SetColumns;
|
|---|
| 160 | End;
|
|---|
| 161 |
|
|---|
| 162 | TDBEdit=Class(TEdit)
|
|---|
| 163 | Private
|
|---|
| 164 | FDataLink:TFieldDataLink;
|
|---|
| 165 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 166 | Function GetDataSource:TDataSource;
|
|---|
| 167 | Procedure SetDataField(NewValue:String);
|
|---|
| 168 | Function GetDataField:String;
|
|---|
| 169 | Procedure WriteBack;
|
|---|
| 170 | Protected
|
|---|
| 171 | Procedure SetupComponent;Override;
|
|---|
| 172 | Procedure SetupShow;Override;
|
|---|
| 173 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 174 | Procedure KillFocus;Override;
|
|---|
| 175 | Procedure ScanEvent(Var KeyCode:TKeyCode;RepeatCount:Byte);Override;
|
|---|
| 176 | Public
|
|---|
| 177 | Destructor Destroy;Override;
|
|---|
| 178 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 179 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 180 | Published
|
|---|
| 181 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 182 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 183 | End;
|
|---|
| 184 |
|
|---|
| 185 | TDBText=Class(TLabel)
|
|---|
| 186 | Private
|
|---|
| 187 | FDataLink:TFieldDataLink;
|
|---|
| 188 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 189 | Function GetDataSource:TDataSource;
|
|---|
| 190 | Procedure SetDataField(NewValue:String);
|
|---|
| 191 | Function GetDataField:String;
|
|---|
| 192 | Protected
|
|---|
| 193 | Procedure SetupComponent;Override;
|
|---|
| 194 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 195 | Procedure SetupShow;Override;
|
|---|
| 196 | Public
|
|---|
| 197 | Destructor Destroy;Override;
|
|---|
| 198 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 199 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 200 | Published
|
|---|
| 201 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 202 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 203 | End;
|
|---|
| 204 |
|
|---|
| 205 | TDBCheckBox=Class(TCheckBox)
|
|---|
| 206 | Private
|
|---|
| 207 | FDataLink:TFieldDataLink;
|
|---|
| 208 | FValueChecked:PString;
|
|---|
| 209 | FValueUnchecked:PString;
|
|---|
| 210 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 211 | Function GetDataSource:TDataSource;
|
|---|
| 212 | Procedure SetDataField(NewValue:String);
|
|---|
| 213 | Function GetDataField:String;
|
|---|
| 214 | Procedure SetValueChecked(NewValue:String);
|
|---|
| 215 | Function GetValueChecked:String;
|
|---|
| 216 | Procedure SetValueUnchecked(NewValue:String);
|
|---|
| 217 | Function GetValueUnchecked:String;
|
|---|
| 218 | Procedure WriteBack;
|
|---|
| 219 | Protected
|
|---|
| 220 | Procedure SetupComponent;Override;
|
|---|
| 221 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 222 | Procedure SetupShow;Override;
|
|---|
| 223 | Procedure Click;Override;
|
|---|
| 224 | Public
|
|---|
| 225 | Destructor Destroy;Override;
|
|---|
| 226 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 227 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 228 | Published
|
|---|
| 229 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 230 | Property ValueChecked:String Read GetValueChecked Write SetValueChecked;
|
|---|
| 231 | Property ValueUnchecked:String Read GetValueUnchecked Write SetValueUnchecked;
|
|---|
| 232 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 233 | End;
|
|---|
| 234 |
|
|---|
| 235 |
|
|---|
| 236 | TDBImage=Class(TImage)
|
|---|
| 237 | Private
|
|---|
| 238 | FDataLink:TFieldDataLink;
|
|---|
| 239 | FChangeLock:Boolean;
|
|---|
| 240 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 241 | Function GetDataSource:TDataSource;
|
|---|
| 242 | Procedure SetDataField(NewValue:String);
|
|---|
| 243 | Function GetDataField:String;
|
|---|
| 244 | Procedure WriteBack;
|
|---|
| 245 | Protected
|
|---|
| 246 | Procedure SetupComponent;Override;
|
|---|
| 247 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 248 | Procedure SetupShow;Override;
|
|---|
| 249 | Procedure Change;Override;
|
|---|
| 250 | Public
|
|---|
| 251 | Destructor Destroy;Override;
|
|---|
| 252 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 253 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 254 | Property Bitmap;
|
|---|
| 255 | Published
|
|---|
| 256 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 257 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 258 | End;
|
|---|
| 259 |
|
|---|
| 260 |
|
|---|
| 261 | TDBMemo=Class(TMemo)
|
|---|
| 262 | Private
|
|---|
| 263 | FDataLink:TFieldDataLink;
|
|---|
| 264 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 265 | Function GetDataSource:TDataSource;
|
|---|
| 266 | Procedure SetDataField(NewValue:String);
|
|---|
| 267 | Function GetDataField:String;
|
|---|
| 268 | Procedure WriteBack;
|
|---|
| 269 | Protected
|
|---|
| 270 | Procedure SetupComponent;Override;
|
|---|
| 271 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 272 | Procedure SetupShow;Override;
|
|---|
| 273 | Procedure KillFocus;Override;
|
|---|
| 274 | Public
|
|---|
| 275 | Destructor Destroy;Override;
|
|---|
| 276 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 277 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 278 | Published
|
|---|
| 279 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 280 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 281 | End;
|
|---|
| 282 |
|
|---|
| 283 | {$HINTS OFF}
|
|---|
| 284 | TDBListBox=Class(TListBox)
|
|---|
| 285 | Private
|
|---|
| 286 | FDataLink:TFieldDataLink;
|
|---|
| 287 | FDBStrings:TStrings;
|
|---|
| 288 | Private
|
|---|
| 289 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 290 | Function GetDataSource:TDataSource;
|
|---|
| 291 | Procedure SetDataField(NewValue:String);
|
|---|
| 292 | Function GetDataField:String;
|
|---|
| 293 | Procedure SetItems(NewValue:TStrings);
|
|---|
| 294 | Protected
|
|---|
| 295 | Procedure SetupComponent;Override;
|
|---|
| 296 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 297 | Procedure SetupShow;Override;
|
|---|
| 298 | Procedure ItemFocus(Index:LongInt);Override;
|
|---|
| 299 | Public
|
|---|
| 300 | Destructor Destroy;Override;
|
|---|
| 301 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 302 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 303 | Public
|
|---|
| 304 | Property Items:TStrings Read FDBStrings Write SetItems;
|
|---|
| 305 | Published
|
|---|
| 306 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 307 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 308 | End;
|
|---|
| 309 | {$HINTS ON}
|
|---|
| 310 |
|
|---|
| 311 | TDBComboBox=Class(TComboBox)
|
|---|
| 312 | Private
|
|---|
| 313 | FDataLink:TFieldDataLink;
|
|---|
| 314 | FLock:Boolean;
|
|---|
| 315 | Private
|
|---|
| 316 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 317 | Function GetDataSource:TDataSource;
|
|---|
| 318 | Procedure SetDataField(NewValue:String);
|
|---|
| 319 | Function GetDataField:String;
|
|---|
| 320 | Procedure WriteBack;
|
|---|
| 321 | Protected
|
|---|
| 322 | Procedure EditChange;Override;
|
|---|
| 323 | Procedure SetupShow;Override;
|
|---|
| 324 | Procedure SetupComponent;Override;
|
|---|
| 325 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 326 | Public
|
|---|
| 327 | Destructor Destroy;Override;
|
|---|
| 328 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 329 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 330 | Published
|
|---|
| 331 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 332 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 333 | End;
|
|---|
| 334 |
|
|---|
| 335 | TDBRadioGroup=Class(TRadioGroup)
|
|---|
| 336 | Private
|
|---|
| 337 | FDataLink:TFieldDataLink;
|
|---|
| 338 | FValues:TStrings;
|
|---|
| 339 | FLock:Boolean;
|
|---|
| 340 | Private
|
|---|
| 341 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 342 | Function GetDataSource:TDataSource;
|
|---|
| 343 | Procedure SetDataField(NewValue:String);
|
|---|
| 344 | Function GetDataField:String;
|
|---|
| 345 | Function GetValue:String;
|
|---|
| 346 | Procedure SetValue(Const NewValue:String);
|
|---|
| 347 | Procedure SetValues(NewValue:TStrings);
|
|---|
| 348 | Procedure WriteBack;
|
|---|
| 349 | Protected
|
|---|
| 350 | Procedure SetupShow;Override;
|
|---|
| 351 | Procedure SetupComponent;Override;
|
|---|
| 352 | Procedure DataChange(Sender:TObject;event:TDataChange);Virtual;
|
|---|
| 353 | Procedure ItemIndexChange;Override;
|
|---|
| 354 | Public
|
|---|
| 355 | Destructor Destroy;Override;
|
|---|
| 356 | Function WriteSCUResource(Stream:TResourceStream):Boolean;Override;
|
|---|
| 357 | Procedure ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);Override;
|
|---|
| 358 | Public
|
|---|
| 359 | Property Value:String Read GetValue Write SetValue;
|
|---|
| 360 | Property Values:TStrings Read FValues Write SetValues;
|
|---|
| 361 | Published
|
|---|
| 362 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 363 | Property DataField:String Read GetDataField Write SetDataField;
|
|---|
| 364 | End;
|
|---|
| 365 |
|
|---|
| 366 | {$M+}
|
|---|
| 367 | TNavigateBtn=(dbFirst, dbPrior, dbNext, dbLast, dbInsert,
|
|---|
| 368 | dbDelete, dbEdit, dbPost, dbCancel, dbRefresh);
|
|---|
| 369 | TNavigateBtnSet=Set Of TNavigateBtn;
|
|---|
| 370 |
|
|---|
| 371 | TNavClick=Procedure(Sender:TObject;Button:TNavigateBtn) Of Object;
|
|---|
| 372 | {$M-}
|
|---|
| 373 |
|
|---|
| 374 | TDBNavigator=Class(TControl)
|
|---|
| 375 | Private
|
|---|
| 376 | FButtons:Array[TNavigateBtn] Of TBitBtn;
|
|---|
| 377 | FVisibleButtons:TNavigateBtnSet;
|
|---|
| 378 | FEnabledButtons:TNavigateBtnSet;
|
|---|
| 379 | FDataLink:TTableDataLink;
|
|---|
| 380 | FOnNavClick:TNavClick;
|
|---|
| 381 | Procedure SetVisibleButtons(NewState:TNavigateBtnSet);
|
|---|
| 382 | Procedure SetEnabledButtons(NewState:TNavigateBtnSet);
|
|---|
| 383 | Function GetButton(Index:TNavigateBtn):TBitBtn;
|
|---|
| 384 | Function GetDataSource:TDataSource;
|
|---|
| 385 | Procedure SetDataSource(NewValue:TDataSource);
|
|---|
| 386 | Procedure EvButtonClick(Sender:TObject);
|
|---|
| 387 | Protected
|
|---|
| 388 | Procedure CommandEvent(Var Command:TCommand);Override;
|
|---|
| 389 | Procedure SetupComponent;Override;
|
|---|
| 390 | Procedure CreateWnd;Override;
|
|---|
| 391 | Procedure RealignControls;Override;
|
|---|
| 392 | Property Buttons[Index:TNavigateBtn]:TBitBtn Read GetButton;
|
|---|
| 393 | Property Hint;
|
|---|
| 394 | Property Cursor;
|
|---|
| 395 | Public
|
|---|
| 396 | Destructor Destroy;Override;
|
|---|
| 397 | Property XAlign;
|
|---|
| 398 | Property XStretch;
|
|---|
| 399 | Property YAlign;
|
|---|
| 400 | Property YStretch;
|
|---|
| 401 | Published
|
|---|
| 402 | Property Align;
|
|---|
| 403 | Property DataSource:TDataSource Read GetDataSource Write SetDataSource;
|
|---|
| 404 | Property DragCursor;
|
|---|
| 405 | Property DragMode;
|
|---|
| 406 | Property Enabled;
|
|---|
| 407 | Property EnabledButtons:TNavigateBtnSet Read FEnabledButtons Write SetEnabledButtons;
|
|---|
| 408 | Property ParentShowHint;
|
|---|
| 409 | Property ShowHint;
|
|---|
| 410 | Property TabOrder;
|
|---|
| 411 | Property TabStop;
|
|---|
| 412 | Property Visible;
|
|---|
| 413 | Property VisibleButtons:TNavigateBtnSet Read FVisibleButtons Write SetVisibleButtons;
|
|---|
| 414 | Property ZOrder;
|
|---|
| 415 |
|
|---|
| 416 | Property OnCanDrag;
|
|---|
| 417 | Property OnClick:TNavClick Read FOnNavClick Write FOnNavClick;
|
|---|
| 418 | Property OnDragDrop;
|
|---|
| 419 | Property OnDragOver;
|
|---|
| 420 | Property OnEndDrag;
|
|---|
| 421 | Property OnEnter;
|
|---|
| 422 | Property OnExit;
|
|---|
| 423 | Property OnMouseMove;
|
|---|
| 424 | Property OnResize;
|
|---|
| 425 | Property OnSetupShow;
|
|---|
| 426 | Property OnStartDrag;
|
|---|
| 427 | End;
|
|---|
| 428 |
|
|---|
| 429 |
|
|---|
| 430 | Implementation
|
|---|
| 431 |
|
|---|
| 432 | {
|
|---|
| 433 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 434 | º º
|
|---|
| 435 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 436 | º º
|
|---|
| 437 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 438 | º º
|
|---|
| 439 | º This section: TDBGridColumns Class Implementation º
|
|---|
| 440 | º º
|
|---|
| 441 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 442 | º º
|
|---|
| 443 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 444 | }
|
|---|
| 445 |
|
|---|
| 446 |
|
|---|
| 447 | Procedure TDBGridColumns.BeginUpdate;
|
|---|
| 448 | Begin
|
|---|
| 449 | FUpdateLocked:=True;
|
|---|
| 450 | End;
|
|---|
| 451 |
|
|---|
| 452 | Procedure TDBGridColumns.EndUpdate;
|
|---|
| 453 | Begin
|
|---|
| 454 | FUpdateLocked:=False;
|
|---|
| 455 | If FGrid<>Nil Then
|
|---|
| 456 | If FGrid.FColumns=Self Then FGrid.Invalidate;
|
|---|
| 457 | End;
|
|---|
| 458 |
|
|---|
| 459 | Function TDBGridColumns.GetColumn(Index:LongInt):TDBGridColumn;
|
|---|
| 460 | Begin
|
|---|
| 461 | Result:=TDBGridColumn(Inherited Items[Index]);
|
|---|
| 462 | End;
|
|---|
| 463 |
|
|---|
| 464 | Procedure TDBGridColumns.SetColumn(Index:LongInt;Column:TDBGridColumn);
|
|---|
| 465 | Var OldColumn:TDBGridColumn;
|
|---|
| 466 | Begin
|
|---|
| 467 | OldColumn:=Items[Index];
|
|---|
| 468 | If OldColumn<>Column Then OldColumn.Destroy;
|
|---|
| 469 |
|
|---|
| 470 | Inherited Items[Index]:=Column;
|
|---|
| 471 | End;
|
|---|
| 472 |
|
|---|
| 473 | Procedure TDBGridColumns.FreeItem(Item:Pointer);
|
|---|
| 474 | Var Column:TDBGridColumn;
|
|---|
| 475 | Begin
|
|---|
| 476 | Inherited FreeItem(Item);
|
|---|
| 477 | Column:=Item;
|
|---|
| 478 | If Column<>Nil Then Column.Destroy;
|
|---|
| 479 | End;
|
|---|
| 480 |
|
|---|
| 481 | Function TDBGridColumns.Add:TDBGridColumn;
|
|---|
| 482 | Begin
|
|---|
| 483 | Result.Create(FGrid,Self);
|
|---|
| 484 | Inherited Add(Result);
|
|---|
| 485 | End;
|
|---|
| 486 |
|
|---|
| 487 | Procedure TDBGridColumns.Delete(Index:LongInt);
|
|---|
| 488 | Begin
|
|---|
| 489 | Inherited Delete(Index);
|
|---|
| 490 | If FGrid<>Nil Then If Not FUpdateLocked Then
|
|---|
| 491 | If FGrid.FColumns=Self Then FGrid.Invalidate;
|
|---|
| 492 | End;
|
|---|
| 493 |
|
|---|
| 494 | Constructor TDBGridColumns.Create(DBGrid:TDBGrid);
|
|---|
| 495 | Begin
|
|---|
| 496 | Inherited Create;
|
|---|
| 497 | FGrid:=DBGrid;
|
|---|
| 498 | End;
|
|---|
| 499 |
|
|---|
| 500 | Destructor TDBGridColumns.Destroy;
|
|---|
| 501 | Begin
|
|---|
| 502 | If FGrid<>Nil Then
|
|---|
| 503 | If FGrid.FColumns=Self Then FGrid.FColumns:=Nil;
|
|---|
| 504 | Inherited Destroy;
|
|---|
| 505 | End;
|
|---|
| 506 |
|
|---|
| 507 | {
|
|---|
| 508 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 509 | º º
|
|---|
| 510 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 511 | º º
|
|---|
| 512 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 513 | º º
|
|---|
| 514 | º This section: TDBGridColumn Class Implementation º
|
|---|
| 515 | º º
|
|---|
| 516 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 517 | º º
|
|---|
| 518 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 519 | }
|
|---|
| 520 |
|
|---|
| 521 | Function TDBGridColumn.GetFieldName:String;
|
|---|
| 522 | Begin
|
|---|
| 523 | If FFieldName<>Nil Then Result:=FFieldName^
|
|---|
| 524 | Else Result:='';
|
|---|
| 525 | End;
|
|---|
| 526 |
|
|---|
| 527 | Procedure TDBGridColumn.SetFieldName(Const NewValue:String);
|
|---|
| 528 | Begin
|
|---|
| 529 | If FFieldName<>Nil Then FreeMem(FFieldName,Length(FFieldName^)+1);
|
|---|
| 530 | GetMem(FFieldName,Length(NewValue)+1);
|
|---|
| 531 | FFieldName^:=NewValue;
|
|---|
| 532 | If FColumns<>Nil Then
|
|---|
| 533 | If Not FColumns.FUpdateLocked Then
|
|---|
| 534 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 535 | End;
|
|---|
| 536 |
|
|---|
| 537 | Procedure TDBGridColumn.SetTitle(NewTitle:TDBColumnTitle);
|
|---|
| 538 | Begin
|
|---|
| 539 | If NewTitle<>FTitle Then FTitle.Destroy;
|
|---|
| 540 | FTitle:=NewTitle;
|
|---|
| 541 | If FTitle=Nil Then FTitle.Create(FGrid,Self);
|
|---|
| 542 | FTitle.FGrid:=FGrid;
|
|---|
| 543 | If FColumns<>Nil Then
|
|---|
| 544 | If Not FColumns.FUpdateLocked Then
|
|---|
| 545 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 546 | End;
|
|---|
| 547 |
|
|---|
| 548 | Procedure TDBGridColumn.SetColor(NewColor:TColor);
|
|---|
| 549 | Begin
|
|---|
| 550 | FColor:=NewColor;
|
|---|
| 551 | If FColumns<>Nil Then
|
|---|
| 552 | If Not FColumns.FUpdateLocked Then
|
|---|
| 553 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 554 | End;
|
|---|
| 555 |
|
|---|
| 556 | Procedure TDBGridColumn.SetPenColor(NewColor:TColor);
|
|---|
| 557 | Begin
|
|---|
| 558 | FPenColor:=NewColor;
|
|---|
| 559 | If FColumns<>Nil Then
|
|---|
| 560 | If Not FColumns.FUpdateLocked Then
|
|---|
| 561 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 562 | End;
|
|---|
| 563 |
|
|---|
| 564 | Function TDBGridColumn.GetWidth:LongInt;
|
|---|
| 565 | Begin
|
|---|
| 566 | If FGrid.Columns<>Nil Then
|
|---|
| 567 | If FGrid.Columns.IndexOf(Self)>=0 Then
|
|---|
| 568 | Result:=FGrid.ColWidths[FGrid.FColumns.IndexOf(Self)+FGrid.FixedCols];
|
|---|
| 569 | End;
|
|---|
| 570 |
|
|---|
| 571 | Procedure TDBGridColumn.SetWidth(NewWidth:LongInt);
|
|---|
| 572 | Begin
|
|---|
| 573 | If FGrid.Columns<>Nil Then
|
|---|
| 574 | If FGrid.Columns.IndexOf(Self)>=0 Then
|
|---|
| 575 | FGrid.ColWidths[FGrid.FColumns.IndexOf(Self)+FGrid.FixedCols]:=NewWidth;
|
|---|
| 576 | End;
|
|---|
| 577 |
|
|---|
| 578 | Procedure TDBGridColumn.SetAlignment(NewValue:TAlignment);
|
|---|
| 579 | Begin
|
|---|
| 580 | FAlignment:=NewValue;
|
|---|
| 581 | If FColumns<>Nil Then
|
|---|
| 582 | If Not FColumns.FUpdateLocked Then
|
|---|
| 583 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 584 | End;
|
|---|
| 585 |
|
|---|
| 586 | Function TDBGridColumn.GetFont:TFont;
|
|---|
| 587 | Begin
|
|---|
| 588 | If FFont<>Nil Then Result:=FFont
|
|---|
| 589 | Else Result:=FGrid.Font;
|
|---|
| 590 | End;
|
|---|
| 591 |
|
|---|
| 592 | Procedure TDBGridColumn.SetFont(NewFont:TFont);
|
|---|
| 593 | Begin
|
|---|
| 594 | If NewFont=FFont Then Exit;
|
|---|
| 595 | FFont:=NewFont;
|
|---|
| 596 | If FColumns<>Nil Then
|
|---|
| 597 | If Not FColumns.FUpdateLocked Then
|
|---|
| 598 | If FGrid.FColumns=FColumns Then FGrid.Invalidate;
|
|---|
| 599 | End;
|
|---|
| 600 |
|
|---|
| 601 | {$HINTS OFF}
|
|---|
| 602 | Constructor TDBGridColumn.Create(DBGrid:TDBGrid;Columns:TDBGridColumn);
|
|---|
| 603 | Begin
|
|---|
| 604 | Inherited Create;
|
|---|
| 605 | FGrid:=DBGrid;
|
|---|
| 606 | FTitle.Create(FGrid,Self);
|
|---|
| 607 | FColor:=FGrid.EntryColor;
|
|---|
| 608 | FPenColor:=FGrid.PenColor;
|
|---|
| 609 | FWidth:=40;
|
|---|
| 610 | FAlignment:=taLeftJustify;
|
|---|
| 611 | End;
|
|---|
| 612 | {$HINTS ON}
|
|---|
| 613 |
|
|---|
| 614 | Destructor TDBGridColumn.Destroy;
|
|---|
| 615 | Begin
|
|---|
| 616 | If FFieldName<>Nil Then FreeMem(FFieldName,Length(FFieldName^)+1);
|
|---|
| 617 | If FTitle<>Nil Then FTitle.Destroy;
|
|---|
| 618 | End;
|
|---|
| 619 |
|
|---|
| 620 | {
|
|---|
| 621 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 622 | º º
|
|---|
| 623 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 624 | º º
|
|---|
| 625 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 626 | º º
|
|---|
| 627 | º This section: TDBColumnTitle Class Implementation º
|
|---|
| 628 | º º
|
|---|
| 629 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 630 | º º
|
|---|
| 631 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 632 | }
|
|---|
| 633 |
|
|---|
| 634 | Function TDBColumnTitle.GetFont:TFont;
|
|---|
| 635 | Begin
|
|---|
| 636 | If FFont<>Nil Then Result:=FFont
|
|---|
| 637 | Else Result:=FGrid.Font;
|
|---|
| 638 | End;
|
|---|
| 639 |
|
|---|
| 640 | Procedure TDBColumnTitle.SetFont(NewFont:TFont);
|
|---|
| 641 | Begin
|
|---|
| 642 | If NewFont=FFont Then Exit;
|
|---|
| 643 | FFont:=NewFont;
|
|---|
| 644 | If FColumn.FColumns<>Nil Then
|
|---|
| 645 | If Not FColumn.FColumns.FUpdateLocked Then
|
|---|
| 646 | If FGrid.FColumns=FColumn.FColumns Then FGrid.Invalidate;
|
|---|
| 647 | End;
|
|---|
| 648 |
|
|---|
| 649 | Procedure TDBColumnTitle.SetColor(NewColor:TColor);
|
|---|
| 650 | Begin
|
|---|
| 651 | FColor:=NewColor;
|
|---|
| 652 | If FColumn.FColumns<>Nil Then
|
|---|
| 653 | If Not FColumn.FColumns.FUpdateLocked Then
|
|---|
| 654 | If FGrid.FColumns=FColumn.FColumns Then FGrid.Invalidate;
|
|---|
| 655 | End;
|
|---|
| 656 |
|
|---|
| 657 | Procedure TDBColumnTitle.SetPenColor(NewColor:TColor);
|
|---|
| 658 | Begin
|
|---|
| 659 | FPenColor:=NewColor;
|
|---|
| 660 | If FColumn.FColumns<>Nil Then
|
|---|
| 661 | If Not FColumn.FColumns.FUpdateLocked Then
|
|---|
| 662 | If FGrid.FColumns=FColumn.FColumns Then FGrid.Invalidate;
|
|---|
| 663 | End;
|
|---|
| 664 |
|
|---|
| 665 | Procedure TDBColumnTitle.SetAlignment(NewValue:TAlignment);
|
|---|
| 666 | Begin
|
|---|
| 667 | FAlignment:=NewValue;
|
|---|
| 668 | If FColumn.FColumns<>Nil Then
|
|---|
| 669 | If Not FColumn.FColumns.FUpdateLocked Then
|
|---|
| 670 | If FGrid.FColumns=FColumn.FColumns Then FGrid.Invalidate;
|
|---|
| 671 | End;
|
|---|
| 672 |
|
|---|
| 673 | Constructor TDBColumnTitle.Create(DBGrid:TDBGrid;Column:TDBGridColumn);
|
|---|
| 674 | Begin
|
|---|
| 675 | Inherited Create;
|
|---|
| 676 |
|
|---|
| 677 | FGrid:=DBGrid;
|
|---|
| 678 | FColumn:=Column;
|
|---|
| 679 | FColor:=FGrid.FixedColor;
|
|---|
| 680 | FPenColor:=FGrid.PenColor;
|
|---|
| 681 | FAlignment:=taLeftJustify;
|
|---|
| 682 | End;
|
|---|
| 683 |
|
|---|
| 684 | Destructor TDBColumnTitle.Destroy;
|
|---|
| 685 | Begin
|
|---|
| 686 | If FCaption<>Nil Then FreeMem(FCaption,Length(FCaption^)+1);
|
|---|
| 687 | Inherited Destroy;
|
|---|
| 688 | End;
|
|---|
| 689 |
|
|---|
| 690 | Function TDBColumnTitle.GetCaption:String;
|
|---|
| 691 | Begin
|
|---|
| 692 | If FCaption<>Nil Then Result:=FCaption^
|
|---|
| 693 | Else Result:=FColumn.FieldName;
|
|---|
| 694 | End;
|
|---|
| 695 |
|
|---|
| 696 | Procedure TDBColumnTitle.SetCaption(Const NewValue:String);
|
|---|
| 697 | Begin
|
|---|
| 698 | If FCaption<>Nil Then FreeMem(FCaption,Length(FCaption^)+1);
|
|---|
| 699 | GetMem(FCaption,Length(NewValue)+1);
|
|---|
| 700 | FCaption^:=NewValue;
|
|---|
| 701 | If FColumn.FColumns<>Nil Then
|
|---|
| 702 | If Not FColumn.FColumns.FUpdateLocked Then
|
|---|
| 703 | If FGrid.FColumns=FColumn.FColumns Then FGrid.Invalidate;
|
|---|
| 704 | End;
|
|---|
| 705 |
|
|---|
| 706 | {
|
|---|
| 707 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 708 | º º
|
|---|
| 709 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 710 | º º
|
|---|
| 711 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 712 | º º
|
|---|
| 713 | º This section: TDBGrid Class Implementation º
|
|---|
| 714 | º º
|
|---|
| 715 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 716 | º º
|
|---|
| 717 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 718 | }
|
|---|
| 719 |
|
|---|
| 720 | Type TInplaceDBEdit=Class(TInplaceEdit)
|
|---|
| 721 | Protected
|
|---|
| 722 | FControl:TControl;
|
|---|
| 723 | FFieldType:TFieldType;
|
|---|
| 724 | Protected
|
|---|
| 725 | Function GetText:String;Override;
|
|---|
| 726 | Function GetControl:TComponent;Override;
|
|---|
| 727 | Procedure SetText(Const NewValue:String);Override;
|
|---|
| 728 | Procedure SetWindowPos(X,Y,W,H:LongInt);Override;
|
|---|
| 729 | Procedure SetupEdit(Grid:TGrid);Override;
|
|---|
| 730 | Destructor Destroy;Override;
|
|---|
| 731 | Procedure Show;Override;
|
|---|
| 732 | Procedure Hide;Override;
|
|---|
| 733 | End;
|
|---|
| 734 |
|
|---|
| 735 | Function TInplaceDBEdit.GetText:String;
|
|---|
| 736 | Begin
|
|---|
| 737 | Case FFieldType Of
|
|---|
| 738 | ftSmallInt,ftInteger,ftWord,ftFloat,ftCurrency:Result:=TEdit(FControl).Text;
|
|---|
| 739 | ftBoolean:Result:=TComboBox(FControl).Text;
|
|---|
| 740 | ftDate,ftTime,ftDateTime:Result:=TMaskEdit(FControl).Text;
|
|---|
| 741 | End; //case
|
|---|
| 742 | End;
|
|---|
| 743 |
|
|---|
| 744 | Function TInplaceDBEdit.GetControl:TComponent;
|
|---|
| 745 | Begin
|
|---|
| 746 | Result:=FControl;
|
|---|
| 747 | End;
|
|---|
| 748 |
|
|---|
| 749 | Procedure TInplaceDBEdit.SetText(Const NewValue:String);
|
|---|
| 750 | Begin
|
|---|
| 751 | Case FFieldType Of
|
|---|
| 752 | ftSmallInt,ftInteger,ftWord,ftFloat,ftCurrency:TEdit(FControl).Text:=NewValue;
|
|---|
| 753 | ftBoolean:TComboBox(FControl).Text:=NewValue;
|
|---|
| 754 | ftDate,ftTime,ftDateTime:TMaskEdit(FControl).Text:=NewValue;
|
|---|
| 755 | End; //case
|
|---|
| 756 | End;
|
|---|
| 757 |
|
|---|
| 758 | Procedure TInplaceDBEdit.SetWindowPos(X,Y,W,H:LongInt);
|
|---|
| 759 | Begin
|
|---|
| 760 | Case FFieldType Of
|
|---|
| 761 | ftSmallInt,ftInteger,ftWord,ftFloat,ftCurrency,
|
|---|
| 762 | ftDate,ftTime,ftDateTime:FControl.SetWindowPos(X,Y,W,H);
|
|---|
| 763 | ftBoolean:FControl.SetWindowPos(X-1,Y+2,W+2,H);
|
|---|
| 764 | End; //case
|
|---|
| 765 | End;
|
|---|
| 766 |
|
|---|
| 767 | Procedure TInplaceDBEdit.SetupEdit(Grid:TGrid);
|
|---|
| 768 | Var Edit:TEdit;
|
|---|
| 769 | ComboBox:TComboBox;
|
|---|
| 770 | FieldType:TFieldType;
|
|---|
| 771 | MaskEdit:TMaskEdit;
|
|---|
| 772 | Index:Longint;
|
|---|
| 773 |
|
|---|
| 774 | Function BuildMask(Value:String):String;
|
|---|
| 775 | Var t:LongInt;
|
|---|
| 776 | Begin
|
|---|
| 777 | If pos(' ampm',Value)<>0 Then Value[0]:=chr(Pos(' ampm',Value)-1);
|
|---|
| 778 | If ((pos('h:',Value)=1)Or(pos(' h:',Value)<>0)) Then
|
|---|
| 779 | Insert('h',Value,pos('h:',Value));
|
|---|
| 780 | For t:=1 To Length(Value) Do
|
|---|
| 781 | If Value[t] In ['y','d','m','h','s'] Then Value[t]:='9';
|
|---|
| 782 | Result:=Value+';1;0';
|
|---|
| 783 | End;
|
|---|
| 784 | Begin
|
|---|
| 785 | Index:=Col-Grid.FixedCols;
|
|---|
| 786 | FieldType:=TDBGrid(Grid).FDataLink.DataSource.DataSet.FieldTypes[Index];
|
|---|
| 787 | If FControl<>Nil Then If FieldType<>FFieldType Then
|
|---|
| 788 | Begin
|
|---|
| 789 | FControl.Destroy;
|
|---|
| 790 | FControl:=Nil;
|
|---|
| 791 | End;
|
|---|
| 792 | FFieldType:=FieldType;
|
|---|
| 793 |
|
|---|
| 794 | If FControl=Nil Then
|
|---|
| 795 | Begin
|
|---|
| 796 | Case FFieldType Of
|
|---|
| 797 | ftSmallInt,ftInteger,ftWord,ftFloat,ftCurrency:
|
|---|
| 798 | Begin
|
|---|
| 799 | Edit.Create(Grid);
|
|---|
| 800 | Edit.NumbersOnly:=True;
|
|---|
| 801 | Edit.BorderStyle:=bsNone;
|
|---|
| 802 | FControl:=Edit;
|
|---|
| 803 | End;
|
|---|
| 804 | ftBoolean:
|
|---|
| 805 | Begin
|
|---|
| 806 | ComboBox.Create(Grid);
|
|---|
| 807 | ComboBox.Style:=csDropDownList;
|
|---|
| 808 | ComboBox.Items.Add('True');
|
|---|
| 809 | ComboBox.Items.Add('False');
|
|---|
| 810 | ComboBox.BorderStyle:=bsNone;
|
|---|
| 811 | FControl:=ComboBox;
|
|---|
| 812 | End;
|
|---|
| 813 | ftDate:
|
|---|
| 814 | Begin
|
|---|
| 815 | MaskEdit.Create(Grid);
|
|---|
| 816 | MaskEdit.BorderStyle:=bsNone;
|
|---|
| 817 | MaskEdit.EditMask:=BuildMask(ShortDateFormat);
|
|---|
| 818 | FControl:=MaskEdit;
|
|---|
| 819 | End;
|
|---|
| 820 | ftTime:
|
|---|
| 821 | Begin
|
|---|
| 822 | MaskEdit.Create(Grid);
|
|---|
| 823 | MaskEdit.BorderStyle:=bsNone;
|
|---|
| 824 | MaskEdit.EditMask:=BuildMask(LongTimeFormat);
|
|---|
| 825 | FControl:=MaskEdit;
|
|---|
| 826 | End;
|
|---|
| 827 | ftDateTime:
|
|---|
| 828 | Begin
|
|---|
| 829 | MaskEdit.Create(Grid);
|
|---|
| 830 | MaskEdit.BorderStyle:=bsNone;
|
|---|
| 831 | MaskEdit.EditMask:=BuildMask(ShortDateFormat+' '+LongTimeFormat);
|
|---|
| 832 | FControl:=MaskEdit;
|
|---|
| 833 | End;
|
|---|
| 834 | End; //case
|
|---|
| 835 | End;
|
|---|
| 836 | End;
|
|---|
| 837 |
|
|---|
| 838 | Destructor TInplaceDBEdit.Destroy;
|
|---|
| 839 | Begin
|
|---|
| 840 | FControl.Destroy;
|
|---|
| 841 | Inherited Destroy;
|
|---|
| 842 | End;
|
|---|
| 843 |
|
|---|
| 844 | Procedure TInplaceDBEdit.Show;
|
|---|
| 845 | Begin
|
|---|
| 846 | If FFieldType=ftBoolean Then TComboBox(FControl).OnExit:=Nil; //!!
|
|---|
| 847 | FControl.Show;
|
|---|
| 848 | End;
|
|---|
| 849 |
|
|---|
| 850 | Procedure TInplaceDBEdit.Hide;
|
|---|
| 851 | Begin
|
|---|
| 852 | FControl.Hide;
|
|---|
| 853 | End;
|
|---|
| 854 |
|
|---|
| 855 | Type
|
|---|
| 856 | TColumnsRec=Record
|
|---|
| 857 | ColAlignment:TAlignment;
|
|---|
| 858 | ColColor:TColor;
|
|---|
| 859 | ColPenColor:TColor;
|
|---|
| 860 | ColWidth:LongInt;
|
|---|
| 861 | ColReadOnly:Boolean;
|
|---|
| 862 | TitleAlignment:TAlignment;
|
|---|
| 863 | TitleColor:TColor;
|
|---|
| 864 | TitlePenColor:TColor;
|
|---|
| 865 | End;
|
|---|
| 866 |
|
|---|
| 867 | Function TDBGrid.ShowEditor(Col,Row:LongInt):TInplaceEditClass;
|
|---|
| 868 | Var FieldType:TFieldType;
|
|---|
| 869 | Begin
|
|---|
| 870 | Col:=Col-FixedCols;
|
|---|
| 871 | Result:=Nil; //default editor
|
|---|
| 872 | If FGridOptions*[dgEnableMaskEdit]<>[] Then
|
|---|
| 873 | If FDataLink.DataSource<>Nil Then
|
|---|
| 874 | If FDataLink.DataSource.DataSet<>Nil Then
|
|---|
| 875 | If FDataLink.DataSource.DataSet.Active Then
|
|---|
| 876 | If Col>=0 Then
|
|---|
| 877 | If Col<=FDataLink.DataSource.DataSet.FieldCount Then
|
|---|
| 878 | Begin
|
|---|
| 879 | FieldType:=FDataLink.DataSource.DataSet.FieldTypes[Col];
|
|---|
| 880 | Case FieldType Of
|
|---|
| 881 | ftSmallInt,ftInteger,ftWord,ftBoolean,
|
|---|
| 882 | ftFloat,ftCurrency:Result:=TInplaceDBEdit;
|
|---|
| 883 | ftDate,ftTime,ftDateTime:Result:=TInplaceDBEdit;
|
|---|
| 884 | End; //case
|
|---|
| 885 | End;
|
|---|
| 886 | End;
|
|---|
| 887 |
|
|---|
| 888 | Procedure TDBGrid.SetFont(NewFont:TFont);
|
|---|
| 889 | Var Column:TDBGridColumn;
|
|---|
| 890 | OldFont:TFont;
|
|---|
| 891 | T:LongInt;
|
|---|
| 892 | Begin
|
|---|
| 893 | OldFont:=Font;
|
|---|
| 894 | Inherited SetFont(NewFont);
|
|---|
| 895 |
|
|---|
| 896 | If ((NewFont<>OldFont)And(FColumns<>Nil)) Then For T:=0 To FColumns.Count-1 Do
|
|---|
| 897 | Begin
|
|---|
| 898 | Column:=FColumns[T];
|
|---|
| 899 | If Column.Font=OldFont Then Column.Font:=NewFont;
|
|---|
| 900 | If Column.Title.Font=OldFont Then Column.Title.Font:=NewFont;
|
|---|
| 901 | End;
|
|---|
| 902 | End;
|
|---|
| 903 |
|
|---|
| 904 | {$HINTS OFF}
|
|---|
| 905 | Procedure TDBGrid.RowHeightChanged(Row:LongInt);
|
|---|
| 906 | Begin
|
|---|
| 907 | End;
|
|---|
| 908 | {$HINTS ON}
|
|---|
| 909 |
|
|---|
| 910 | Procedure TDBGrid.ColWidthChanged(Col:LongInt);
|
|---|
| 911 | Var Column:TDBGridColumn;
|
|---|
| 912 | Begin
|
|---|
| 913 | If FColumns<>Nil Then
|
|---|
| 914 | Begin
|
|---|
| 915 | If Col-FixedCols>=0 Then
|
|---|
| 916 | If Col-FixedCols<=FColumns.Count-1 Then
|
|---|
| 917 | Begin
|
|---|
| 918 | Column:=FColumns.Items[Col-FixedCols];
|
|---|
| 919 | If Column<>Nil Then Column.Width:=ColWidths[Col];
|
|---|
| 920 | End;
|
|---|
| 921 | FColumns.FAutoCreated := False;
|
|---|
| 922 | End;
|
|---|
| 923 | End;
|
|---|
| 924 |
|
|---|
| 925 | Function TDBGrid.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 926 | Var MemStream:TMemoryStream;
|
|---|
| 927 | T:LongInt;
|
|---|
| 928 | Column:TDBGridColumn;
|
|---|
| 929 | rec:TColumnsRec;
|
|---|
| 930 | S,s1:String;
|
|---|
| 931 | Attrs:TFontAttributes;
|
|---|
| 932 | Begin
|
|---|
| 933 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 934 | If Not Result Then Exit;
|
|---|
| 935 |
|
|---|
| 936 | If FColumns<>Nil Then
|
|---|
| 937 | If Not FColumns.AutoCreated Then
|
|---|
| 938 | If FColumns.Count>0 Then
|
|---|
| 939 | Begin
|
|---|
| 940 | MemStream.Create;
|
|---|
| 941 |
|
|---|
| 942 | T:=FColumns.Count-1;
|
|---|
| 943 | MemStream.WriteBuffer(T,4); //Array elements
|
|---|
| 944 | For T:=0 To FColumns.Count-1 Do
|
|---|
| 945 | Begin
|
|---|
| 946 | Column:=FColumns.Items[T];
|
|---|
| 947 |
|
|---|
| 948 | rec.ColAlignment:=Column.Alignment;
|
|---|
| 949 | rec.ColColor:=Column.color;
|
|---|
| 950 | rec.ColPenColor:=Column.PenColor;
|
|---|
| 951 | rec.ColWidth:=Column.Width;
|
|---|
| 952 | rec.ColReadOnly:=Column.ReadOnly;
|
|---|
| 953 | rec.TitleAlignment:=Column.Title.Alignment;
|
|---|
| 954 | rec.TitlePenColor:=Column.Title.PenColor;
|
|---|
| 955 | rec.TitleColor:=Column.Title.color;
|
|---|
| 956 |
|
|---|
| 957 | MemStream.WriteBuffer(rec,SizeOf(TColumnsRec));
|
|---|
| 958 |
|
|---|
| 959 | S:=Column.FieldName;
|
|---|
| 960 | MemStream.WriteBuffer(S,Length(S)+1);
|
|---|
| 961 | S:=Column.Title.Caption;
|
|---|
| 962 | MemStream.WriteBuffer(S,Length(S)+1);
|
|---|
| 963 |
|
|---|
| 964 | If Column.Font=Font Then S:=''
|
|---|
| 965 | Else
|
|---|
| 966 | Begin
|
|---|
| 967 | S:=Column.Font.FaceName;
|
|---|
| 968 | If Column.Font.IsDefault Then S:='System Default Font';
|
|---|
| 969 | S:=tostr(Column.Font.PointSize)+'.'+S;
|
|---|
| 970 |
|
|---|
| 971 | s1:=S;
|
|---|
| 972 | UpcaseStr(s1);
|
|---|
| 973 | Attrs:=Column.Font.Attributes;
|
|---|
| 974 | If Attrs*[faBold]<>[] Then If Pos(' BOLD',s1)=0 Then S:=S+'!BOLD!';
|
|---|
| 975 | If Attrs*[faItalic]<>[] Then If Pos(' ITALIC',s1)=0 Then S:=S+'!ITALIC!';
|
|---|
| 976 | If Attrs*[faOutline]<>[] Then S:=S+'!OUTLINE!';
|
|---|
| 977 | If Attrs*[faStrikeOut]<>[] Then S:=S+'!STRIKEOUT!';
|
|---|
| 978 | If Attrs*[faUnderScore]<>[] Then S:=S+'!UNDERSCORE!';
|
|---|
| 979 | End;
|
|---|
| 980 | MemStream.WriteBuffer(S,Length(S)+1);
|
|---|
| 981 |
|
|---|
| 982 | If Column.Title.Font=Font Then S:=''
|
|---|
| 983 | Else
|
|---|
| 984 | Begin
|
|---|
| 985 | S:=Column.Title.Font.FaceName;
|
|---|
| 986 | If Column.Title.Font.IsDefault Then S:='System Default Font';
|
|---|
| 987 | S:=tostr(Column.Title.Font.PointSize)+'.'+S;
|
|---|
| 988 |
|
|---|
| 989 | s1:=S;
|
|---|
| 990 | UpcaseStr(s1);
|
|---|
| 991 | Attrs:=Column.Title.Font.Attributes;
|
|---|
| 992 | If Attrs*[faBold]<>[] Then If Pos(' BOLD',s1)=0 Then S:=S+'!BOLD!';
|
|---|
| 993 | If Attrs*[faItalic]<>[] Then If Pos(' ITALIC',s1)=0 Then S:=S+'!ITALIC!';
|
|---|
| 994 | If Attrs*[faOutline]<>[] Then S:=S+'!OUTLINE!';
|
|---|
| 995 | If Attrs*[faStrikeOut]<>[] Then S:=S+'!STRIKEOUT!';
|
|---|
| 996 | If Attrs*[faUnderScore]<>[] Then S:=S+'!UNDERSCORE!';
|
|---|
| 997 | End;
|
|---|
| 998 | MemStream.WriteBuffer(S,Length(S)+1);
|
|---|
| 999 | End;
|
|---|
| 1000 |
|
|---|
| 1001 | If MemStream.Size>0 Then Result:=Stream.NewResourceEntry(rnDBGridCols,
|
|---|
| 1002 | MemStream.Memory^,MemStream.Size);
|
|---|
| 1003 | MemStream.Destroy;
|
|---|
| 1004 | End;
|
|---|
| 1005 | End;
|
|---|
| 1006 |
|
|---|
| 1007 | Function ModifyFontName(FontName:String;Const Attrs:TFontAttributes):String;
|
|---|
| 1008 | Begin
|
|---|
| 1009 | Result:=FontName;
|
|---|
| 1010 | UpcaseStr(FontName);
|
|---|
| 1011 | If Attrs*[faItalic]<>[] Then If Pos(' ITALIC',FontName)=0 Then Result:=Result+'.Italic';
|
|---|
| 1012 | If Attrs*[faBold]<>[] Then If Pos(' BOLD',FontName)=0 Then Result:=Result+'.Bold';
|
|---|
| 1013 | If Attrs*[faOutline]<>[] Then Result:=Result+'.Outline';
|
|---|
| 1014 | If Attrs*[faStrikeOut]<>[] Then Result:=Result+'.Strikeout';
|
|---|
| 1015 | If Attrs*[faUnderScore]<>[] Then Result:=Result+'.Underscore';
|
|---|
| 1016 | End;
|
|---|
| 1017 |
|
|---|
| 1018 | Procedure TDBGrid.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 1019 | Var Count:^LongInt;
|
|---|
| 1020 | T,t1:LongInt;
|
|---|
| 1021 | Temp:^Byte;
|
|---|
| 1022 | Column:TDBGridColumn;
|
|---|
| 1023 | rec:TColumnsRec;
|
|---|
| 1024 | S,s1:String;
|
|---|
| 1025 | PointSize:LongInt;
|
|---|
| 1026 | C:Integer;
|
|---|
| 1027 | Attrs:TFontAttributes;
|
|---|
| 1028 | Begin
|
|---|
| 1029 | If ResName=rnDBGridCols Then
|
|---|
| 1030 | Begin
|
|---|
| 1031 | Count:=@Data;
|
|---|
| 1032 | Temp:=@Data;
|
|---|
| 1033 | Inc(Temp,4);
|
|---|
| 1034 | If Count^>=0 Then //FColumns.Count-1 was written to SCU
|
|---|
| 1035 | Begin
|
|---|
| 1036 | FColumns.Create(Self);
|
|---|
| 1037 | FColumns.BeginUpdate;
|
|---|
| 1038 | End;
|
|---|
| 1039 | For T:=0 To Count^ Do
|
|---|
| 1040 | Begin
|
|---|
| 1041 | Column:=FColumns.Add;
|
|---|
| 1042 | System.Move(Temp^,rec,SizeOf(TColumnsRec));
|
|---|
| 1043 | Inc(Temp,SizeOf(TColumnsRec));
|
|---|
| 1044 | Column.Alignment:=rec.ColAlignment;
|
|---|
| 1045 | Column.color:=rec.ColColor;
|
|---|
| 1046 | Column.PenColor:=rec.ColPenColor;
|
|---|
| 1047 | Column.Width:=rec.ColWidth;
|
|---|
| 1048 | Column.ReadOnly:=rec.ColReadOnly;
|
|---|
| 1049 | Column.Title.Alignment:=rec.TitleAlignment;
|
|---|
| 1050 | Column.Title.PenColor:=rec.TitlePenColor;
|
|---|
| 1051 | Column.Title.color:=rec.TitleColor;
|
|---|
| 1052 |
|
|---|
| 1053 | System.Move(Temp^,S,Temp^+1);
|
|---|
| 1054 | Inc(Temp,Temp^+1);
|
|---|
| 1055 | Column.FieldName:=S;
|
|---|
| 1056 | System.Move(Temp^,S,Temp^+1);
|
|---|
| 1057 | Inc(Temp,Temp^+1);
|
|---|
| 1058 | Column.Title.Caption:=S;
|
|---|
| 1059 |
|
|---|
| 1060 | System.Move(Temp^,S,Temp^+1);
|
|---|
| 1061 | Inc(Temp,Temp^+1);
|
|---|
| 1062 | If S<>'' Then
|
|---|
| 1063 | Begin
|
|---|
| 1064 | Attrs:=[];
|
|---|
| 1065 | t1:=Pos('!',S);
|
|---|
| 1066 | If t1<>0 Then
|
|---|
| 1067 | Begin
|
|---|
| 1068 | If Pos('!BOLD!',S)<>0 Then Attrs:=Attrs+[faBold];
|
|---|
| 1069 | If Pos('!ITALIC!',S)<>0 Then Attrs:=Attrs+[faItalic];
|
|---|
| 1070 | If Pos('!OUTLINE!',S)<>0 Then Attrs:=Attrs+[faOutline];
|
|---|
| 1071 | If Pos('!STRIKEOUT!',S)<>0 Then Attrs:=Attrs+[faStrikeOut];
|
|---|
| 1072 | If Pos('!UNDERSCORE!',S)<>0 Then Attrs:=Attrs+[faUnderScore];
|
|---|
| 1073 | If Attrs<>[] Then S[0]:=Chr(t1-1);
|
|---|
| 1074 | End;
|
|---|
| 1075 |
|
|---|
| 1076 | PointSize:=0;
|
|---|
| 1077 | If Pos('.',S)<>0 Then
|
|---|
| 1078 | Begin
|
|---|
| 1079 | s1:=Copy(S,1,Pos('.',S)-1);
|
|---|
| 1080 | Delete(S,1,Pos('.',S));
|
|---|
| 1081 | Val(s1,PointSize,C);
|
|---|
| 1082 | End;
|
|---|
| 1083 | S:=ModifyFontName(S,Attrs);
|
|---|
| 1084 | Column.Font:=Screen.GetFontFromPointSize(S,PointSize);
|
|---|
| 1085 | End;
|
|---|
| 1086 |
|
|---|
| 1087 | System.Move(Temp^,S,Temp^+1);
|
|---|
| 1088 | Inc(Temp,Temp^+1);
|
|---|
| 1089 | If S<>'' Then
|
|---|
| 1090 | Begin
|
|---|
| 1091 | Attrs:=[];
|
|---|
| 1092 | t1:=Pos('!',S);
|
|---|
| 1093 | If t1<>0 Then
|
|---|
| 1094 | Begin
|
|---|
| 1095 | If Pos('!BOLD!',S)<>0 Then Attrs:=Attrs+[faBold];
|
|---|
| 1096 | If Pos('!ITALIC!',S)<>0 Then Attrs:=Attrs+[faItalic];
|
|---|
| 1097 | If Pos('!OUTLINE!',S)<>0 Then Attrs:=Attrs+[faOutline];
|
|---|
| 1098 | If Pos('!STRIKEOUT!',S)<>0 Then Attrs:=Attrs+[faStrikeOut];
|
|---|
| 1099 | If Pos('!UNDERSCORE!',S)<>0 Then Attrs:=Attrs+[faUnderScore];
|
|---|
| 1100 | If Attrs<>[] Then S[0]:=Chr(t1-1);
|
|---|
| 1101 | End;
|
|---|
| 1102 |
|
|---|
| 1103 | PointSize:=0;
|
|---|
| 1104 | If Pos('.',S)<>0 Then
|
|---|
| 1105 | Begin
|
|---|
| 1106 | s1:=Copy(S,1,Pos('.',S)-1);
|
|---|
| 1107 | Delete(S,1,Pos('.',S));
|
|---|
| 1108 | Val(s1,PointSize,C);
|
|---|
| 1109 | End;
|
|---|
| 1110 | S:=ModifyFontName(S,Attrs);
|
|---|
| 1111 | Column.Title.Font:=Screen.GetFontFromPointSize(S,PointSize);
|
|---|
| 1112 | End;
|
|---|
| 1113 | End;
|
|---|
| 1114 | If FColumns<>Nil Then FColumns.EndUpdate;
|
|---|
| 1115 | End
|
|---|
| 1116 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 1117 | End;
|
|---|
| 1118 |
|
|---|
| 1119 | Procedure TDBGrid.SetColumns(NewColumns:TDBGridColumns);
|
|---|
| 1120 | Var T:LongInt;
|
|---|
| 1121 | Column:TDBGridColumn;
|
|---|
| 1122 | Begin
|
|---|
| 1123 | If NewColumns<>FColumns Then If FColumns<>Nil Then FColumns.Destroy;
|
|---|
| 1124 | FColumns:=NewColumns;
|
|---|
| 1125 |
|
|---|
| 1126 | If FColumns<>Nil Then FColumns.FGrid:=Self;
|
|---|
| 1127 |
|
|---|
| 1128 | If FColumns<>Nil Then If FColumns.Count=0 Then
|
|---|
| 1129 | Begin
|
|---|
| 1130 | FColumns.Destroy;
|
|---|
| 1131 | FColumns:=Nil;
|
|---|
| 1132 | End;
|
|---|
| 1133 |
|
|---|
| 1134 | If FColumns<>Nil Then
|
|---|
| 1135 | Begin
|
|---|
| 1136 | ColCount:=FColumns.Count+FixedCols;
|
|---|
| 1137 | For T:=0 To FColumns.Count-1 Do
|
|---|
| 1138 | Begin
|
|---|
| 1139 | Column:=FColumns.Items[T];
|
|---|
| 1140 | ColWidths[T+FixedCols]:=Column.Width;
|
|---|
| 1141 | End;
|
|---|
| 1142 | End
|
|---|
| 1143 | Else
|
|---|
| 1144 | Begin
|
|---|
| 1145 | If FDataLink.DataSource<>Nil Then ColCount:=FDataLink.FieldCount+FixedCols;
|
|---|
| 1146 | End;
|
|---|
| 1147 |
|
|---|
| 1148 | Invalidate;
|
|---|
| 1149 | End;
|
|---|
| 1150 |
|
|---|
| 1151 | Procedure TDBGrid.SetGridOptions(NewValue:TDBGridOptions);
|
|---|
| 1152 | Var IOptions:TGridOptions;
|
|---|
| 1153 | Begin
|
|---|
| 1154 | IOptions:=[];
|
|---|
| 1155 | FGridOptions:=NewValue;
|
|---|
| 1156 | If FGridOptions*[dgBorder]<>[] Then Include(IOptions,goBorder);
|
|---|
| 1157 | If FGridOptions*[dgRowResize]<>[] Then Include(IOptions,goRowSizing);
|
|---|
| 1158 | If FGridOptions*[dgColumnResize]<>[] Then Include(IOptions,goColSizing);
|
|---|
| 1159 | If FGridOptions*[dgEditing]<>[] Then Include(IOptions,goEditing);
|
|---|
| 1160 | If FGridOptions*[dgAlwaysShowEditor]<>[] Then Include(IOptions,goAlwaysShowEditor);
|
|---|
| 1161 | If FGridOptions*[dgShowSelection]<>[] Then Include(IOptions,goShowSelection);
|
|---|
| 1162 | If FGridOptions*[dgAlwaysShowSelection]<>[] Then Include(IOptions,goAlwaysShowSelection);
|
|---|
| 1163 | If FGridOptions*[dgMouseSelect]<>[] Then Include(IOptions,goMouseSelect);
|
|---|
| 1164 | Inherited Options:=IOptions;
|
|---|
| 1165 |
|
|---|
| 1166 | If FGridOptions*[dgIndicator]=[] Then FixedCols:=0
|
|---|
| 1167 | Else FixedCols:=1;
|
|---|
| 1168 | If FGridOptions*[dgTitles]=[] Then FixedRows:=0
|
|---|
| 1169 | Else FixedRows:=1;
|
|---|
| 1170 | End;
|
|---|
| 1171 |
|
|---|
| 1172 | Function TDBGrid.SelectCell(Col,Row:LongInt):Boolean;
|
|---|
| 1173 | Begin
|
|---|
| 1174 | Result:=Inherited SelectCell(Col,Row);
|
|---|
| 1175 | If FDataLink.DataSource<>Nil Then
|
|---|
| 1176 | If FDataLink.DataSource.DataSet<>Nil Then
|
|---|
| 1177 | If FDataLink.DataSource.DataSet.Active Then
|
|---|
| 1178 | Begin
|
|---|
| 1179 | Try
|
|---|
| 1180 | FDataLink.DataSource.DataSet.CurrentRow:=Row-1;
|
|---|
| 1181 | Except
|
|---|
| 1182 | ON E:ESQLError Do ErrorBox(E.Message);
|
|---|
| 1183 | Else Raise;
|
|---|
| 1184 | End;
|
|---|
| 1185 | End;
|
|---|
| 1186 | End;
|
|---|
| 1187 |
|
|---|
| 1188 | Procedure TDBGrid.Scroll(ScrollBar:TScrollBar;ScrollCode:TScrollCode;Var ScrollPos:LongInt);
|
|---|
| 1189 | Begin
|
|---|
| 1190 | If ScrollCode In [scVertTrack,scHorzTrack] Then Exit;
|
|---|
| 1191 | Inherited Scroll(ScrollBar,ScrollCode,ScrollPos);
|
|---|
| 1192 | End;
|
|---|
| 1193 |
|
|---|
| 1194 | Procedure TDBGrid.SetupCellColors(Col,Row:LongInt;AState:TGridDrawState;Var background,ForeGround:TColor);
|
|---|
| 1195 | Var Col1:LongInt;
|
|---|
| 1196 | Column:TDBGridColumn;
|
|---|
| 1197 | Begin
|
|---|
| 1198 | Col1:=Col-FixedCols;
|
|---|
| 1199 | If ((FColumns<>Nil)And(Col1>=0)And(Col1<FColumns.Count)) Then
|
|---|
| 1200 | Begin
|
|---|
| 1201 | Column:=FColumns.Items[Col1];
|
|---|
| 1202 | If Row<FixedRows Then
|
|---|
| 1203 | Begin
|
|---|
| 1204 | background:=Column.Title.color;
|
|---|
| 1205 | ForeGround:=Column.Title.PenColor;
|
|---|
| 1206 | End
|
|---|
| 1207 | Else
|
|---|
| 1208 | Begin
|
|---|
| 1209 | background:=Column.color;
|
|---|
| 1210 | ForeGround:=Column.PenColor;
|
|---|
| 1211 | End;
|
|---|
| 1212 | End
|
|---|
| 1213 | Else Inherited SetupCellColors(Col,Row,AState,background,ForeGround);
|
|---|
| 1214 |
|
|---|
| 1215 | If AState*[gdFixed]=[] Then
|
|---|
| 1216 | Begin
|
|---|
| 1217 | If AState*[gdSelected]<>[] Then If Options*[goShowSelection,goEditing]<>[] Then
|
|---|
| 1218 | Begin
|
|---|
| 1219 | If AState*[gdFocused]=[] Then
|
|---|
| 1220 | Begin
|
|---|
| 1221 | If Options*[goAlwaysShowSelection]<>[] Then
|
|---|
| 1222 | Begin
|
|---|
| 1223 | background:=clHighlight;
|
|---|
| 1224 | ForeGround:=clHighlightText;
|
|---|
| 1225 | End;
|
|---|
| 1226 | End
|
|---|
| 1227 | Else
|
|---|
| 1228 | Begin
|
|---|
| 1229 | background:=clHighlight;
|
|---|
| 1230 | ForeGround:=clHighlightText;
|
|---|
| 1231 | End;
|
|---|
| 1232 | End;
|
|---|
| 1233 | End;
|
|---|
| 1234 | End;
|
|---|
| 1235 |
|
|---|
| 1236 | Procedure TDBGrid.SetupCellDrawing(Col,Row:LongInt;AState:TGridDrawState;
|
|---|
| 1237 | Var Alignment:TAlignment;Var DrawFont:TFont);
|
|---|
| 1238 | Var Col1:LongInt;
|
|---|
| 1239 | Column:TDBGridColumn;
|
|---|
| 1240 | Begin
|
|---|
| 1241 | Col1:=Col-FixedCols;
|
|---|
| 1242 | If ((FColumns<>Nil)And(Col1>=0)And(Col1<FColumns.Count)) Then
|
|---|
| 1243 | Begin
|
|---|
| 1244 | Column:=FColumns.Items[Col1];
|
|---|
| 1245 | If Row<FixedRows Then
|
|---|
| 1246 | Begin
|
|---|
| 1247 | Alignment:=Column.Title.Alignment;
|
|---|
| 1248 | DrawFont:=Column.Title.Font;
|
|---|
| 1249 | End
|
|---|
| 1250 | Else
|
|---|
| 1251 | Begin
|
|---|
| 1252 | Alignment:=Column.Alignment;
|
|---|
| 1253 | DrawFont:=Column.Font;
|
|---|
| 1254 | End;
|
|---|
| 1255 | End
|
|---|
| 1256 | Else Inherited SetupCellDrawing(Col,Row,AState,Alignment,DrawFont);
|
|---|
| 1257 | End;
|
|---|
| 1258 |
|
|---|
| 1259 | Procedure TDBGrid.DrawCell(Col,Row:LongInt;rec:TRect;AState:TGridDrawState);
|
|---|
| 1260 | Var rc:TRect;
|
|---|
| 1261 | X,Y,CX,CY:LongInt;
|
|---|
| 1262 | s:String;
|
|---|
| 1263 | Begin
|
|---|
| 1264 | If Canvas=Nil Then Exit;
|
|---|
| 1265 |
|
|---|
| 1266 | Inherited DrawCell(Col,Row,rec,AState);
|
|---|
| 1267 |
|
|---|
| 1268 | If ((AState*[gdFixed]<>[])And(Col=0)And(Col<FixedCols)And(Row-FixedRows>=0)And
|
|---|
| 1269 | (FDataLink.DataSource<>Nil)And(FDataLink.DataSource.DataSet<>Nil)) Then
|
|---|
| 1270 | Begin
|
|---|
| 1271 | If Row-FixedRows=FDataLink.DataSource.DataSet.CurrentRow Then
|
|---|
| 1272 | Begin
|
|---|
| 1273 | {Draw Polygon To Mark Current Row In DataSet}
|
|---|
| 1274 | rc:=GridRects[Col,Row];
|
|---|
| 1275 | Canvas.ClipRect := rc;
|
|---|
| 1276 | X:=rc.Left+((((rc.Right-rc.Left)-10) Div 2));
|
|---|
| 1277 | Y:=rc.Bottom+(((rc.Top-rc.Bottom)-10) Div 2);
|
|---|
| 1278 | Canvas.Pen.Color:=PenColor;
|
|---|
| 1279 | If FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 1280 | Then Canvas.PolyLine([Point(X,Y),Point(X,Y+10),Point(X+10,Y+5),Point(X,Y)])
|
|---|
| 1281 | Else Canvas.Polygon([Point(X,Y),Point(X,Y+10),Point(X+10,Y+5),Point(X,Y)]);
|
|---|
| 1282 | End
|
|---|
| 1283 | Else
|
|---|
| 1284 | Begin
|
|---|
| 1285 | If dgLineNumbers In FGridOptions Then
|
|---|
| 1286 | Begin
|
|---|
| 1287 | rc:=GridRects[Col,Row];
|
|---|
| 1288 | Canvas.ClipRect:=rc;
|
|---|
| 1289 | s:=tostr(Row-FixedRows+1);
|
|---|
| 1290 | Canvas.GetTextExtent(s,CX,CY);
|
|---|
| 1291 | X:=rc.Right-3-CX;
|
|---|
| 1292 | Y:=rc.Top-2-Canvas.Font.Height;
|
|---|
| 1293 | Canvas.Pen.Color:=PenColor;
|
|---|
| 1294 | Canvas.TextOut(X,Y,s);
|
|---|
| 1295 | End;
|
|---|
| 1296 | End;
|
|---|
| 1297 | End;
|
|---|
| 1298 | End;
|
|---|
| 1299 |
|
|---|
| 1300 | Function TDBGrid.GetCell(Col,Row:LongInt):String;
|
|---|
| 1301 | Var
|
|---|
| 1302 | Field:TField;
|
|---|
| 1303 | Column:TDBGridColumn;
|
|---|
| 1304 | Col1:LongInt;
|
|---|
| 1305 | Begin
|
|---|
| 1306 | Result:='';
|
|---|
| 1307 |
|
|---|
| 1308 | If Row<=FixedRows-1 Then
|
|---|
| 1309 | Begin
|
|---|
| 1310 | If Row=0 Then If Col>=FixedCols-1 Then
|
|---|
| 1311 | Begin
|
|---|
| 1312 | If FColumns<>Nil Then
|
|---|
| 1313 | Begin
|
|---|
| 1314 | Col1:=Col-FixedCols;
|
|---|
| 1315 | If ((Col1>=0)And(Col1<FColumns.Count)) Then
|
|---|
| 1316 | Begin
|
|---|
| 1317 | Column:=FColumns.Items[Col1];
|
|---|
| 1318 | Result:=Column.Title.Caption;
|
|---|
| 1319 | If Result='' Then Result:=Column.FieldName;
|
|---|
| 1320 | End
|
|---|
| 1321 | Else Result:=Inherited GetCell(Col,Row);
|
|---|
| 1322 | End
|
|---|
| 1323 | Else
|
|---|
| 1324 | Begin
|
|---|
| 1325 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 1326 | Result:=FDataLink.DataSource.DataSet.FieldNames[Col-FixedCols];
|
|---|
| 1327 | End;
|
|---|
| 1328 | End;
|
|---|
| 1329 | End
|
|---|
| 1330 | Else If Col<=FixedCols-1 Then Exit
|
|---|
| 1331 | Else
|
|---|
| 1332 | Begin
|
|---|
| 1333 | Try
|
|---|
| 1334 | Field:=Nil;
|
|---|
| 1335 | If FColumns<>Nil Then
|
|---|
| 1336 | Begin
|
|---|
| 1337 | Col1:=Col-FixedCols;
|
|---|
| 1338 | If ((Col1>=0)And(Col1<FColumns.Count)) Then
|
|---|
| 1339 | Begin
|
|---|
| 1340 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then
|
|---|
| 1341 | Begin
|
|---|
| 1342 | Result:=Inherited GetCell(Col,Row);
|
|---|
| 1343 | Exit;
|
|---|
| 1344 | End;
|
|---|
| 1345 |
|
|---|
| 1346 | Column:=FColumns.Items[Col1];
|
|---|
| 1347 | Field:=FDataLink.FieldsFromColumnName[Column.FieldName,Row-FixedRows];
|
|---|
| 1348 | If Field=Nil Then //ColumnName does Not exist
|
|---|
| 1349 | Begin
|
|---|
| 1350 | Result:=Inherited GetCell(Col,Row);
|
|---|
| 1351 | Exit;
|
|---|
| 1352 | End;
|
|---|
| 1353 | End
|
|---|
| 1354 | Else
|
|---|
| 1355 | Begin
|
|---|
| 1356 | Result:=Inherited GetCell(Col,Row);
|
|---|
| 1357 | Exit;
|
|---|
| 1358 | End;
|
|---|
| 1359 | End
|
|---|
| 1360 | Else
|
|---|
| 1361 | Begin
|
|---|
| 1362 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 1363 | Field:=FDataLink.Fields[Col-FixedCols,Row-FixedRows];
|
|---|
| 1364 | If Field=Nil Then RowCount:=Row; {no more Rows}
|
|---|
| 1365 | End;
|
|---|
| 1366 | Except
|
|---|
| 1367 | ON E:ESQLError Do
|
|---|
| 1368 | Begin
|
|---|
| 1369 | ErrorBox(E.Message);
|
|---|
| 1370 | Field:=Nil;
|
|---|
| 1371 | End;
|
|---|
| 1372 | Else Raise;
|
|---|
| 1373 | End;
|
|---|
| 1374 | If Field<>Nil Then Result:=Field.AsString;
|
|---|
| 1375 | End;
|
|---|
| 1376 | End;
|
|---|
| 1377 |
|
|---|
| 1378 | {$HINTS OFF}
|
|---|
| 1379 | Procedure TDBGrid.SetCell(Col,Row:LongInt;Const NewContent:String);
|
|---|
| 1380 | Var Field:TField;
|
|---|
| 1381 | Column:TDBGridColumn;
|
|---|
| 1382 | Col1:LongInt;
|
|---|
| 1383 | Begin
|
|---|
| 1384 | If FDataLink.DataSource=Nil Then Exit;
|
|---|
| 1385 | If FDataLink.DataSource.DataSet=Nil Then Exit;
|
|---|
| 1386 |
|
|---|
| 1387 | If ((Col<FixedCols)Or(Row<FixedRows)) Then Exit;
|
|---|
| 1388 |
|
|---|
| 1389 | Try
|
|---|
| 1390 | Field:=Nil;
|
|---|
| 1391 | If FColumns<>Nil Then
|
|---|
| 1392 | Begin
|
|---|
| 1393 | Col1:=Col-FixedCols;
|
|---|
| 1394 | If ((Col1>=0)And(Col1<FColumns.Count)) Then
|
|---|
| 1395 | Begin
|
|---|
| 1396 | Column:=FColumns.Items[Col1];
|
|---|
| 1397 | If Not Column.ReadOnly Then
|
|---|
| 1398 | Begin
|
|---|
| 1399 | Field:=FDataLink.FieldsFromColumnName[Column.FieldName,Row-FixedRows];
|
|---|
| 1400 | If Field=Nil Then //ColumnName does Not exist
|
|---|
| 1401 | Begin
|
|---|
| 1402 | Inherited SetCell(Col,Row,NewContent);
|
|---|
| 1403 | Exit;
|
|---|
| 1404 | End;
|
|---|
| 1405 | End;
|
|---|
| 1406 | End
|
|---|
| 1407 | Else
|
|---|
| 1408 | Begin
|
|---|
| 1409 | Inherited SetCell(Col,Row,NewContent);
|
|---|
| 1410 | Exit;
|
|---|
| 1411 | End;
|
|---|
| 1412 | End
|
|---|
| 1413 | Else Field:=FDataLink.Fields[Col-FixedCols,Row-FixedRows];
|
|---|
| 1414 | Except
|
|---|
| 1415 | ON E:ESQLError Do
|
|---|
| 1416 | Begin
|
|---|
| 1417 | ErrorBox(E.Message);
|
|---|
| 1418 | Field:=Nil;
|
|---|
| 1419 | End;
|
|---|
| 1420 | Else Raise;
|
|---|
| 1421 | End;
|
|---|
| 1422 |
|
|---|
| 1423 | If Field=Nil Then Exit;
|
|---|
| 1424 |
|
|---|
| 1425 | If Field.AsString=NewContent Then Exit;
|
|---|
| 1426 | Field.AsString:=NewContent;
|
|---|
| 1427 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 1428 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 1429 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 1430 | End;
|
|---|
| 1431 |
|
|---|
| 1432 | Procedure TDBGrid.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 1433 | Var Col,Row:LongInt;
|
|---|
| 1434 | I:LongInt;
|
|---|
| 1435 | FieldClass:TFieldClass;
|
|---|
| 1436 | LastRow:LongInt;
|
|---|
| 1437 | T,t1:LongInt;
|
|---|
| 1438 | X,Y:LongInt;
|
|---|
| 1439 | su:Boolean;
|
|---|
| 1440 | Max:LongInt;
|
|---|
| 1441 | dummy:TDBGridColumn;
|
|---|
| 1442 | Begin
|
|---|
| 1443 | If Event=deTableNameChanged Then
|
|---|
| 1444 | Begin
|
|---|
| 1445 | Columns:=Nil;
|
|---|
| 1446 | exit;
|
|---|
| 1447 | End;
|
|---|
| 1448 |
|
|---|
| 1449 | GridUpdateLocked:=True;
|
|---|
| 1450 | If FDataLink.DataSource<>Nil Then
|
|---|
| 1451 | Begin
|
|---|
| 1452 | If (FColumns=Nil) And (FDataLink.FieldCount>0) Then
|
|---|
| 1453 | Begin
|
|---|
| 1454 | //add default columns
|
|---|
| 1455 | ColCount:=FDataLink.FieldCount+FixedCols; {!!}
|
|---|
| 1456 |
|
|---|
| 1457 | FColumns.Create(Self);
|
|---|
| 1458 | FColumns.FAutoCreated := True;
|
|---|
| 1459 |
|
|---|
| 1460 | For t:=0 To FDataLink.FieldCount-1 Do
|
|---|
| 1461 | Begin
|
|---|
| 1462 | dummy:=FColumns.Add;
|
|---|
| 1463 | dummy.Alignment:=taLeftJustify;
|
|---|
| 1464 | dummy.Color:=clEntryField;
|
|---|
| 1465 | dummy.PenColor:=clBlack;
|
|---|
| 1466 | dummy.Width:=DefaultColWidth;
|
|---|
| 1467 | dummy.Font:=Font;
|
|---|
| 1468 | dummy.FieldName:=FDataLink.FieldNames[t];
|
|---|
| 1469 | dummy.Title.Alignment:=taLeftJustify;
|
|---|
| 1470 | dummy.Title.Color:=clLtGray;
|
|---|
| 1471 | dummy.Title.PenColor:=clBlack;
|
|---|
| 1472 | dummy.Title.Font:=Font;
|
|---|
| 1473 | If FDataLink.DataSource.DataSet<>Nil Then
|
|---|
| 1474 | Begin
|
|---|
| 1475 | FieldClass:=FDataLink.DataSource.DataSet.FieldDefs[t].FieldClass;
|
|---|
| 1476 | If (FieldClass Is TMemoField) Or
|
|---|
| 1477 | (FieldClass Is TBlobField)
|
|---|
| 1478 | Then dummy.ReadOnly:=True;
|
|---|
| 1479 |
|
|---|
| 1480 | If (FieldClass Is TSmallintField) Or
|
|---|
| 1481 | (FieldClass Is TIntegerField) Or
|
|---|
| 1482 | (FieldClass Is TFloatField)
|
|---|
| 1483 | Then dummy.Alignment:=taRightJustify;
|
|---|
| 1484 |
|
|---|
| 1485 | If (FieldClass Is TStringField)
|
|---|
| 1486 | Then dummy.Width:=Font.Width*FDataLink.DataSource.DataSet.FieldDefs[t].Size Div 2;
|
|---|
| 1487 | End;
|
|---|
| 1488 | End;
|
|---|
| 1489 | End;
|
|---|
| 1490 |
|
|---|
| 1491 | If (FDataLink.FieldCount = 0) Then
|
|---|
| 1492 | If FColumns <> Nil Then
|
|---|
| 1493 | If FColumns.FAutoCreated Then
|
|---|
| 1494 | Begin
|
|---|
| 1495 | //remove default columns
|
|---|
| 1496 | SetColumns(Nil);
|
|---|
| 1497 | End;
|
|---|
| 1498 |
|
|---|
| 1499 | If FColumns<>Nil Then ColCount:=FColumns.Count+FixedCols
|
|---|
| 1500 | Else ColCount:=FDataLink.FieldCount+FixedCols;
|
|---|
| 1501 |
|
|---|
| 1502 | If FDataLink.DataSource.DataSet<>Nil Then
|
|---|
| 1503 | Begin
|
|---|
| 1504 | If RowCount<>FDataLink.DataSource.DataSet.MaxRows+FixedRows Then
|
|---|
| 1505 | RowCount:=FDataLink.DataSource.DataSet.MaxRows+FixedRows;
|
|---|
| 1506 |
|
|---|
| 1507 | //check If CurrentRow fits In Window
|
|---|
| 1508 | Max:=FDataLink.DataSource.DataSet.CurrentRow;
|
|---|
| 1509 | If Max<>-1 Then
|
|---|
| 1510 | Begin
|
|---|
| 1511 | If Max<TopRow Then
|
|---|
| 1512 | Begin
|
|---|
| 1513 | {Scroll up}
|
|---|
| 1514 | FUpScrolled:=0;
|
|---|
| 1515 | FUpExtent:=0;
|
|---|
| 1516 | su:=True;
|
|---|
| 1517 | End
|
|---|
| 1518 | Else su:=False;
|
|---|
| 1519 |
|
|---|
| 1520 | //check If marker would fit In Window
|
|---|
| 1521 | If GridOptions*[dgBorder]<>[] Then Y:=Height-1
|
|---|
| 1522 | Else Y:=Height;
|
|---|
| 1523 | If HorzScrollBar<>Nil Then
|
|---|
| 1524 | If HorzScrollBar.Visible Then Dec(Y,HorzScrollBar.Height);
|
|---|
| 1525 | For T:=0 To FixedRows-1 Do Dec(Y,RowHeights[T]);
|
|---|
| 1526 | For T:=FixedRows+TopRow To FixedRows+Max Do Dec(Y,RowHeights[T]);
|
|---|
| 1527 | If Y<0 Then //Scroll
|
|---|
| 1528 | Begin
|
|---|
| 1529 | T:=TopRow;
|
|---|
| 1530 | For t1:=FixedRows+TopRow To FixedRows+Max Do
|
|---|
| 1531 | Begin
|
|---|
| 1532 | Inc(FUpExtent,RowHeights[t1]);
|
|---|
| 1533 | Inc(T);
|
|---|
| 1534 | Inc(Y,RowHeights[t1]);
|
|---|
| 1535 | If Y>0 Then break;
|
|---|
| 1536 | End;
|
|---|
| 1537 | FUpScrolled:=T;
|
|---|
| 1538 | End;
|
|---|
| 1539 | VertScrollBar.Position:=FUpExtent;
|
|---|
| 1540 | Invalidate;
|
|---|
| 1541 | End;
|
|---|
| 1542 | End;
|
|---|
| 1543 | End;
|
|---|
| 1544 | GridUpdateLocked:=False; //Redraw whole Grid
|
|---|
| 1545 | End;
|
|---|
| 1546 | {$HINTS ON}
|
|---|
| 1547 |
|
|---|
| 1548 | Procedure TDBGrid.SetDataSource(NewValue:TDataSource);
|
|---|
| 1549 | Begin
|
|---|
| 1550 | FDataLink.DataSource:=NewValue;
|
|---|
| 1551 | End;
|
|---|
| 1552 |
|
|---|
| 1553 | Function TDBGrid.GetDataSource:TDataSource;
|
|---|
| 1554 | Begin
|
|---|
| 1555 | Result:=FDataLink.DataSource;
|
|---|
| 1556 | End;
|
|---|
| 1557 |
|
|---|
| 1558 | Procedure TDBGrid.SetupComponent;
|
|---|
| 1559 | Begin
|
|---|
| 1560 | Inherited SetupComponent;
|
|---|
| 1561 |
|
|---|
| 1562 | FGridOptions:=[dgBorder,dgShowSelection,dgTitles,dgIndicator,dgMouseSelect,dgEnableMaskEdit];
|
|---|
| 1563 | FDataLink.Create(Self);
|
|---|
| 1564 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 1565 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 1566 | Name:='DBGrid';
|
|---|
| 1567 | ColWidths[0]:=20;
|
|---|
| 1568 | End;
|
|---|
| 1569 |
|
|---|
| 1570 | Destructor TDBGrid.Destroy;
|
|---|
| 1571 | Begin
|
|---|
| 1572 | If FColumns<>Nil Then FColumns.Destroy;
|
|---|
| 1573 | FDataLink.OnDataChange:=Nil;
|
|---|
| 1574 | FDataLink.Destroy;
|
|---|
| 1575 | FDataLink:=Nil;
|
|---|
| 1576 |
|
|---|
| 1577 | Inherited Destroy;
|
|---|
| 1578 | End;
|
|---|
| 1579 |
|
|---|
| 1580 | {
|
|---|
| 1581 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 1582 | º º
|
|---|
| 1583 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 1584 | º º
|
|---|
| 1585 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 1586 | º º
|
|---|
| 1587 | º This section: TDBEdit Class Implementation º
|
|---|
| 1588 | º º
|
|---|
| 1589 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 1590 | º º
|
|---|
| 1591 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 1592 | }
|
|---|
| 1593 |
|
|---|
| 1594 | Function TDBEdit.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 1595 | Var S:String;
|
|---|
| 1596 | Begin
|
|---|
| 1597 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 1598 | If Result=False Then Exit;
|
|---|
| 1599 |
|
|---|
| 1600 | S:=FDataLink.FieldName;
|
|---|
| 1601 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 1602 | End;
|
|---|
| 1603 |
|
|---|
| 1604 | Procedure TDBEdit.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 1605 | Var S:String;
|
|---|
| 1606 | Begin
|
|---|
| 1607 | If ResName = rnDBDataField Then
|
|---|
| 1608 | Begin
|
|---|
| 1609 | System.Move(Data,S,DataLen);
|
|---|
| 1610 | FDataLink.FieldName:=S;
|
|---|
| 1611 | End
|
|---|
| 1612 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 1613 | End;
|
|---|
| 1614 |
|
|---|
| 1615 | Procedure TDBEdit.SetDataSource(NewValue:TDataSource);
|
|---|
| 1616 | Begin
|
|---|
| 1617 | FDataLink.DataSource:=NewValue;
|
|---|
| 1618 | End;
|
|---|
| 1619 |
|
|---|
| 1620 | Function TDBEdit.GetDataSource:TDataSource;
|
|---|
| 1621 | Begin
|
|---|
| 1622 | Result:=FDataLink.DataSource;
|
|---|
| 1623 | End;
|
|---|
| 1624 |
|
|---|
| 1625 | Procedure TDBEdit.SetDataField(NewValue:String);
|
|---|
| 1626 | Begin
|
|---|
| 1627 | FDataLink.FieldName:=NewValue;
|
|---|
| 1628 | End;
|
|---|
| 1629 |
|
|---|
| 1630 | Function TDBEdit.GetDataField:String;
|
|---|
| 1631 | Begin
|
|---|
| 1632 | Result:=FDataLink.FieldName;
|
|---|
| 1633 | End;
|
|---|
| 1634 |
|
|---|
| 1635 | Procedure TDBEdit.SetupComponent;
|
|---|
| 1636 | Begin
|
|---|
| 1637 | Inherited SetupComponent;
|
|---|
| 1638 |
|
|---|
| 1639 | FDataLink.Create(Self);
|
|---|
| 1640 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 1641 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 1642 | Name:='DBEdit';
|
|---|
| 1643 | End;
|
|---|
| 1644 |
|
|---|
| 1645 | Destructor TDBEdit.Destroy;
|
|---|
| 1646 | Begin
|
|---|
| 1647 | FDataLink.OnDataChange:=Nil;
|
|---|
| 1648 | FDataLink.Destroy;
|
|---|
| 1649 | FDataLink:=Nil;
|
|---|
| 1650 |
|
|---|
| 1651 | Inherited Destroy;
|
|---|
| 1652 | End;
|
|---|
| 1653 |
|
|---|
| 1654 | {$HINTS OFF}
|
|---|
| 1655 | Procedure TDBEdit.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 1656 | Var Field:TField;
|
|---|
| 1657 | Begin
|
|---|
| 1658 | Try
|
|---|
| 1659 | Field:=FDataLink.Field;
|
|---|
| 1660 | Except
|
|---|
| 1661 | ON E:ESQLError Do
|
|---|
| 1662 | Begin
|
|---|
| 1663 | ErrorBox(E.Message);
|
|---|
| 1664 | Field:=Nil;
|
|---|
| 1665 | End;
|
|---|
| 1666 | Else Raise;
|
|---|
| 1667 | End;
|
|---|
| 1668 | If Field<>Nil Then Caption:=Field.AsString
|
|---|
| 1669 | Else Caption:='';
|
|---|
| 1670 | End;
|
|---|
| 1671 | {$HINTS ON}
|
|---|
| 1672 |
|
|---|
| 1673 | Procedure TDBEdit.SetupShow;
|
|---|
| 1674 | Begin
|
|---|
| 1675 | Inherited SetupShow;
|
|---|
| 1676 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 1677 | End;
|
|---|
| 1678 |
|
|---|
| 1679 |
|
|---|
| 1680 | Procedure TDBEdit.WriteBack;
|
|---|
| 1681 | Var S:String;
|
|---|
| 1682 | Field:TField;
|
|---|
| 1683 | Begin
|
|---|
| 1684 | If FDataLink = Nil Then exit;
|
|---|
| 1685 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 1686 | S:=Text;
|
|---|
| 1687 |
|
|---|
| 1688 | Try
|
|---|
| 1689 | Field:=FDataLink.Field;
|
|---|
| 1690 | If Field<>Nil Then
|
|---|
| 1691 | If Field.AsString<>S Then
|
|---|
| 1692 | Begin
|
|---|
| 1693 | Field.AsString:=S;
|
|---|
| 1694 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 1695 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 1696 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 1697 | End;
|
|---|
| 1698 | Except
|
|---|
| 1699 | ON E:ESQLError Do
|
|---|
| 1700 | Begin
|
|---|
| 1701 | ErrorBox(E.Message);
|
|---|
| 1702 | Field:=Nil;
|
|---|
| 1703 | End;
|
|---|
| 1704 | Else Raise;
|
|---|
| 1705 | End;
|
|---|
| 1706 | End;
|
|---|
| 1707 |
|
|---|
| 1708 | Procedure TDBEdit.KillFocus;
|
|---|
| 1709 | Begin
|
|---|
| 1710 | WriteBack;
|
|---|
| 1711 |
|
|---|
| 1712 | Inherited KillFocus;
|
|---|
| 1713 | End;
|
|---|
| 1714 |
|
|---|
| 1715 | Procedure TDBEdit.ScanEvent(Var KeyCode:TKeyCode;RepeatCount:Byte);
|
|---|
| 1716 | Begin
|
|---|
| 1717 | If KeyCode=kbCR Then WriteBack;
|
|---|
| 1718 |
|
|---|
| 1719 | Inherited ScanEvent(KeyCode,RepeatCount);
|
|---|
| 1720 | End;
|
|---|
| 1721 |
|
|---|
| 1722 | {
|
|---|
| 1723 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 1724 | º º
|
|---|
| 1725 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 1726 | º º
|
|---|
| 1727 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 1728 | º º
|
|---|
| 1729 | º This section: TDBText Class Implementation º
|
|---|
| 1730 | º º
|
|---|
| 1731 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 1732 | º º
|
|---|
| 1733 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 1734 | }
|
|---|
| 1735 |
|
|---|
| 1736 | Function TDBText.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 1737 | Var S:String;
|
|---|
| 1738 | Begin
|
|---|
| 1739 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 1740 | If Result=False Then Exit;
|
|---|
| 1741 | S:=FDataLink.FieldName;
|
|---|
| 1742 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 1743 | End;
|
|---|
| 1744 |
|
|---|
| 1745 | Procedure TDBText.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 1746 | Var S:String;
|
|---|
| 1747 | Begin
|
|---|
| 1748 | If ResName = rnDBDataField Then
|
|---|
| 1749 | Begin
|
|---|
| 1750 | System.Move(Data,S,DataLen);
|
|---|
| 1751 | FDataLink.FieldName:=S;
|
|---|
| 1752 | End
|
|---|
| 1753 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 1754 | End;
|
|---|
| 1755 |
|
|---|
| 1756 |
|
|---|
| 1757 | Procedure TDBText.SetDataSource(NewValue:TDataSource);
|
|---|
| 1758 | Begin
|
|---|
| 1759 | FDataLink.DataSource:=NewValue;
|
|---|
| 1760 | End;
|
|---|
| 1761 |
|
|---|
| 1762 | Function TDBText.GetDataSource:TDataSource;
|
|---|
| 1763 | Begin
|
|---|
| 1764 | Result:=FDataLink.DataSource;
|
|---|
| 1765 | End;
|
|---|
| 1766 |
|
|---|
| 1767 | Procedure TDBText.SetDataField(NewValue:String);
|
|---|
| 1768 | Begin
|
|---|
| 1769 | FDataLink.FieldName:=NewValue;
|
|---|
| 1770 | End;
|
|---|
| 1771 |
|
|---|
| 1772 | Function TDBText.GetDataField:String;
|
|---|
| 1773 | Begin
|
|---|
| 1774 | Result:=FDataLink.FieldName;
|
|---|
| 1775 | End;
|
|---|
| 1776 |
|
|---|
| 1777 | Procedure TDBText.SetupComponent;
|
|---|
| 1778 | Begin
|
|---|
| 1779 | Inherited SetupComponent;
|
|---|
| 1780 |
|
|---|
| 1781 | FDataLink.Create(Self);
|
|---|
| 1782 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 1783 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 1784 |
|
|---|
| 1785 | Name:='DBText';
|
|---|
| 1786 | Caption:=Name;
|
|---|
| 1787 | AutoSize:=False;
|
|---|
| 1788 | End;
|
|---|
| 1789 |
|
|---|
| 1790 | Destructor TDBText.Destroy;
|
|---|
| 1791 | Begin
|
|---|
| 1792 | FDataLink.OnDataChange:=Nil;
|
|---|
| 1793 | FDataLink.Destroy;
|
|---|
| 1794 | FDataLink:=Nil;
|
|---|
| 1795 |
|
|---|
| 1796 | Inherited Destroy;
|
|---|
| 1797 | End;
|
|---|
| 1798 |
|
|---|
| 1799 | {$HINTS OFF}
|
|---|
| 1800 | Procedure TDBText.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 1801 | Var Field:TField;
|
|---|
| 1802 | Begin
|
|---|
| 1803 | Try
|
|---|
| 1804 | Field:=FDataLink.Field;
|
|---|
| 1805 | Except
|
|---|
| 1806 | ON E:ESQLError Do
|
|---|
| 1807 | Begin
|
|---|
| 1808 | ErrorBox(E.Message);
|
|---|
| 1809 | Field:=Nil;
|
|---|
| 1810 | End;
|
|---|
| 1811 | Else Raise;
|
|---|
| 1812 | End;
|
|---|
| 1813 | If Field<>Nil Then Caption:=Field.AsString
|
|---|
| 1814 | Else Caption:='';
|
|---|
| 1815 | End;
|
|---|
| 1816 | {$HINTS ON}
|
|---|
| 1817 |
|
|---|
| 1818 | Procedure TDBText.SetupShow;
|
|---|
| 1819 | Begin
|
|---|
| 1820 | Inherited SetupShow;
|
|---|
| 1821 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 1822 | End;
|
|---|
| 1823 |
|
|---|
| 1824 | {
|
|---|
| 1825 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 1826 | º º
|
|---|
| 1827 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 1828 | º º
|
|---|
| 1829 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 1830 | º º
|
|---|
| 1831 | º This section: TDBCheckBox Class Implementation º
|
|---|
| 1832 | º º
|
|---|
| 1833 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 1834 | º º
|
|---|
| 1835 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 1836 | }
|
|---|
| 1837 |
|
|---|
| 1838 | Function TDBCheckBox.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 1839 | Var S:String;
|
|---|
| 1840 | Begin
|
|---|
| 1841 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 1842 | If Result=False Then Exit;
|
|---|
| 1843 | S:=FDataLink.FieldName;
|
|---|
| 1844 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 1845 | End;
|
|---|
| 1846 |
|
|---|
| 1847 | Procedure TDBCheckBox.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 1848 | Var S:String;
|
|---|
| 1849 | Begin
|
|---|
| 1850 | If ResName = rnDBDataField Then
|
|---|
| 1851 | Begin
|
|---|
| 1852 | System.Move(Data,S,DataLen);
|
|---|
| 1853 | FDataLink.FieldName:=S;
|
|---|
| 1854 | End
|
|---|
| 1855 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 1856 | End;
|
|---|
| 1857 |
|
|---|
| 1858 |
|
|---|
| 1859 | Procedure TDBCheckBox.SetDataSource(NewValue:TDataSource);
|
|---|
| 1860 | Begin
|
|---|
| 1861 | FDataLink.DataSource:=NewValue;
|
|---|
| 1862 | End;
|
|---|
| 1863 |
|
|---|
| 1864 | Function TDBCheckBox.GetDataSource:TDataSource;
|
|---|
| 1865 | Begin
|
|---|
| 1866 | Result:=FDataLink.DataSource;
|
|---|
| 1867 | End;
|
|---|
| 1868 |
|
|---|
| 1869 | Procedure TDBCheckBox.SetDataField(NewValue:String);
|
|---|
| 1870 | Begin
|
|---|
| 1871 | FDataLink.FieldName:=NewValue;
|
|---|
| 1872 | End;
|
|---|
| 1873 |
|
|---|
| 1874 | Function TDBCheckBox.GetDataField:String;
|
|---|
| 1875 | Begin
|
|---|
| 1876 | Result:=FDataLink.FieldName;
|
|---|
| 1877 | End;
|
|---|
| 1878 |
|
|---|
| 1879 | Procedure TDBCheckBox.SetupComponent;
|
|---|
| 1880 | Begin
|
|---|
| 1881 | Inherited SetupComponent;
|
|---|
| 1882 |
|
|---|
| 1883 | FDataLink.Create(Self);
|
|---|
| 1884 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 1885 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 1886 |
|
|---|
| 1887 | Name:='DBCheckBox';
|
|---|
| 1888 | Caption:=Name;
|
|---|
| 1889 |
|
|---|
| 1890 | ValueChecked := 'True';
|
|---|
| 1891 | ValueUnchecked := 'False';
|
|---|
| 1892 | End;
|
|---|
| 1893 |
|
|---|
| 1894 | Destructor TDBCheckBox.Destroy;
|
|---|
| 1895 | Begin
|
|---|
| 1896 | FDataLink.OnDataChange:=Nil;
|
|---|
| 1897 | FDataLink.Destroy;
|
|---|
| 1898 | FDataLink:=Nil;
|
|---|
| 1899 | If FValueChecked<>Nil Then FreeMem(FValueChecked,Length(FValueChecked^)+1);
|
|---|
| 1900 | FValueChecked:=Nil;
|
|---|
| 1901 | If FValueUnchecked<>Nil Then FreeMem(FValueUnchecked,Length(FValueUnchecked^)+1);
|
|---|
| 1902 | FValueUnchecked:=Nil;
|
|---|
| 1903 |
|
|---|
| 1904 | Inherited Destroy;
|
|---|
| 1905 | End;
|
|---|
| 1906 |
|
|---|
| 1907 |
|
|---|
| 1908 | Procedure TDBCheckBox.WriteBack;
|
|---|
| 1909 | Var S:String;
|
|---|
| 1910 | Field:TField;
|
|---|
| 1911 | Begin
|
|---|
| 1912 | If FDataLink = Nil Then exit;
|
|---|
| 1913 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 1914 | If Checked Then S:=ValueChecked
|
|---|
| 1915 | Else S:=ValueUnchecked;
|
|---|
| 1916 |
|
|---|
| 1917 | Try
|
|---|
| 1918 | Field:=FDataLink.Field;
|
|---|
| 1919 | If Field<>Nil Then
|
|---|
| 1920 | If Field.AsString<>S Then
|
|---|
| 1921 | Begin
|
|---|
| 1922 | Field.AsString:=S;
|
|---|
| 1923 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 1924 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 1925 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 1926 | End;
|
|---|
| 1927 | Except
|
|---|
| 1928 | ON E:ESQLError Do
|
|---|
| 1929 | Begin
|
|---|
| 1930 | ErrorBox(E.Message);
|
|---|
| 1931 | Field:=Nil;
|
|---|
| 1932 | End;
|
|---|
| 1933 | Else Raise;
|
|---|
| 1934 | End;
|
|---|
| 1935 | End;
|
|---|
| 1936 |
|
|---|
| 1937 | Procedure TDBCheckBox.Click;
|
|---|
| 1938 | Begin
|
|---|
| 1939 | Inherited Click;
|
|---|
| 1940 |
|
|---|
| 1941 | WriteBack;
|
|---|
| 1942 | End;
|
|---|
| 1943 |
|
|---|
| 1944 | {$HINTS OFF}
|
|---|
| 1945 | Procedure TDBCheckBox.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 1946 | Var Field:TField;
|
|---|
| 1947 | S,s1:String;
|
|---|
| 1948 | Value:String;
|
|---|
| 1949 | B:Byte;
|
|---|
| 1950 | Begin
|
|---|
| 1951 | Try
|
|---|
| 1952 | Field:=FDataLink.Field;
|
|---|
| 1953 | Except
|
|---|
| 1954 | ON E:ESQLError Do
|
|---|
| 1955 | Begin
|
|---|
| 1956 | ErrorBox(E.Message);
|
|---|
| 1957 | Field:=Nil;
|
|---|
| 1958 | End;
|
|---|
| 1959 | Else Raise;
|
|---|
| 1960 | End;
|
|---|
| 1961 | If Field<>Nil Then
|
|---|
| 1962 | Begin
|
|---|
| 1963 | Value:=Field.AsString;
|
|---|
| 1964 | If Value <> '' Then
|
|---|
| 1965 | Begin
|
|---|
| 1966 | S:=ValueChecked;
|
|---|
| 1967 | UpcaseStr(S);
|
|---|
| 1968 | UpcaseStr(Value);
|
|---|
| 1969 | B:=Pos(';',S);
|
|---|
| 1970 | While B<>0 Do
|
|---|
| 1971 | Begin
|
|---|
| 1972 | s1:=Copy(S,1,B-1);
|
|---|
| 1973 | Delete(S,1,B);
|
|---|
| 1974 | If s1=Value Then
|
|---|
| 1975 | Begin
|
|---|
| 1976 | Checked:=True;
|
|---|
| 1977 | Exit;
|
|---|
| 1978 | End;
|
|---|
| 1979 | B:=Pos(';',S);
|
|---|
| 1980 | End;
|
|---|
| 1981 | Checked:=S=Value;
|
|---|
| 1982 | End
|
|---|
| 1983 | Else State:=cbGrayed;
|
|---|
| 1984 | End
|
|---|
| 1985 | //Else Checked:=False;
|
|---|
| 1986 | Else State:=cbGrayed;
|
|---|
| 1987 | End;
|
|---|
| 1988 | {$HINTS ON}
|
|---|
| 1989 |
|
|---|
| 1990 | Procedure TDBCheckBox.SetupShow;
|
|---|
| 1991 | Begin
|
|---|
| 1992 | Inherited SetupShow;
|
|---|
| 1993 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 1994 | End;
|
|---|
| 1995 |
|
|---|
| 1996 | Procedure TDBCheckBox.SetValueChecked(NewValue:String);
|
|---|
| 1997 | Begin
|
|---|
| 1998 | If FValueChecked<>Nil Then FreeMem(FValueChecked,Length(FValueChecked^)+1);
|
|---|
| 1999 | If NewValue<>'' Then
|
|---|
| 2000 | Begin
|
|---|
| 2001 | GetMem(FValueChecked,Length(NewValue)+1);
|
|---|
| 2002 | FValueChecked^:=NewValue;
|
|---|
| 2003 | End
|
|---|
| 2004 | Else FValueChecked:=Nil;
|
|---|
| 2005 | End;
|
|---|
| 2006 |
|
|---|
| 2007 | Function TDBCheckBox.GetValueChecked:String;
|
|---|
| 2008 | Begin
|
|---|
| 2009 | If FValueChecked=Nil Then Result:=''
|
|---|
| 2010 | Else Result:=FValueChecked^;
|
|---|
| 2011 | End;
|
|---|
| 2012 |
|
|---|
| 2013 | Procedure TDBCheckBox.SetValueUnchecked(NewValue:String);
|
|---|
| 2014 | Begin
|
|---|
| 2015 | If FValueUnchecked<>Nil Then FreeMem(FValueUnchecked,Length(FValueUnchecked^)+1);
|
|---|
| 2016 | If NewValue<>'' Then
|
|---|
| 2017 | Begin
|
|---|
| 2018 | GetMem(FValueUnchecked,Length(NewValue)+1);
|
|---|
| 2019 | FValueUnchecked^:=NewValue;
|
|---|
| 2020 | End
|
|---|
| 2021 | Else FValueUnchecked:=Nil;
|
|---|
| 2022 | End;
|
|---|
| 2023 |
|
|---|
| 2024 | Function TDBCheckBox.GetValueUnchecked:String;
|
|---|
| 2025 | Begin
|
|---|
| 2026 | If FValueUnchecked=Nil Then Result:=''
|
|---|
| 2027 | Else Result:=FValueUnchecked^;
|
|---|
| 2028 | End;
|
|---|
| 2029 |
|
|---|
| 2030 |
|
|---|
| 2031 | {
|
|---|
| 2032 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2033 | º º
|
|---|
| 2034 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2035 | º º
|
|---|
| 2036 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2037 | º º
|
|---|
| 2038 | º This section: TDBImage Class Implementation º
|
|---|
| 2039 | º º
|
|---|
| 2040 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2041 | º º
|
|---|
| 2042 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2043 | }
|
|---|
| 2044 |
|
|---|
| 2045 | Function TDBImage.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 2046 | Var S:String;
|
|---|
| 2047 | Begin
|
|---|
| 2048 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 2049 | If Result=False Then Exit;
|
|---|
| 2050 | S:=FDataLink.FieldName;
|
|---|
| 2051 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 2052 | End;
|
|---|
| 2053 |
|
|---|
| 2054 | Procedure TDBImage.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 2055 | Var S:String;
|
|---|
| 2056 | Begin
|
|---|
| 2057 | If ResName = rnDBDataField Then
|
|---|
| 2058 | Begin
|
|---|
| 2059 | System.Move(Data,S,DataLen);
|
|---|
| 2060 | FDataLink.FieldName:=S;
|
|---|
| 2061 | End
|
|---|
| 2062 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 2063 | End;
|
|---|
| 2064 |
|
|---|
| 2065 |
|
|---|
| 2066 | Procedure TDBImage.SetDataSource(NewValue:TDataSource);
|
|---|
| 2067 | Begin
|
|---|
| 2068 | FDataLink.DataSource:=NewValue;
|
|---|
| 2069 | End;
|
|---|
| 2070 |
|
|---|
| 2071 | Function TDBImage.GetDataSource:TDataSource;
|
|---|
| 2072 | Begin
|
|---|
| 2073 | Result:=FDataLink.DataSource;
|
|---|
| 2074 | End;
|
|---|
| 2075 |
|
|---|
| 2076 | Procedure TDBImage.SetDataField(NewValue:String);
|
|---|
| 2077 | Begin
|
|---|
| 2078 | FDataLink.FieldName:=NewValue;
|
|---|
| 2079 | End;
|
|---|
| 2080 |
|
|---|
| 2081 | Function TDBImage.GetDataField:String;
|
|---|
| 2082 | Begin
|
|---|
| 2083 | Result:=FDataLink.FieldName;
|
|---|
| 2084 | End;
|
|---|
| 2085 |
|
|---|
| 2086 | Procedure TDBImage.SetupComponent;
|
|---|
| 2087 | Begin
|
|---|
| 2088 | Inherited SetupComponent;
|
|---|
| 2089 |
|
|---|
| 2090 | FDataLink.Create(Self);
|
|---|
| 2091 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 2092 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 2093 |
|
|---|
| 2094 | Name:='DBImage';
|
|---|
| 2095 | End;
|
|---|
| 2096 |
|
|---|
| 2097 | Destructor TDBImage.Destroy;
|
|---|
| 2098 | Begin
|
|---|
| 2099 | (* destroyed In Inherited
|
|---|
| 2100 | If FBitmap<>Nil Then
|
|---|
| 2101 | Begin
|
|---|
| 2102 | FBitmap.Destroy;
|
|---|
| 2103 | FBitmap:=Nil;
|
|---|
| 2104 | End;
|
|---|
| 2105 | *)
|
|---|
| 2106 | FDataLink.OnDataChange:=Nil;
|
|---|
| 2107 | FDataLink.Destroy;
|
|---|
| 2108 | FDataLink:=Nil;
|
|---|
| 2109 |
|
|---|
| 2110 | Inherited Destroy;
|
|---|
| 2111 | End;
|
|---|
| 2112 |
|
|---|
| 2113 | Procedure TDBImage.SetupShow;
|
|---|
| 2114 | Begin
|
|---|
| 2115 | NeedBitmap := False;
|
|---|
| 2116 | Inherited SetupShow;
|
|---|
| 2117 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 2118 | End;
|
|---|
| 2119 |
|
|---|
| 2120 | //Inhalt der Grafik hat sich gendert - in DB zurckschreiben
|
|---|
| 2121 | Procedure TDBImage.Change;
|
|---|
| 2122 | Begin
|
|---|
| 2123 | If FChangeLock Then exit;
|
|---|
| 2124 |
|
|---|
| 2125 | Inherited Change;
|
|---|
| 2126 |
|
|---|
| 2127 | FChangeLock:=True;
|
|---|
| 2128 | WriteBack;
|
|---|
| 2129 |
|
|---|
| 2130 | FChangeLock:=False;
|
|---|
| 2131 | End;
|
|---|
| 2132 |
|
|---|
| 2133 | {$HINTS OFF}
|
|---|
| 2134 | Procedure TDBImage.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 2135 | Var Field:TField;
|
|---|
| 2136 | Begin
|
|---|
| 2137 | If FChangeLock Then exit;
|
|---|
| 2138 | FChangeLock:=True;
|
|---|
| 2139 | Try
|
|---|
| 2140 | Field := FDataLink.Field;
|
|---|
| 2141 | Except
|
|---|
| 2142 | ON E:ESQLError Do
|
|---|
| 2143 | Begin
|
|---|
| 2144 | ErrorBox(E.Message);
|
|---|
| 2145 | Field:=Nil;
|
|---|
| 2146 | End;
|
|---|
| 2147 | Else
|
|---|
| 2148 | Begin
|
|---|
| 2149 | FChangeLock:=False;
|
|---|
| 2150 | Raise;
|
|---|
| 2151 | End;
|
|---|
| 2152 | End;
|
|---|
| 2153 | If Field Is TBlobField Then
|
|---|
| 2154 | Begin
|
|---|
| 2155 | Try
|
|---|
| 2156 | {creates A New Bitmap In GetBitmap If FBitmap = Nil}
|
|---|
| 2157 | Bitmap.LoadFromMem(TBlobField(Field).Value^,Field.ValueLen);
|
|---|
| 2158 | Except
|
|---|
| 2159 | Bitmap := Nil;
|
|---|
| 2160 | End;
|
|---|
| 2161 | End
|
|---|
| 2162 | Else Bitmap := Nil;
|
|---|
| 2163 |
|
|---|
| 2164 | Invalidate;
|
|---|
| 2165 | FChangeLock:=False;
|
|---|
| 2166 | End;
|
|---|
| 2167 | {$HINTS ON}
|
|---|
| 2168 |
|
|---|
| 2169 | Procedure TDBImage.WriteBack;
|
|---|
| 2170 | Var Field:TBlobField;
|
|---|
| 2171 | Stream:TMemoryStream;
|
|---|
| 2172 | Begin
|
|---|
| 2173 | If FDataLink = Nil Then exit;
|
|---|
| 2174 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2175 |
|
|---|
| 2176 | Try
|
|---|
| 2177 | Field:=TBlobField(FDataLink.Field);
|
|---|
| 2178 | If Field<>Nil Then
|
|---|
| 2179 | Begin
|
|---|
| 2180 | If Field Is TBlobField Then
|
|---|
| 2181 | Begin
|
|---|
| 2182 | Stream.Create;
|
|---|
| 2183 | Bitmap.SaveToStream(Stream);
|
|---|
| 2184 | Field.LoadFromStream(Stream);
|
|---|
| 2185 | Stream.Destroy;
|
|---|
| 2186 |
|
|---|
| 2187 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 2188 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 2189 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 2190 | End;
|
|---|
| 2191 | End;
|
|---|
| 2192 | Except
|
|---|
| 2193 | On E:ESQLError Do
|
|---|
| 2194 | Begin
|
|---|
| 2195 | ErrorBox(E.Message);
|
|---|
| 2196 | Field:=Nil;
|
|---|
| 2197 | End;
|
|---|
| 2198 | Else Raise;
|
|---|
| 2199 | End;
|
|---|
| 2200 | End;
|
|---|
| 2201 |
|
|---|
| 2202 |
|
|---|
| 2203 | {
|
|---|
| 2204 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2205 | º º
|
|---|
| 2206 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2207 | º º
|
|---|
| 2208 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2209 | º º
|
|---|
| 2210 | º This section: TDBMemo Class Implementation º
|
|---|
| 2211 | º º
|
|---|
| 2212 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2213 | º º
|
|---|
| 2214 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2215 | }
|
|---|
| 2216 |
|
|---|
| 2217 | Function TDBMemo.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 2218 | Var S:String;
|
|---|
| 2219 | Begin
|
|---|
| 2220 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 2221 | If Result=False Then Exit;
|
|---|
| 2222 | S:=FDataLink.FieldName;
|
|---|
| 2223 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 2224 | End;
|
|---|
| 2225 |
|
|---|
| 2226 | Procedure TDBMemo.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 2227 | Var S:String;
|
|---|
| 2228 | Begin
|
|---|
| 2229 | If ResName = rnDBDataField Then
|
|---|
| 2230 | Begin
|
|---|
| 2231 | System.Move(Data,S,DataLen);
|
|---|
| 2232 | FDataLink.FieldName:=S;
|
|---|
| 2233 | End
|
|---|
| 2234 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 2235 | End;
|
|---|
| 2236 |
|
|---|
| 2237 |
|
|---|
| 2238 | Procedure TDBMemo.SetDataSource(NewValue:TDataSource);
|
|---|
| 2239 | Begin
|
|---|
| 2240 | FDataLink.DataSource:=NewValue;
|
|---|
| 2241 | End;
|
|---|
| 2242 |
|
|---|
| 2243 | Function TDBMemo.GetDataSource:TDataSource;
|
|---|
| 2244 | Begin
|
|---|
| 2245 | Result:=FDataLink.DataSource;
|
|---|
| 2246 | End;
|
|---|
| 2247 |
|
|---|
| 2248 | Procedure TDBMemo.SetDataField(NewValue:String);
|
|---|
| 2249 | Begin
|
|---|
| 2250 | FDataLink.FieldName:=NewValue;
|
|---|
| 2251 | End;
|
|---|
| 2252 |
|
|---|
| 2253 | Function TDBMemo.GetDataField:String;
|
|---|
| 2254 | Begin
|
|---|
| 2255 | Result:=FDataLink.FieldName;
|
|---|
| 2256 | End;
|
|---|
| 2257 |
|
|---|
| 2258 | Procedure TDBMemo.SetupComponent;
|
|---|
| 2259 | Begin
|
|---|
| 2260 | Inherited SetupComponent;
|
|---|
| 2261 |
|
|---|
| 2262 | FDataLink.Create(Self);
|
|---|
| 2263 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 2264 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 2265 |
|
|---|
| 2266 | Name:='DBMemo';
|
|---|
| 2267 | End;
|
|---|
| 2268 |
|
|---|
| 2269 | Destructor TDBMemo.Destroy;
|
|---|
| 2270 | Begin
|
|---|
| 2271 | FDataLink.OnDataChange:=Nil;
|
|---|
| 2272 | FDataLink.Destroy;
|
|---|
| 2273 | FDataLink:=Nil;
|
|---|
| 2274 |
|
|---|
| 2275 | Inherited Destroy;
|
|---|
| 2276 | End;
|
|---|
| 2277 |
|
|---|
| 2278 | {$HINTS OFF}
|
|---|
| 2279 | Procedure TDBMemo.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 2280 | Var Field:TField;
|
|---|
| 2281 | Begin
|
|---|
| 2282 | Try
|
|---|
| 2283 | Field:=FDataLink.Field;
|
|---|
| 2284 | Except
|
|---|
| 2285 | ON E:ESQLError Do
|
|---|
| 2286 | Begin
|
|---|
| 2287 | ErrorBox(E.Message);
|
|---|
| 2288 | Field:=Nil;
|
|---|
| 2289 | End;
|
|---|
| 2290 | Else Raise;
|
|---|
| 2291 | End;
|
|---|
| 2292 | If Field<>Nil Then
|
|---|
| 2293 | Begin
|
|---|
| 2294 | If Field Is TBlobField Then
|
|---|
| 2295 | Lines.SetText(PChar(TBlobField(Field).Value))
|
|---|
| 2296 | Else If Field Is TMemoField Then
|
|---|
| 2297 | Lines.SetText(PChar(TMemoField(Field).Value))
|
|---|
| 2298 | Else
|
|---|
| 2299 | Lines.SetText(Nil);
|
|---|
| 2300 | End
|
|---|
| 2301 | Else
|
|---|
| 2302 | Begin
|
|---|
| 2303 | Lines.SetText(Nil);
|
|---|
| 2304 | End;
|
|---|
| 2305 | End;
|
|---|
| 2306 | {$HINTS ON}
|
|---|
| 2307 |
|
|---|
| 2308 | Procedure TDBMemo.SetupShow;
|
|---|
| 2309 | Begin
|
|---|
| 2310 | Inherited SetupShow;
|
|---|
| 2311 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 2312 | End;
|
|---|
| 2313 |
|
|---|
| 2314 |
|
|---|
| 2315 | Procedure TDBMemo.WriteBack;
|
|---|
| 2316 | Var Ansi:AnsiString;
|
|---|
| 2317 | pc:PChar;
|
|---|
| 2318 | Field:TField;
|
|---|
| 2319 | Begin
|
|---|
| 2320 | If FDataLink = Nil Then exit;
|
|---|
| 2321 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2322 |
|
|---|
| 2323 | Try
|
|---|
| 2324 | Field:=FDataLink.Field;
|
|---|
| 2325 | If Field<>Nil Then
|
|---|
| 2326 | Begin
|
|---|
| 2327 | pc:=Lines.GetText;
|
|---|
| 2328 | If pc <> Nil Then
|
|---|
| 2329 | Begin
|
|---|
| 2330 | Ansi:=pc^;
|
|---|
| 2331 | StrDispose(pc);
|
|---|
| 2332 | End
|
|---|
| 2333 | Else Ansi := '';
|
|---|
| 2334 |
|
|---|
| 2335 | If Field.AsAnsiString<>Ansi Then
|
|---|
| 2336 | Begin
|
|---|
| 2337 | Field.AsAnsiString:=Ansi;
|
|---|
| 2338 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 2339 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 2340 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 2341 | End;
|
|---|
| 2342 | End;
|
|---|
| 2343 | Except
|
|---|
| 2344 | On E:ESQLError Do
|
|---|
| 2345 | Begin
|
|---|
| 2346 | ErrorBox(E.Message);
|
|---|
| 2347 | Field:=Nil;
|
|---|
| 2348 | End;
|
|---|
| 2349 | Else Raise;
|
|---|
| 2350 | End;
|
|---|
| 2351 | End;
|
|---|
| 2352 |
|
|---|
| 2353 | Procedure TDBMemo.KillFocus;
|
|---|
| 2354 | Begin
|
|---|
| 2355 | WriteBack;
|
|---|
| 2356 |
|
|---|
| 2357 | Inherited KillFocus;
|
|---|
| 2358 | End;
|
|---|
| 2359 |
|
|---|
| 2360 |
|
|---|
| 2361 | {
|
|---|
| 2362 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2363 | º º
|
|---|
| 2364 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2365 | º º
|
|---|
| 2366 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2367 | º º
|
|---|
| 2368 | º This section: TDBListBox Class Implementation º
|
|---|
| 2369 | º º
|
|---|
| 2370 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2371 | º º
|
|---|
| 2372 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2373 | }
|
|---|
| 2374 |
|
|---|
| 2375 | Function TDBListBox.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 2376 | Var S:String;
|
|---|
| 2377 | Begin
|
|---|
| 2378 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 2379 | If Result=False Then Exit;
|
|---|
| 2380 | S:=FDataLink.FieldName;
|
|---|
| 2381 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 2382 | End;
|
|---|
| 2383 |
|
|---|
| 2384 | Procedure TDBListBox.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 2385 | Var S:String;
|
|---|
| 2386 | Begin
|
|---|
| 2387 | If ResName = rnDBDataField Then
|
|---|
| 2388 | Begin
|
|---|
| 2389 | System.Move(Data,S,DataLen);
|
|---|
| 2390 | FDataLink.FieldName:=S;
|
|---|
| 2391 | End
|
|---|
| 2392 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 2393 | End;
|
|---|
| 2394 |
|
|---|
| 2395 |
|
|---|
| 2396 | Procedure TDBListBox.SetDataSource(NewValue:TDataSource);
|
|---|
| 2397 | Begin
|
|---|
| 2398 | FDataLink.DataSource:=NewValue;
|
|---|
| 2399 | End;
|
|---|
| 2400 |
|
|---|
| 2401 | Function TDBListBox.GetDataSource:TDataSource;
|
|---|
| 2402 | Begin
|
|---|
| 2403 | Result:=FDataLink.DataSource;
|
|---|
| 2404 | End;
|
|---|
| 2405 |
|
|---|
| 2406 | Procedure TDBListBox.SetDataField(NewValue:String);
|
|---|
| 2407 | Begin
|
|---|
| 2408 | FDataLink.FieldName:=NewValue;
|
|---|
| 2409 | End;
|
|---|
| 2410 |
|
|---|
| 2411 | Function TDBListBox.GetDataField:String;
|
|---|
| 2412 | Begin
|
|---|
| 2413 | Result:=FDataLink.FieldName;
|
|---|
| 2414 | End;
|
|---|
| 2415 |
|
|---|
| 2416 | Type
|
|---|
| 2417 | TDBListBoxStrings=Class(TStrings)
|
|---|
| 2418 | Private
|
|---|
| 2419 | Items:TStrings;
|
|---|
| 2420 | DataLink:TFieldDataLink;
|
|---|
| 2421 | Protected
|
|---|
| 2422 | Function GetCount:LongInt; Override;
|
|---|
| 2423 | Function Get(Index:LongInt):String; Override;
|
|---|
| 2424 | Function GetObject(Index:LongInt):TObject; Override;
|
|---|
| 2425 | Procedure Put(Index:LongInt;Const S:String); Override;
|
|---|
| 2426 | Procedure PutObject(Index:LongInt;AObject:TObject); Override;
|
|---|
| 2427 | Public
|
|---|
| 2428 | Procedure Assign(AStrings:TStrings); Override;
|
|---|
| 2429 | Function Add(Const S:String):LongInt; Override;
|
|---|
| 2430 | Procedure Insert(Index:LongInt;Const S:String); Override;
|
|---|
| 2431 | Procedure Delete(Index:LongInt); Override;
|
|---|
| 2432 | Procedure Clear; Override;
|
|---|
| 2433 | {$IFDEF OS2}
|
|---|
| 2434 | Function IndexOf(Const S:String):LongInt; Override;
|
|---|
| 2435 | {$ENDIF}
|
|---|
| 2436 | End;
|
|---|
| 2437 |
|
|---|
| 2438 | Function TDBListBoxStrings.GetCount:LongInt;
|
|---|
| 2439 | Begin
|
|---|
| 2440 | Result:=Items.Count;
|
|---|
| 2441 | End;
|
|---|
| 2442 |
|
|---|
| 2443 | Function TDBListBoxStrings.Get(Index:LongInt):String;
|
|---|
| 2444 | Begin
|
|---|
| 2445 | Result:=Items.Strings[Index];
|
|---|
| 2446 | End;
|
|---|
| 2447 |
|
|---|
| 2448 | Function TDBListBoxStrings.GetObject(Index:LongInt):TObject;
|
|---|
| 2449 | Begin
|
|---|
| 2450 | Result:=Items.Objects[Index];
|
|---|
| 2451 | End;
|
|---|
| 2452 |
|
|---|
| 2453 | Procedure TDBListBoxStrings.Put(Index:LongInt;Const S:String);
|
|---|
| 2454 | Var Field:TField;
|
|---|
| 2455 | Begin
|
|---|
| 2456 | If ((DataLink.DataSource=Nil)Or(DataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2457 |
|
|---|
| 2458 | //Change DataBase
|
|---|
| 2459 | Try
|
|---|
| 2460 | Field:=DataLink.Field;
|
|---|
| 2461 | If Field<>Nil Then If Field.AsString<>S Then
|
|---|
| 2462 | Begin
|
|---|
| 2463 | Field.AsString:=S;
|
|---|
| 2464 | If Not DataLink.DataSource.DataSet.RowInserted
|
|---|
| 2465 | Then DataLink.DataSource.DataSet.Post
|
|---|
| 2466 | Else DataLink.DataSource.DataSet.Refresh;
|
|---|
| 2467 | End;
|
|---|
| 2468 | Except
|
|---|
| 2469 | ON E:ESQLError Do
|
|---|
| 2470 | Begin
|
|---|
| 2471 | ErrorBox(E.Message);
|
|---|
| 2472 | Field:=Nil;
|
|---|
| 2473 | End;
|
|---|
| 2474 | Else Raise;
|
|---|
| 2475 | End;
|
|---|
| 2476 |
|
|---|
| 2477 | If Field<>Nil Then Items.Strings[Index]:=S;
|
|---|
| 2478 | End;
|
|---|
| 2479 |
|
|---|
| 2480 | Procedure TDBListBoxStrings.PutObject(Index:LongInt;AObject:TObject);
|
|---|
| 2481 | Begin
|
|---|
| 2482 | Items.Objects[Index]:=AObject;
|
|---|
| 2483 | End;
|
|---|
| 2484 |
|
|---|
| 2485 | Procedure TDBListBoxStrings.Assign(AStrings:TStrings);
|
|---|
| 2486 | Var T:LongInt;
|
|---|
| 2487 | Begin
|
|---|
| 2488 | If AStrings=Nil Then Exit;
|
|---|
| 2489 | For T:=0 To Count-1 Do
|
|---|
| 2490 | Begin
|
|---|
| 2491 | If T>AStrings.Count-1 Then Exit;
|
|---|
| 2492 | Strings[T]:=AStrings.Strings[T];
|
|---|
| 2493 | End;
|
|---|
| 2494 | End;
|
|---|
| 2495 |
|
|---|
| 2496 | Function TDBListBoxStrings.Add(Const S:String):LongInt;
|
|---|
| 2497 | Begin
|
|---|
| 2498 | Result := Items.Add(S);
|
|---|
| 2499 | //Change DataBase
|
|---|
| 2500 | End;
|
|---|
| 2501 |
|
|---|
| 2502 | Procedure TDBListBoxStrings.Insert(Index:LongInt;Const S:String);
|
|---|
| 2503 | Begin
|
|---|
| 2504 | Items.Insert(Index,S);
|
|---|
| 2505 | //Change DataBase
|
|---|
| 2506 | End;
|
|---|
| 2507 |
|
|---|
| 2508 | Procedure TDBListBoxStrings.Delete(Index:LongInt);
|
|---|
| 2509 | Begin
|
|---|
| 2510 | Items.Delete(Index);
|
|---|
| 2511 | //Change DataBase
|
|---|
| 2512 | End;
|
|---|
| 2513 |
|
|---|
| 2514 | Procedure TDBListBoxStrings.Clear;
|
|---|
| 2515 | Begin
|
|---|
| 2516 | Items.Clear;
|
|---|
| 2517 | //Change DataBase
|
|---|
| 2518 | End;
|
|---|
| 2519 |
|
|---|
| 2520 | {$IFDEF OS2}
|
|---|
| 2521 | Function TDBListBoxStrings.IndexOf(Const S:String):LongInt;
|
|---|
| 2522 | Begin
|
|---|
| 2523 | Result:=Items.IndexOf(S);
|
|---|
| 2524 | End;
|
|---|
| 2525 | {$ENDIF}
|
|---|
| 2526 |
|
|---|
| 2527 | Procedure TDBListBox.SetupComponent;
|
|---|
| 2528 | Begin
|
|---|
| 2529 | Inherited SetupComponent;
|
|---|
| 2530 |
|
|---|
| 2531 | FDBStrings:=TDBListBoxStrings.Create;
|
|---|
| 2532 | TDBListBoxStrings(FDBStrings).Items:=Inherited Items;
|
|---|
| 2533 | FDataLink.Create(Self);
|
|---|
| 2534 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 2535 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 2536 |
|
|---|
| 2537 | Name:='DBListBox';
|
|---|
| 2538 | End;
|
|---|
| 2539 |
|
|---|
| 2540 | Destructor TDBListBox.Destroy;
|
|---|
| 2541 | Begin
|
|---|
| 2542 | FDataLink.OnDataChange:=Nil;
|
|---|
| 2543 | FDataLink.Destroy;
|
|---|
| 2544 | FDataLink:=Nil;
|
|---|
| 2545 | FDBStrings.Destroy;
|
|---|
| 2546 | FDBStrings:=Nil;
|
|---|
| 2547 |
|
|---|
| 2548 | Inherited Destroy;
|
|---|
| 2549 | End;
|
|---|
| 2550 |
|
|---|
| 2551 | {$HINTS OFF}
|
|---|
| 2552 | Procedure TDBListBox.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 2553 | Var Field:TField;
|
|---|
| 2554 | OldRow:LongInt;
|
|---|
| 2555 | Eof:Boolean;
|
|---|
| 2556 | Begin
|
|---|
| 2557 | If ((event=deDataBaseChanged)Or(Items.Count=0)) Then
|
|---|
| 2558 | Begin
|
|---|
| 2559 | BeginUpdate;
|
|---|
| 2560 | Items.Clear;
|
|---|
| 2561 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)Or
|
|---|
| 2562 | (Not FDataLink.DataSource.DataSet.Active)) Then
|
|---|
| 2563 | Begin
|
|---|
| 2564 | EndUpdate;
|
|---|
| 2565 | Exit;
|
|---|
| 2566 | End;
|
|---|
| 2567 |
|
|---|
| 2568 | FDataLink.DataSource.DataSet.DataChangeLock:=True;
|
|---|
| 2569 | OldRow:=FDataLink.DataSource.DataSet.CurrentRow;
|
|---|
| 2570 |
|
|---|
| 2571 | Try
|
|---|
| 2572 | FDataLink.DataSource.DataSet.First;
|
|---|
| 2573 |
|
|---|
| 2574 | Repeat
|
|---|
| 2575 | Try
|
|---|
| 2576 | Field:=FDataLink.Field;
|
|---|
| 2577 | Except
|
|---|
| 2578 | ON E:ESQLError Do
|
|---|
| 2579 | Begin
|
|---|
| 2580 | ErrorBox(E.Message);
|
|---|
| 2581 | Field:=Nil;
|
|---|
| 2582 | End;
|
|---|
| 2583 | Else Raise;
|
|---|
| 2584 | End;
|
|---|
| 2585 |
|
|---|
| 2586 | If Field<>Nil Then TDBListBoxStrings(FDBStrings).Items.Add(Field.AsString);
|
|---|
| 2587 |
|
|---|
| 2588 | Eof:=FDataLink.DataSource.DataSet.Eof;
|
|---|
| 2589 | FDataLink.DataSource.DataSet.Next;
|
|---|
| 2590 | Until Eof;
|
|---|
| 2591 | Except
|
|---|
| 2592 | End;
|
|---|
| 2593 |
|
|---|
| 2594 | FDataLink.DataSource.DataSet.CurrentRow:=OldRow;
|
|---|
| 2595 | FDataLink.DataSource.DataSet.DataChangeLock:=False;
|
|---|
| 2596 | EndUpdate;
|
|---|
| 2597 | ItemIndex:=OldRow;
|
|---|
| 2598 | End
|
|---|
| 2599 | Else If event=dePositionChanged Then
|
|---|
| 2600 | Begin
|
|---|
| 2601 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2602 | ItemIndex:=FDataLink.DataSource.DataSet.CurrentRow;
|
|---|
| 2603 | End;
|
|---|
| 2604 | End;
|
|---|
| 2605 | {$HINTS ON}
|
|---|
| 2606 |
|
|---|
| 2607 | Procedure TDBListBox.SetupShow;
|
|---|
| 2608 | Begin
|
|---|
| 2609 | Inherited SetupShow;
|
|---|
| 2610 | TDBListBoxStrings(FDBStrings).Items:=Inherited Items;
|
|---|
| 2611 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 2612 | End;
|
|---|
| 2613 |
|
|---|
| 2614 | Procedure TDBListBox.SetItems(NewValue:TStrings);
|
|---|
| 2615 | Begin
|
|---|
| 2616 | TDBListBoxStrings(FDBStrings).Assign(NewValue);
|
|---|
| 2617 | End;
|
|---|
| 2618 |
|
|---|
| 2619 | Procedure TDBListBox.ItemFocus(Index:LongInt);
|
|---|
| 2620 | Begin
|
|---|
| 2621 | Inherited ItemFocus(Index);
|
|---|
| 2622 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2623 | FDataLink.DataSource.DataSet.CurrentRow:=ItemIndex;
|
|---|
| 2624 | End;
|
|---|
| 2625 |
|
|---|
| 2626 | {
|
|---|
| 2627 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2628 | º º
|
|---|
| 2629 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2630 | º º
|
|---|
| 2631 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2632 | º º
|
|---|
| 2633 | º This section: TDBComboBox Class Implementation º
|
|---|
| 2634 | º º
|
|---|
| 2635 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2636 | º º
|
|---|
| 2637 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2638 | }
|
|---|
| 2639 |
|
|---|
| 2640 | Function TDBComboBox.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 2641 | Var S:String;
|
|---|
| 2642 | Begin
|
|---|
| 2643 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 2644 | If Result=False Then Exit;
|
|---|
| 2645 | S:=FDataLink.FieldName;
|
|---|
| 2646 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 2647 | End;
|
|---|
| 2648 |
|
|---|
| 2649 | Procedure TDBComboBox.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 2650 | Var S:String;
|
|---|
| 2651 | Begin
|
|---|
| 2652 | If ResName = rnDBDataField Then
|
|---|
| 2653 | Begin
|
|---|
| 2654 | System.Move(Data,S,DataLen);
|
|---|
| 2655 | FDataLink.FieldName:=S;
|
|---|
| 2656 | End
|
|---|
| 2657 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 2658 | End;
|
|---|
| 2659 |
|
|---|
| 2660 | Procedure TDBComboBox.SetDataSource(NewValue:TDataSource);
|
|---|
| 2661 | Begin
|
|---|
| 2662 | FDataLink.DataSource:=NewValue;
|
|---|
| 2663 | End;
|
|---|
| 2664 |
|
|---|
| 2665 | Function TDBComboBox.GetDataSource:TDataSource;
|
|---|
| 2666 | Begin
|
|---|
| 2667 | Result:=FDataLink.DataSource;
|
|---|
| 2668 | End;
|
|---|
| 2669 |
|
|---|
| 2670 | Procedure TDBComboBox.SetDataField(NewValue:String);
|
|---|
| 2671 | Begin
|
|---|
| 2672 | FDataLink.FieldName:=NewValue;
|
|---|
| 2673 | End;
|
|---|
| 2674 |
|
|---|
| 2675 | Function TDBComboBox.GetDataField:String;
|
|---|
| 2676 | Begin
|
|---|
| 2677 | Result:=FDataLink.FieldName;
|
|---|
| 2678 | End;
|
|---|
| 2679 |
|
|---|
| 2680 | Procedure TDBComboBox.SetupComponent;
|
|---|
| 2681 | Begin
|
|---|
| 2682 | Inherited SetupComponent;
|
|---|
| 2683 |
|
|---|
| 2684 | FDataLink.Create(Self);
|
|---|
| 2685 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 2686 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 2687 |
|
|---|
| 2688 | Name:='DBComboBox';
|
|---|
| 2689 | End;
|
|---|
| 2690 |
|
|---|
| 2691 | Destructor TDBComboBox.Destroy;
|
|---|
| 2692 | Begin
|
|---|
| 2693 | FDataLink.OnDataChange:=Nil;
|
|---|
| 2694 | FDataLink.Destroy;
|
|---|
| 2695 | FDataLink:=Nil;
|
|---|
| 2696 |
|
|---|
| 2697 | Inherited Destroy;
|
|---|
| 2698 | End;
|
|---|
| 2699 |
|
|---|
| 2700 | {$HINTS OFF}
|
|---|
| 2701 | Procedure TDBComboBox.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 2702 | Var Field:TField;
|
|---|
| 2703 | S:String;
|
|---|
| 2704 | Begin
|
|---|
| 2705 | Try
|
|---|
| 2706 | Field:=FDataLink.Field;
|
|---|
| 2707 | If Field<>Nil Then
|
|---|
| 2708 | Begin
|
|---|
| 2709 | S:=Field.AsString;
|
|---|
| 2710 | If S<>Text Then Text:=S;
|
|---|
| 2711 | End;
|
|---|
| 2712 | Except
|
|---|
| 2713 | ON E:ESQLError Do
|
|---|
| 2714 | Begin
|
|---|
| 2715 | ErrorBox(E.Message);
|
|---|
| 2716 | Field:=Nil;
|
|---|
| 2717 | End;
|
|---|
| 2718 | Else Raise;
|
|---|
| 2719 | End;
|
|---|
| 2720 | End;
|
|---|
| 2721 | {$HINTS ON}
|
|---|
| 2722 |
|
|---|
| 2723 | Procedure TDBComboBox.SetupShow;
|
|---|
| 2724 | Begin
|
|---|
| 2725 | Inherited SetupShow;
|
|---|
| 2726 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 2727 | End;
|
|---|
| 2728 |
|
|---|
| 2729 | Procedure TDBComboBox.WriteBack;
|
|---|
| 2730 | Var Field:TField;
|
|---|
| 2731 | Begin
|
|---|
| 2732 | If FDataLink = Nil Then exit;
|
|---|
| 2733 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2734 |
|
|---|
| 2735 | Try
|
|---|
| 2736 | Field:=FDataLink.Field;
|
|---|
| 2737 | If Field<>Nil Then
|
|---|
| 2738 | If Field.AsString<>Text Then
|
|---|
| 2739 | Begin
|
|---|
| 2740 | Field.AsString:=Text;
|
|---|
| 2741 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 2742 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 2743 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 2744 | End;
|
|---|
| 2745 | Except
|
|---|
| 2746 | FLock:=False;
|
|---|
| 2747 | ON E:ESQLError Do
|
|---|
| 2748 | Begin
|
|---|
| 2749 | ErrorBox(E.Message);
|
|---|
| 2750 | Field:=Nil;
|
|---|
| 2751 | End;
|
|---|
| 2752 | Else Raise;
|
|---|
| 2753 | End;
|
|---|
| 2754 | End;
|
|---|
| 2755 |
|
|---|
| 2756 |
|
|---|
| 2757 | Procedure TDBComboBox.EditChange;
|
|---|
| 2758 | Begin
|
|---|
| 2759 | If FLock Then Exit;
|
|---|
| 2760 | FLock:=True;
|
|---|
| 2761 | WriteBack;
|
|---|
| 2762 | FLock:=False;
|
|---|
| 2763 | End;
|
|---|
| 2764 |
|
|---|
| 2765 |
|
|---|
| 2766 | {
|
|---|
| 2767 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2768 | º º
|
|---|
| 2769 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2770 | º º
|
|---|
| 2771 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2772 | º º
|
|---|
| 2773 | º This section: TDBRadioGroup Class Implementation º
|
|---|
| 2774 | º º
|
|---|
| 2775 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2776 | º º
|
|---|
| 2777 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2778 | }
|
|---|
| 2779 |
|
|---|
| 2780 | Function TDBRadioGroup.WriteSCUResource(Stream:TResourceStream):Boolean;
|
|---|
| 2781 | Var S:String;
|
|---|
| 2782 | Begin
|
|---|
| 2783 | Result:=Inherited WriteSCUResource(Stream);
|
|---|
| 2784 | If Result=False Then Exit;
|
|---|
| 2785 | S:=FDataLink.FieldName;
|
|---|
| 2786 | Result:=Stream.NewResourceEntry(rnDBDataField,S,Length(S)+1);
|
|---|
| 2787 | End;
|
|---|
| 2788 |
|
|---|
| 2789 | Procedure TDBRadioGroup.ReadSCUResource(Const ResName:TResourceName;Var Data;DataLen:LongInt);
|
|---|
| 2790 | Var S:String;
|
|---|
| 2791 | Begin
|
|---|
| 2792 | If ResName = rnDBDataField Then
|
|---|
| 2793 | Begin
|
|---|
| 2794 | System.Move(Data,S,DataLen);
|
|---|
| 2795 | FDataLink.FieldName:=S;
|
|---|
| 2796 | End
|
|---|
| 2797 | Else Inherited ReadSCUResource(ResName,Data,DataLen);
|
|---|
| 2798 | End;
|
|---|
| 2799 |
|
|---|
| 2800 | Procedure TDBRadioGroup.SetDataSource(NewValue:TDataSource);
|
|---|
| 2801 | Begin
|
|---|
| 2802 | FDataLink.DataSource:=NewValue;
|
|---|
| 2803 | End;
|
|---|
| 2804 |
|
|---|
| 2805 | Function TDBRadioGroup.GetDataSource:TDataSource;
|
|---|
| 2806 | Begin
|
|---|
| 2807 | Result:=FDataLink.DataSource;
|
|---|
| 2808 | End;
|
|---|
| 2809 |
|
|---|
| 2810 | Procedure TDBRadioGroup.SetDataField(NewValue:String);
|
|---|
| 2811 | Begin
|
|---|
| 2812 | FDataLink.FieldName:=NewValue;
|
|---|
| 2813 | End;
|
|---|
| 2814 |
|
|---|
| 2815 | Function TDBRadioGroup.GetDataField:String;
|
|---|
| 2816 | Begin
|
|---|
| 2817 | Result:=FDataLink.FieldName;
|
|---|
| 2818 | End;
|
|---|
| 2819 |
|
|---|
| 2820 | Procedure TDBRadioGroup.SetupComponent;
|
|---|
| 2821 | Begin
|
|---|
| 2822 | Inherited SetupComponent;
|
|---|
| 2823 |
|
|---|
| 2824 | FValues:=TStringList.Create;
|
|---|
| 2825 | FDataLink.Create(Self);
|
|---|
| 2826 | FDataLink.OnDataChange:=DataChange;
|
|---|
| 2827 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 2828 |
|
|---|
| 2829 | Name:='DBRadioGroup';
|
|---|
| 2830 | End;
|
|---|
| 2831 |
|
|---|
| 2832 | Destructor TDBRadioGroup.Destroy;
|
|---|
| 2833 | Begin
|
|---|
| 2834 | FDataLink.OnDataChange:=Nil;
|
|---|
| 2835 | FDataLink.Destroy;
|
|---|
| 2836 | FDataLink:=Nil;
|
|---|
| 2837 | FValues.Destroy;
|
|---|
| 2838 | FValues:=Nil;
|
|---|
| 2839 |
|
|---|
| 2840 | Inherited Destroy;
|
|---|
| 2841 | End;
|
|---|
| 2842 |
|
|---|
| 2843 | {$HINTS OFF}
|
|---|
| 2844 | Procedure TDBRadioGroup.DataChange(Sender:TObject;event:TDataChange);
|
|---|
| 2845 | Var Field:TField;
|
|---|
| 2846 | S:String;
|
|---|
| 2847 | T:LongInt;
|
|---|
| 2848 | Begin
|
|---|
| 2849 | Try
|
|---|
| 2850 | Field:=FDataLink.Field;
|
|---|
| 2851 | If Field<>Nil Then
|
|---|
| 2852 | If Value<>Field.AsString Then Value:=Field.AsString;
|
|---|
| 2853 | Except
|
|---|
| 2854 | ON E:ESQLError Do
|
|---|
| 2855 | Begin
|
|---|
| 2856 | ErrorBox(E.Message);
|
|---|
| 2857 | Field:=Nil;
|
|---|
| 2858 | End;
|
|---|
| 2859 | Else Raise;
|
|---|
| 2860 | End;
|
|---|
| 2861 | End;
|
|---|
| 2862 | {$HINTS ON}
|
|---|
| 2863 |
|
|---|
| 2864 | Procedure TDBRadioGroup.SetupShow;
|
|---|
| 2865 | Begin
|
|---|
| 2866 | Inherited SetupShow;
|
|---|
| 2867 | DataChange(FDataLink,deDataBaseChanged);
|
|---|
| 2868 | End;
|
|---|
| 2869 |
|
|---|
| 2870 | Procedure TDBRadioGroup.WriteBack;
|
|---|
| 2871 | Var S:String;
|
|---|
| 2872 | Field:TField;
|
|---|
| 2873 | Begin
|
|---|
| 2874 | If FDataLink = Nil Then exit;
|
|---|
| 2875 | If ((FDataLink.DataSource=Nil)Or(FDataLink.DataSource.DataSet=Nil)) Then Exit;
|
|---|
| 2876 | If ((FLock)Or(ItemIndex<0)) Then Exit;
|
|---|
| 2877 |
|
|---|
| 2878 | FLock:=True;
|
|---|
| 2879 | If ItemIndex<FValues.Count Then S:=FValues[ItemIndex]
|
|---|
| 2880 | Else If ItemIndex<Items.Count Then S:=Items[ItemIndex]
|
|---|
| 2881 | Else Exit;
|
|---|
| 2882 |
|
|---|
| 2883 | Try
|
|---|
| 2884 | Field:=FDataLink.Field;
|
|---|
| 2885 | If Field<>Nil Then
|
|---|
| 2886 | If Field.AsString<>S Then
|
|---|
| 2887 | Begin
|
|---|
| 2888 | Field.AsString:=S;
|
|---|
| 2889 | If Not FDataLink.DataSource.DataSet.RowInserted
|
|---|
| 2890 | Then FDataLink.DataSource.DataSet.Post
|
|---|
| 2891 | Else FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 2892 | End;
|
|---|
| 2893 | Except
|
|---|
| 2894 | FLock:=False;
|
|---|
| 2895 | ON E:ESQLError Do
|
|---|
| 2896 | Begin
|
|---|
| 2897 | ErrorBox(E.Message);
|
|---|
| 2898 | Field:=Nil;
|
|---|
| 2899 | End;
|
|---|
| 2900 | Else Raise;
|
|---|
| 2901 | End;
|
|---|
| 2902 | FLock:=False;
|
|---|
| 2903 | End;
|
|---|
| 2904 |
|
|---|
| 2905 |
|
|---|
| 2906 | Procedure TDBRadioGroup.ItemIndexChange;
|
|---|
| 2907 | Begin
|
|---|
| 2908 | WriteBack;
|
|---|
| 2909 | End;
|
|---|
| 2910 |
|
|---|
| 2911 |
|
|---|
| 2912 | Function TDBRadioGroup.GetValue:String;
|
|---|
| 2913 | Begin
|
|---|
| 2914 | If ItemIndex<0 Then Result:=''
|
|---|
| 2915 | Else
|
|---|
| 2916 | Begin
|
|---|
| 2917 | If ItemIndex<FValues.Count Then Result:=FValues[ItemIndex]
|
|---|
| 2918 | Else If ItemIndex<Items.Count Then Result:=Items[ItemIndex]
|
|---|
| 2919 | Else Result:='';
|
|---|
| 2920 | End;
|
|---|
| 2921 | End;
|
|---|
| 2922 |
|
|---|
| 2923 | Procedure TDBRadioGroup.SetValue(Const NewValue:String);
|
|---|
| 2924 | Var T:LongInt;
|
|---|
| 2925 | Begin
|
|---|
| 2926 | For T:=0 To FValues.Count-1 Do
|
|---|
| 2927 | Begin
|
|---|
| 2928 | If FValues[T]=NewValue Then
|
|---|
| 2929 | Begin
|
|---|
| 2930 | If ItemIndex<>T Then ItemIndex:=T;
|
|---|
| 2931 | Exit;
|
|---|
| 2932 | End;
|
|---|
| 2933 | End;
|
|---|
| 2934 |
|
|---|
| 2935 | For T:=0 To Items.Count-1 Do
|
|---|
| 2936 | Begin
|
|---|
| 2937 | If Items[T]=NewValue Then
|
|---|
| 2938 | Begin
|
|---|
| 2939 | If ItemIndex<>T Then ItemIndex:=T;
|
|---|
| 2940 | Exit;
|
|---|
| 2941 | End;
|
|---|
| 2942 | End;
|
|---|
| 2943 |
|
|---|
| 2944 | ItemIndex:=-1;
|
|---|
| 2945 | End;
|
|---|
| 2946 |
|
|---|
| 2947 | Procedure TDBRadioGroup.SetValues(NewValue:TStrings);
|
|---|
| 2948 | Begin
|
|---|
| 2949 | FValues.Assign(NewValue);
|
|---|
| 2950 | End;
|
|---|
| 2951 |
|
|---|
| 2952 | {
|
|---|
| 2953 | ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
|
|---|
| 2954 | º º
|
|---|
| 2955 | º Speed-Pascal/2 Version 2.0 º
|
|---|
| 2956 | º º
|
|---|
| 2957 | º Speed-Pascal Component Classes (SPCC) º
|
|---|
| 2958 | º º
|
|---|
| 2959 | º This section: TDBNavigator Class Implementation º
|
|---|
| 2960 | º º
|
|---|
| 2961 | º (C) 1995,97 SpeedSoft. All rights reserved. Disclosure probibited ! º
|
|---|
| 2962 | º º
|
|---|
| 2963 | ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍŒ
|
|---|
| 2964 | }
|
|---|
| 2965 |
|
|---|
| 2966 | Const
|
|---|
| 2967 | cmDBFirst = TCommand(cmBase+70);
|
|---|
| 2968 | cmDBPrior = TCommand(cmBase+71);
|
|---|
| 2969 | cmDBNext = TCommand(cmBase+72);
|
|---|
| 2970 | cmDBLast = TCommand(cmBase+73);
|
|---|
| 2971 | cmDBInsert = TCommand(cmBase+74);
|
|---|
| 2972 | cmDBDelete = TCommand(cmBase+75);
|
|---|
| 2973 | cmDBEdit = TCommand(cmBase+76);
|
|---|
| 2974 | cmDBPost = TCommand(cmBase+77);
|
|---|
| 2975 | cmDBCancel = TCommand(cmBase+78);
|
|---|
| 2976 | cmDBRefresh = TCommand(cmBase+79);
|
|---|
| 2977 |
|
|---|
| 2978 |
|
|---|
| 2979 | Procedure TDBNavigator.SetVisibleButtons(NewState:TNavigateBtnSet);
|
|---|
| 2980 | Var T:TNavigateBtn;
|
|---|
| 2981 | Begin
|
|---|
| 2982 | FVisibleButtons:=NewState;
|
|---|
| 2983 | For T:=dbFirst To dbRefresh Do FButtons[T].Visible:=NewState*[T]<>[];
|
|---|
| 2984 | RealignControls;
|
|---|
| 2985 | End;
|
|---|
| 2986 |
|
|---|
| 2987 | Procedure TDBNavigator.SetEnabledButtons(NewState:TNavigateBtnSet);
|
|---|
| 2988 | Var T:TNavigateBtn;
|
|---|
| 2989 | Begin
|
|---|
| 2990 | FEnabledButtons:=NewState;
|
|---|
| 2991 | For T:=dbFirst To dbRefresh Do FButtons[T].Enabled:=NewState*[T]<>[];
|
|---|
| 2992 | If Handle<>0 Then Invalidate;
|
|---|
| 2993 | End;
|
|---|
| 2994 |
|
|---|
| 2995 | Procedure TDBNavigator.RealignControls;
|
|---|
| 2996 | Var X:LongInt;
|
|---|
| 2997 | Count,W:LongInt;
|
|---|
| 2998 | T:TNavigateBtn;
|
|---|
| 2999 | Begin
|
|---|
| 3000 | If Handle=0 Then Exit;
|
|---|
| 3001 |
|
|---|
| 3002 | X:=0;
|
|---|
| 3003 |
|
|---|
| 3004 | Count:=0;
|
|---|
| 3005 | For T:=dbFirst To dbRefresh Do If FVisibleButtons*[T]<>[] Then Inc(Count);
|
|---|
| 3006 |
|
|---|
| 3007 | W:=Width Div Count;
|
|---|
| 3008 | For T:=dbFirst To dbRefresh Do
|
|---|
| 3009 | Begin
|
|---|
| 3010 | If FVisibleButtons*[T]<>[] Then
|
|---|
| 3011 | Begin
|
|---|
| 3012 | FButtons[T].SetWindowPos(X,0,W,Height);
|
|---|
| 3013 | Inc(X,FButtons[T].Width);
|
|---|
| 3014 | End
|
|---|
| 3015 | Else
|
|---|
| 3016 | If Designed Then FButtons[T].SetWindowPos(X,Height,W,Height);
|
|---|
| 3017 | End;
|
|---|
| 3018 | End;
|
|---|
| 3019 |
|
|---|
| 3020 |
|
|---|
| 3021 | Function TDBNavigator.GetButton(Index:TNavigateBtn):TBitBtn;
|
|---|
| 3022 | Begin
|
|---|
| 3023 | Result := FButtons[Index];
|
|---|
| 3024 | End;
|
|---|
| 3025 |
|
|---|
| 3026 |
|
|---|
| 3027 | Procedure TDBNavigator.SetupComponent;
|
|---|
| 3028 | Type
|
|---|
| 3029 | TButDataRec=Record
|
|---|
| 3030 | bmp:String[20];
|
|---|
| 3031 | cmd:TCommand;
|
|---|
| 3032 | Bubble:LongWord;
|
|---|
| 3033 | End;
|
|---|
| 3034 | Const
|
|---|
| 3035 | ButData:Array[TNavigateBtn] Of TButDataRec=
|
|---|
| 3036 | ((bmp:'StdBmpDBFirst';cmd:cmDBFirst;Bubble:SFirstRecordHint),
|
|---|
| 3037 | (bmp:'StdBmpDBPrior';cmd:cmDBPrior;Bubble:SPriorRecordHint),
|
|---|
| 3038 | (bmp:'StdBmpDBNext';cmd:cmDBNext;Bubble:SNextRecordHint),
|
|---|
| 3039 | (bmp:'StdBmpDBLast';cmd:cmDBLast;Bubble:SLastRecordHint),
|
|---|
| 3040 | (bmp:'StdBmpDBInsert';cmd:cmDBInsert;Bubble:SInsertRecordHint),
|
|---|
| 3041 | (bmp:'StdBmpDBDelete';cmd:cmDBDelete;Bubble:SDeleteRecordHint),
|
|---|
| 3042 | (bmp:'StdBmpDBEdit';cmd:cmDBEdit;Bubble:SEditRecordHint),
|
|---|
| 3043 | (bmp:'StdBmpDBPost';cmd:cmDBPost;Bubble:SPostRecordHint),
|
|---|
| 3044 | (bmp:'StdBmpDBCancel';cmd:cmDBCancel;Bubble:SCancelRecordHint),
|
|---|
| 3045 | (bmp:'StdBmpDBRefresh';cmd:cmDBRefresh;Bubble:SRefreshRecordHint));
|
|---|
| 3046 | Var T:TNavigateBtn;
|
|---|
| 3047 | Begin
|
|---|
| 3048 | Inherited SetupComponent;
|
|---|
| 3049 |
|
|---|
| 3050 | FDataLink.Create(Self);
|
|---|
| 3051 | FDataLink.OnDataChange:=Nil{DataChange};
|
|---|
| 3052 | Include(FDataLink.ComponentState, csDetail);
|
|---|
| 3053 |
|
|---|
| 3054 | Name:='DBNavigator';
|
|---|
| 3055 | FVisibleButtons:=[dbFirst..dbRefresh];
|
|---|
| 3056 | FEnabledButtons:=[dbFirst..dbRefresh];
|
|---|
| 3057 | Width:=240;
|
|---|
| 3058 | Height:=25;
|
|---|
| 3059 | ParentColor:=True;
|
|---|
| 3060 |
|
|---|
| 3061 | For T:=dbFirst To dbRefresh Do
|
|---|
| 3062 | Begin
|
|---|
| 3063 | FButtons[T]:=InsertBitBtn(Self,32,0,32,32, bkCustom,'',
|
|---|
| 3064 | LoadNLSStr(ButData[T].Bubble));
|
|---|
| 3065 | FButtons[T].Command:=ButData[T].cmd;
|
|---|
| 3066 | FButtons[T].Glyph.LoadFromResourceName(ButData[T].bmp);
|
|---|
| 3067 | FButtons[T].YAlign:=yaBottom;
|
|---|
| 3068 | FButtons[T].YStretch:=ysParent;
|
|---|
| 3069 | Include(FButtons[T].ComponentState, csDetail);
|
|---|
| 3070 | FButtons[T].SetDesigning(Designed);
|
|---|
| 3071 |
|
|---|
| 3072 | If Not Designed Then
|
|---|
| 3073 | Begin
|
|---|
| 3074 | FButtons[T].Tag := LongInt(T);
|
|---|
| 3075 | FButtons[T].OnClick := EvButtonClick;
|
|---|
| 3076 | End;
|
|---|
| 3077 | End;
|
|---|
| 3078 |
|
|---|
| 3079 | VisibleButtons:=VisibleButtons-[dbEdit];
|
|---|
| 3080 | End;
|
|---|
| 3081 |
|
|---|
| 3082 | Destructor TDBNavigator.Destroy;
|
|---|
| 3083 | Begin
|
|---|
| 3084 | FDataLink.OnDataChange:=Nil;
|
|---|
| 3085 | FDataLink.Destroy;
|
|---|
| 3086 | FDataLink:=Nil;
|
|---|
| 3087 |
|
|---|
| 3088 | Inherited Destroy;
|
|---|
| 3089 | End;
|
|---|
| 3090 |
|
|---|
| 3091 | Procedure TDBNavigator.CreateWnd;
|
|---|
| 3092 | Begin
|
|---|
| 3093 | Inherited CreateWnd;
|
|---|
| 3094 |
|
|---|
| 3095 | RealignControls;
|
|---|
| 3096 | End;
|
|---|
| 3097 |
|
|---|
| 3098 |
|
|---|
| 3099 | Procedure TDBNavigator.SetDataSource(NewValue:TDataSource);
|
|---|
| 3100 | Begin
|
|---|
| 3101 | FDataLink.DataSource:=NewValue;
|
|---|
| 3102 | End;
|
|---|
| 3103 |
|
|---|
| 3104 | Function TDBNavigator.GetDataSource:TDataSource;
|
|---|
| 3105 | Begin
|
|---|
| 3106 | Result:=FDataLink.DataSource;
|
|---|
| 3107 | End;
|
|---|
| 3108 |
|
|---|
| 3109 |
|
|---|
| 3110 | Procedure TDBNavigator.CommandEvent(Var Command:TCommand);
|
|---|
| 3111 | Begin
|
|---|
| 3112 | Inherited CommandEvent(Command);
|
|---|
| 3113 |
|
|---|
| 3114 | If ((FDataLink<>Nil)And(FDataLink.DataSource<>Nil)And
|
|---|
| 3115 | (FDataLink.DataSource.DataSet<>Nil)) Then
|
|---|
| 3116 | Begin
|
|---|
| 3117 | Try
|
|---|
| 3118 | Case Command Of
|
|---|
| 3119 | cmDBFirst:FDataLink.DataSource.DataSet.First;
|
|---|
| 3120 | cmDBPrior:FDataLink.DataSource.DataSet.Prior;
|
|---|
| 3121 | cmDBNext:FDataLink.DataSource.DataSet.Next;
|
|---|
| 3122 | cmDBLast:FDataLink.DataSource.DataSet.Last;
|
|---|
| 3123 | cmDBInsert:FDataLink.DataSource.DataSet.Insert;
|
|---|
| 3124 | cmDBDelete:FDataLink.DataSource.DataSet.Delete;
|
|---|
| 3125 | cmDBEdit: ;
|
|---|
| 3126 | cmDBPost:FDataLink.DataSource.DataSet.Post;
|
|---|
| 3127 | cmDBCancel:FDataLink.DataSource.DataSet.Cancel;
|
|---|
| 3128 | cmDBRefresh:FDataLink.DataSource.DataSet.Refresh;
|
|---|
| 3129 | End;
|
|---|
| 3130 | Except
|
|---|
| 3131 | ON E:ESQLError Do ErrorBox(E.Message);
|
|---|
| 3132 | ON EDataBaseError Do
|
|---|
| 3133 | Begin
|
|---|
| 3134 | End;
|
|---|
| 3135 | Else Raise;
|
|---|
| 3136 | End;
|
|---|
| 3137 | End;
|
|---|
| 3138 | End;
|
|---|
| 3139 |
|
|---|
| 3140 |
|
|---|
| 3141 | Procedure TDBNavigator.EvButtonClick(Sender:TObject);
|
|---|
| 3142 | Begin
|
|---|
| 3143 | If FOnNavClick <> Nil
|
|---|
| 3144 | Then FOnNavClick(Self,TNavigateBtn(TComponent(Sender).Tag));
|
|---|
| 3145 | End;
|
|---|
| 3146 |
|
|---|
| 3147 |
|
|---|
| 3148 | Begin
|
|---|
| 3149 | End.
|
|---|
| 3150 |
|
|---|