gl_enter_balancesheet.pas

一个MRPII系统源代码版本

unit Gl_Enter_BalanceSheet;

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_Gl_Enter_BalanceSheet = Class(TFrm_Base_Outer)
    AdoQry_MainProjectCode: TStringField;
    AdoQry_MainISSum: TIntegerField;
    AdoQry_MainAssetProject: TStringField;
    AdoQry_MainFirstProject: TStringField;
    AdoQry_MainLastProject: TStringField;
    AdoQry_MainOwesProssessoryProject: TStringField;
    AdoQry_MainFirstProject1: TStringField;
    AdoQry_MainLastProject1: TStringField;
    AdoQry_MainPLineNo: TIntegerField;
    AdoQry_MainPLineNo1: TIntegerField;
    procedure FormDestroy(Sender: TObject);
    procedure Act_DeleteExecute(Sender: TObject);
    procedure Act_PreviewExecute(Sender: TObject);
    procedure Act_PrintExecute(Sender: TObject);
  private
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function SetDeleteSql:String;Override;
    { Public declarations }
  end;

var
  Frm_Gl_Enter_BalanceSheet: TFrm_Gl_Enter_BalanceSheet;

implementation
uses Gl_Enter_BalanceSheet_D,Gl_Enter_BalanceSheet_P,Sys_Global;
{$R *.DFM}

{ TFrm_Ar_Enter_Gathering }

procedure TFrm_Gl_Enter_BalanceSheet.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  Application.ProcessMessages;
  extendCaption:=False;
  Inherited;
  selectfromsql:='select * from Gl_BalanceSheet';
  AdoQry_Main.Connection:=AdOConnection;
  Orderbyfields:='projectCode';
  getdata;
  Frm_Sys_Detail:=TFrm_Gl_Enter_BalanceSheet_D.Create(Application);
end;

procedure TFrm_Gl_Enter_BalanceSheet.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Gl_Enter_BalanceSheet:=nil;
end;

function TFrm_Gl_Enter_BalanceSheet.SetDeleteSql: String;
begin
  Result:='delete from Gl_BalanceSheet '
         +' where projectCode='+quotedstr(AdoQry_Main.fieldbyname('projectCode').asstring);
end;

procedure TFrm_Gl_Enter_BalanceSheet.Act_DeleteExecute(Sender: TObject);
begin
  if AdoQry_Main.RecordCount=0 then exit;
  if DispInfo(' 真的删除当前记录吗？ ',2)<>'y' then exit;
  try
    dbconnect.beginTrans;
    saveBalanceSheethistory(dbconnect,AdoQry_Main.fieldbyname('projectCode').asstring,userCode,2);
    AdoQry_Tmp.Close;
    AdoQry_Tmp.SQL.Text:=SetDeleteSql;
    AdoQry_Tmp.ExecSQL;
    AdoQry_Main.Delete;
    dbconnect.CommitTrans;
  except
    if dbconnect.InTransaction then dbconnect.RollBackTrans;
    DispInfo(' 无法删除当前记录，可能已经被其他数据表引用！',1);
    Abort;
  end;
end;

procedure TFrm_Gl_Enter_BalanceSheet.Act_PreviewExecute(Sender: TObject);
begin
//  inherited;
  If AdoQry_Main.RecordCount=0 Then
  begin
    DispInfo('没有数据,不能预览!',1);
    Abort;
  end;
  Frm_Gl_Enter_BalanceSheet_P:=TFrm_Gl_Enter_BalanceSheet_P.Create(Application);
  Frm_Gl_Enter_BalanceSheet_P.SetDBConnect(DbConnect);
  Frm_Gl_Enter_BalanceSheet_P.SetSysParam(UserCode,ModuleCode,MenuId,DateTimeToStr(Now));
  Frm_Gl_Enter_BalanceSheet_P.GetHeadData(AdoQry_Main,'Preview');
  Frm_Gl_Enter_BalanceSheet_P:=Nil;

end;

procedure TFrm_Gl_Enter_BalanceSheet.Act_PrintExecute(Sender: TObject);
begin
//  inherited;
  If AdoQry_Main.RecordCount=0 Then
  begin
    DispInfo('没有数据,不能打印!',1);
    Abort;
  end;
  Frm_Gl_Enter_BalanceSheet_P:=TFrm_Gl_Enter_BalanceSheet_P.Create(Application);
  Frm_Gl_Enter_BalanceSheet_P.SetDBConnect(DbConnect);
  Frm_Gl_Enter_BalanceSheet_P.SetSysParam(UserCode,ModuleCode,MenuId,DateTimeToStr(Now));
  Frm_Gl_Enter_BalanceSheet_P.GetHeadData(AdoQry_Main,'Print');
  Frm_Gl_Enter_BalanceSheet_P:=Nil;

end;

end.