CamstarVP下拉选，筛选失效

// Copyright Siemens 2019  
using Camstar.WCF.ObjectStack;
using Camstar.WebPortal.FormsFramework;
using Camstar.WebPortal.FormsFramework.Utilities;
using Camstar.WebPortal.WCFUtilities;
using System;


namespace Camstar.WebPortal.WebPortlets
{
    public class MfgOrderMaint : MatrixWebPart
    {
        protected virtual Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject rdoSpec
        {
            get { return Page.FindCamstarControl("rdoSpec") as Camstar.WebPortal.FormsFramework.WebControls.RevisionedObject; }
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            LoadPickList();
        }

        public void LoadPickList() {
            string _FilterText = rdoSpec.PickListPanelControl.FilterControl.FilterText;
            string sqltext = @" select sb.SpecName Name,s.SpecRevision Revision,s.IsFrozen,s.SpecId InstanceID,s.Description from spec s,specbase sb
where s.SpecBaseId = sb.SpecBaseId ";
            if (!string.IsNullOrEmpty(_FilterText))
            {
                sqltext += " and sb.SpecName like '%" + _FilterText + "%'";
            }
            RecordSet objResult = AdHocRequestRecordSet(sqltext);
            if (objResult != null)
            {
                rdoSpec.PickListPanelControl.DataProvider = new Camstar.WebPortal.FormsFramework.WebControls.PickLists.StaticValuesDataProvider(objResult);
                CamstarWebControl.SetRenderToClient(rdoSpec);
            }
        }

        public RecordSet AdHocRequestRecordSet(string sqltext, int _RowSetSize = 100)
        {
            FrameworkSession currentSession = FrameworkManagerUtil.GetFrameworkSession();
            QueryUtil QueryService = new QueryUtil(currentSession.CurrentUserProfile);
            RecordSet queryResult = new RecordSet();
            ResultStatus resultStatus = new ResultStatus();
            QueryOptions queryOption = new QueryOptions
            {
                QueryType = WCF.ObjectStack.QueryType.User,
                StartRow = 1,
                RowSetSize = _RowSetSize
            };
            QueryService.ExecuteSQL(sqltext, queryOption, ref queryResult, ref resultStatus);
            if (queryResult != null)
                if (queryResult.Rows != null)
                    return queryResult;
            return null;
        }
    }
}