unit ghskccx1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  dxPSCore, dxPSdxTLLnk, dxPSdxDBCtrlLnk, dxPSdxDBGrLnk, Db, ADODB,
  dxDBCtrl, dxDBGrid, dxTL, dxDBTLCl, dxGrClms, dxCntner, ComCtrls,
  StdCtrls, ExtCtrls;

type
  Tghskccx = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Button1: TButton;
    Button2: TButton;
    dxDBGrid1: TdxDBGrid;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    dxComponentPrinter1: TdxComponentPrinter;
    dxComponentPrinter1Link1: TdxDBGridReportLink;
    ADOQuery1ghscode: TStringField;
    ADOQuery1ghsname: TStringField;
    ADOQuery1spcode: TStringField;
    ADOQuery1spname: TStringField;
    ADOQuery1barcode: TStringField;
    ADOQuery1kcsl: TBCDField;
    ADOQuery1jhj: TBCDField;
    ADOQuery1hsje: TBCDField;
    ADOQuery1wsjj: TBCDField;
    ADOQuery1wsje: TBCDField;
    dxDBGrid1ghscode: TdxDBGridMaskColumn;
    dxDBGrid1ghsname: TdxDBGridMaskColumn;
    dxDBGrid1spcode: TdxDBGridMaskColumn;
    dxDBGrid1spname: TdxDBGridMaskColumn;
    dxDBGrid1barcode: TdxDBGridMaskColumn;
    dxDBGrid1kcsl: TdxDBGridMaskColumn;
    dxDBGrid1jhj: TdxDBGridCurrencyColumn;
    dxDBGrid1hsje: TdxDBGridCurrencyColumn;
    dxDBGrid1wsjj: TdxDBGridCurrencyColumn;
    dxDBGrid1wsje: TdxDBGridCurrencyColumn;
    Button3: TButton;
    SaveDialog1: TSaveDialog;
    ADOQuery1bz: TStringField;
    dxDBGrid1Column11: TdxDBGridMaskColumn;
    ADOQuery1ckcode: TStringField;
    dxDBGrid1Column12: TdxDBGridMaskColumn;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ghskccx: Tghskccx;

implementation

uses MainForm1;

{$R *.DFM}

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

procedure Tghskccx.Button2Click(Sender: TObject);
begin
  dxComponentPrinter1.Preview(true, nil);
end;

procedure Tghskccx.Button1Click(Sender: TObject);
begin
  ADOQuery1.close;
  ADOQuery1.Parameters[0].Value := Edit1.text + '%';
  ADOQuery1.Parameters[1].Value := Edit1.text + '%';
  ADOQuery1.Parameters[2].Value := Edit2.text + '%';
  ADOQuery1.Parameters[3].Value := Edit3.text + '%';
  ADOQuery1.open;
end;

procedure Tghskccx.Button3Click(Sender: TObject);
begin
  SaveDialog1.Filter := 'Excel表格|*.xls';
  if SaveDialog1.Execute then
  begin
    dxDBGrid1.SaveToXLS(SaveDialog1.FileName, true);
    Application.MessageBox('文件已成功導出.', '提示', MB_OK + MB_ICONINFORMATION);
  end;
end;

end.