【场景】由于动态表单是由插件实现的绑定界面数据，并非按照字段的数据库映射逻辑取数，因此动态表单套打的逻辑也需要插件进行绑定处理
【案例】
自定义一个动态表单，根据单据头字段过滤，实现自定义查询逻辑在单据体中，并进行套打打印
a)设计动态表单，增加单据头字段，过滤，单据体字段，以及打印关联查询操作
b)代码案例
GetData——获取表体的数据逻辑
OnPrepareNotePrintData——套打显示逻辑，将表体的数据填入套打模板
```csharp
using Kingdee.BOS;
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Core.DynamicForm.PlugIn;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.Orm.DataEntity;
using System;
using System.Collections.Generic;
using System.Data;
namespace DynamicFormPlugIn.NotePrint
{
[Kingdee.BOS.Util.HotUpdate]
[System.ComponentModel.Description("动态表单套打逻辑")]
public class DynamicForm_NotePrint : AbstractDynamicFormPlugIn
{
public static string Head_Key = "FBillHead";
public static string Head_Date = "FDate";
public static string Entity_Key = "FEntity";
public static string Entity_BillNo = "FBillNo";
public static string Entity_Material = "FMATERIALNAME";
public static string Entity_Qty = "FQty";
private DataTable curShowTable;
public override void ButtonClick(ButtonClickEventArgs e)
{
if(string.Equals(e.Key, "FRefresh", StringComparison.OrdinalIgnoreCase))
{
curShowTable = GetData();
ShowInEntity(curShowTable);
}
}
/// <summary>
/// 实现取自定义逻辑
/// </summary>
/// <returns></returns>
private DataTable GetData()
{
var dateVal = this.View.Model.GetValue(Head_Date);
if (dateVal == null)
throw new Exception("日期为空");
DateTime date = Convert.ToDateTime(dateVal);
string strSelect = @"SELECT BILL.FBILLNO,WLL.FNAME AS FMATERIALNAME,ENTRY.FQTY FROM T_PUR_POORDER BILL
LEFT JOIN T_PUR_POORDERENTRY ENTRY ON BILL.FID = ENTRY.FID
LEFT JOIN T_BD_MATERIAL WL ON ENTRY.FMATERIALID = WL.FMATERIALID
LEFT JOIN T_BD_MATERIAL_L WLL ON WL.FMATERIALID = WLL.FMATERIALID AND WLL.FLOCALEID = 2052
WHERE BILL.FCREATEDATE >= @ST AND BILL.FCREATEDATE < @ET";
List<SqlParam> paramList = new List<SqlParam>();
paramList.Add(new SqlParam("@ST", KDDbType.DateTime, date.Date));
paramList.Add(new SqlParam("@ET", KDDbType.DateTime, date.Date.AddDays(1)));
var dataSet = DBUtils.ExecuteDataSet(this.Context, strSelect, paramList);
if (dataSet == null || dataSet.Tables.Count <= 0)
throw new Exception("查询异常");
return dataSet.Tables[0];
}
/// <summary>
/// 界面显示逻辑
/// </summary>
/// <param name="dt"></param>
private void ShowInEntity(DataTable dt)
{
var entity = this.View.BillBusinessInfo.GetEntity(Entity_Key);
var entityObjs = this.View.Model.GetEntityDataObject(entity);
entityObjs.Clear();
for (int i = 0; i < dt.Rows.Count; ++i)
{
var entityObj = new DynamicObject(entityObjs.DynamicCollectionItemPropertyType);
var dr = dt.Rows[i];
entityObj[Entity_BillNo] = dr[Entity_BillNo];
entityObj[E
