rzsc.pas

集成酒店桑拿食管管理的完整程序

unit rzsc;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Db, DBTables, Grids, DBGrids, ComCtrls, ExtCtrls;

type
  TrzscForm = class(TForm)
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Query1: TQuery;
    Panel2: TPanel;
    Label2: TLabel;
    Label7: TLabel;
    Label1: TLabel;
    Panel1: TPanel;
    cx: TCheckBox;
    begdate: TDateTimePicker;
    enddate: TDateTimePicker;
    Panel3: TPanel;
    Button1: TButton;
    Button2: TButton;
    procedure FormCreate(Sender: TObject);
    procedure begdateChange(Sender: TObject);
    procedure cxClick(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  rzscForm: TrzscForm;

implementation

uses dataproc;

{$R *.DFM}

procedure init;
begin
with rzscform do
begin
  DataSource1.DataSet:=query1;
  query1.Active :=false;
  query1.sql.clear;
  query1.sql.add('select * from logo where time>='''+datetostr(begdate.date)+''' and time<='''+datetostr(enddate.date)+' 23:59'+'''');
  query1.prepare;
  query1.open;
  chinesegrid(dbgrid1);
end;
end;




procedure TrzscForm.FormCreate(Sender: TObject);
begin
  shortdateformat:='yyyy-mm-dd';
  enddate.date:=now-365;
  begdate.date:=now-730;
  init;

end;

procedure TrzscForm.begdateChange(Sender: TObject);
begin
   cx.Checked:=false;
   Panel1.Enabled:=true;
   query1.Close;

end;

procedure TrzscForm.cxClick(Sender: TObject);
begin
   init;
   Panel1.Enabled:=false;

end;

procedure TrzscForm.Button1Click(Sender: TObject);
begin
  if cx.Checked then
  begin
    DataSource1.DataSet:=nil;
    query1.Close;
    query1.Active :=false;
    query1.sql.clear;
    query1.sql.add('delete from logo where time>='''+datetostr(begdate.date)+''' and time<='''+datetostr(enddate.date)+' 23:59'+'''');
    query1.prepare;
    query1.ExecSQL;
    query1.Active :=false;
    query1.sql.clear;
    cx.Checked:=false;
  end;

end;

procedure TrzscForm.Button2Click(Sender: TObject);
begin
  close;
end;

end.