unit jh_find_unit;

interface

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

type
  Tjh_find_form = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    GroupBox7: TGroupBox;
    Label35: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    Label38: TLabel;
    SpeedButton21: TSpeedButton;
    ComboBox4: TComboBox;
    ComboBox5: TComboBox;
    Edit1: TEdit;
    CheckBox2: TCheckBox;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    DBGrid3: TDBGrid;
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    StatusBar2: TStatusBar;
    DBGrid2: TDBGrid;
    StatusBar3: TStatusBar;
    SpeedButton3: TSpeedButton;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    SpeedButton6: TSpeedButton;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton7: TSpeedButton;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit2: TEdit;
    CheckBox1: TCheckBox;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    GroupBox2: TGroupBox;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    SpeedButton2: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton8: TSpeedButton;
    ComboBox3: TComboBox;
    ComboBox6: TComboBox;
    Edit3: TEdit;
    CheckBox3: TCheckBox;
    DateTimePicker5: TDateTimePicker;
    DateTimePicker6: TDateTimePicker;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton8Click(Sender: TObject);
    procedure SpeedButton21Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jh_find_form: Tjh_find_form;

implementation

uses data_unit;

{$R *.dfm}


procedure Tjh_find_form.SpeedButton1Click(Sender: TObject);
begin
with database do
begin
adoq1.Connection :=adoc;
adoq1.SQL.Clear ;
edit8.Text :=formatdatetime('MM-dd-yy',datetimepicker5.date);
edit9.Text :=formatdatetime('MM-dd-yy',datetimepicker6.date);

case combobox1.ItemIndex of
    0:
     begin
     case combobox2.ItemIndex of
      0:
        begin
           if checkbox3.Checked  then
            begin
             adoq1.SQL.Add('select * from jhfk where 單據編碼=:yhbh and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('yhbh').Value :=edit2.Text ;
            end
          else
           begin
            adoq1.SQL.Add('select * from jhfk where 單據編碼=:yhbh order by 編號');
            adoq1.Parameters.ParamByName('yhbh').Value :=edit2.Text;
           end;
         end;
       1:
         if checkbox2.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 單據編碼 like :yhbh2 and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('yhbh2').Value :=edit2.Text+'%' ;
          end
          else
         begin
          adoq1.SQL.Add('select * from jhfk where 單據編碼 like :yhbh2 order by 編號');
          adoq1.Parameters.ParamByName('yhbh2').Value :=edit2.Text+'%';
         end;
        end;
   end;
    1:
     begin
     case combobox2.ItemIndex of
      0:
        begin
           if checkbox1.Checked  then
            begin
             adoq1.SQL.Add('select * from jhfk where 供貨商名稱=:bh and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('bh').Value :=edit2.Text ;
            end
          else
           begin
            adoq1.SQL.Add('select * from jhfk where 供貨商名稱=:bh order by 編號');
            adoq1.Parameters.ParamByName('bh').Value :=edit2.Text;
           end;
         end;
       1:
         if checkbox2.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 供貨商名稱 like :bh2 and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('bh2').Value :=edit2.Text+'%' ;
          end
          else
         begin
          adoq1.SQL.Add('select * from jhfk where 供貨商名稱 like :bh2 order by 編號');
          adoq1.Parameters.ParamByName('bh2').Value :=edit2.Text+'%';
         end;
        end;
   end;
  2:
   begin
     case combobox2.ItemIndex of
      0:
        begin
        if checkbox2.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 經手人=:mc and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('mc').Value :=edit2.Text ;
           end
          else
           begin
            adoq1.SQL.Add('select * from jhfk where 經手人=:mc order by 編號');
            adoq1.Parameters.ParamByName('mc').Value :=edit2.Text;
            end;
           end;
          1:
         if checkbox2.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 經手人 like :mc and 錄單日期 between #'+edit4.text+ '# and #' +edit5.text+'# order by 編號');
             adoq1.Parameters.ParamByName('mc').Value :=edit2.Text+'%' ;
          end
          else
         begin
          adoq1.SQL.Add('select * from jhfk where 經手人 like :mc order by 編號');
          adoq1.Parameters.ParamByName('mc').Value :=edit2.Text+'%';
         end;
         end;
end;
//end
  3:
   begin
     case combobox2.ItemIndex of
      0:
        begin
        if checkbox1.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 發票類型=:lx and 錄單日期 between #'+edit6.text+ '# and #' +edit7.text+'# order by 編號');
             adoq1.Parameters.ParamByName('lx').Value :=edit1.Text ;
           end
          else
           begin
            adoq1.SQL.Add('select * from jhfk where 發票類型=:mc order by 編號');
            adoq1.Parameters.ParamByName('lx').Value :=edit2.Text;
            end;
           end;
          1:
         if checkbox1.Checked  then
          begin
             adoq1.SQL.Add('select * from jhfk where 發票類型 like :lx1 and 錄單日期 between #'+edit4.text+ '# and #' +edit5.text+'# order by 編號');
             adoq1.Parameters.ParamByName('lx1').Value :=edit2.Text+'%' ;
          end
          else
         begin
          adoq1.SQL.Add('select * from jhfk where 發票類型 like :lx2 order by 編號');
          adoq1.Parameters.ParamByName('lx2').Value :=edit2.Text+'%';
         end;
         end;
end
else
    begin
     adoq1.SQL.Clear ;
     adoq1.SQL.Add('select * from jhfk order by 編號 ');
  end;
end;
adoq1.Active :=true;
datas2.DataSet :=nil;
datas2.DataSet :=adoq1;
dbgrid1.DataSource :=datas2;
end;

end;

procedure Tjh_find_form.SpeedButton2Click(Sender: TObject);
begin
with database do
begin
adoq1.Connection :=adoc;
adoq1.SQL.Clear ;
edit8.Text :=formatdatetime('MM-dd-yy',datetimepicker5.date);
edit9.Text :=formatdatetime('MM-dd-yy',datetimepicker6.date);

case combobox3.ItemIndex of
    0:
     begin
     case combobox6.ItemIndex of