ddgl_xx.pas

商品批发管理系统ADO版

unit ddgl_XX;

interface

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

type
  TddglXX = class(TForm)
    DBECDW: TDBEdit;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    DBCBcpbh: 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
  ddglXX: TddglXX;

implementation

uses main, newDM;

{$R *.dfm}

procedure TddglXX.FormActivate(Sender: TObject);
begin
  ddglXX.Caption:=DBECDW.Text+'定单详细资料';
  DBCBcpbh.SetFocus;

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

  DM.ADOTddglMX.Append;
end;

procedure TddglXX.Button1Click(Sender: TObject);
var
  spglJS:string;
begin
 if strtoint(DBedit4.Text)>DM.ADOTspgl.Lookup('cpbh',ddglxx.DBCBcpbh.Text,'kcl') then
   begin
    showmessage('已经没有足够库存量了');
    DBedit4.SetFocus;
   end
 else
    begin
       if dbedit3.Text='' then
          showmessage('价格没填')
       else
          if dbedit4.Text='' then
            showmessage('数量没填')
          else
             if dbedit5.Text='' then
               showmessage('折扣没填')
             else
                 begin
                    try
                       DM.ADOTddglMX.Post;

                        //商品管理库存的修改
                        DM.ADOTspgl.Locate('cpbh',ddglxx.DBCBcpbh.Text,[]);
                        spglJS:=inttostr(DM.ADOTspgl.Lookup('cpbh',ddglxx.DBCBcpbh.Text,'kcl')-strtoint(DBedit4.Text));
                        DM.ADOTspgl.Edit;
                        DM.ADOTspgl.FieldByName('kcl').AsString:=spglJS;
                        DM.ADOTspgl.UpdateBatch;

                    except
                       begin
                          DBCBcpbh.SetFocus;
                          showmessage('产品编号重复或无此编号，请重填！！！');
                          abort;
                       end;
                 end;
       DM.ADOTddglMX.Append;
       DBCBcpbh.SetFocus;
    end;
 end;
end;

procedure TddglXX.Button2Click(Sender: TObject);
begin
DM.ADOTddglMX.Cancel;
form1.ddglJSLR;
close;
end;

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

end.