pm_qry_chginfopo.pas

一个MRPII系统源代码版本

unit Pm_Qry_ChgInfoPo;

Interface

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

Type
  TFrm_Pm_Qry_ChgInfoPo = Class(TFrm_Base_Qry)
    AdoQry_MainItemName: TStringField;
    AdoQry_MainPOLChgId: TAutoIncField;
    AdoQry_MainPONO: TStringField;
    AdoQry_MainPOLINENo: TIntegerField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainPOLineDATE: TDateTimeField;
    AdoQry_MainPOQTY: TFloatField;
    AdoQry_MainPONoFinishQty: TFloatField;
    AdoQry_MainPOREFERENCEDPRICE: TIntegerField;
    AdoQry_MainPOLINESTATUS: TIntegerField;
    AdoQry_MainPoNoTaxPrice: TFloatField;
    AdoQry_MainPONoTaxAmount: TBCDField;
    AdoQry_MainPoTaxPrice: TFloatField;
    AdoQry_MainPoTaxAmount: TBCDField;
    AdoQry_MainPOStArtWorkDate: TDateTimeField;
    AdoQry_MainPOLChgEmployeeCode: TStringField;
    AdoQry_MainPOLChgTime: TDateTimeField;
    AdoQry_MainPOLChgType: TStringField;
    AdoQry_MainEmployeeName: TStringField;
    AdoQry_MainUomCode: TStringField;
    AdoQry_MainUomName: TStringField;
    AdoQry_MainEmployeeflag: TStringField;
    AdoQry_MainItemflag: TStringField;
    dbtxtpono: TDBText;
    Label2: TLabel;
    Label1: TLabel;
    dbtxtItemflag: TDBText;
    dbtxTEmployeeflag: TDBText;
    Label3: TLabel;
    procedure FormDestroy(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
        procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
{ Public declarations }
  end;

var
  Frm_Pm_Qry_ChgInfoPo: TFrm_Pm_Qry_ChgInfoPo;

implementation
 uses Sys_Global,Pm_Qry_ChgInfoPo_C;
{$R *.DFM}

{ TFrm_Pm_Qry_ChgInfoPo }

procedure TFrm_Pm_Qry_ChgInfoPo.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
 Application.ProcessMessages;
  inherited;
  Pricefields:='potaxPrice,ponotaxPrice,';
   Frm_Sys_Condition:=TFrm_Pm_Qry_ChgInfoPo_C.Create(self);
   Act_Filter.Execute;
   selectfromsql:='select * from #poLineHistoryQry';
   Frm_Sys_Condition:=nil;

end;

procedure TFrm_Pm_Qry_ChgInfoPo.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Pm_Qry_ChgInfoPo:=nil;
end;

procedure TFrm_Pm_Qry_ChgInfoPo.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  try
    Executesql(AdoQry_tmp,'drop table #poLineHistoryQry',1);
  except
  end;

end;

end.