inputgoodspec.pas

港口货物管理系统

unit inputgoodspec;

interface

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

type
  Tfminputgoodspec = class(TForm)
    Table1: TTable;
    Table1Agname: TStringField;
    Table1Adime: TStringField;
    Table1Aspec: TStringField;
    Label1: TLabel;
    DataSource1: TDataSource;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Bevel1: TBevel;
    DBGrid1: TDBGrid;
    BitBtn2: TBitBtn;
    BitBtn1: TBitBtn;
    BitBtn3: TBitBtn;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Label5: TLabel;
    DBLookupComboBox1: TDBLookupComboBox;
    DataSource2: TDataSource;
    Query1: TQuery;
    BitBtn4: TBitBtn;
    Label6: TLabel;
    GroupBox1: TGroupBox;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormPaint(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure Edit1Exit(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure DBGrid1Enter(Sender: TObject);
    procedure DBLookupComboBox1Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure Edit2Enter(Sender: TObject);
  private
    { Private declarations }
  public
{ Public declarations }
  end;

var
  fminputgoodspec: Tfminputgoodspec;

implementation

uses ulogin;

{$R *.dfm}

procedure Tfminputgoodspec.BitBtn1Click(Sender: TObject);
begin
table1.filtered:=false;
with table1 do
if locate('agname;adime',vararrayof([edit1.text,edit2.text]),[])=false
then
begin
table1.Append;
table1.FieldByName('agname').Value:=edit1.Text;
table1.FieldByName('adime').Value:=edit2.Text;
table1.FieldByName('aspec').Value:=edit3.Text;
table1.Post;
end;
query1.Close;
query1.ExecSQL;
query1.Active:=true;
dblookupcombobox1.SetFocus;
table1.filtered:=true;
end;

procedure Tfminputgoodspec.FormPaint(Sender: TObject);
begin
bitbtn1.Enabled:=length(edit1.Text)>0;
end;

procedure Tfminputgoodspec.FormCreate(Sender: TObject);
begin
application.OnMessage:=fmlogin.doenterastab;
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
end;

procedure Tfminputgoodspec.BitBtn3Click(Sender: TObject);
begin
table1.delete;
query1.Close;
query1.ExecSQL;
query1.Active:=true;
dblookupcombobox1.SetFocus;
table1.filtered:=true;
end;

procedure Tfminputgoodspec.BitBtn2Click(Sender: TObject);
begin
fminputgoodspec.Close;
end;

procedure Tfminputgoodspec.Edit1Exit(Sender: TObject);
begin
bitbtn1.Enabled:=length(edit1.Text)>0;
end;


procedure Tfminputgoodspec.DBGrid1CellClick(Column: TColumn);
begin
edit1.Text:=table1.Fields[0].Value;
edit2.text:=table1.fields[1].Value;

end;

procedure Tfminputgoodspec.DBGrid1Enter(Sender: TObject);
begin
 edit1.Text:=table1.Fields[0].text;
edit2.text:=table1.fields[1].Text;;
end;

procedure Tfminputgoodspec.DBLookupComboBox1Click(Sender: TObject);
begin
table1.Filter:='agname='''+dblookupcombobox1.Text+'''';
table1.Filtered:=true;
dbgrid1.SetFocus;
end;

procedure Tfminputgoodspec.BitBtn4Click(Sender: TObject);
begin
table1.Edit;
table1.FieldValues['agname']:=edit1.Text;
table1.FieldValues['adime']:=edit2.Text;
table1.FieldValues['aspec']:=edit3.Text;
query1.Close;
query1.ExecSQL;
query1.Active:=true;
dblookupcombobox1.SetFocus;
table1.filtered:=true;
end;

procedure Tfminputgoodspec.Edit2Enter(Sender: TObject);
begin
       bitbtn1.Enabled:=length(edit1.Text)>0;
end;

end.