本文介绍了如何使用内存记录创建报表的示例

Created: November-22, 2018

此示例显示如何使用数据视图委托返回的数据填充报表。在练习期间，我们将开发一个查询屏幕，显示两个日期之间的销售订单列表。数据视图委托将用于填充销售订单信息。

先决条件：

我们从 SOOrderFilter DAC 的声明开始：

[Serializable]
public class SOOrderFilter : IBqlTable
{
    public abstract class dateFrom : IBqlField
    {
    }
    [PXDate()]
    [PXUIField(DisplayName = "Date From")]
    public DateTime? DateFrom { get; set; }

    public abstract class dateTo : IBqlField
    {
    }
    [PXDate()]
    [PXUIField(DisplayName = "Date To")]
    public DateTime? DateTo { get; set; }
}

继续声明 SOOrderData DAC：

[Serializable]
public class SOOrderData : IBqlTable
{
    #region OrderType
    public abstract class orderType : PX.Data.IBqlField
    {
    }
    [PXString(2, IsKey = true, IsFixed = true)]
    [PXUIField(DisplayName = "Type")]
    public virtual string OrderType { get; set; }
    #endregion
    #region OrderNbr
    public abstract class orderNbr : PX.Data.IBqlField
    {
    }
    [PXString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC")]
    [PXUIField(DisplayName = "Order Nbr.")]
    public virtual string OrderNbr { get; set; }
    #endregion
    #region OrderDate
    public abstract class orderDate : PX.Data.IBqlField
    {
    }
    [PXDate]
    [PXUIField(DisplayName = "Date")]
    public virtual DateTime? OrderDate { get; set; }
    #endregion
    #region Status
    public abstract class status : PX.Data.IBqlField
    {
    }
    [PXString(1, IsFixed = true)]
    [PXUIField(DisplayName = "Status")]
    [SOOrderStatus.List()]
    public virtual string Status { get; set; }
    #endregion
    #region OrderDesc
    public abstract class orderDesc : PX.Data.IBqlField
    {
    }
    [PXString(60, IsUnicode = true)]
    [PXUIField(DisplayName = "Description", Visibility = PXUIVisibility.SelectorVisible)]
    public virtual string OrderDesc { get; set; }
    #endregion
    #region OrderTotal
    public abstract class orderTotal : PX.Data.IBqlField
    {
    }
    [PXDecimal(4)]
    [PXDefault(TypeCode.Decimal, "0.0")]
    public virtual decimal? OrderTotal { get; set; }
    #endregion
    #region DueDate
    public abstract class dueDate : PX.Data.IBqlField
    {
    }
    [PXDate]
    [PXUIField(DisplayName = "Due Date")]
    public virtual DateTime? DueDate { get; set; }
    #endregion
}

在 PX.Documentation 命名空间中，使用下面的代码片段来创建 SOOrderInq BLC 以声明结果数据视图委托，稍后将使用该委托填充报告中的数据：

public class SOOrderInq : PXGraph<SOOrderInq>
{
    public PXCancel<SOOrderFilter> Cancel;
    public PXFilter<SOOrderFilter> Filter;

    [PXFilterable]
    public PXSelectOrderBy<SOOrderData,
        OrderBy<Desc<SOOrderData.orderNbr>>> Result;
    protected virtual IEnumerable result()
    {
        BqlCommand cmd = PXSelect<SOOrder, 
            Where<SOOrder.orderDate,
                Between<Current<SOOrderFilter.dateFrom>,
                    Current<SOOrderFilter.dateTo>>>>.GetCommand();
        PXView inView = new PXView(this, true, cmd);
        int startRow = PXView.StartRow;
        int totalRows = 0;
        foreach (SOOrder order in inView.Select(PXView.Currents, PXView.Parameters,
            PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters,
            ref startRow, PXView.MaximumRows, ref totalRows))
        {
            yield return new SOOrderData
            {
                OrderType = order.OrderType,
                OrderNbr = order.OrderNbr,
                OrderDate = order.OrderDate,
                Status = order.Status,
                OrderDesc = order.OrderDesc,
                OrderTotal = order.OrderTotal,
                DueDate = order.DueDate,
            };
        }
        PXView.StartRow = 0;
    }

    public SOOrderInq()
    {
        Result.Cache.AllowInsert = false;
        Result.Cache.AllowUpdate = false;
        Result.Cache.AllowDelete = false;
    }

    public PXAction<SOOrderFilter> Report;
    [PXButton]
    [PXUIField(DisplayName = "View As Report", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]
    protected virtual void report()
    {
        PXReportResultset reportData = new PXReportResultset(typeof(SOOrderData));
        foreach (SOOrderData row in Result.Select())
        {
            reportData.Add(row);
        }
        throw new PXReportRequiredException(reportData, "SO610501", PXBaseRedirectException.WindowMode.NewWindow, "Report");
    }
}

选择 FormDetail 模板创建 SO401090.aspx 页面，并为 PXDataSource 设置以下属性：

PrimaryView：过滤器

TypeName：PX.Documentation.SOOrderInq

之后在 Filter 头表单上添加输入控件：

 <px:PXFormView ID="form" runat="server" DataSourceID="ds" Style="z-index: 100" 
     Width="100%" DataMember="Filter">
     <Template>
         <px:PXLayoutRule runat="server" StartRow="True" Merge="True" LabelsWidth="XS" ControlSize="S" />
         <px:PXDateTimeEdit ID="edDateFrom" runat="server" CommitChanges="True" DataField="DateFrom" />
         <px:PXDateTimeEdit ID="edDateTo" runat="server" CommitChanges="True" DataField="DateTo" />
         <px:PXLayoutRule runat="server" />
     </Template>
 </px:PXFormView>

并为 Detail 网格创建以下列：

 <px:PXGrid ID="grid" runat="server" DataSourceID="ds" Style="z-index: 100" 
     Width="100%" Height="150px" SkinID="Inquire" AllowPaging="True" AdjustPageSize="Auto">
     <Levels>
         <px:PXGridLevel DataMember="Result">
             <Columns>
                 <px:PXGridColumn DataField="OrderType" />
                 <px:PXGridColumn DataField="OrderNbr" Width="90px" />
                 <px:PXGridColumn DataField="OrderDate" Width="90px" />
                 <px:PXGridColumn DataField="Status" />
                 <px:PXGridColumn DataField="OrderDesc" Width="200px" />
                 <px:PXGridColumn DataField="DueDate" Width="90px" />
             </Columns>
         </px:PXGridLevel>
     </Levels>
     <AutoSize Container="Window" Enabled="True" MinHeight="150" />
 </px:PXGrid>

将创建的屏幕添加到站点地图

使用数据视图委托返回的数据填充报表：

将 SO610501.rpx 报告文件粘贴到 Acumatica 网站的 ReportsCustomized 文件夹中，然后在“站点地图隐藏” 文件夹中添加销售订单报告

StackOverflow 文档

在 SOOrderInq BLC 中声明“ 查看为报告” 操作，以生成并显示销售订单报告。PXReportRequiredException 接受在操作内部准备的 PXReportResultset，以使用 Result 数据视图委托返回的数据填充报告：

public class SOOrderInq : PXGraph<SOOrderInq>
{
    ...

    public PXAction<SOOrderFilter> Report;
    [PXButton]
    [PXUIField(DisplayName = "View as Report", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]
    protected virtual void report()
    {
        PXReportResultset reportData = new PXReportResultset(typeof(SOOrderData));
        foreach (SOOrderData row in Result.Select())
        {
            reportData.Add(row);
        }
        throw new PXReportRequiredException(reportData, "SO610501", PXBaseRedirectException.WindowMode.NewWindow, "Report");
    }
}

StackOverflow 文档