wei_dai_lai_liao.pas

来自「品质管理系统：delphi+sql实现了制造企业在生产过程中对产品质量的控制」· PAS 代码 · 共 47 行

unit wei_dai_lai_liao;

interface

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

type
  Twei_dai_lai_lia = class(TForm)
    SpeedButton1: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    DataSource1: TDataSource;
    sp1: TStoredProc;
    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
  wei_dai_lai_lia: Twei_dai_lai_lia;

implementation
 uses excel;
{$R *.dfm}

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

procedure Twei_dai_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 A.ding_gou_no as''璹潦絪腹'',A.ding_gou_date as ''璹潦ら戳'',A.jiao_ji as ''ユ戳'',A.chang_shang_no as ''ㄑ坝絪腹'',A.chang_shang_name as''ㄑ坝