📄 sum050.pas
字号:
unit SUM050;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
BaseDialog, StdCtrls, Db, DBTables, Buttons, Grids, DBGrids, ExtCtrls,
ComCtrls;
type
TfmSUM050 = class(TfmBaseDialog)
dgCardStock: TDBGrid;
qyQuery: TQuery;
dsCardStock: TDataSource;
bnPrint: TBitBtn;
Panel6: TPanel;
Splitter1: TSplitter;
GroupBox1: TGroupBox;
DTP1: TDateTimePicker;
DTP2: TDateTimePicker;
Label7: TLabel;
Label8: TLabel;
qyQueryCARDTYPE: TStringField;
qyQueryCARDPARVALUE: TFloatField;
qyQueryINCOUNT: TFloatField;
qyQueryINSUM: TFloatField;
qyQueryOUTCOUNT: TFloatField;
qyQueryOUTSUM: TFloatField;
procedure bnOKClick(Sender: TObject);
procedure bnPrintClick(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure bnCancelClick(Sender: TObject);
procedure sbExitClick(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
procedure PrepareDlg; override;
end;
var
fmSUM050: TfmSUM050;
implementation
uses PublicFunction, Main, DataModule,GetData,SUM050Report;
var
sPrevPassword : String;
{$R *.DFM}
procedure TfmSUM050.PrepareDlg;
begin
end;
procedure TfmSUM050.bnOKClick(Sender: TObject);
var
ls_sql :string ;
begin
inherited;
with qyQuery do
begin
Close;
//Sql.Clear;
//Sql.Add(ls_sql);
ParamByName('BeginDate').AsDateTime := DTP1.DateTime;
ParamByName('EndDate').AsDateTime := DTP2.DateTime;
Open;
end;
end;
procedure TfmSUM050.bnPrintClick(Sender: TObject);
begin
inherited;
//打印
ProSUM050Print( DTP1.DateTime, DTP2.DateTime);
end;
procedure TfmSUM050.FormClose(Sender: TObject; var Action: TCloseAction);
begin
inherited;
Action := caFree;
end;
procedure TfmSUM050.bnCancelClick(Sender: TObject);
begin
inherited;
Close;
end;
procedure TfmSUM050.sbExitClick(Sender: TObject);
begin
inherited;
close;
end;
procedure TfmSUM050.FormCreate(Sender: TObject);
begin
inherited;
DTP1.Date := GetSysDate() - 30;
DTP2.Date := GetSysDate();
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -