realtychange1.pas

物业管理系统系统特点 一、 实现集中式管理 系统将集团公司、各分公司、各物业管理处连接到一起

unit RealtyChange1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dbcgrids, Grids, DBGrids, DB, ADODB, StdCtrls, Buttons, ExtCtrls,
  StrUtils, ExtDlgs, ComCtrls, math, Menus, ImgList, ToolWin;

type
    Tf_RealtyChange1 = class(TForm)
    Button5: TButton;
    Button6: TButton;
    Label4: TLabel;
    Edit1: TEdit;
    Label1: TLabel;
    Edit2: TEdit;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button6Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Edit1Exit(Sender: TObject);


  private
    { Private declarations }
  public
    { Public declarations }
      bOK:bool;
  end;

var
  f_RealtyChange1: Tf_RealtyChange1;


implementation

uses MAIN,RealtyJ3, data;


{$R *.dfm}




//Tab
procedure Tf_RealtyChange1.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
    if key=13 then
    Begin
        key:=0;
        perform(WM_NEXTDLGCTL,0,0);
    end
    else if key=VK_ESCAPE then close;
end;



procedure Tf_RealtyChange1.Button6Click(Sender: TObject);
begin
    bOK:=false;
    Close;
end;

procedure Tf_RealtyChange1.Button5Click(Sender: TObject);
begin
    mainform.t1:=Edit1.text;
    mainform.t2:=Edit2.text;
    bOK:=true;
    close;
end;



procedure Tf_RealtyChange1.FormCreate(Sender: TObject);
begin
    if f_RealtyJ3.listview1.selcount=0 then exit;
    edit1.text:=f_RealtyJ3.listview1.selected.subitems[3];
    edit2.text:=f_RealtyJ3.listview1.selected.subitems[4];
end;

procedure Tf_RealtyChange1.Edit1Exit(Sender: TObject);
var
    query:TADOQuery;
    d:double;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;

    query.SQL.Clear;
    query.SQL.Add('select * from 库存 where 物料编号='''+f_RealtyJ3.ListView1.Selected.Caption+'''');
    query.open;
    if query.RecordCount>0 then d:=strtofloat(query.fieldbyname('库存数量').Value);

    query.Close;
    quERy.free;

    if strtofloat(edit1.Text)>d then
    begin
        showmessage('出库数量不能大于库存数量');
        exit;
    end;

end;

end.