栏位里面有名称和描述怎么搜索

51 阅读1分钟
 public void LoadPickList(NamedObject ndoControl)
        {
            string _FilterText = ndoControl.PickListPanelControl.FilterControl.FilterText;
            string sqltext = @" select employeename Name,'' IsFrozen,employeeid InstanceID,FullName Description from employee ";
            if (!string.IsNullOrEmpty(_FilterText))
            {
                sqltext += " where employeename like '%" + _FilterText + "%' or Description like N'%" + _FilterText + "%' ";
            }
            RecordSet objResult = AdHocQueryHandle.AdHocRequestRecordSet(sqltext);
            if (objResult != null)
            {
                ndoControl.PickListPanelControl.DataProvider = new Camstar.WebPortal.FormsFramework.WebControls.PickLists.StaticValuesDataProvider(objResult);
                CamstarWebControl.SetRenderToClient(ndoControl);
            }
        }