1. StackOverflow 文件
  2. acumatica 教程
  3. 通過程式碼填充報告和資料
  4. 本文介紹瞭如何使用記憶體記錄建立報表的示例

本文介紹瞭如何使用記憶體記錄建立報表的示例

Created: November-22, 2018

此示例顯示如何使用資料檢視委託返回的資料填充報表。在練習期間，我們將開發一個查詢螢幕，顯示兩個日期之間的銷售訂單列表。資料檢視委託將用於填充銷售訂單資訊。

先決條件：

  1. 我們從 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; }
}

  2. 繼續宣告 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
}

  3. 在 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");
    }
}

  4. 選擇 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>
  1. 將建立的螢幕新增到站點地圖

使用資料檢視委託返回的資料填充報表：

  1. 將 SO610501.rpx 報告檔案貼上到 Acumatica 網站的 ReportsCustomized 資料夾中，然後在“站點地圖隱藏” 資料夾中新增銷售訂單報告

StackOverflow 文件

  1. 在 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 文件