ddgl_tj.pas

商品批发管理系统ADO版

unit ddgl_TJ;

interface

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

type
  TddglTJ = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    DBEdit9: TDBEdit;
    Label10: TLabel;
    DBEdit10: TDBEdit;
    Label11: TLabel;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    DBEdit12: TDBEdit;
    Label13: TLabel;
    DBEdit13: TDBEdit;
    Label14: TLabel;
    DBEdit14: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    DBCBkhbh: TDBComboBox;
    DBCBgybh: TDBComboBox;
    DateTimedgrq: TDateTimePicker;
    DateTimedhrq: TDateTimePicker;
    DateTimefhrq: TDateTimePicker;
    DBCByhsbh: TDBComboBox;
    XPMenu1: TXPMenu;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ddglTJ: TddglTJ;

implementation

uses newDM;

{$R *.dfm}

procedure TddglTJ.Button1Click(Sender: TObject);
begin
    DM.ADOTddgl.fieldbyname('dgrq').AsDatetime:=datetimedgrq.Date;
    DM.ADOTddgl.fieldbyname('dhrq').AsDatetime:=datetimedhrq.Date;
    DM.ADOTddgl.fieldbyname('fhrq').AsDatetime:=datetimefhrq.Date;

    if DBCBkhbh.Text='' then
       showmessage('客户编号没选')
    else
       if DBCBgybh.Text='' then
          showmessage('雇员编号没选')
          else
             if DBCByhsbh.Text='' then
                showmessage('运货商编号没选')
       else
          begin
            try
              DM.ADOTddgl.Post;
            except
               begin
                 DBEdit1.SetFocus;
                 showmessage('定单编号重复或为空，请重填！！！');
                 abort;
               end;

          end;
    DM.ADOTddgl.Append;
    DBEdit1.SetFocus;
end;
end;

procedure TddglTJ.Button2Click(Sender: TObject);
begin
DM.ADOTddgl.Cancel;
close;
end;

procedure TddglTJ.FormActivate(Sender: TObject);
begin
  DM.ADOTddgl.Append;

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

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

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

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

end.