sfgl.pas

欢迎大家相互学习。delphi系统 四个文件夹分别对应书中的四个实例

unit sfgl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Menus, Grids, DBGrids, StdCtrls, ExtCtrls, FMTBcd,
  Borland.Vcl.SqlExpr, System.ComponentModel, Borland.Vcl.Db,
  Borland.Vcl.DBTables;

type
  Tsfgl_Form = class(TForm)
    GroupBox1: TGroupBox;
    cmdok: TButton;
    cmdclose: TButton;
    xm_LEdit: TLabeledEdit;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    DBGrid2: TDBGrid;
    DataSource2: TDataSource;
    Query1: TQuery;
    Query2: TQuery;
    procedure cmdokClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure cmdcloseClick(Sender: TObject);
    procedure N1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  sfgl_Form: Tsfgl_Form;

implementation

uses main, sf;

{$R *.dfm}

procedure Tsfgl_Form.cmdokClick(Sender: TObject);
var
    xm,sqlstr:string;
begin
    Query2.Close;
    xm:=trim(xm_ledit.Text);
    if length(xm)<1 then
    begin
        sqlstr:='select a.*,b.zymc as zymc,c.xbmc as xbmc,d.jbmc as jbmc 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+' INNER JOIN [gydm] d ON a.gydm = d.gydm  ';
    end
    else
    begin
        xm:='%'+xm+'%';
        sqlstr:='select a.*,b.zymc as zymc,c.xbmc as xbmc,d.jbmc as jbmc 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+' INNER JOIN [gydm] d ON a.gydm = d.gydm  ';
        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 Tsfgl_Form.FormCreate(Sender: TObject);
begin
    Query1.sessionName:=main_Form.Database1.SessionName;
    Query1.DatabaseName:=main_Form.Database1.DatabaseName;
    Query2.sessionName:=main_Form.Database1.SessionName;
    Query2.DatabaseName:=main_Form.Database1.DatabaseName;
end;

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

procedure Tsfgl_Form.DBGrid1CellClick(Column: TColumn);
var
    xh,sqlstr:string;
begin
    xh:=Query1.fieldbyname('xh').AsString;
    sqlstr:='select * from [sfb] where(xh='''+xh+''')';
    Query2.Close;
    Query2.SQL.Clear;
    Query2.SQL.Add(sqlstr);
    Query2.Open;
end;

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

procedure Tsfgl_Form.N1Click(Sender: TObject);
begin
    Application.CreateForm(Tsf_Form, sf_Form);
    sf_form.ShowModal;
end;

end.