bas_enter_balancetype.pas

一个MRPII系统源代码版本

unit Bas_Enter_BalanceType;

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_Bas_Enter_BalanceType = Class(TFrm_Base_Outer)
    AdoQry_MainBalanceTypeID: TStringField;
    AdoQry_MainBalanceTypeCode: TStringField;
    AdoQry_MainBalanceTypeName: TStringField;
    AdoQry_MainGatheringKMCode: TStringField;
    AdoQry_MainkmName: TStringField;
    AdoQry_MainRemArk: TStringField;
  private
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function  SetDeleteSql:String;Override;
    { Public declarations }
  end;

var
  Frm_Bas_Enter_BalanceType: TFrm_Bas_Enter_BalanceType;


implementation

uses Bas_Enter_BalanceType_D, Sys_Global;

{$R *.DFM}

{ TFrm_Bas_Enter_ShipMode }

procedure TFrm_Bas_Enter_BalanceType.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  inherited;
  SelectFromSql:=' Select Convert(varchAr(10),BalanceTypeID) as BalanceTypeID,'
                +' BalanceTypeCode,BalanceTypeName,GatheringKMCode,'
                +' kmName,RemArk '
                +' From BalanceType '
                +' Left join Gl_AccountSubject On  BalanceType.GatheringKMCode=Gl_AccountSubject.KmCode ';
  OrderByFields:=' BalanceTypeCode';
  GetData;
  Frm_Sys_Detail:=TFrm_Bas_Enter_BalanceType_D.Create(Application);
end;

function TFrm_Bas_Enter_BalanceType.SetDeleteSql: String;
begin
  If AdoQry_Main.fieldbyname('BalanceTypeID').AsInteger=0 then
  begin
    DispInfo('请刷新后再进行删除操作!',3);
    Abort;
  end;
  Result:=' Delete BalanceType Where  BalanceTypeID='''+IntToStr(AdoQry_Main.fieldbyname('BalanceTypeID').AsInteger)+'''';
end;

end.