unit bddgl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, ExtCtrls, Menus, DB, DBTables;

type
  Tbddgl_Form = class(TForm)
    GroupBox1: TGroupBox;
    cmdok: TButton;
    cmdclose: TButton;
    xm_LEdit: TLabeledEdit;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    Query1: TQuery;
    procedure cmdokClick(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure cmdcloseClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  bddgl_Form: Tbddgl_Form;

implementation

uses main;

{$R *.dfm}

procedure Tbddgl_Form.cmdokClick(Sender: TObject);
var
    xm,sqlstr:string;
begin
    xm:=trim(xm_ledit.Text);
    if length(xm)<1 then
    begin
        sqlstr:='select a.*,b.zymc as zymc,c.xbmc as xbmc from [xsb] a';
        sqlstr:=sqlstr+' INNER JOIN  [zydm] b ON a.zydm = b.zydm ';
        sqlstr:=sqlstr+' INNER JOIN [xbdm] c ON a.xbdm = c.xbdm  ';
    end
    else
    begin
        xm:='%'+xm+'%';
        sqlstr:='select a.*,b.zymc as zymc,c.xbmc as xbmc from [xsb] a';
        sqlstr:=sqlstr+' INNER JOIN  [zydm] b ON a.zydm = b.zydm ';
        sqlstr:=sqlstr+' INNER JOIN [xbdm] c ON a.xbdm = c.xbdm  ';
        sqlstr:=sqlstr+' where(a.xm like '''+xm+''')';
    end;
    Query1.Close;
    Query1.SQL.Clear;
    Query1.SQL.Add(sqlstr);
    Query1.Open;
    if Query1.RecordCount > 0 then
        N1.Enabled:=true
    else
        N1.Enabled:=false;
end;

procedure Tbddgl_Form.N1Click(Sender: TObject);
var
    xh,sqlstr:string;
begin
    if Query1.FieldByName('zt').AsInteger=0 then
    begin
        xh:=Query1.fieldbyname('xh').AsString;
        sqlstr:='update [xsb] set zt=1 where (xh='''+xh+''')';
        with tquery.Create(nil) do
        begin
            try
            sessionName:=main_Form.Database1.SessionName;
            DatabaseName:=main_Form.Database1.DatabaseName;
            SQL.Clear;
            SQL.Add(sqlstr);
            ExecSQL;
            finally
            Free;
            end;
        end;
    end
    else
    begin
        ShowMessage('該同學已經報到！');
        exit;
    end;
end;

procedure Tbddgl_Form.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
begin
    if gdSelected in State then Exit;
    case Query1.FieldByName('zt').AsInteger of
    0:(Sender as TDBGrid).Canvas.Brush.Color:=clwindow;
    1:(Sender as TDBGrid).Canvas.Brush.Color :=clyellow;
    2:(Sender as TDBGrid).Canvas.Brush.Color :=clblue;
    3:(Sender as TDBGrid).Canvas.Brush.Color :=clred;
    end;
    DBGrid1.DefaultDrawColumnCell(Rect,DataCol,Column,State);
end;

procedure Tbddgl_Form.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    Action:=caFree;
    main_form.N21.Enabled:=true;
end;

procedure Tbddgl_Form.cmdcloseClick(Sender: TObject);
begin
    Close;
end;

procedure Tbddgl_Form.FormCreate(Sender: TObject);
begin
    query1.sessionName:=main_Form.Database1.SessionName;
    query1.DatabaseName:=main_Form.Database1.DatabaseName;
end;

end.