bas_vendoritem.pas

一个MRPII系统源代码版本

unit Bas_VendorItem;

Interface

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

Type
  TFrm_Bas_VendorItem = Class(TFrm_Base_Outer)
    AdoQry_MaInvendorCode: TStringField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MaInvendorItemCode: TStringField;
    AdoQry_MaInvendorName: TStringField;
    AdoQry_MainItemName: TStringField;
    procedure FormCreate(Sender: TObject);
    procedure Act_NewExecute(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
     procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
     function SetDeleteSql:String;Override;
  end;

var
  Frm_Bas_VendorItem: TFrm_Bas_VendorItem;

implementation
uses Bas_VendorItem_D;
{$R *.DFM}

{ TFrm_Bas_Dept }

function TFrm_Bas_VendorItem.SetDeleteSql: String;
begin
  Result:='delete from VendorItem where VendorCode='''+AdoQry_Main.fieldbyname('VendorCode').asstring+''''+
   'and VendorItemCode='''+AdoQry_Main.fieldbyname('VendorItemCode').asstring+'''';
end;

procedure TFrm_Bas_VendorItem.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  inherited;
   SelectFromSQL:='select VendorItem.*,Vendor.VendorName,Item.ItemName from '+
     'VendorItem join Vendor on VendorItem.VendorCode=Vendor.VendorCode  join'+
     ' Item on Item.ItemCode=VendorItem.ItemCode';
   OrderByFields:='VendorCode,ItemCode';
   Lbl_Order.Caption:='供应商代码,物料代码';
   AdoQry_Main.Connection:=AdOConnection;
   GetData;
   Frm_Sys_Detail:=TFrm_Bas_VendorItem_D.Create(Application);
end;

procedure TFrm_Bas_VendorItem.FormCreate(Sender: TObject);
begin
  inherited;
  TlBtn_New.Action:=act_New;
end;

procedure TFrm_Bas_VendorItem.Act_NewExecute(Sender: TObject);
begin
  inherited;
  //
end;

end.