unit U_Form_Storage_InitFind;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, EasyGrid, ButtonExCtl, StdCtrls,uAdoSet,uCheckValidate,uString;

type
  TForm_Storage_InitFind = class(TForm)
    GroupBox2: TGroupBox;
    BtnExit: TButtonExCtl;
    ButtonExCtl1: TButtonExCtl;
    GroupBox1: TGroupBox;
    Grid1: TEasyGrid;
    procedure BtnExitClick(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure FormCreate(Sender: TObject);
    procedure ButtonExCtl1Click(Sender: TObject);
  private
    { Private declarations }
    _AdoNewProduce:TuAdoSet;
    _Adosale:TuAdoSet;
    _Check:TCheckValidate;
    _str:TuString;
  public
    { Public declarations }
  end;

var
  Form_Storage_InitFind: TForm_Storage_InitFind;

implementation

uses U_Form_Storage_Init,uGlobal;

{$R *.dfm}

procedure TForm_Storage_InitFind.BtnExitClick(Sender: TObject);
begin
     EnableWindow(Form_Storage_Init.Handle,true);
     Close;
end;

procedure TForm_Storage_InitFind.FormCloseQuery(Sender: TObject;
  var CanClose: Boolean);
begin
     EnableWindow(Form_Storage_Init.Handle,true);
     CanClose:=true;
end;

procedure TForm_Storage_InitFind.FormCreate(Sender: TObject);
begin
    _AdoNewProduce:=TuAdoSet.Create('newProduce',1);
    _Adosale:=TuAdoSet.Create('newsale',1);
    _Check:=TCheckValidate.create;
    _str:=TuString.Create;



     with _AdoNewProduce do
     begin
         setGridTitle(grid1,1,'序號(hào)',60);
         setGridTitle(grid1,2,'產(chǎn)品名稱(chēng)',140);
         setGridTitle(grid1,3,'規(guī)格',80);
         setGridTitle(grid1,4,'單位',80);
         setGridTitle(grid1,5,'成套數(shù)',90);
         setGridTitle(grid1,6,'空箱數(shù)',80);
         setGridTitle(grid1,7,'整瓶數(shù)',100);

     end;
end;

procedure TForm_Storage_InitFind.ButtonExCtl1Click(Sender: TObject);
var
   param:TStringList;
   strSql:string;
begin
   param:=TStringList.Create;
   {/*
       顯示記錄
   */}
   {/*
       開(kāi)始檢索數(shù)據(jù) ,fxdgdfg
   */}
   param.Add(_whichStore);
   strSql:='select  OrderID,ProduceName,specification,UnitName,boxNum,emptyboxNum,bottleNum  from  sale_Storage  Where  whichStore=:s1  order by  OrderID';
   _AdoNewproduce.BindToGrid(grid1,strsql,param);
   grid1.Refresh; 
end;

end.