bas_enter_itemamountscrap.pas

一个MRPII系统源代码版本

unit Bas_Enter_ItemAmountScrAp;

Interface

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

Type
  TFrm_Bas_Enter_ItemAmountScrAp = Class(TFrm_Base_Outer)
    AdoQry_MainId: TAutoIncField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainAmount_StAr: TFloatField;
    AdoQry_MainAmount_End: TFloatField;
    AdoQry_MainScrAp: TFloatField;
    AdoQry_MainRemArk: TStringField;
    AdoQry_MainItemName: TStringField;
    procedure FormDestroy(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function  SetDeleteSql:String;Override;
  end;

var
  Frm_Bas_Enter_ItemAmountScrAp: TFrm_Bas_Enter_ItemAmountScrAp;

implementation

uses Bas_Enter_ItemAmountScrAp_D,Sys_Global;

{$R *.DFM}

{ TFrm_Bas_Enter_ItemAmountScrAp }

procedure TFrm_Bas_Enter_ItemAmountScrAp.InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);
begin
  inherited;
  SelectFromSQL:='Select Item_AmountScrAp.*,Item.ItemName '+
                 'From Item_AmountScrAp Left outer join Item on Item_AmountScrAp.ItemCode=Item.ItemCode';
  OrderByFields:='ItemCode,Amount_StAr';
  GetData;

  Frm_Sys_Detail:=TFrm_Bas_Enter_ItemAmountScrAp_D.Create(Application);
end;

procedure TFrm_Bas_Enter_ItemAmountScrAp.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Bas_Enter_ItemAmountScrAp:=nil;
end;

function TFrm_Bas_Enter_ItemAmountScrAp.SetDeleteSql: String;
begin
   Result:='Delete Item_AmountScrAp Where [ID]='''+IntToStr(AdoQry_Main.fieldbyname('ID').AsInteger)+'''';
end;

end.