pm_qry_analyzerpo3.pas

一个MRPII系统源代码版本

unit Pm_Qry_AnalyzerPo3;

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_AnalyzerPo3 = Class(TFrm_Base_Qry)
    Label1: TLabel;
    dbtxtItemflag: TDBText;
    AdoQry_MaInvendorCode: TStringField;
    AdoQry_MaInvendorName: TStringField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MainTotalPoQty: TFloatField;
    AdoQry_MainTotalFinishQty: TFloatField;
    AdoQry_MainTotalPoNoFinishQty: TFloatField;
    AdoQry_MainTotalPoTaxACount: TBCDField;
    AdoQry_MainTotalPoNoTaxACount: TBCDField;
    AdoQry_MainFinishRate: TStringField;
    AdoQry_MaInvendorflag: TStringField;
    AdoQry_MainItemflag: TStringField;
    Label2: TLabel;
    dbtxtVendorflag: TDBText;
    Label3: TLabel;
    dbtxtFinishrate: TDBText;
    AdoQry_Mainpoinqty: TFloatField;
    procedure FormDestroy(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
  end;

var
  Frm_Pm_Qry_AnalyzerPo3: TFrm_Pm_Qry_AnalyzerPo3;

implementation
uses Pm_Qry_AnalyzerPo3_C;
{$R *.DFM}

{ TFrm_Pm_Qry_AnalyzerPo3 }

procedure TFrm_Pm_Qry_AnalyzerPo3.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  inherited;
//freefields:='Totalpoqty,TotalponoFinishqty,TotalFinishqty,';
  {SelectFromSQL:='Select Po.VendorCode,'+
    'Vendor.VendorName,'+
    'PoLine.ItemCode,'+
    'Item.ItemName,'+
    'Sum(PoLine.PoQty) As TotalPoQty,'+
    'Sum(PoLine.PoQty-PoLine.PONoFinishQty) As TotalFinishQty,'+
    'Convert(varChAr,Case Sum(PoLine.PoQty) when 0 then 0 '+
    'else '+
    'Sum(PoLine.PoQty-PoLine.PONoFinishQty)*100/Sum(PoLine.PoQty) end )+''%'''+
    'As FinishRate, '+
    'Sum(PoLine.PoNoFinishQty) As TotalPoNoFinishQty,'+
    'Sum(PoLine.PoTaxAmount) As TotalPoTaxACount,'+
    'Sum(PoLine.PoNoTaxAmount) As TotalPoNoTaxACount '+
    'From PoLine Left Outer Join Item On PoLine.ItemCode=Item.ItemCode ,'+
    'Po Left Outer Join Vendor On Po.VendorCode=Vendor.VendorCode '; 
  ConditionUserDefine:='(PoLine.PoNo=Po.PoNo)';
  GroupByFields:='Po.VendorCode,Vendor.VendorName,PoLine.ItemCode,Item.ItemName';}
  Frm_Sys_Condition:=TFrm_Pm_Qry_AnalyzerPo3_C.Create(self);
  Act_Filter.Execute;
end;

procedure TFrm_Pm_Qry_AnalyzerPo3.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Pm_Qry_AnalyzerPo3:=nil;
end;

end.