jin_lai_liao.pas

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

unit jin_lai_liao;

interface

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

type
  Tjin_lai_lia = class(TForm)
    SpeedButton1: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    StoredProc1: TStoredProc;
    DataSource1: TDataSource;
    Query1: TQuery;
    SpeedButton2: TSpeedButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jin_lai_lia: Tjin_lai_lia;

implementation
uses excel;
{$R *.dfm}

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

procedure Tjin_lai_lia.SpeedButton2Click(Sender: TObject);
var exce:Texce;
begin
exce:=Texce.Create(self);
exce.Query1.Active:=false;
exce.Query1.SQL.Clear;
exce.Query1.SQL.Add('select ding_gou_no as''璹潦絪腹'',ding_gou_date as''璹潦ら戳'',jiao_ji as''ユ戳'',chang_shang_name as''ㄑ坝