uform_fw_select.pas

这是在SQL数据库下编写的一个源代码

unit Uform_fw_select;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Spin, Buttons, ComCtrls, ImgList, ExtCtrls, DB, ADODB;

type
  Tform_fw_select = class(TForm)
    Panel1: TPanel;
    Image1: TImage;
    Label2: TLabel;
    Label4: TLabel;
    Label3: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    Image2: TImage;
    ImageList1: TImageList;
    Panel2: TPanel;
    Apart_list: TListView;
    Panel3: TPanel;
    Panel4: TPanel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    SpinEdit1: TSpinEdit;
    Label5: TLabel;
    recordset_temp: TADOQuery;
    procedure FormShow(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    intCount:integer;
    yesno:bool;
    fwid:integer;
    fwname:string;
    fwcount:integer;
    fwmoney:real;
  end;

var
  form_fw_select: Tform_fw_select;

implementation

{$R *.dfm}

procedure Tform_fw_select.FormShow(Sender: TObject);
var
   i:integer;
   ListItem: TListItem;
   p:^integer;
begin
   apart_list.Items.Clear ;
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add ('select * from [FW]');
   recordset_temp.Open ;
   intCount:=recordset_temp.RecordCount ;
   Label4.Caption :=inttostr(intCount) + '种';
   for i:=1 to recordset_temp.RecordCount do
   begin
      listitem:=apart_LIST.Items.Add ;
      listitem.Caption :=recordset_temp.Fields[1].AsString ;
      listitem.ImageIndex :=0;
      listitem.SubItems.Add(format( '%8.2f￥',[recordset_temp.Fields[2].asfloat]));
      new(p);
      p^ := recordset_temp.Fields[0].AsInteger ;
      listitem.Data :=p;
      recordset_temp.Next;
   end;
   yesno:=false;
end;

procedure Tform_fw_select.BitBtn1Click(Sender: TObject);
var
   p:^integer;
begin
   if apart_list.Selected =nil then exit;
   p:=Apart_list.Selected.Data;
   fwid:=p^;
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add ('select * from [FW] where [FW_ID]=' + inttostr(p^));
   recordset_temp.Open ;
   if recordset_temp.RecordCount <>0 then
   begin
      fwname:=recordset_temp.Fields[1].AsString ;
      fwmoney:=recordset_temp.Fields[2].AsFloat ;
      recordset_temp.Close;
      fwcount:=SpinEdit1.Value ;
      yesno:=true;
      close;
   end;
   recordset_temp.close ;
end;

procedure Tform_fw_select.BitBtn2Click(Sender: TObject);
begin
   close;
end;

end.