rm_f1book6.pas

来自「胜天进销存源码,国产优秀的进销存」· PAS 代码 · 共 564 行 · 第 1/2 页

{*****************************************}
{                                         }
{          Report Machine v2.4            }
{          F1Book6 Report v1.10           }
{          Arm Tech Group                 }
{          [e-mail]                }
{*****************************************}
unit RM_F1book6;

interface

{$I RM.INC}

{2002-3-1 修正了合并单元的对齐问题}
{2002-3-5 修正了显示问题}
{2002-7-22重写了部分代码，修正了单元格的高和宽计算误差问题}
{2002-7-22修正了负数的位置问题}
{2002-7-23修正了显示数字的小数点问题}
{2002-7-31增加了随f1book61.viewscale变化大小的功能}

{todo 2002-8-15 FitPageWidth FitPageHeight 功能}

uses
  SysUtils, Windows, Dialogs, Classes, Graphics, Controls, TTF160_TLB, RM_DataSet, RM_Class,
  RM_FormReport;

const
  Ver = 1.09;
type
  TRMPrintF1Book = class(TComponent)
  end;
  { TRMPrintF1book6 }
  TRMPrintF1book6 = class(TRMFormReportObject)
  private
    FFormReport: TRMFormReport;
    FGrid: TF1Book6;
    FUserDataset: TRMUserDataset;
    FList: TStringList;
    FCurrentRow: Integer;
    procedure OnUserDatasetCheckEOF(Sender: TObject; var Eof: Boolean);
    procedure OnUserDatasetFirst(Sender: TObject);
    procedure OnUserDatasetNext(Sender: TObject);
    procedure OnUserDatasetPrior(Sender: TObject);
    procedure OnReportBeginBand(Band: TRMBand);
    procedure SetMemos;
  public
    constructor Create; override;
    destructor Destroy; override;
    procedure OnGenerate_Object(aFormReport: TRMFormReport; Page: TRMReportPage;
      Control: TControl; var t: TRMView); override;
  end;
function IsNumber(S: string): boolean;
function RMConvertToPixels1(Avalue: extended): extended;
procedure Register;
implementation


uses RM_Utils;


type
  THackBook = class(TF1book6)
  end;

  THackFormReport = class(TRMFormReport)
  end;
{ TRMPrintF1book6 }

constructor TRMPrintF1book6.Create;
begin
  inherited Create;
  AutoFree := False;
end;

destructor TRMPrintF1book6.Destroy;
begin
  if FUserDataset <> nil then
  begin
    FUserDataset.Free;
    FUserDataset := nil;
  end;
  if FList <> nil then
  begin
    FList.Free;
    FList := nil;
  end;
  inherited Destroy;
end;

procedure TRMPrintF1book6.OnGenerate_Object(aFormReport: TRMFormReport;
  Page: TRMReportPage; Control: TControl; var t: TRMView);
var
  liView: TRMMemoView;
  i, j, liPageNo, Leftx, NextLeft, NextTop: Integer;
  liNum: Integer;
  liGrid: THackBook;
  s: string;
  liPage: TRMReportPage;
  liGridTitleHeight: Integer;
  procedure MakeOneHeader(aRow, aIndex: Integer);
    procedure FormatOneHeader(RowNo, ColNo: integer);
    var
      j: integer;
      liHeight, temp, pRow1, pCol1, pRow2, pCol2: integer;
      Cellformat: F1CellFormat;
    begin
      liHeight := Round(RMConvertToPixels1(FGrid.RowHeight[RowNo] / 1440 * FGrid.ViewScale / 100)) + 4;

      if (ColNo div 26) = 0 then
        FGrid.Selection := Chr(64 + ColNo) + inttostr(RowNo)
      else
        FGrid.Selection := Chr(64 + (ColNo div 26)) + Chr(64 + (ColNo mod 26)) + inttostr(FCurrentRow);
      begin
        FGrid.GetSelection(0, pRow1, pCol1, pRow2, pCol2);
        if (pRow1 < pRow2) and (pRow1 = RowNo) then
        begin
          Temp := 0;
          for J := pRow1 to pRow2 do
            Temp := Temp + Round(RMConvertToPixels1(FGrid.RowHeight[J] / 1440 * FGrid.ViewScale / 100)) + 4;
          liView.spHeight := temp;
        end
        else
          liView.spHeight := liHeight;
        if (pCol1 < pCol2) and (pCol1 = ColNo) then
        begin
          Temp := 0;
          for J := pCol1 to pCol2 do
            Temp := Temp + Round(RMConvertToPixels1(FGrid.ColWidthtwips[J] / 1440 * FGrid.ViewScale / 100)) + 1;
          liView.spWidth := Temp;
        end
        else
          liView.spWidth := Round(RMConvertToPixels1(FGrid.ColWidthtwips[ColNo] / 1440 * FGrid.ViewScale / 100)) + 1;
      end;
        //对齐方式
      FGrid.SetActiveCell(RowNo, ColNo);
      s := FGrid.TextRC[RowNo, ColNo];
      Cellformat := FGrid.GetCellFormat;
        //水平排列
      if CellFormat.AlignHorizontal = F1HAlignCenter then
        LiView.HAlign := rmhCenter;
      if CellFormat.AlignHorizontal = F1HalignRight then
        LiView.HAlign := rmhRight;
      if CellFormat.AlignHorizontal = F1HAlignLeft then
        LiView.HAlign := rmhLeft;
        {//垂直排列}
      if CellFormat.AlignVertical = F1VAlignTop then
        LiView.VAlign := rmvTop;
      if CellFormat.AlignVertical = F1VAlignCenter then
        LiView.VAlign := rmvCenter;
      if CellFormat.AlignVertical = F1VAlignBottom then
        LiView.VAlign := rmvBottom;
        //
      if CellFormat.AlignHorizontal = F1HAlignGeneral then
        if IsNumber(s) then
          LiView.HAlign := rmhRight
        else
          LiView.HAlign := rmhLeft;
       //字体
      LiView.Font.Name := CellFormat.FontName;
      LiView.Font.Size := CellFormat.FontSize;
      LiView.Font.Color := CellFormat.FontColor;
      Liview.Font.Style := [];
      if CellFormat.FontBold then
        Liview.Font.Style := LiView.Font.style + [fsBold];
      if CellFormat.FontItalic then
        Liview.Font.Style := LiView.Font.style + [fsItalic];
      if CellFormat.FontUnderline then
        Liview.Font.Style := LiView.Font.style + [fsUnderline];
      if CellFormat.FontStrikeout then
        Liview.Font.Style := LiView.Font.style + [fsStrikeOut];

     //画表格线
      FGrid.GetSelection(0, pRow1, pCol1, pRow2, pCol2);
      liView.LeftFrame.Visible := False;
      liView.TopFrame.Visible := False;
      liView.RightFrame.Visible := False;
      liView.BottomFrame.Visible := False;
      if RowNo = PRow1 then
        if cellformat.BorderStyle[F1TopBorder] > 0 then
          liView.TopFrame.Visible := True;
      if ColNo = PCol1 then
        if cellformat.BorderStyle[F1LeftBorder] > 0 then
          liView.LeftFrame.Visible := True;
      if RowNo = PRow2 then
        if cellformat.BorderStyle[F1BottomBorder] > 0 then
          liView.BottomFrame.Visible := True;
      if ColNo = PCol2 then
        if cellformat.BorderStyle[F1RightBorder] > 0 then
          liView.RightFrame.Visible := True;
    end;

  begin
    liView := TRMMemoView(RMCreateObject(gtMemo, ''));
    liView.ParentPage := liPage;
    TRMMemoView(liView).Stretched := rmgoStretch in aFormReport.ReportOptions;
    liView.WordWrap := rmgoWordWrap in aFormReport.ReportOptions;
    liView.spLeft := NextLeft;
    liView.spTop := NextTop;
    FormatOneHeader(aRow, aIndex);
    liView.Memo.Text := liGrid.TextRC[aRow, aIndex];
    aFormReport.ColumnHeaderViews.Add(liView);
    NextLeft := NextLeft + Round(RMConvertToPixels1(liGrid.ColWidthTwips[aIndex] / 1440 * FGrid.ViewScale / 100)) + 1;
  end;


  procedure MakeOneDetail(aIndex: Integer);
  var
    i: integer;
  begin
    if NextLeft = 0 then
    begin
      for i := 1 to aFormReport.GridFixedCols do
      begin
        liView := TRMMemoView(RMCreateObject(gtMemo, ''));
        liView.ParentPage := liPage;
        TRMMemoView(liView).Stretched := rmgoStretch in aFormReport.ReportOptions;
        liView.WordWrap := rmgoWordWrap in aFormReport.ReportOptions;
        liView.spLeft := NextLeft;
        liView.spWidth := Round(RMConvertToPixels1(liGrid.ColWidthTwips[i] / 1440 * FGrid.ViewScale / 100)) + 1;
        liView.spTop := 0;
        liView.spHeight := 20;
        liView.Font.Assign(liGrid.Font);
        aFormReport.PageDetailViews.Add(liView);
        FList.Add(liView.Name + '$' + IntToStr(I));
        NextLeft := NextLeft + liView.spWidth;
      end;
    end;
    if aIndex <= aFormReport.GridFixedCols then //
      exit;
    liView := TRMMemoView(RMCreateObject(gtMemo, ''));
    liView.ParentPage := liPage;
    TRMMemoView(liView).Stretched := rmgoStretch in aFormReport.ReportOptions;
    liView.WordWrap := rmgoWordWrap in aFormReport.ReportOptions;
    liView.spLeft := NextLeft;
    liView.spWidth := Round(RMConvertToPixels1(liGrid.ColWidthTwips[aIndex] / 1440 * FGrid.ViewScale / 100)) + 1;
    liView.spTop := 0;
    liView.spHeight := 20;
    aFormReport.PageDetailViews.Add(liView);
    FList.Add(liView.Name);
    NextLeft := NextLeft + liView.spWidth;
  end;
  procedure DrawFixedHeader(aRow: Integer);
  var
    j: Integer;
  begin
    for j := 1 to aFormReport.GridFixedCols do
    begin
      if j < liGrid.LastCol then
        MakeOneHeader(aRow, j);
    end;
  end;
begin
  if aFormReport.DrawOnPageFooter then exit;
  liGrid := THackBook(Control);
  FGrid := THackBook(Control);
  FFormReport := aFormReport;
  aFormReport.DrawOnPageFooter := TRUE;
  aFormReport.GridTop := THackFormReport(aFormReport).OffsY + Control.Top;
  aFormReport.GridHeight := Control.Height;
  liGridTitleHeight := 0;
  NextTop := Control.Top + THackFormReport(aFormReport).OffsY;

  if FUserDataset = nil then
    FUserDataset := TRMUserDataset.Create(nil);
  if FList = nil then
    FList := TStringList.Create;

  THackFormReport(aFormReport).CanSetDataSet := False;
  FList.Clear;
  FUserDataset.OnCheckEOF := OnUserDatasetCheckEOF;
  FUserDataset.OnFirst := OnUserDatasetFirst;
  FUserDataset.OnNext := OnUserDatasetNext;
  FUserDataset.OnPrior := OnUserDatasetPrior;
  aFormReport.Report.DataSet := FUserDataset;
  aFormReport.Report.OnBeginBand := OnReportBeginBand;


  Leftx := 0;
  for i := 1 to liGrid.LastCol do
    Leftx := Leftx + Round(RMConvertToPixels1(liGrid.ColWidthTwips[i] / 1440 * FGrid.ViewScale / 100)) + 1;

  if (aFormReport.PrintControl = Control) or (Leftx > StrToInt(THackFormReport(aFormReport).FormWidth[0])) then