dfm_tcheck.pas

仓库管理系统 仓库管理系统

unit dfm_tcheck;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, StdCtrls, Buttons, ExtCtrls, Grids, DBGrids, Db, DBTables, Mask,
  DBCtrls, ADODB, DBGridEh;

type
  Tdfmtcheck = class(TForm)
    StatusBar1: TStatusBar;
    Panel2: TPanel;
    postbtn: TBitBtn;
    dstmanrec: TDataSource;
    DBGridEh1: TDBGridEh;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    ADOQuery3: TADOQuery;
    MaskEdit1: TMaskEdit;
    Label1: TLabel;
    Label2: TLabel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure quitbtnClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure postbtnClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmtcheck: Tdfmtcheck;

implementation

uses  dbmRainbowMis;

{$R *.DFM}

procedure Tdfmtcheck.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  action:=cafree;
end;

procedure Tdfmtcheck.quitbtnClick(Sender: TObject);
begin
  close;
end;

procedure Tdfmtcheck.FormCreate(Sender: TObject);
begin
  ADOQuery1.ExecSQL ;
  ADOQuery2.ExecSQL ;
  ADOQuery3.Open ;
end;

procedure Tdfmtcheck.postbtnClick(Sender: TObject);
var
  fstr:String;
begin
  fstr:='SELECT bmh, clabel, left(t_check.spbh,%d) AS spbh, sum(t_check.cnumber) AS cnumber, cdate FROM t_check'
       +' GROUP BY bmh, clabel, left(t_check.spbh,%d), cdate';
  with ADOQuery3 do
  begin
    close;
    sql.Clear ;
    sql.Add(Format(fstr,[strtoint(trim(MaskEdit1.text)),strtoint(MaskEdit1.text)]));
    Prepared;
    open;
  end;
end;

end.