
【场景】打开SQL账表时修改关键字默认值,如日期为这个月的第一天
【案例】
(0)增加SQL账表,复制 平台的过滤表单

(1)过滤表单二开表单插件

```csharp
using Kingdee.BOS.Core.Bill.PlugIn;
using Kingdee.BOS.Core.CommonFilter;
using Kingdee.BOS.Core.CommonFilter.PlugIn;
using Kingdee.BOS.Core.DynamicForm;
using Kingdee.BOS.Core.DynamicForm.PlugIn;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel;
using Kingdee.BOS.Core.ReportFilter;
using Kingdee.BOS.JSON;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Util;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace DynamicFormPlugIn.Report
{
[Kingdee.BOS.Util.HotUpdate]
public class ReportFilterPlugIn_DefaultKeyWord : AbstractCommonFilterPlugIn
{
JSONArray SQLKeyWord = null;
public override void OnInitialize(InitializeEventArgs e)
{
/*
* 初始化关键字逻辑
*/
JSONArray keyWordMap = new JSONArray();
JSONObject materialNumberPara = new JSONObject();
materialNumberPara.Add("KeyWord", "#mydate#");
materialNumberPara.Add("Caption", "我的日期");
materialNumberPara.Add("Value", DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd"));
materialNumberPara.Add("IsTitle", false);
keyWordMap.Add(materialNumberPara);
SQLKeyWord = keyWordMap;
}
/*
* 将关键字加载到第一次点击的方案中(也就是默认方案),切换保存的方案不受影响
*/
//public override void AfterBindData(EventArgs e)
//{
// base.AfterBindData(e);
// if (SQLKeyWord == null)
// return;
// ISQLReportFilterModelService modelService = View.Model as ISQLReportFilterModelService;
// if (modelService == null)
// return;
// ((SQLFilterSchemeEntity)modelService.SchemeEntity).SQLFil