unit Uform_advice_inf;

interface

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

type
  Tform_advice_inf = class(TForm)
    Panel1: TPanel;
    Image1: TImage;
    Label2: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    Image2: TImage;
    Label23: TLabel;
    Label24: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    recordset_temp: TADOQuery;
    recordset_temp2: TADOQuery;
    ImageList1: TImageList;
    Panel2: TPanel;
    ListView1: TListView;
    Panel3: TPanel;
    Panel4: TPanel;
    BitBtn3: TBitBtn;
    BitBtn1: TBitBtn;
    Label5: TLabel;
    Label6: TLabel;
    procedure BitBtn3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    sdate:tdate;
    edate:tdate;
    partid:integer;
    partname:string;
  end;

var
  form_advice_inf: Tform_advice_inf;

implementation

uses Uform_dollor_list;

{$R *.dfm}

procedure Tform_advice_inf.BitBtn3Click(Sender: TObject);
begin
   close;
end;

procedure Tform_advice_inf.FormShow(Sender: TObject);
var
   i:integer;
   ListItem: TListItem;
   p:^integer;
begin
   listview1.Clear;

   label24.Caption :=partname;
   label4.Caption :=datetostr(sdate) + ' - ' + datetostr(edate);

   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add('select [CUSTOM_ID],[CUSTOM_CODE],[CUSTOM_MNAME],[CUSTOM_FNAME],[PJ_OK],[PJ_DATE],[PJ_TEXT] from [PJ],[CUSTOM] where [PJ_CU_ID]=[CUSTOM_ID] and [PJ_APART_ID]=' + inttostr(partid) + ' and [PJ_DATE]>=#'
     + datetostr(sdate) + '# and [PJ_DATE]<=#' + datetostr(edate+1) + '#');
   recordset_temp.Open ;
   label6.Caption := inttostr(recordset_temp.RecordCount ) + '條評價';

   for i:=1 to recordset_temp.RecordCount do
   begin
      listitem:=listview1.Items.Add ;
      listitem.Caption :=recordset_temp.Fields[1].AsString ;
      listitem.ImageIndex :=0;

      listitem.SubItems.Add(recordset_temp.Fields[2].AsString );
      listitem.SubItems.Add(recordset_temp.Fields[3].AsString );

      case recordset_temp.Fields[4].AsInteger of
      0:
         listitem.SubItems.Add('好');
      1:
         listitem.SubItems.Add('一般');
      2:
         listitem.SubItems.Add('差');
      end;

      listitem.SubItems.Add(datetostr(recordset_temp.Fields[5].asdatetime));
      listitem.SubItems.Add(recordset_temp.Fields[6].AsString );
      new(p);
      p^ := recordset_temp.Fields[0].AsInteger ;
      listitem.Data :=p;
      recordset_temp.Next ;
   end;

   recordset_temp.Close ;
end;

procedure Tform_advice_inf.BitBtn1Click(Sender: TObject);
var
   p:^integer;
begin
   if listview1.selected=nil then exit;
   p:=listview1.Selected.Data ;
   form_dollor_list.cid:=p^;
   form_dollor_list.ShowModal ;
end;

end.