lsbksc.pas

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

unit lsbksc;

interface

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

type
  TlsbkscForm = class(TForm)
    DataSource1: TDataSource;
    Query1: TQuery;
    DBGrid1: TDBGrid;
    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
  lsbkscForm: TlsbkscForm;

implementation

uses dataproc;

{$R *.DFM}

procedure init;
begin
with lsbkscform do
begin
  DataSource1.DataSet:=query1;
  query1.Active :=false;
  query1.sql.clear;
  query1.sql.add('select roomno,handno,istime,isbj,s.sexname,begtime,sdjcode,guest,regid from lsnowin,lssex s where (s.sex=lsnowin.sex) and begtime>='''+datetostr(begdate.date)+''' and begtime<='''+datetostr(enddate.date)+' 23:59'+'''');
  query1.prepare;
  query1.open;
  chinesegrid(dbgrid1);
end;
end;



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

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

end;

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

end;

procedure TlsbkscForm.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 lscustom where Welid in ');
    query1.sql.add('(select Welid from lsnowin where begtime>='''+datetostr(begdate.date)+''' and begtime<='''+datetostr(enddate.date)+' 23:59'+''')');
    query1.sql.add('delete from lschangeroom where Welid in ');
    query1.sql.add('(select Welid from lsnowin where begtime>='''+datetostr(begdate.date)+''' and begtime<='''+datetostr(enddate.date)+' 23:59'+''')');
    query1.sql.add('delete from lsjz where accno in ');
    query1.sql.add('(select accno from lsnowin where begtime>='''+datetostr(begdate.date)+''' and begtime<='''+datetostr(enddate.date)+' 23:59'+''')');
    query1.sql.add('delete from lsnowin where begtime>='''+datetostr(begdate.date)+''' and begtime<='''+datetostr(enddate.date)+' 23:59'+'''');
    query1.prepare;
    query1.ExecSQL;
    query1.Active :=false;
    query1.sql.clear;
    cx.Checked:=false;
  end;
end;

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

end.