mrp_enter_moparent.pas

一个MRPII系统源代码版本

unit Mrp_Enter_MoParent;

Interface

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

Type
  TFrm_Mrp_Enter_MoParent = Class(TFrm_Base_Qry)
    Label1: TLabel;
    DBText1: TDBText;
    AdoQry_MainMoNo: TStringField;
    AdoQry_MainMoLineNo: TIntegerField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MainItemFlag: TStringField;
    AdoQry_MainUomName: TStringField;
    AdoQry_MainMoStArtWorkDate: TDateTimeField;
    AdoQry_MainMoLineDate: TDateTimeField;
    AdoQry_MainMoQty: TFloatField;
    procedure FormDestroy(Sender: TObject);
  private
    ItemCode:String;
    MoLineDate:String;
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    { Public declarations }
  end;
  procedure MoInitForm(AdOConnection:TAdOConnection;ItemCode,MoLineDate:String);
var
  Frm_Mrp_Enter_MoParent: TFrm_Mrp_Enter_MoParent;

implementation

{$R *.DFM}

{ TFrm_Mrp_Enter_MoParent }

procedure MoInitForm(AdOConnection: TAdOConnection;
  ItemCode: String;MoLineDate: String);
begin
  Frm_Mrp_Enter_MoParent:=TFrm_Mrp_Enter_MoParent.Create(Application);
  Frm_Mrp_Enter_MoParent.ItemCode:=ItemCode;
  Frm_Mrp_Enter_MoParent.MoLineDate:=MoLineDate;
  Frm_Mrp_Enter_MoParent.InitForm(AdoConnection,False);
end;

{ TFrm_Mrp_Enter_MoParent }

procedure TFrm_Mrp_Enter_MoParent.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  inherited;
  SelectFromSQL:=' Select MoLine.MoNo,MoLine.MoLineNo,Item.ItemCode,Item.ItemName, '
                +' Item.ItemCode+'''+' '+'''+Item.ItemName As ItemFlag, '
                +' Uom.UomName,MoLine.MoStArtWorkDate,MoLine.MoLineDate,MoLine.MoQty '
                +' From MoLine '
                +' Join Bom on Bom.ItemCode=MoLine.ItemCode '
                +' Join Item On Item.ItemCode=Bom.Ite_ItemCode '
                +' left outer Join Uom On Item.UomCode=Uom.UomCode '
                +' where Bom.ItemCode='''+ItemCode+''''
                +' And MoLine.MoStArtWorkDate='''+MoLineDate+''''
                +' And MoLine.MoLineStatus In (5,6)';
  OrderByFields:='MoNo,MoStArtWorkDate';
  GetData;
end;

procedure TFrm_Mrp_Enter_MoParent.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Mrp_Enter_MoParent:=Nil;
end;

end.