tuifang.pas

来自「完整的delphi书籍源代码,大家有空的时候自己慢慢看看」· PAS 代码 · 共 101 行

unit tuifang;

interface

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

type
  TtuifangFrm = class(TForm)
    Button1: TButton;
    ComboBox1: TComboBox;
    Label1: TLabel;
    Button2: TButton;
    Label2: TLabel;
    Label3: TLabel;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    Label4: TLabel;
    ComboBox4: TComboBox;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  tuifangFrm: TtuifangFrm;

implementation

uses DB_Frm;

{$R *.dfm}

procedure TtuifangFrm.FormCreate(Sender: TObject);
var
  qrystring,temp_roomid,temp_cost,temp_state,temp_end:string;
  i:integer;
begin
  qrystring:='select * from Room where room_state='+''''+'满'+'''';
  with DBFrm.Room_Query do
    begin
      close;
      SQL.Clear;
      SQL.Add(qrystring);
      open;
      first;
      recordcount;
      for i:=1 to recordcount do
        begin
          temp_roomid:=fieldbyname('Room_id').asstring;
          temp_state:=fieldbyname('state_time').asstring;
          temp_end:=fieldbyname('end_time').asstring;
          temp_cost:=fieldbyname('cost').asstring;
          ComboBox1.Items.Add(temp_roomid);
          ComboBox2.Items.Add(temp_cost);
          ComboBox3.Items.Add(temp_state);
          ComboBox4.Items.Add(temp_end);
          next;
        end;
    end;
end;

procedure TtuifangFrm.Button1Click(Sender: TObject);
begin
  with DBFrm.Room_Table do
    begin
      close;
      indexfieldnames:='Room_id';
      open;
      findkey([ComboBox1.Text]);
      edit;
      fieldbyname('room_state').AsString:='空';
      fieldbyname('customer_name').AsString:='';
      fieldbyname('state_time').AsString:='';
      fieldbyname('end_time').AsString:='';
      post;
    end;
end;

procedure TtuifangFrm.Button2Click(Sender: TObject);
begin
  Button1.Visible:=true;
end;

procedure TtuifangFrm.ComboBox1Change(Sender: TObject);
var
  i:integer;
begin
  i:=ComboBox1.Items.IndexOf(ComboBox1.Text);
  ComboBox2.Text:=ComboBox2.Items[i];
  ComboBox3.Text:=ComboBox3.Items[i];
  ComboBox4.Text:=ComboBox4.Items[i];
end;
end.