pm_pclinehistory.pas

一个MRPII系统源代码版本

unit Pm_PcLineHistory;

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_PcLineHistory = Class(TFrm_Base_Qry)
    DBText1: TDBText;
    Label1: TLabel;
    AdoQry_MainPcNo: TStringField;
    AdoQry_MainItemCodeName: TStringField;
    AdoQry_MainUomName: TStringField;
    AdoQry_MainPcTaxPrice: TFloatField;
    AdoQry_MainPcNoTaxPrice: TFloatField;
    AdoQry_MainPcStArtDate: TDateTimeField;
    AdoQry_MainPcendDate: TDateTimeField;
    AdoQry_MainPcStArtQty: TFloatField;
    AdoQry_MainPcendQty: TFloatField;
    AdoQry_MainPcPriceType: TIntegerField;
    AdoQry_MainPCReferencedPrice: TIntegerField;
    AdoQry_MainEmployeeCodeName: TStringField;
    AdoQry_MainChgTime: TDateTimeField;
    AdoQry_MainChgType: TStringField;
    AdoQry_MainPclineid: TIntegerField;
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
  end;

var
  Frm_Pm_PcLineHistory: TFrm_Pm_PcLineHistory;

implementation
uses Pm_PcLineHistory_C;
{$R *.DFM}

{ TFrm_Base_Qry1 }

procedure TFrm_Pm_PcLineHistory.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  inherited;
  SelectFromSQL:='Select PcLineHistory.PcNo,PcLineHistory.Pclineid'
    +',PcLineHistory.ItemCode+'' ''+Item.ItemName As ItemCodeName'
    +',Uom.UomName'
    +',PcLineHistory.PcTaxPrice'
    +',PcLineHistory.PcNoTaxPrice'
    +',PcLineHistory.PcStArtDate'
    +',PcLineHistory.PcendDate'
    +',PcLineHistory.PcStArtQty'
    +',PcLineHistory.PcendQty'
    +',PcLineHistory.PcPriceType'
    +',PcLineHistory.PCReferencedPrice'
    +',PcLineHistory.ChgEmployeeCode+'' ''+Employee.EmployeeName As EmployeeCodeName'
    +',PcLineHistory.ChgTime'
    +',PcLineHistory.ChgType'
    +' From PcLineHistory Join Item On PcLineHistory.ItemCode=Item.ItemCode'
    +' Join Employee On PcLineHistory.ChgEmployeeCode=Employee.EmployeeCode'
    +' Left Outer Join Uom On Item.UomCode=Uom.UomCode';
  OrderByFields:='pclineid,pcno,ChgTime';
  Frm_Sys_Condition:=TFrm_Pm_PcLineHistory_C.Create(Self);
  Act_Filter.Execute;
  GetData;
end;

end.