cgshmx1.pas

来自「思微POS连锁超市管理系统 (商业代码),几年前的东西了」· PAS 代码 · 共 122 行

unit cgshmx1;

interface

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

type
  Tcgshmx = class(TForm)
    Panel1: TPanel;
    Button1: TButton;
    Button2: TButton;
    dxDBGrid1: TdxDBGrid;
    dxComponentPrinter1: TdxComponentPrinter;
    Query1: TADOQuery;
    DataSource1: TDataSource;
    Query1kdrq: TDateTimeField;
    Query1spcode: TStringField;
    Query1spname: TStringField;
    Query1jldw: TStringField;
    Query1bzgg: TFloatField;
    Query1js: TBCDField;
    Query1ss: TBCDField;
    Query1sl: TBCDField;
    Query1dj: TBCDField;
    Query1sui: TBCDField;
    Query1je: TBCDField;
    Query1lb: TStringField;
    Query1barcode: TStringField;
    Query1mainghs: TStringField;
    Query1bz: TStringField;
    dxDBGrid1kdrq: TdxDBGridDateColumn;
    dxDBGrid1spcode: TdxDBGridMaskColumn;
    dxDBGrid1spname: TdxDBGridMaskColumn;
    dxDBGrid1jldw: TdxDBGridMaskColumn;
    dxDBGrid1bzgg: TdxDBGridMaskColumn;
    dxDBGrid1js: TdxDBGridMaskColumn;
    dxDBGrid1ss: TdxDBGridMaskColumn;
    dxDBGrid1sl: TdxDBGridMaskColumn;
    dxDBGrid1dj: TdxDBGridMaskColumn;
    dxDBGrid1sui: TdxDBGridMaskColumn;
    dxDBGrid1je: TdxDBGridMaskColumn;
    dxDBGrid1lb: TdxDBGridMaskColumn;
    dxDBGrid1barcode: TdxDBGridMaskColumn;
    dxDBGrid1mainghs: TdxDBGridMaskColumn;
    dxDBGrid1bz: TdxDBGridMaskColumn;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label4: TLabel;
    Edit2: TEdit;
    dxComponentPrinter1Link1: TdxDBGridReportLink;
    Button3: TButton;
    SaveDialog1: TSaveDialog;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cgshmx: Tcgshmx;

implementation

uses MainForm1;

{$R *.DFM}

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

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

procedure Tcgshmx.FormCreate(Sender: TObject);
begin
  DateTimePicker1.DateTime := MainForm.DateTimePicker2.DateTime;
  DateTimePicker2.DateTime := MainForm.DateTimePicker1.DateTime;
end;

procedure Tcgshmx.Button1Click(Sender: TObject);
var aa, bb: string;
begin
  if Edit1.Text = '' then aa := '%' else aa := Edit1.Text;
  if Edit2.Text = '' then bb := '%' else bb := Edit2.Text;
  Query1.close;
  Query1.Parameters[0].Value := aa;
  Query1.Parameters[3].Value := bb;
  Query1.Parameters[4].Value := bb;
  Query1.Parameters[1].Value := DateTimePicker1.date;
  Query1.Parameters[2].Value := DateTimePicker2.date;
  Query1.open;
end;

procedure Tcgshmx.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.