inv_safeinvqry.pas

一个MRPII系统源代码版本

unit Inv_SafeInvQry;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base_Qry, Menus, ExtPrintReport, Db, ActnList, AdODB, Grids, DBGridEh,
  StdCtrls, ExtCtrls, ComCtrls, ToolWin, DBCtrls;

Type
  TFrm_Inv_SafeInvQry = Class(TFrm_Base_Qry)
    Label1: TLabel;
    DBText1: TDBText;
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
    procedure GetData; Override;
  end;

var
  Frm_Inv_SafeInvQry: TFrm_Inv_SafeInvQry;

implementation

uses Inv_SafeInvQry_C;

{$R *.DFM}

{ TFrm_Inv_SafeInvQry }

procedure TFrm_Inv_SafeInvQry.GetData;
var
  i:Integer;
begin
  AdoQry_Main.Close;
  AdoQry_Main.SQL.Text:=Condition;
  AdoQry_Main.Open;
  AdoQry_Main.Sort:=OrderByFields;
  DBGridEh.Columns[0].Title.Alignment:=taCenter;
  DBGridEh.Columns[0].Width:=100;
  DBGridEh.Columns[0].Visible:=False;
  DBGridEh.Columns[1].Title.Alignment:=taCenter;
  DBGridEh.Columns[1].Width:=200;
  DBGridEh.Columns[1].Visible:=False;
  DBGridEh.Columns[2].Title.Alignment:=taCenter;
  DBGridEh.Columns[2].Width:=300;
  for i:=3 to DBGridEh.Columns.Count-1 do
  begin
    DBGridEh.Columns[i].Title.Alignment:=taCenter;
    DBGridEh.Columns[i].Width:=60;
  end;
end;

procedure TFrm_Inv_SafeInvQry.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  inherited;
  if Param1='Safe' then
  begin
    Caption:='物料安全库存预警列表';
    Pnl_Title.Caption:='物料安全库存预警列表';
  end
  else if Param1='Over' then
  begin
    Caption:='物料超储库存预警列表';
    Pnl_Title.Caption:='物料超储库存预警列表';
  end;
  Frm_Sys_Condition:=TFrm_Inv_SafeInvQry_C.Create(Self);
  OrderByFields:='物料代码';
  Act_Filter.Execute;
end;

end.