📄 worklog.pas
字号:
unit worklog;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ComCtrls, Buttons, StdCtrls, Grids, DBGrids, DB, ADODB;
type
TFrmworklog = class(TForm)
GroupBox1: TGroupBox;
Label1: TLabel;
Label2: TLabel;
SpeedButton1: TSpeedButton;
begindate: TDateTimePicker;
enddate: TDateTimePicker;
GroupBox2: TGroupBox;
DBGrid1: TDBGrid;
ADOQuery1: TADOQuery;
DataSource1: TDataSource;
procedure SpeedButton1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Frmworklog: TFrmworklog;
implementation
uses dbmodule;
{$R *.dfm}
procedure TFrmworklog.SpeedButton1Click(Sender: TObject);
begin
if adoquery1.Active then
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from Q_worklog where logdate between #'+datetostr(begindate.Date)+' 00:00:00# and #'+datetostr(enddate.Date)+' 23:59:59#');
adoquery1.Open ;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -