unit USorting;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, DBTables, URGrids, ExtCtrls, StdCtrls;

type
  TfrmSorting = class(TForm)
    memoMain: TMemo;
    Splitter1: TSplitter;
    grdMain: TRealGrid;
    tblMain: TTable;
    tblMainACCT_NBR: TFloatField;
    tblMainSYMBOL: TStringField;
    tblMainSHARES: TFloatField;
    tblMainPUR_PRICE: TFloatField;
    tblMainPUR_DATE: TDateField;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure grdMainColumnTitleClick(AColumn: TwColumn);
    procedure grdMainDrawRow(Sender: TObject; ARow: Integer; var BCol,
      FCol: TColor; var FStyle: TFontStyles);
    procedure grdMainDrawCol(Sender: TObject; ACol, ARow: Integer;
      var Text: String; var BCol, FCol: TColor; var FStyle: TFontStyles);
  private
    procedure SelectData;

  public
  end;

implementation

{$R *.DFM}

const
  GD_ACCT_NBR  = 0;
  GD_SYMBOL    = 1;
  GD_SHARES    = 2;
  GD_PUR_PRICE = 3;
  GD_PUR_DATE  = 4;

  Description = 'TRealGrid綽 拿煩竄困狼 瀝紡 皋筋靛 Sort 甫 力傍欽聰促.' + #13#10 +
                '肚茄 TwColumn.Title籃 SortMark 加己闌 力傍竅咯 鷗撈撇俊 瀝紡 惑怕甫 ' +
                '釬矯且 薦 樂檔廢 欽聰促.' + #13#10 +
                '酒貳綽 弊府靛狼 OnColumnTitleClick 撈亥飄俊輯 Sort竊薦甫 貿府茄 抗澇聰促.' +
                '阿 拿煩狼 鷗撈撇闌 努腐秦焊矯扁 官而聰促.' + #13#10 +
                '拿煩鷗撈撇 努腐籃 促弗 儈檔肺 葷儈瞪 薦檔 樂欄骨肺 鷗撈撇 努腐父欄肺 ' +
                '磊悼 瀝紡登瘤綽 臼嚼聰促.';

(*** Private Methods ***)
procedure TfrmSorting.SelectData;
begin
  with tblMain, grdMain do
  begin
    Open;

    while not EOF do
    begin
      AddRow;

      Cells[GD_ACCT_NBR , RowCount - 1].AsFloat  := FieldByName('Acct_Nbr' ).AsFloat;
      Cells[GD_SYMBOL   , RowCount - 1].AsString := FieldByName('Symbol'   ).AsString;
      Cells[GD_SHARES   , RowCount - 1].AsFloat  := FieldByName('Shares'   ).AsFloat;
      Cells[GD_PUR_PRICE, RowCount - 1].AsFloat  := FieldByName('Pur_Price').AsFloat;
      Cells[GD_PUR_DATE , RowCount - 1].AsDate   := FieldByName('Pur_Date' ).AsDateTime;

      Next;
    end;

    Close;
  end;
end;

(*** Event Handlers ***)
procedure TfrmSorting.FormCreate(Sender: TObject);
begin
  SelectData;
  memoMain.Lines.Text := Description;
end;

procedure TfrmSorting.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := caFree;
end;

procedure TfrmSorting.grdMainColumnTitleClick(AColumn: TwColumn);
begin
  if AColumn.Title.SortMark = wsmAsc then
    grdMain.Sort(AColumn.Index, True)
  else
    grdMain.Sort(AColumn.Index);
end;

procedure TfrmSorting.grdMainDrawRow(Sender: TObject; ARow: Integer;
  var BCol, FCol: TColor; var FStyle: TFontStyles);
begin
  with grdMain do
    if Cells[GD_SHARES, ARow].AsFloat >= 10000 then
    begin
      BCol := clGreen;
      FCol := clWhite;
    end
    else if Cells[GD_SHARES, ARow].AsFloat <= 2000 then
    begin
      BCol := clInfoBk;
    end
end;

procedure TfrmSorting.grdMainDrawCol(Sender: TObject; ACol, ARow: Integer;
  var Text: String; var BCol, FCol: TColor; var FStyle: TFontStyles);
begin
  if ACol = GD_PUR_PRICE then
    with grdMain do
      if Cells[ACol, ARow].AsFloat >= 50 then
      begin
        BCol   := clRed;
        FCol   := clWhite;
        FStyle := [fsBold];
      end
      else if Cells[ACol, ARow].AsFloat >= 40 then
      begin
        BCol   := clYellow;
        FCol   := clBlack;
        FStyle := [fsBold];
      end;
end;

end.