【场景】插件调用excel打印
【案例】调用采购订单的excel打印，指定模板的预览
<1>数据库获取excel模板的内码
```sql
select * from t_bos_excelprint
--fbillformid,业务对象标识
```
<2>表单插件案例
```csharp
using Kingdee.BOS.Core;
using Kingdee.BOS.Core.Bill.PlugIn;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.JSON;
using Kingdee.BOS.ServiceHelper.ExcelPrint;
using System;
using System.Collections.Generic;
namespace DynamicFormPlugIn.NotePrint
{
[Kingdee.BOS.Util.HotUpdate]
public class TestExcelPrintPlugIn : AbstractBillPlugIn
{
public override void BarItemClick(BarItemClickEventArgs e)
{
base.BarItemClick(e);
if (!string.Equals(e.BarItemKey, "tb_Text_ExcelPrint", StringComparison.OrdinalIgnoreCase))
return;
object pkVal = this.View.Model.GetPKValue();
if (pkVal == null)
return;
//模板单据内码集合
Dictionary<string, List<string>> tempBillDict = new Dictionary<string, List<string>>();
tempBillDict["3680011a-f62a-4d2a-a23d-b368bd080116"] = new List<string>() { pkVal.ToString() };
JSONObject jsonObject = new JSONObject();
jsonObject.Add("Data",tempBillDict);
jsonObject.Add("JSONObject", null);//自定义参数
LoginExcelPrintParam loginParam = new LoginExcelPrintParam();
loginParam.ActionType = Kingdee.BOS.Core.NotePrint.ExcelPrintAction.Preview;
loginParam.FormId = this.View.BillBusinessInfo.GetForm().Id;
loginParam.PageId = this.View.PageId;
loginParam.ActionNumber = this.GetType().Name;
loginParam.PrintParam = jsonObject;
ExcelPrintServiceHelper.SendExcelPrintAction(View, loginParam);
}
}
}
```
【效果】自动弹出预览窗
