ar_enter_exporttradetype.pas

一个MRPII系统源代码版本

unit Ar_Enter_ExportTradeType;

Interface

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

Type
  TFrm_Ar_Enter_ExportTradeType = Class(TFrm_Base_Outer)
    AdoQry_MainExportTradeTypeCode: TStringField;
    AdoQry_MainExportTradeTypeName: TStringField;
    AdoQry_MainGenerallyInvoiceArKmCode: TStringField;
    AdoQry_MainkmName: TStringField;
    procedure FormDestroy(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations } 
  public
    { Public declarations }
    procedure Initform(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function  SetDeleteSql:String;Override;
  end;

var
  Frm_Ar_Enter_ExportTradeType: TFrm_Ar_Enter_ExportTradeType;

implementation

uses Ar_Enter_ExpoArtTrAdeType_D;

{$R *.DFM}

{ TFrm_Ar_Enter_ExportTradeType }

procedure TFrm_Ar_Enter_ExportTradeType.Initform(
  AdOConnection: TAdOConnection; ReadOnly: Boolean);
begin
  inherited;
  SelectFromSQL:='select a.ExportTradeTypeCode,a.ExportTradeTypeName,a.GenerallyInvoiceArKmCode,b.kmName '+
                 'from Sa_ExportTradeType a left join Gl_AccountSubject b on a.GenerallyInvoiceArKmCode=b.KmCode';
  OrderByFields:='ExportTradeTypeCode';
  GetData;

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

procedure TFrm_Ar_Enter_ExportTradeType.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Ar_Enter_ExportTradeType:=nil;
end;

procedure TFrm_Ar_Enter_ExportTradeType.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  //inherited;
  if Frm_Sys_Condition<>nil then
    Frm_Sys_Condition.Release;
  if Frm_Sys_Detail<>nil then
    Frm_Sys_Detail.Release;
  if Frm_Sys_SortOrder<>nil then
    Frm_Sys_SortOrder.Release;
  if Frm_Sys_QuickLocate<>nil then
    Frm_Sys_QuickLocate.Release;
  if Frm_Sys_SetColumn<>nil then
    Frm_Sys_SetColumn.Release;
  Action:=CaFree;  
end;

function TFrm_Ar_Enter_ExportTradeType.SetDeleteSql: String;
begin
  //SaveHistoryChangeType('删除');
  Result:='Delete From Sa_ExportTradeType'
    +' Where ExportTradeTypeCode='''+AdoQry_Main.fieldbyname('ExportTradeTypeCode').AsString+'''';
end;

end.