unit Uform_custom_pj;

interface

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

type
  mytype=record
        pjid:integer;
        apartid:integer;
        cuid:integer;
        good:integer;
        pjdd:tdatetime;
        theytext:string;
        pjbool:bool;
  end;
  Tform_custom_pj = class(TForm)
    Panel1: TPanel;
    Image1: TImage;
    Label2: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    Image2: TImage;
    recordset_temp: TADOQuery;
    ImageList1: TImageList;
    Panel2: TPanel;
    GroupBox1: TGroupBox;
    Panel4: TPanel;
    Label9: TLabel;
    Label6: TLabel;
    Label5: TLabel;
    Label11: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label10: TLabel;
    Label12: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    Edit1: TEdit;
    StaticText2: TStaticText;
    StaticText1: TStaticText;
    StaticText3: TStaticText;
    StaticText4: TStaticText;
    StaticText5: TStaticText;
    StaticText6: TStaticText;
    StaticText7: TStaticText;
    ListView1: TListView;
    Panel5: TPanel;
    BitBtn1: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn2: TBitBtn;
    button_add: TBitBtn;
    recordset_temp1: TADOQuery;
    procedure Edit1Change(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure button_addClick(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    
  private
    { Private declarations }
  public
    { Public declarations }
    cid:integer;
  end;

var
  form_custom_pj: Tform_custom_pj;

implementation

uses Uform_use_select, Uform_apart_yj, Uform_dollor_list;

{$R *.dfm}

procedure Tform_custom_pj.Edit1Change(Sender: TObject);
var
   i:integer;
   idc:integer;
   ListItem: TListItem;
   p:^mytype;
begin
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add ('select * from [CUSTOM] where [CUSTOM_CODE]="' + trim(edit1.Text ) + '"');
   recordset_temp.Open ;
   if (recordset_temp.RecordCount <> 0) then
   begin
      cid:=recordset_temp.Fields [0].AsInteger ;
      StaticText2.Caption := recordset_temp.Fields[2].AsString ;
      StaticText1.Caption := recordset_temp.Fields[3].AsString ;
      StaticText3.Caption := recordset_temp.Fields[9].AsString ;
      StaticText7.Caption := recordset_temp.Fields[8].AsString ;
      StaticText6.Caption := recordset_temp.Fields[4].AsString ;
      StaticText4.Caption := recordset_temp.Fields[6].AsString ;
      idc:=recordset_temp.Fields[5].AsInteger ;
      recordset_temp.Close;
      recordset_temp.SQL.Clear ;
      recordset_temp.SQL.Add('select * from [AREA] where [AREA_ID]=' + inttostr(IDC));
      recordset_temp.Open ;
      if( recordset_temp.RecordCount <>0) then
      begin
         statictext5.Caption :=recordset_temp.Fields[1].AsString;
      end;


      listview1.Clear ;
      recordset_temp.Close;
      recordset_temp.SQL.Clear ;
      recordset_temp.SQL.Add('select * from [APART]');
      recordset_temp.Open ;
      for i:=1 to recordset_temp.RecordCount do
      begin
         new(p);
         p^.cuid :=cid;
         p^.apartid :=recordset_temp.Fields[0].AsInteger ;
         recordset_temp1.SQL.Clear ;
         recordset_temp1.SQL.Add('select * from [PJ] where [PJ_APART_ID]=' + inttostr(recordset_temp.Fields[0].asinteger) + ' and [PJ_CU_ID]=' + inttostr(cid));
         recordset_temp1.Open ;
         listitem:=listview1.Items.Add;
         listitem.Caption :=recordset_temp.Fields[1].AsString ;
         listitem.ImageIndex :=0;
         if recordset_temp1.recordcount<>0 then
         begin
            p^.pjbool :=true;
            p^.pjid :=recordset_temp1.Fields[0].AsInteger ;
            p^.pjdd :=recordset_temp1.Fields[4].AsDateTime ;
            P^.theytext :=recordset_temp1.Fields[5].AsString ;

            if recordset_temp1.Fields[3].AsInteger =0 then
            begin
               p^.good :=0;
               listitem.SubItems.Add('優秀');
               listitem.SubItems.Add(datetimetostr(recordset_temp1.Fields[4].asdatetime));
            end;


            if recordset_temp1.Fields[3].AsInteger =1 then
            begin
               listitem.SubItems.Add('一般');
               p^.good :=1;
               listitem.SubItems.Add(datetimetostr(recordset_temp1.Fields[4].asdatetime));
            end;

            if recordset_temp1.Fields[3].AsInteger =2 then
            begin
               listitem.SubItems.Add('不好');
               listitem.SubItems.Add(datetimetostr(recordset_temp1.Fields[4].asdatetime));
               p^.good :=2;
            end;
         end
         else
         begin
            p^.pjbool :=false;
            listitem.SubItems.Add('沒有評價');
         end;
         listitem.Data:=p;
         recordset_temp1.Close;
         recordset_temp.Next;
      end;
   end
   else
   begin
      cid:=0;
      StaticText1.Caption := '';
      StaticText2.Caption := '';
      StaticText3.Caption := '';
      StaticText4.Caption := '';
      StaticText5.Caption := '';
      StaticText6.Caption := '';
      StaticText7.Caption := '';
   end;
   recordset_temp.close;

end;

procedure Tform_custom_pj.SpeedButton2Click(Sender: TObject);
begin
   form_use_select.ShowModal ;
   if form_use_select.yesno =true then
   begin
      edit1.Text :=form_use_select.usercode ;
   end;
end;

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

procedure Tform_custom_pj.BitBtn1Click(Sender: TObject);
var
   p:^mytype;
   temp:pchar;
begin
   temp:=pchar('對此部門這個用戶已經評價過了，是否覆蓋原評價');
   if listview1.Selected = nil then exit ;
   p:=listview1.Selected.Data ;

   if p^.pjbool =true then
   begin
      if messagebox(self.Handle, temp,
                  '警告',MB_yesno or MB_ICONQUESTION	)<>IDyes then
      begin
         exit;
      end;
      recordset_temp.SQL.Clear ;
      recordset_temp.SQL.Add('select * from [PJ] where [PJ_ID]=' + inttostr(p^.pjid ));
      recordset_temp.Open ;
      if recordset_temp.RecordCount >0 then
      begin
         recordset_temp.Delete ;
      end;
      recordset_temp.Close ;
   end;

   form_apart_yj.ShowModal ;

   if form_apart_yj.yesno =false then exit;

   p^.good :=0;
   p^.pjbool :=true;
   p^.theytext :=form_apart_yj.tt ;
   p^.pjdd :=now;
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add('select * from [PJ]');
   recordset_temp.Open ;
   recordset_temp.Insert;
   recordset_temp.Fields[1].AsInteger :=p^.apartid;
   recordset_temp.Fields[2].AsInteger :=p^.cuid;
   recordset_temp.Fields[3].AsInteger :=p^.good;
   recordset_temp.Fields[4].AsDateTime :=p^.pjdd;
   recordset_temp.Fields[5].AsString :=p^.theytext + ' ';
   recordset_temp.UpdateBatch ;

   recordset_temp.Last ;
   p^.pjid:=recordset_temp.Fields[0].AsInteger ;
   recordset_temp.close;
   listview1.Selected.SubItems.Clear ;
   listview1.Selected.SubItems.Add('優秀');
   listview1.Selected.SubItems.add(datetimetostr(p^.pjdd ));

end;



procedure Tform_custom_pj.BitBtn2Click(Sender: TObject);
var
   p:^mytype;
   temp:pchar;
begin
   temp:=pchar('對此部門這個用戶已經評價過了，是否覆蓋原評價');
   if listview1.Selected = nil then exit ;
   p:=listview1.Selected.Data ;

   if p^.pjbool =true then
   begin
      if messagebox(self.Handle, temp,
                  '警告',MB_yesno or MB_ICONQUESTION	)<>IDyes then
      begin
         exit;
      end;
      recordset_temp.SQL.Clear ;
      recordset_temp.SQL.Add('select * from [PJ] where [PJ_ID]=' + inttostr(p^.pjid ));
      recordset_temp.Open ;
      if recordset_temp.RecordCount >0 then
      begin
         recordset_temp.Delete ;
      end;
      recordset_temp.Close ;
   end;

   form_apart_yj.ShowModal ;

   if form_apart_yj.yesno =false then exit;

   p^.good :=1;
   p^.pjbool :=true;
   p^.theytext :=form_apart_yj.tt ;
   p^.pjdd :=now;
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add('select * from [PJ]');
   recordset_temp.Open ;
   recordset_temp.Insert;
   recordset_temp.Fields[1].AsInteger :=p^.apartid;
   recordset_temp.Fields[2].AsInteger :=p^.cuid;
   recordset_temp.Fields[3].AsInteger :=p^.good;
   recordset_temp.Fields[4].AsDateTime :=p^.pjdd;
   recordset_temp.Fields[5].AsString :=p^.theytext+ ' ';
   recordset_temp.UpdateBatch ;

   recordset_temp.Last ;
   p^.pjid:=recordset_temp.Fields[0].AsInteger ;
   recordset_temp.close;
   listview1.Selected.SubItems.Clear ;
   listview1.Selected.SubItems.Add('一般');
   listview1.Selected.SubItems.add(datetimetostr(p^.pjdd ));

end;

procedure Tform_custom_pj.button_addClick(Sender: TObject);
var
   p:^mytype;
   temp:pchar;
begin
   temp:=pchar('對此部門這個用戶已經評價過了，是否覆蓋原評價');
   if listview1.Selected = nil then exit ;
   p:=listview1.Selected.Data ;

   if p^.pjbool =true then
   begin
      if messagebox(self.Handle, temp,
                  '警告',MB_yesno or MB_ICONQUESTION	)<>IDyes then
      begin
         exit;
      end;
      recordset_temp.SQL.Clear ;
      recordset_temp.SQL.Add('select * from [PJ] where [PJ_ID]=' + inttostr(p^.pjid ));
      recordset_temp.Open ;
      if recordset_temp.RecordCount >0 then
      begin
         recordset_temp.Delete ;
      end;
      recordset_temp.Close ;
   end;

   form_apart_yj.ShowModal ;

   if form_apart_yj.yesno =false then exit;

   p^.good :=2;
   p^.pjbool :=true;
   p^.theytext :=form_apart_yj.tt ;
   p^.pjdd :=now;
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add('select * from [PJ]');
   recordset_temp.Open ;
   recordset_temp.Insert;
   recordset_temp.Fields[1].AsInteger :=p^.apartid;
   recordset_temp.Fields[2].AsInteger :=p^.cuid;
   recordset_temp.Fields[3].AsInteger :=p^.good;
   recordset_temp.Fields[4].AsDateTime :=p^.pjdd;
   recordset_temp.Fields[5].AsString :=p^.theytext+ ' ';
   recordset_temp.UpdateBatch ;

   recordset_temp.Last ;
   p^.pjid:=recordset_temp.Fields[0].AsInteger ;
   recordset_temp.close;
   listview1.Selected.SubItems.Clear ;
   listview1.Selected.SubItems.Add('不好');
   listview1.Selected.SubItems.add(datetimetostr(p^.pjdd ));

end;

procedure Tform_custom_pj.SpeedButton1Click(Sender: TObject);
begin
   if cid<>0 then
   begin
      form_dollor_list.cid:=cid;
      form_dollor_list.ShowModal ;
   end;
end;

end.