spgl_tj.pas

商品批发管理系统ADO版

unit spgl_TJ;

interface

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

type
  TspglTJ = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    DBEdit9: TDBEdit;
    Label10: TLabel;
    DBEdit10: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    DBCBgysbh: TDBComboBox;
    DBCBlbbh: TDBComboBox;
    XPMenu1: TXPMenu;
    procedure FormActivate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  spglTJ: TspglTJ;

implementation

uses newDM;

{$R *.dfm}

procedure TspglTJ.FormActivate(Sender: TObject);
begin
  DM.ADOTspgl.Append;

  DM.ADOTgysb.First;
  DBCBgysbh.Items.Clear;
  while not DM.ADOTgysb.Eof do
  begin
    DBCBgysbh.Items.Add(DM.ADOTgysb.Fields.Fields[0].AsString);
    DM.ADOTgysb.Next;
  end;

  DM.ADOTlbgl.First;
  DBCBlbbh.Items.Clear;
  while not DM.ADOTlbgl.Eof do
  begin
    DBCBlbbh.Items.Add(DM.ADOTlbgl.Fields.Fields[0].AsString);
    DM.ADOTlbgl.Next;
  end;

end;

procedure TspglTJ.Button1Click(Sender: TObject);
begin

    if DBCBgysbh.Text='' then
       showmessage('供应商编号没选')
    else
       if DBCBlbbh.Text='' then
          showmessage('类别编号没选')
       else
          if DBedit6.Text='' then
             showmessage('单价没填')
          else
              if DBedit7.Text='' then
                  showmessage('库存量没填')
              else

         begin
           try
             DM.ADOTspgl.Post;
           except
             begin
               DBEdit1.SetFocus;
               showmessage('产品编号重复或为空，请重填！！！');
               abort;
             end;
         end;
    DBEdit1.SetFocus;
    DM.ADOTspgl.Append;
end;
    


end;

procedure TspglTJ.Button2Click(Sender: TObject);
begin
DM.ADOTspgl.Cancel;
close;
end;

procedure TspglTJ.FormClose(Sender: TObject; var Action: TCloseAction);
begin
button2.Click;
end;

end.