u_cusmonstat.pas

河南师范大学餐饮进销存软件,只要控制库存的数据。

unit u_CusMonStat;

interface

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

type
  TfrmCusMonStat = class(TForm)
    CusStatQry: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    cmbCus: TEdit;
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure cmbCusChange(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmCusMonStat: TfrmCusMonStat;

implementation

uses u_DataCtrl;

{$R *.dfm}

procedure TfrmCusMonStat.FormShow(Sender: TObject);
begin
  CusStatQry.Active := true;
end;

procedure TfrmCusMonStat.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := Cafree ;
end;

procedure TfrmCusMonStat.cmbCusChange(Sender: TObject);
begin
  CusStatQry.Close;
  CusStatQry.SQL.Clear;
  CusStatQry.SQL.Add('select * from vw_CusBalanceMonStat  where BalanceMon>0 and ');
  CusStatQry.SQL.Add(' CusSName like '''+cmbCus.Text+'%''');
  try
    CusStatQry.Active := true ;
  except
  end;
end;

procedure TfrmCusMonStat.Edit1Change(Sender: TObject);
begin
  CusStatQry.Close;
  CusStatQry.SQL.Clear;
  CusStatQry.SQL.Add('select * from vw_CusBalanceMonStat  where BalanceMon>0 and ');
  CusStatQry.SQL.Add(' CusSName like '''+cmbCus.Text+'%''');
  try
    CusStatQry.Active := true ;
  except
  end;
end;

end.