分享过滤条件中增加一个自定义过滤变量插件代码

// 以下代码示例演示过滤条件中增加一个自定义过滤变量，例如预算部门// 另外还需要在t_mdl_filtercondition,t_mdl_filtercondition_l中增加相应记录，例如/*--插入配置过滤条件<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />DELETE FROM T_MDL_FILTERCONDITION WHERE FID=1000001;INSERT INTO T_MDL_FILTERCONDITION(FID,FCONDITIONTYPEID,FSEQ,FOPERATE,FINPUTCTLTYPE,FDATASOURCETYPE,FDATAFIELDINDEX,FVALUE,FINPUT,FCLASSNAME) VALUES (1000001, 1000001,1,'=',0,0,0,'ISNULL',0,'XXApp.Core.BuggetDeptFilter.CurrBuggetDeptFilter,XXApp.Core') ;--插入配置过滤条件多语言DELETE FROM T_MDL_FILTERCONDITION_L WHERE FID=1000001;INSERT INTO T_MDL_FILTERCONDITION_L(FPKID,FID,FLOCALEID,FNAME,FDATASOURCE,FTOOLTIP) VALUES (1000001,1000001,2052,N'当前预算部门',null,null) ;*/using System;using System.Collections.Generic;using System.Linq;using System.Text;using Kingdee.BOS.Core.CommonFilter.ConditionVariableAnalysis;using Kingdee.BOS.Core.CommonFilter;using System.ComponentModel;using Kingdee.BOS.App.Data;namespace XXApp.Core.BuggetDeptFilter{/// <summary>/// 当前用户根据预算部门进行过滤/// </summary>[Description("当前用户根据预算部门进行过滤")]public class CurrBuggetDeptFilter : AbstractVariableAnalysisPlugin {public override string GetVariableFilter(ConditionVariableContext ctx){StringBuilder sb = new StringBuilder();// 获取当前登录用户所在的部门sb.AppendFormat("select staff.FDEPTID ");sb.AppendFormat(" from t_bd_staff staff ");sb.AppendFormat(" inner join t_sec_user suser on staff.fpersonid=suser.FLINKOBJECT ");sb.AppendFormat(" inner join V_BD_CONTACTOBJECT vcon on vcon.fid=suser.FLINKOBJECT and vcon.ftype=1 ");sb.AppendFormat(" where suser.fuserid={0} ", ctx.Context.UserId);// 获取部门对应的预算部门内码string strSelect = string.Format(@"select fdeptidfrom t_bd_department where fdeptid IN ({0}) and FISBUDGET=1union allselect FBudgetDeptfrom t_bd_department where fdeptid IN ({0}) and FISBUDGET=0", sb.ToString());long currDeptId = DBUtils.ExecuteScalar<long>(ctx.Context, strSelect, 0, null);// 当前用户没有关联职员if (currDeptId <= 0){return "1=1";}// 取出当前预算部门的名称string strSql = string.Format(@"SELECT FNAME FROM T_BD_DEPARTMENT_L WHERE FDEPTID={0} AND FLOCALEID={1}", currDeptId, ctx.Context.UserLocale.LCID);string strName = DBUtils.ExecuteScalar<string>(ctx.Context, strSql, string.Empty, null);return string.Format("{0} {1} '{2}'", ctx.FieldName , ctx.Operater, strName);}}}