unit9.pas

以学习为目的,使用DIPH开发而成,功能强大,是我们的老师提供的!

unit Unit9;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ExtCtrls, Grids, DBGrids, ComCtrls, StdCtrls, Db, DBTables, Mask, DBCtrls;

type
  TForm9 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Panel1: TPanel;
    DBGrid2: TDBGrid;
    Splitter1: TSplitter;
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    ComboBox1: TComboBox;
    Label3: TLabel;
    Edit2: TEdit;
    DateTimePicker1: TDateTimePicker;
    ComboBox2: TComboBox;
    Label4: TLabel;
    Label5: TLabel;
    Edit3: TEdit;
    Label6: TLabel;
    ComboBox3: TComboBox;
    Label7: TLabel;
    Memo1: TMemo;
    Label8: TLabel;
    GroupBox2: TGroupBox;
    ComboBox4: TComboBox;
    Label9: TLabel;
    Label10: TLabel;
    ComboBox5: TComboBox;
    Label11: TLabel;
    ComboBox6: TComboBox;
    Label12: TLabel;
    ComboBox7: TComboBox;
    Label13: TLabel;
    ComboBox8: TComboBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    Label14: TLabel;
    Label15: TLabel;
    Edit4: TEdit;
    Label16: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Edit5: TEdit;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Edit7: TEdit;
    Label20: TLabel;
    Label21: TLabel;
    Button5: TButton;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    GroupBox3: TGroupBox;
    Button6: TButton;
    StatusBar1: TStatusBar;
    Table1: TTable;
    DataSource1: TDataSource;
    Table2: TTable;
    DataSource2: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    Query1: TQuery;
    Button7: TButton;
    Label26: TLabel;
    Table3: TTable;
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button6Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure RadioButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure ComboBox4Change(Sender: TObject);
    procedure ComboBox5Change(Sender: TObject);
    procedure ComboBox6Change(Sender: TObject);
    procedure ComboBox7Change(Sender: TObject);
    procedure ComboBox8Change(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form9: TForm9;

implementation

{$R *.DFM}

procedure TForm9.Button3Click(Sender: TObject);
begin
  form9.Close;
end;

procedure TForm9.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=cafree;
end;

procedure TForm9.Button6Click(Sender: TObject);
begin
  form9.Close;
end;

procedure TForm9.Button2Click(Sender: TObject);
begin
   table1.Refresh;
   table2.Refresh;
end;

procedure TForm9.Button1Click(Sender: TObject);
begin
if not table1.FindKey([edit4.text]) then
begin
showmessage('没有这个房间。');
edit4.Clear;
edit4.SetFocus;
exit;
end;
if table1.FieldByName('zt').asstring='已住人' then
begin
showmessage('这个房间已住人。');
edit4.Clear;
edit4.SetFocus;
exit;
end;
if length(edit1.text+combobox1.Text+combobox2.Text+edit2.Text+combobox3.Text+edit3.Text)=0
then
showmessage('输入不能为空。')
else
begin
with table2 do
begin
Append;
FieldByName('fh').asstring:=edit4.Text;
FieldByName('xm').asstring:=edit1.Text;
FieldByName('xb').asstring:=combobox1.Text;
FieldByName('rs').asstring:=combobox2.Text;
FieldByName('zjh').asstring:=edit2.Text;
FieldByName('zjlx').asstring:=combobox3.Text;
FieldByName('yj').asstring:=edit3.Text;
FieldByName('rq').asdatetime:=datetimepicker1.Date;
FieldByName('bz').asstring:=memo1.Text;
{++++?}
post;
end;
table1.Edit;
table1.FieldByName('zt').asstring:='已住人';
table1.Post;
end;
end;

procedure TForm9.RadioButton2Click(Sender: TObject);
begin
if radiobutton2.Checked then
 begin
 combobox4.Enabled:=true;
 combobox5.Enabled:=true;
 combobox6.Enabled:=true;
 combobox7.Enabled:=true;
 combobox8.Enabled:=true;
 datasource1.DataSet:=query1;      {&&&&&&&}
 table2.MasterSource:=datasource1;
 table2.MasterFields:='fh';
 table2.IndexFieldNames:='fh';
 end
end;

procedure TForm9.RadioButton1Click(Sender: TObject);
begin
if radiobutton1.Checked then
 begin
 combobox4.Enabled:=false;
 combobox5.Enabled:=false;
 combobox6.Enabled:=false;
 combobox7.Enabled:=false;
 combobox8.Enabled:=false;
 datasource1.DataSet:=table1;
 table2.MasterFields:='';
 table2.IndexFieldNames:='';
 end
end;

procedure TForm9.FormCreate(Sender: TObject);
begin
datetimepicker1.DateTime:=now;
end;

procedure TForm9.Button4Click(Sender: TObject);
var
temp:real;
begin
if not table2.FindKey([edit5.text]) then
showmessage('没有找到。')
else
begin
table1.First;
while not table1.Eof do
begin
if table1.FieldByName('fh').asstring=edit5.Text then
begin
temp:=table1.fieldbyname('jg').asfloat;
break;
end;
table1.Next;
end;
edit7.Text:=floattostr(abs(trunc(now)-trunc(table2.fieldbyname('rq').asdatetime))*temp+table2.fieldbyname('fw').asfloat);
temp:=strtofloat(edit7.text)-table2.fieldbyname('yj').asfloat;
if temp<0 then
label21.Caption:='还要退：'
else
label21.Caption:='还要收：';
label24.Caption:=floattostr(abs(temp));
button7.Enabled:=true;
end;
end;
procedure TForm9.ComboBox4Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 资源表一.db where fh=:cc');
query1.ParamByName('cc').asstring:=combobox4.Text;
query1.open;
combobox5.Text:='';
combobox6.Text:='';
combobox7.Text:='';
combobox8.Text:='';
end;

procedure TForm9.ComboBox5Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 资源表一.db where lx=:cc');
query1.ParamByName('cc').asstring:=combobox5.Text;
query1.open;
combobox4.Text:='';
combobox6.Text:='';
combobox7.Text:='';
combobox8.Text:='';
end;

procedure TForm9.ComboBox6Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 资源表一.db where rs=:cc');
query1.ParamByName('cc').asinteger:=strtoint(combobox6.Text);
query1.open;
combobox4.Text:='';
combobox5.Text:='';
combobox7.Text:='';
combobox8.Text:='';
end;

procedure TForm9.ComboBox7Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 资源表一.db where lc=:cc');
query1.ParamByName('cc').asstring:=combobox7.Text;
query1.open;
combobox4.Text:='';
combobox5.Text:='';
combobox6.Text:='';
combobox8.Text:='';
end;

procedure TForm9.ComboBox8Change(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 资源表一.db where zt=:cc');
query1.ParamByName('cc').asstring:=combobox8.Text;
query1.open;
combobox4.Text:='';
combobox5.Text:='';
combobox6.Text:='';
combobox7.Text:='';
end;

procedure TForm9.Button7Click(Sender: TObject);
begin
table2.First;
while not table2.Eof do
  begin
    if table2.FieldByName('fh').asstring=edit5.Text then
      break;
    table2.Next;
  end;
table2.Delete;
table1.First;
while not table1.Eof do
  begin
    if table1.FieldByName('fh').asstring=edit5.Text then
      break;
    table1.Next;
  end;
table1.Edit;
table1.FieldByName('zt').asstring:='未住人';
table1.Post;


table3.Append;
table3.Edit;
table3.FieldByName('lb').asstring:='住房';
table3.FieldByName('rq').asdatetime:=now;
table3.FieldByName('sr').asfloat:=strtofloat(edit7.text);
table3.post;
showmessage('已办理完退房手续。');
end;

procedure TForm9.Button5Click(Sender: TObject);
begin
label26.Caption:=table2.fieldbyname('bz').asstring;
end;

end.