unit Printfact;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, ExtCtrls;

type
  TPrintFactFrm = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Button3: TButton;
    Button4: TButton;
    Button1: TButton;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  PrintFactFrm: TPrintFactFrm;

implementation

uses MSDM, PickFactory, factrpt;

{$R *.DFM}

procedure TPrintFactFrm.Button1Click(Sender: TObject);
var temp:string;
begin
if not ((trim(edit1.text)='')and (trim(edit2.text)='')) then
   begin
     if (edit1.Text>edit2.text)then
     begin
         temp:=edit1.Text;
         edit1.text:=edit2.text;
         edit2.Text:=temp;
     end;
     msdm.ModernSolidDM.FactQry.close;
     msdm.ModernSolidDM.FactQry.SQL.Clear;
     msdm.ModernSolidDM.FactQry.sql.Add('select * from factory');
     msdm.ModernSolidDM.FactQry.sql.add(' where factno>= ');
     msdm.ModernSolidDM.FactQry.sql.add( ''''+edit1.Text+'''');
     msdm.ModernSolidDM.FactQry.sql.Add('and factno<= ');
     msdm.ModernSolidDM.FactQry.sql.Add(''''+edit2.text+'''');
     msdm.ModernSolidDM.FactQry.sql.Add('order by factno');
     msdm.ModernSolidDM.FactQry.open;
     factrptfrm.QuickRep1.Preview;
   end
else
   begin
     msdm.ModernSolidDM.FactQry.close;
     msdm.ModernSolidDM.FactQry.SQL.Clear;
     msdm.ModernSolidDM.FactQry.sql.Add('select * from factory');
     msdm.ModernSolidDM.FactQry.sql.Add('order by factno');
     msdm.ModernSolidDM.FactQry.open;
     factrptfrm.QuickRep1.Preview;     
   end;
end;

procedure TPrintFactFrm.Button3Click(Sender: TObject);
begin
if pickfactoryfrm.ShowModal=mrok then
begin
   edit1.Text:=msdm.ModernSolidDM.Factfactno.Value;
end;
end;

procedure TPrintFactFrm.Button4Click(Sender: TObject);
begin
if pickfactoryfrm.ShowModal=mrok then
begin
   edit1.Text:=msdm.ModernSolidDM.Factfactno.Value;
end;
end;

procedure TPrintFactFrm.Button2Click(Sender: TObject);
begin
close;
end;

end.