u_browse.pas

销售业绩核算系统

unit U_browse;

interface

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

type
  TForm_browse = class(TForm)
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    ADOQuery1: TADOQuery;
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Edit2: TEdit;
    Edit3: TEdit;
    Button1: TButton;
    Label1: TLabel;
    Label2: TLabel;
    Edit4: TEdit;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure SpeedButton2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form_browse: TForm_browse;

implementation

uses F_DM;

{$R *.dfm}

procedure TForm_browse.SpeedButton3Click(Sender: TObject);
begin
close;
end;

procedure TForm_browse.SpeedButton1Click(Sender: TObject);
var
temp:double;
strtemp:string;
begin
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select sum(jiangjin) as countjiangjin from yejidan where username='''+trim(edit1.text)+'''';
adoquery1.Open;
temp:=adoquery1.FieldValues['countjiangjin'];
str(temp,strtemp);
edit4.Text:=strtemp;
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select * from yejidan where username='''+trim(edit1.text)+'''';
adoquery1.Open;
end;

procedure TForm_browse.DBGrid1CellClick(Column: TColumn);
begin
if adoquery1.RecordCount>0 then
      begin
      edit2.text:=adoquery1.FieldValues['zhiname'];
      edit3.text:=adoquery1.FieldValues['username'];
      end;
end;

procedure TForm_browse.SpeedButton2Click(Sender: TObject);
begin
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select * from yejidan where bianhao='''+'HK080'+trim(edit2.text)+'''';
adoquery1.Open;
end;

procedure TForm_browse.Button1Click(Sender: TObject);
begin
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select * from yejidan where jiangjin>='+trim(edit3.text)+'';
adoquery1.Open;

end;

procedure TForm_browse.FormActivate(Sender: TObject);
begin
adoquery1.Active:=true;
end;

end.