ddglxx_xg.pas

商品批发管理系统 本作品采用C/S模式

unit ddglXX_XG;

interface

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

type
  TddglXXXG = class(TForm)
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    DBEdit5: TDBEdit;
    Label5: TLabel;
    DBEdit4: TDBEdit;
    Label4: TLabel;
    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
  ddglXXXG: TddglXXXG;
  YuanLai:string;

implementation

uses newDM, main;

{$R *.dfm}

procedure TddglXXXG.FormActivate(Sender: TObject);
begin
  dbedit3.SetFocus;
  DM.ADOTddglMX.Edit;
  YuanLai:=DBedit4.Text;
end;

procedure TddglXXXG.Button1Click(Sender: TObject);
var
 HouLai,ChaJia,spglJS:string;
begin
  HouLai:=DBedit4.Text;

  if abs(strtoint(YuanLai)-strtoint(HouLai))>DM.ADOTspgl.Lookup('cpbh',ddglxxxg.DBCBcpbh.Text,'kcl') then
    begin
      showmessage('已经没有足够库存量了');
      DBedit4.SetFocus;
    end
  else
    begin
      DM.ADOTddglMX.UpdateBatch;

       //商品管理库存的修改
      if strtoint(HouLai)>strtoint(YuanLai) then
        begin
         DM.ADOTspgl.Locate('cpbh',ddglxxxg.DBCBcpbh.Text,[]);
         ChaJia:=inttostr(strtoint(HouLai)-strtoint(YuanLai));
         spglJS:=inttostr(DM.ADOTspgl.Lookup('cpbh',ddglxxxg.DBCBcpbh.Text,'kcl')-strtoint(ChaJia));
         DM.ADOTspgl.Edit;
         DM.ADOTspgl.FieldByName('kcl').AsString:=spglJS;
         DM.ADOTspgl.UpdateBatch;
        end
      else
        begin
         DM.ADOTspgl.Locate('cpbh',ddglxxxg.DBCBcpbh.Text,[]);
         ChaJia:=inttostr(strtoint(YuanLai)-strtoint(HouLai));
         spglJS:=inttostr(DM.ADOTspgl.Lookup('cpbh',ddglxxxg.DBCBcpbh.Text,'kcl')+strtoint(ChaJia));
         DM.ADOTspgl.Edit;
         DM.ADOTspgl.FieldByName('kcl').AsString:=spglJS;
         DM.ADOTspgl.UpdateBatch;
        end;

    end;
end;

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

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

end.