printcust.~pas

进销存源码,这是一个可移植企业的进销存系统,大家可以参考一下做法

unit PrintCust;

interface

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

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

var
  PrintCustFrm: TPrintCustFrm;

implementation

uses MSDM, PickCustomer, custrpt;

{$R *.DFM}

procedure TPrintCustFrm.Button3Click(Sender: TObject);
begin
if pickcustomerfrm.ShowModal=mrok then
begin
   edit1.Text:= msdm.ModernSolidDM.CustCustno.Value;
end;
end;

procedure TPrintCustFrm.Button4Click(Sender: TObject);
begin
if pickcustomerfrm.ShowModal=mrok then
begin
   edit2.Text:= msdm.ModernSolidDM.CustCustno.Value;
end;
end;

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

procedure TPrintCustFrm.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.CustQry.close;
     msdm.ModernSolidDM.CustQry.SQL.Clear;
     msdm.ModernSolidDM.CustQry.sql.Add('select * from customer');
     msdm.ModernSolidDM.CustQry.sql.add(' where custno>= ');
     msdm.ModernSolidDM.CustQry.sql.add( ''''+edit1.Text+'''');
     msdm.ModernSolidDM.CustQry.sql.Add('and custno<= ');
     msdm.ModernSolidDM.CustQry.sql.Add(''''+edit2.text+'''');
     msdm.ModernSolidDM.CustQry.sql.Add('order by custno');
     msdm.ModernSolidDM.CustQry.open;
     custrptfrm.QuickRep1.Preview;
   end
else
   begin
     msdm.ModernSolidDM.CustQry.close;
     msdm.ModernSolidDM.CustQry.SQL.Clear;
     msdm.ModernSolidDM.CustQry.sql.Add('select * from customer');
     msdm.ModernSolidDM.CustQry.sql.Add('order by custno');
     msdm.ModernSolidDM.CustQry.open;
     custrptfrm.QuickRep1.Preview;
   end;
end;

end.