fmyunits.pas

进销存开发系统

unit Fmyunits;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB, Mask, DBCtrls;

type
  TF_myunits = class(TForm)
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    Label7: TLabel;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Button1: TButton;
    Button2: TButton;
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_myunits: TF_myunits;

implementation
  uses Fdm;
{$R *.dfm}

procedure TF_myunits.FormShow(Sender: TObject);
begin
  with Adoquery1 do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from tb_unit');
    Open;
  end;
end;

procedure TF_myunits.Button1Click(Sender: TObject);
begin
  if (Trim(Dbedit1.Text)='') or (Trim(Dbedit2.Text)='') then
  begin
    Application.MessageBox('单位编号与单位全称必须填写','提示',mb_ok);
    Exit;
  end;
  try
    Adoquery1.Edit;
    Adoquery1.Post;
    Application.MessageBox('保存成功','提示',mb_ok);
  except
    Application.MessageBox('保存失败','提示',mb_ok);
  end;
end;

procedure TF_myunits.Button2Click(Sender: TObject);
begin
  Close;
end;

procedure TF_myunits.FormKeyPress(Sender: TObject; var Key: Char);
begin
  if Key=#13 then
    selectnext(sender as Twincontrol,true,true);  
end;

end.