pm_qry_supplypoitem.pas

一个MRPII系统源代码版本

unit Pm_Qry_SupplyPoItem;

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_SupplyPoItem = Class(TFrm_Base_Qry)
    AdoQry_MaInvendorItemCode: TStringField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainPoQty: TFloatField;
    AdoQry_MainPoLineDate: TDateTimeField;
    AdoQry_MainUomName: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MainItemflag: TStringField;
    Label1: TLabel;
    DBText1: TDBText;
    procedure FormDestroy(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    { Public declarations }
  end;

var
  Frm_Pm_Qry_SupplyPoItem: TFrm_Pm_Qry_SupplyPoItem;

implementation
uses Pm_Qry_SupplyPoItem_C;
{$R *.DFM}

{ TFrm_Pm_Qry_SupplyPoItem }

procedure TFrm_Pm_Qry_SupplyPoItem.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  inherited;
  Frm_Pm_Qry_SupplyPoItem_C:=TFrm_Pm_Qry_SupplyPoItem_C.Create(self);
  Frm_Pm_Qry_SupplyPoItem_C.AdoQry_Tmp.Connection:=dbconnect;
  Frm_Pm_Qry_SupplyPoItem_C.ShowModal;
  selectfromsql:='select * from #tmppoItemResult';
end;

procedure TFrm_Pm_Qry_SupplyPoItem.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Pm_Qry_SupplyPoItem:=nil;
end;

procedure TFrm_Pm_Qry_SupplyPoItem.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
with AdoQry_tmp do
  begin
    Close;
    sql.clear;
    sql.Add('drop table #tmppoline,#tmppoItemResult');
    Prepared;
    try
    execsql;
    except
    end;
  end;

end;

end.