pm_qry_purchaseassignalanysis.pas

一个MRPII系统源代码版本

unit Pm_Qry_PurchaseAssignAlanysis;
Interface

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

Type
  TFrm_Pm_Qry_PurchaseAssignAlanysis = Class(TFrm_Base_Qry)
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MaInvendorCode: TStringField;
    AdoQry_MaInvendorName: TStringField;
    AdoQry_Mainpoqty: TFloatField;
    AdoQry_Mainper_Sumpoqty: TStringField;
    AdoQry_MainDiffpoqty: TStringField;
    AdoQry_Mainporealinqty: TFloatField;
    AdoQry_Mainper_Sumporealinqty: TStringField;
    AdoQry_Mainper_Finishqty: TStringField;
    AdoQry_MainAssignrate: TStringField;
    AdoQry_Mainflag: TIntegerField;
    procedure FormDestroy(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Act_FilterExecute(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;

  end;

var
  Frm_Pm_Qry_PurchaseAssignAlanysis: TFrm_Pm_Qry_PurchaseAssignAlanysis;

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

procedure TFrm_Pm_Qry_PurchaseAssignAlanysis.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Pm_Qry_PurchaseAssignAlanysis:=nil;
end;

procedure TFrm_Pm_Qry_PurchaseAssignAlanysis.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  Application.ProcessMessages;
  inherited;
  Frm_Sys_Condition:=TFrm_Pm_Qry_PurchaseAssignAlanysis_C.Create(self);
  Act_Filter.Execute;
  Frm_Sys_Condition:=nil;
  selectfromsql:='select * from #poResult';
  Orderbyfields:='ItemCode,VendorCode';
end;

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

procedure TFrm_Pm_Qry_PurchaseAssignAlanysis.Act_FilterExecute(
  Sender: TObject);
begin
  if (not AdoQry_Main.Active)  and (Frm_Sys_Condition=nil) then exit;
  inherited;
end;

end.