pm_qry_chginfopoh.pas

一个MRPII系统源代码版本

unit Pm_Qry_ChgInfoPoH;

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_ChgInfoPoH = Class(TFrm_Base_Qry)
    AdoQry_MainPOChgId: TAutoIncField;
    AdoQry_MainPONO: TStringField;
    AdoQry_MaInvendorCode: TStringField;
    AdoQry_MainPOType: TIntegerField;
    AdoQry_MainPODate: TDateTimeField;
    AdoQry_MainPOTAXRATE_PERCENT: TIntegerField;
    AdoQry_MainCURRENCYCode: TStringField;
    AdoQry_MainEmployeeCode: TStringField;
    AdoQry_MainPORemArk: TStringField;
    AdoQry_MainPoSpecial: TIntegerField;
    AdoQry_MainPcNo: TStringField;
    AdoQry_MainPOChgEmployeeCode: TStringField;
    AdoQry_MainPOChgTime: TDateTimeField;
    AdoQry_MainPOChgType: TStringField;
    AdoQry_MaInvendorName: TStringField;
    AdoQry_MainpochgEmployeeName: TStringField;
    AdoQry_MainCurrencyName: TStringField;
    AdoQry_MainpoEmployeeName: TStringField;
    AdoQry_MaInvendorflag: TStringField;
    AdoQry_MainEmployeeflag: TStringField;
    Label2: TLabel;
    dbtxtpono: TDBText;
    dbtxtVendorflag: TDBText;
    Label1: TLabel;
    Label3: TLabel;
    dbtxTEmployeeflag: TDBText;
    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_ChgInfoPoH: TFrm_Pm_Qry_ChgInfoPoH;

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

{ TFrm_Pm_Qry_ChgInfoPoH }

procedure TFrm_Pm_Qry_ChgInfoPoH.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  inherited;
  Frm_Sys_Condition:=TFrm_Pm_Qry_ChgInfoPoH_C.Create(self);
  Act_Filter.Execute;
  selectfromsql:='select * from #tmppohistory';
  Frm_Sys_Condition:=nil;
end;

procedure TFrm_Pm_Qry_ChgInfoPoH.FormDestroy(Sender: TObject);
begin
  inherited;
 Frm_Pm_Qry_ChgInfoPoH:=nil;
end;

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

end.