zhou_pin_tong.pas

品质管理系统：delphi+sql实现了制造企业在生产过程中对产品质量的控制

unit zhou_pin_tong;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, Mask, DB, DBTables;

type
  Tzhou_pin_ton = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    t1: TMaskEdit;
    t2: TMaskEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Button1: TButton;
    Table1: TTable;
    sp1: TStoredProc;
    Table2: TTable;
    Query1: TQuery;
    sp2: TStoredProc;
    sp3: TStoredProc;
    sp4: TStoredProc;
    sp5: TStoredProc;
    sp6: TStoredProc;
    sp7: TStoredProc;
    Label3: TLabel;
    Query2: TQuery;
    xws: TStoredProc;
    Table3: TTable;
    Query3: TQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure t1KeyPress(Sender: TObject; var Key: Char);
    procedure t2KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure t2Exit(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  zhou_pin_ton: Tzhou_pin_ton;

implementation
uses zhou_pin_tong_report;
{$R *.dfm}

procedure Tzhou_pin_ton.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tzhou_pin_ton.t1KeyPress(Sender: TObject; var Key: Char);
begin
if key=chr(13) then
 t2.SetFocus;
end;

procedure Tzhou_pin_ton.t2KeyPress(Sender: TObject; var Key: Char);
begin
if key=chr(13) then
bitbtn1.SetFocus;
end;

procedure Tzhou_pin_ton.BitBtn2Click(Sender: TObject);
begin
close;
end;

procedure Tzhou_pin_ton.BitBtn1Click(Sender: TObject);
var   q,pi,pi1:integer;     pro_lue1,pro_lue2:double;
begin


  sp1.Active:=false;
   sp1.Prepare;
   sp1.ExecProc;
  query1.Active:=false;
  query1.SQl.Clear;
  query1.SQL.Add('select Distinct bumen from  zhi_chuan_juan_zhu where (juan_date>=:mm) and (juan_date<=:nn)');
 query1.ParamByName('mm').AsDateTime:=strtodate(t1.Text);
  query1.ParamByName('nn').AsDateTime:=strtodate(t2.Text);
  query1.Prepare;
  query1.Active:=true;
  if query1.Fields[0].AsString='' then
  begin
 showmessage('