{立方酒店管理系統 v1.0
 Copyright by CubicSoft
 program by ls.
 Date:20020301-20020601
 20020627 加入注釋
}
unit C_Skqx;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, C_StdJd, DosMove, StdCtrls, Buttons, ExtCtrls, DB, DBTables, C_Define;

type
  TSkqxForm = class(TStdJdForm)
    edtKfh: TLabeledEdit;
    edtFkfs: TLabeledEdit;
    lblKrxm: TLabel;
    Edit1: TEdit;
    tblBqj: TTable;
    procedure edtKfhExit(Sender: TObject);
    procedure btnOKClick(Sender: TObject);
  private
    { Private declarations }
    FKfxx: TKFXX;
    FYjxx: TYjxx;
    procedure ShowYjxx;
  public
    { Public declarations }
  end;

var
  SkqxForm: TSkqxForm;

procedure Skqx;

implementation

uses C_HotelData;

{$R *.dfm}

//散客取消客房
procedure Skqx;
begin
  if CZY.CzyXm <> '巢經理' then Exit;
  SkqxForm := TSkqxForm.Create(Application);
  try
    with SkqxForm do
    begin
      ShowModal;
    end;
  finally
    SkqxForm.Free;
  end;
end;

//顯示押金信息
procedure TSkqxForm.ShowYjxx;
begin
  FYjxx := HotelData.GetYjxx(FKfxx.AYjbh);

  edtFkfs.Text := FYjxx.AFkfs;
  if FYjxx.AFkfs=FKFS_RMB then
    edtFkfs.Text := edtFkfs.Text + ' ' + CurrToStr(FYjxx.AYfje)+'元';
end;

procedure TSkqxForm.edtKfhExit(Sender: TObject);
begin
  inherited;
  if edtKfh.Text<>'' then
  begin
    if (HotelData.CheckKfzt(edtKfh.Text)=KFZT_BF) then
    begin
      FKfxx := HotelData.GetKfxx(edtKfh.Text);
      Edit1.Text := FKfxx.AKrxm;
      ShowYjxx;
    end
    else
    begin
      ShowInfo('該客房不能取消！');
      edtKfh.Text := '';
      edtKfh.SetFocus;
    end;
  end;
end;

//確認
procedure TSkqxForm.btnOKClick(Sender: TObject);
var
  s: string;
begin
  inherited;
  //edit by ls .20021120
  if edtKfh.Text = '' then
  begin
    ShowMessage('請輸入房間號！');
    Exit;
  end;
  if FKfxx.AKfbz=KFBZ_FT then
  begin
    ShowWarning('此房間的客人不是當天來的客人，不能取消');
    Exit;
  end;

  s := 'select sum(D_XFJE) from KRZD where D_ZDBH="'+FKfxx.AZdbh+'"';
  if HotelData.SumJe(s)<>0 then
  begin
    ShowWarning('該房已經存在消費入帳，你不能取消');
    Exit;
  end;
  if not Confirm('你確認取消房間：'+edtKfh.Text+'?') then Exit;

  //事務啟動
  HotelData.DatabaseUser.StartTransaction;
  try
    tblBqj.Open;
    if tblBqj.Locate('D_KFBH',FKfxx.AKfbh,[]) then
    begin
      tblBqj.Edit;
      tblBqj.FieldByName('D_SJFJ').AsCurrency := 0;
      tblBqj.Post;
    end;
    tblBqj.Close;
    //清空客人帳單
    //s := 'select * from KRZD where D_ZDBH="'+FKfxx.AZdbh+'"';
    s := 'delete from KRZD where D_ZDBH="'+FKfxx.AZdbh+'"';
    HotelData.EmptyData(s);

    //清空客人信息
    //s := 'select * from KRXX where D_KRBH="'+FKfxx.AKrbh+'"';
    s := 'delete from KRXX where D_KRBH="'+FKfxx.AKrbh+'"';
    HotelData.EmptyData(s);

    //清空客人押金
    //s := 'select * from KRYJ where D_YJBH="'+FKfxx.AYjbh+'"';
    s := 'delete from KRYJ where D_YJBH="'+FKfxx.AYjbh+'"';
    HotelData.EmptyData(s);

    
    //初始化客房狀態
    HotelData.ClearKfzt(FKfxx.AKfbh);//20020626 修改 by ls.

    ShowInfo('房間取消成功！');

    //事務提交
    HotelData.DatabaseUser.Commit;
  except
    //事務回滾
    HotelData.DatabaseUser.Rollback;
    raise;
  end;

  Close;
end;

end.