spxscx.pas

用delphi编写的销售管理系统

unit spxscx;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, Buttons, StdCtrls, Grids, DBGrids, DB, ComCtrls;

type
  TForm54 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Label1: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    SpeedButton1: TSpeedButton;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Panel3: TPanel;
    BitBtn8: TBitBtn;
    CheckBox1: TCheckBox;
    Label2: TLabel;
    Panel4: TPanel;
    Label3: TLabel;
    CheckBox2: TCheckBox;
    DateTimePicker1: TDateTimePicker;
    Label4: TLabel;
    DateTimePicker2: TDateTimePicker;
    procedure ComboBox1KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1Change(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure BitBtn8MouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure BitBtn8MouseUp(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form54: TForm54;

implementation
  uses Datamodal, DateUtils;
{$R *.dfm}

procedure TForm54.ComboBox1KeyPress(Sender: TObject; var Key: Char);
begin
  Key := #0;
end;

procedure TForm54.ComboBox1Change(Sender: TObject);
begin
  if Trim(ComboBox1.Text)<>''then
  begin
    with Data.ADOQuery1 do
    begin
      Close;
      SQL.Clear;
      SQL.Add('select distinct');
      SQL.Add(Trim(ComboBox1.Text));
      SQL.Add('from 销售表 ');
      Open;
    end;
    ComboBox2.Clear;
    while Not Data.ADOQuery1.Eof do
    begin
      ComboBox2.Items.Add(Data.ADOQuery1.Fields[0].value);
      Data.ADOQuery1.Next;
    end;
  end;
end;

procedure TForm54.SpeedButton1Click(Sender: TObject);
begin
  if (Trim(ComboBox2.Text)<>'')and(Trim(ComboBox1.Text)<>'') then
  begin
    CheckBox1.Checked := False;
    with Data.ADOQuery2 do
    begin
      Close;
      SQL.Clear;
      if CheckBox2.Checked = False then
      begin
        SQL.Add('select * from 销售表 where ');
        SQL.Add(Trim(ComboBox1.Text));
        SQL.Add('=');
        SQL.Add(':a');
      end
      else
      begin
        SQL.Add('Select * from 销售表 where');
        SQL.Add(Trim(ComboBox1.Text));
        SQL.Add('=');
        SQL.Add(':a');
        SQL.Add('and 销售票号 in (Select 销售票号 from 销售票号表 where 销售时间>=:b and 销售时间<= :c)');
        Parameters.ParamByName('b').Value := Int(DateTimePicker1.Date)-2 ;
        Parameters.ParamByName('c').Value := Int(DateTimePicker2.Date)-2+ 0.9998;
      end;
      Parameters.ParamByName('a').value := Trim(ComboBox2.Text);
      Open;
    end;
    if Data.ADOQuery2.RecordCount >0 then
      DataSource1.DataSet := Data.ADOQuery2;
  end;
end;

procedure TForm54.CheckBox1Click(Sender: TObject);
begin
  if CheckBox1.Checked = True then
  begin
    with Data.ADOQuery2 do
    begin
      Close;
      SQL.Clear;
      SQL.Add('select * from 销售表');
      Open;
    end;
    DataSource1.DataSet := Data.ADOQuery2;
  end;
end;

procedure TForm54.FormShow(Sender: TObject);
begin
  ComboBox1.Text := '';
  ComboBox2.Clear;
  DataSource1.DataSet := nil;
  CheckBox1.Checked := False;
end;

procedure TForm54.BitBtn8MouseDown(Sender: TObject; Button: TMouseButton;
  Shift: TShiftState; X, Y: Integer);
begin
  TBitBtn(Sender).Font.Color := clRed;
end;

procedure TForm54.BitBtn8MouseUp(Sender: TObject; Button: TMouseButton;
  Shift: TShiftState; X, Y: Integer);
begin
   TBitBtn(Sender).Font.Color := clBlue;
end;

end.