unit Unit19;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, Buttons, DB, ADODB;

type
  Trctc = class(TForm)
    Label1: TLabel;
    cardid: TEdit;
    Label3: TLabel;
    car_addressid: TComboBox;
    Label2: TLabel;
    carid: TEdit;
    Label5: TLabel;
    money: TEdit;
    Label4: TLabel;
    car_address: TEdit;
    Label6: TLabel;
    carclass: TComboBox;
    stopok: TBitBtn;
    DBGrid1: TDBGrid;
    Label7: TLabel;
    ds_customers: TDataSource;
    adot_card: TADOTable;
    adot_caraddress: TADOTable;
    adoq_car: TADOQuery;
    ADOQuery2: TADOQuery;
    adot_carstop: TADOTable;
    adot_carclass: TADOTable;
    procedure cardidKeyPress(Sender: TObject; var Key: Char);
    procedure stopokClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure car_addressidChange(Sender: TObject);
    procedure caridExit(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormResize(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  rctc: Trctc;
  FormOldWid:Integer;
implementation

uses Unit11, Unit14, Unit1, Unit2;

{$R *.dfm}

procedure clearface();
var
   addressid:  string;
begin
  with rctc do
  begin
  adot_caraddress.Close;
  adot_caraddress.Filtered:=false;
  adot_caraddress.Filter:='addresscase=0' ;
  adot_caraddress.Filtered:=true;
  adot_caraddress.Open;
  adot_caraddress.First;
  cardid.Clear;
  money.Clear;
  car_address.Clear;
  car_addressid.Items.Clear;
  carid.Clear;
  carclass.Items.Clear;
  if adot_caraddress.IsEmpty then
      showmessage('車位已滿！');
  while not(adot_caraddress.Eof) do
    begin
       addressid:=adot_caraddress.FieldByName('addressid').value;
       car_addressid.Items.Add(addressid)  ;
       adot_caraddress.Next;
    end ;      //在car_addressid中顯示可用的車位

    adoquery2.Close;
    adoquery2.SQL.Clear;
    adoquery2.SQL.Add('select cardid as 卡號,usename as 用戶名,sex as 性別,age as 年齡,tele as 聯(lián)系電話,address as 聯(lián)系電話 from customers');
    adoquery2.Open;//顯示Grid中的記錄

   adot_carclass.Open;
   adot_carclass.First;
   while not(adot_carclass.Eof) do
     begin
       carclass.Items.Add(adot_carclass.FieldValues['carclass']) ;
       adot_carclass.Next;
     end ;  //在carclass表中顯示數(shù)據(jù)庫的車輛的類型
   cardid.SetFocus;
  end;
end;

Function checkcardid(card: String):boolean;
var
  lmoney:string;
begin
   checkcardid:=false;
   with rctc do
   begin
   if trim(card)<>'' then
   begin
      adot_card.Open;
    if not adot_card.Locate('cardid',card,[locaseInsensitive]) then
      begin
      showmessage('此停車卡無效，請重新輸入卡號') ;
      cardid.Clear;
      cardid.SetFocus;
      end
      else
      begin
      money.Text:=adot_card.fieldByName('storemoney').Value;  //顯示此卡的余額
      checkcardid:=true;
      form14.adt_set.First;
      lmoney:=trim(form14.adt_set.FieldByName('lmoney').Value);
      if adot_card.fieldByName('storemoney').Value<strtoint(lmoney) then
       //  showmessage('余額少于'+lmoney+'元，請及時充值');
         messagedlg('余額少于'+lmoney+'元，請及時充值',mtconfirmation,[mbok],0);
      end ;
     adot_card.Close;
    end
    else
    begin
     money.Text:='';
     messagedlg('請輸入卡號',mtconfirmation,[mbok],0);
    end;
    adot_card.Open;
    end;
end;

procedure Trctc.stopokClick(Sender: TObject);
begin
  if not checkcardid(cardid.Text) then
  begin
  cardid.SetFocus;
  end
  else if(carid.Text='')  then
  begin
  messagedlg('請輸入車牌號',mtconfirmation,[mbok],0);
  carid.SetFocus;
  end
  else if (car_address.Text='') then
  begin
  messagedlg('請選擇車位號',mtconfirmation,[mbok],0);
  car_addressid.SetFocus;
  end
  else if(carclass.Text='') then
  begin
  messagedlg('請選擇停車類型',mtconfirmation,[mbok],0);
  carclass.SetFocus;
  end
  else
     begin
      adot_caraddress.Open;
      adot_caraddress.Locate('addressid',car_addressid.Text,[locaseInsensitive]);
      adot_caraddress.Delete;
      adot_caraddress.Edit;
      adot_caraddress.AppendRecord([car_addressid.Text,car_address.Text,1]);
       //更改車位為在使用
      adoq_car.Close;
      adoq_car.SQL.Clear;
      adoq_car.SQL.Add('insert into car(carid,carclass) values(:carid,:carclass)');
      adoq_car.Parameters.ParamByName('carid').Value:=carid.Text;
      adoq_car.Parameters.ParamByName('carclass').Value:=carclass.Text;
      adoq_car.ExecSQL;
       //增加停車場中車的信息
      adot_carstop.Open;
      adot_carstop.Edit;
      adot_carstop.AppendRecord([carid.Text,cardid.Text,car_addressid.Text,now,nil,nil,nil,user]);
       //在停車表中加入一條停車記錄
      clearface();
     end  ;
end;

procedure Trctc.cardidKeyPress(Sender: TObject; var Key: Char);
var
  cardidstring:String;
begin
     if not(key in['0'..'9','a'..'z',#008]) then
    begin
      key:=#0;
     end
     else
     begin
       cardidstring:=trim(cardid.Text);
       adoquery2.Close;
       adoquery2.SQL.Clear;
       adoquery2.SQL.Add('select cardid as 卡號,usename as 用戶名,sex as 性別,age as 年齡,tele as 聯(lián)系電話,address as 聯(lián)系電話 from customers where cardid like :cardid');
       adoquery2.Parameters.ParamByName('cardid').Value:=cardidstring+'%';
       adoquery2.Open;
     end;
end;

procedure Trctc.FormShow(Sender: TObject);
begin
  FormOldWid:=self.Width; //組件自動變大小
end;

procedure Trctc.car_addressidChange(Sender: TObject);
var
   addressid,address: string;
begin
    if car_addressid.Text<>'' then
    begin
    addressid:=car_addressid.Text;
    adot_caraddress.Locate('addressid',addressid,[loCaseInsensitive]);
    address:=adot_caraddress.FieldByName('address').value ;
    car_address.Text:=address;   //顯示addressid對應(yīng)的車位地址
    end
end;

procedure Trctc.caridExit(Sender: TObject);
begin
begin
  if carid.Text<>'' then
  begin
      adot_carstop.Close;
      adot_carstop.Open;
      if adot_carstop.Locate('carid',carid.Text,[locaseInsensitive]) then
      begin
         showmessage('此車牌已在停車場使用，請換個車牌') ;
         carid.Clear;
         carid.SetFocus;
      end
  end
end;
end;

procedure Trctc.FormClose(Sender: TObject; var Action: TCloseAction);
begin
adot_caraddress.Close;
adot_carclass.Close;
adot_carstop.Close;
adot_card.Close;
rctc:=nil;
Action:=caFree;
end;

procedure Trctc.FormResize(Sender: TObject);
begin
    if FormOldWid>0 then
    begin
     ScaleBy(self.Width,FormOldWid);
     FormOldWid:=self.Width;
    end ;
end;

procedure Trctc.DBGrid1CellClick(Column: TColumn);
begin
    if not adoquery2.IsEmpty then
    begin
    cardid.Text:=adoquery2.FieldByName('卡號').Value;
    checkcardid(adoquery2.FieldByName('卡號').Value);
    end;
end;

procedure Trctc.FormActivate(Sender: TObject);
begin
  adot_caraddress.Open;
  adot_carclass.Open;
  adot_carstop.Open;
  adot_card.Open;
  clearface();
end;

end.