예제 #1
0
        public LookupFieldResult LookupField(LookupFieldQuery query)
        {
            DisableCaching();
            var result = new LookupFieldResult
            {
                Page  = query.Page,
                Items = new List <LookupFieldResultItem>()
            };

            try
            {
                result.Page = query.Page;
                var queryTerm = query.Query.ToSafeString().ToLowerInvariant();
                var field     = (SPContext.Current.SPList(query.ListId.ToGuid()).FieldById(query.FieldId.ToGuid()) as RosterTableLookupField);
                if (field != null)
                {
                    var content = new RosterDataService().TableContent(field.TableName, field.KeyName, field.FieldName).
                                  Where(i => i.Item2.ToSeparatedString().ToLowerInvariant().Contains(queryTerm)).OrderBy(e => e.Item2.ToSeparatedString());
                    content.Take(PageSize).Skip(PageSize * result.Page).ToList().ForEach(item =>
                    {
                        var resultItem = new LookupFieldResultItem
                        {
                            id   = item.Item1,
                            name = item.Item2.FirstValue(),
                        };
                        ((List <LookupFieldResultItem>)result.Items).Add(resultItem);
                    });
                }
            }
            catch (SqlException ex)
            {
                if (!ex.Message.Contains("Conversion failed"))
                {
                    HandleException(ex);
                }
            }
            catch (Exception ex)
            {
                HandleException(ex);
            }
            return(result);
        }