fjxgunit.pas

集成酒店桑拿食管管理的完整程序

unit fjxgunit;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, DBTables, ExtCtrls, StdCtrls, Spin;

type
  Tfjxgform = class(TForm)
    Label1: TLabel;
    zdrmno: TEdit;
    Button1: TButton;
    Button2: TButton;
    Bevel1: TBevel;
    q1: TQuery;
    rmmoney: TSpinEdit;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure zdrmnoDblClick(Sender: TObject);
    procedure zdrmnoExit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fjxgform: Tfjxgform;

implementation

uses dataproc, xgft;

{$R *.DFM}

procedure Tfjxgform.FormCreate(Sender: TObject);
begin
   zdrmno.text:='';
end;

procedure Tfjxgform.Button1Click(Sender: TObject);
begin
  if rmmoney.Value=0 then
  begin
    showmessage('房价错误');
    rmmoney.setfocus;
    exit;
  end;
  if messagedlg('房价正确吗？',mtInformation, [mbYes, mbNo], 0) = mrno then
      exit;
  if length(trim(zdrmno.text))>0 then
     begin
     q1.Active :=false;
     q1.sql.clear;                                             // (truntime=:pzd) and (isbj=:pbj)');
     q1.sql.add('select handno from nowin where (handno=:phandno) ');
     q1.ParamByName ('phandno').asstring:=trim(zdrmno.text);
    // q1.parambyname('pzd').asboolean:=true;
    // q1.parambyname('pbj').asboolean:=true;
     q1.Prepare;
     q1.open;
     q1.active:=true;
     if q1.RecordCount =0 then
        begin
        showmessage('房间错误');
        zdrmno.setfocus;
        exit;
        end
     else
        begin
        q1.Active :=false;
        q1.sql.clear;
        q1.sql.add('update nowin set roomprice=:pprice  where (handno=:phd)');
        q1.ParamByName ('phd').asstring:=trim(zdrmno.text);
        q1.ParamByName ('pprice').asinteger:=rmmoney.Value;
        q1.Prepare;
        q1.ExecSQL;
        q1.Active :=false;
        addlogo(curper.code,datetimetostr(now),trim(zdrmno.text)+'改房价');
        showmessage('修改房价成功');
        zdrmno.text:='';
        zdrmno.setfocus;
        end;
     end;
end;

procedure Tfjxgform.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  q1.free;
end;

procedure Tfjxgform.Button2Click(Sender: TObject);
begin
  fjxgform.close;
end;

procedure Tfjxgform.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if key=112 then
  begin
    if xt=0 then help(16);
  end;
  if key=13 then
     selectnext(activecontrol,true,true);
  if key=27 then
     fjxgform.close;
end;

procedure Tfjxgform.zdrmnoDblClick(Sender: TObject);
begin
  Application.CreateForm(Txgftform, xgftform);
  xgftform.Caption:='';
  xgftform.Button2.Visible:=false;
  xgftform.Timer1.Free;
  xgftform.showmodal;
  zdrmno.text:=xgftform.xgrmno.Text;
  xgftform.Free;
  activecontrol:=Button1;

end;

procedure Tfjxgform.zdrmnoExit(Sender: TObject);
var aa:array[0..1] of string;
begin
  if trim(zdrmno.text)<>'' then
  begin
     getvalue(aa,'select roomprice from nowin where roomno='''+zdrmno.text+'''');
     Edit1.Text:=trim(aa[0]);
  end;

end;

end.