sfc_shiftinoutsumqry.pas

一个MRPII系统源代码版本

unit Sfc_ShiftInOutSumQry;

Interface

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

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

var
  Frm_Sfc_ShiftInOutSumQry: TFrm_Sfc_ShiftInOutSumQry;

implementation

uses Sfc_ShiftInOutSumQry_C;

{$R *.DFM}

procedure TFrm_Sfc_ShiftInOutSumQry.GetData;
begin
  inherited;
  AdoQry_Main.Close;
  AdoQry_Main.SQL.Text:=Condition;
  AdoQry_Main.Open;
  AdoQry_Main.Sort:=OrderByFields;
end;

procedure TFrm_Sfc_ShiftInOutSumQry.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  if Param1='Out' then
  begin
    Caption:='生产领料分班别汇总表';
    Pnl_Title.Caption:='生产领料分班别汇总表';
  end
  else if Param1='In' then
  begin
    Caption:='生产入库分班别汇总表';
    Pnl_Title.Caption:='生产入库分班别汇总表';
  end;
  inherited;
  OrderByFields:='ShiftType,ItemCode';
  Frm_Sys_Condition:=TFrm_Sfc_ShiftInOutSumQry_C.Create(Self);
  Act_Filter.Execute;
end;

end.