FastReport.NET制作动态栏位列报表C#实例

C# Code:

/// <summary>
/// C#.NET FastReport动态列(动态创建组件)报表类库
/// </summary>
public class MyDynamicReport
{
   private FastReport.Report _Report;
   
   //左侧固定组件
   private IList<TextObjectBase> _LeftFixedColumns = new List<TextObjectBase>();//列头
   private IList<TextObjectBase> _LeftFixedColumnsDataBind = new List<TextObjectBase>();//数据绑定
   
   public IList<TextObjectBase> LeftFixedColumns { get { return _LeftFixedColumns; } }
   public IList<TextObjectBase> LeftFixedColumnsDataBind { get { return _LeftFixedColumnsDataBind; } }
   
   //右侧固定组件
   private IList<TextObjectBase> _RightFixedColumns = new List<TextObjectBase>();//列头
   private IList<TextObjectBase> _RightFixedColumnsDataBind = new List<TextObjectBase>();//数据绑定
   
   public IList<TextObjectBase> RightFixedColumns { get { return _RightFixedColumns; } }
   public IList<TextObjectBase> RightFixedColumnsDataBind { get { return _RightFixedColumnsDataBind; } }
   
   
   private IList<ColumnItem> _DynamicColumns = new List<ColumnItem>();
   
   //private const int MAX_COLUMNS_NORMAL = 5;//纵向A4纸最多支持的动态列数量
   //private const int MAX_COLUMNS_LANDSCAPE = 9;//横向A4纸最多支持的动态列数量
   private const int MIN_WIDTH = 80;//组件最小宽度
   private const string NUM_FORMAT = "0.0000";
   
   public MyDynamicReport(FastReport.Report report)
   {
      _Report = report;
   }
   
   /// <summary>
   /// 创建动态组件
   /// </summary>
   /// <param name="column">列实体类</param>
   /// <param name="isDataBinding">True:数据区的动态对象</param>
   /// <returns></returns>
   private TextObject CreateTextObject(ColumnItem column, bool isDataBinding = false)
   {
      TextObject o = new TextObject();
      
      if (isDataBinding)
      {
         o.Text = column.FieldName;
         o.Name = "D_Field_" + column.ColumnID;
      }
      else
      {
         o.Text = column.ColumnName;
         o.Name = "D_Column_" + column.ColumnID;
      }
      
      o.Font = new Font("宋体", 9);
      o.Visible = true;
      o.Printable = true;
      o.CanGrow = true;
      o.GrowToBottom = true;
      o.HideZeros = true;
      o.Border.Lines = BorderLines.All;
      o.VertAlign = VertAlign.Center;
      o.HorzAlign = HorzAlign.Center;
      o.Format = new FastReport.Format.CustomFormat() { Format = NUM_FORMAT };
      
      return o;
   }
   
   
   /// <summary>
   /// 批量创建动态组件列
   /// </summary>
   /// <param name="startPoint">创建第一个动态组件列的起始位置</param>
   /// <param name="container">所在容器</param>
   /// <param name="height">动态列高度</param>
   /// <param name="isDataBinding">容器是否数据绑定区(DataBand)</param>
   public List<TextObject> BuildDynamicColumns(MyPoint startPoint, BandBase container, float height, bool isDataBinding = false)
   {
      List<TextObject> list = new List<TextObject>();
      
      float MaxWidth = CalcDynamicAreaMaxWidth();
      float tmp = MaxWidth / _DynamicColumns.Count;
      float width = (float)Math.Round(tmp, 2);
      
      TextObject text;
      
      float dynamicWidth = 0;
      float left = startPoint.X;
      foreach (ColumnItem c in _DynamicColumns)
      {
         text = CreateTextObject(c, isDataBinding);
         
         text.Width = width;
         text.Height = height;
         
         text.Left = left;
         text.Top = startPoint.Y;
         
         container.Objects.Add(text);
         list.Add(text);
         
         left += text.Width;
         dynamicWidth += text.Width;
      }
      
      return list;
   }
   
   internal void AlignRightColumns(IList<TextObjectBase> rightControls, List<TextObject> refDynamic)
   {
      //最后一个动态生成的组件
      TextObjectBase last = refDynamic[refDynamic.Count - 1];
      foreach (TextObjectBase o in rightControls)
      {
         o.Left = last.Left + last.Width;
         o.Top = last.Top;
         last = o;
      }
   }
   
   public void CalcWidth(List<TextObject> list)
   {
      float w;
      foreach (TextObject o in list)
      {
         w = o.CalcWidth();
         o.Width = w;
      }
   }
   
   /// <summary>
   /// 计算动态列组件区域的宽度。页面宽度-固定列的宽度
   /// </summary>
   /// <returns></returns>
   private float CalcDynamicAreaMaxWidth()
   {
      float left = 0; float right = 0;
      foreach (TextObjectBase o in _LeftFixedColumns) left += o.Width;
      foreach (TextObjectBase o in _RightFixedColumns) right += o.Width;
      
      DataBand databander = _Report.FindObject("Data1") as DataBand;
      float px1 = databander.Width;//获取一个组件的完整宽度
      return (px1 - left - right) - 5f;
   }
   
   /// <summary>
   /// 是否横向打印
   /// </summary>
   /// <returns></returns>
   public bool IsLandscape()
   {
      float left = 0; float right = 0;
      foreach (TextObjectBase o in _LeftFixedColumns) left += o.Width;
      foreach (TextObjectBase o in _RightFixedColumns) right += o.Width;
      
      int dynamicColumns = _DynamicColumns.Count;
      
      FastReport.ReportPage page = (ReportPage)_Report.Pages[0];
      
      //必须以A4纸宽度作为判断基准
      double px = MillimetersToPixelsWidth(210);//获取默认A4纸张宽度，毫米转换为对应像素宽度
      
      //计算边距
      float margin = (float)MillimetersToPixelsWidth(page.LeftMargin + page.RightMargin);
      
      //判断标准：【页边距+固定列宽度+动态列最小宽度】是否大于A4纸宽度
      bool result = margin + left + right + dynamicColumns * MIN_WIDTH > px;
      return result;
   }
   
   /// <summary>
   /// 调整页面纵向或横向打印
   /// </summary>
   /// <param name="p"></param>
   public void AdjustPageLandscape(ReportPage p)
   {
      if (this.IsLandscape())
      {
         p.Landscape = true;
         p.Width = 297;
         p.Height = 210;
      }
      else
      {
         p.Landscape = false;
         p.Width = 210;
         p.Height = 297;
      }
   }
   
   public void SetDynamicColumns(IEnumerable<ColumnItem> list)
   {
      foreach (ColumnItem o in list) _DynamicColumns.Add(o);
   }
   
   /// <summary>
   /// 毫米宽度转像素宽度
   /// </summary>
   /// <param name="mmUnit"></param>
   /// <returns></returns>
   private static double MillimetersToPixelsWidth(double mmUnit) //length是毫米，1厘米=10毫米
   {
      System.Windows.Forms.Panel p = new System.Windows.Forms.Panel();
      System.Drawing.Graphics g = System.Drawing.Graphics.FromHwnd(p.Handle);
      IntPtr hdc = g.GetHdc();
      int width = GetDeviceCaps(hdc, 4); // HORZRES
      int pixels = GetDeviceCaps(hdc, 8); // BITSPIXEL
      g.ReleaseHdc(hdc);
      return (((double)pixels / (double)width) * (double)mmUnit);
   }
   
   [DllImport("gdi32.dll")]
   private static extern int GetDeviceCaps(IntPtr hdc, int Index);
   
}


//来源:C/S框架网(www.csframework.com) QQ:23404761