internal RangeTemplate(string name, IXLRange range, TempSheetBuffer buff, TemplateErrors errors, IDictionary <string, object> globalVariables) { _rowRange = range; _cells = new TemplateCells(this); _tagsEvaluator = new TagsEvaluator(); var wb = _rowRange.Worksheet.Workbook; _buff = buff; _errors = errors; _globalVariables = globalVariables; _tags = new TagsList(_errors); _rangeTags = new TagsList(_errors); Name = name; Source = name; var rangeName = name + "_tpl"; if (wb.NamedRanges.TryGetValue(rangeName, out var namedRange)) { namedRange.Add(range); } else { wb.NamedRanges.Add(rangeName, range); } _evaluator = new FormulaEvaluator(); }
private void FindTagTextBox_TextChanged(object sender, TextChangedEventArgs e) { int LastSelectedIndex = TagsList.SelectedIndex; string Mask = FindTagTextBox.Text; int Index = 0; if (Mask.Length == 0) { TagsList.SelectedIndex = LastSelectedIndex; TagsList.ScrollIntoView(TagsList.SelectedItem); return; } // Искать метки в списке по мере набора имени foreach (var CurrentTag in LabelsCollection) { if (CurrentTag.Value.StartsWith(Mask)) { TagsList.SelectedIndex = Index; TagsList.ScrollIntoView(TagsList.SelectedItem); return; } Index++; } TagsList.SelectedIndex = LastSelectedIndex; TagsList.ScrollIntoView(TagsList.SelectedItem); }
public async Task <TagServiceResponse <TagsList> > GetTags(bool includeInActive = false) { var response = new TagServiceResponse <TagsList>(); try { var tagClient = await GetTagClient(); var tags = await tagClient.GetTagsAsync(Scope); var tagsList = new TagsList(); tagsList.Count = tags.Count; tagsList.Tags = tags.Select(x => new Tag { Active = x.Active ?? false, Name = x.Name, Id = x.Id, Url = x.Url }).ToList(); response.Data = tagsList; response.IsSuccessStatusCode = true; } catch (Exception exception) { _log.Error(exception, "Error getting Tags"); response.Exception = exception; } return(response); }
private void MyDataBind() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from [ArticleTags] where ID not in (" + Label3.Text + ") order by ID asc "; conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); cmd.CommandText = "select * from [Articles_ArticleTags] where ArticleID = @ArticleID"; cmd.Parameters.AddWithValue("@ArticleID", IDLabel.Text); SqlDataReader rd1 = cmd.ExecuteReader(); ListBox1.DataSource = rd1; ListBox1.DataTextField = "ArticleTagName"; ListBox1.DataValueField = "ArticleTagID"; ListBox1.DataBind(); rd1.Close(); } }
public void AddUsedTags() { if (Used) { if (TagsList.Contains("FreeToUse")) { TagsList.Remove("FreeToUse"); } if (!TagsList.Contains("Used")) { TagsList.Insert(0, "Used"); } } else { if (TagsList.Contains("Used")) { TagsList.Remove("Used"); } if (!TagsList.Contains("FreeToUse")) { TagsList.Insert(0, "FreeToUse"); } } }
public void Get_by_type_should_return_tags_with_inherits() { var errList = new TemplateErrors(); var list = new TagsList(errList) { new GroupTag { Name = "val1" }, new GroupTag { Name = "val2" }, new SortTag { Name = "val3" }, new ProtectedTag { Name = "val4" }, new DescTag { Name = "val5" }, new ColsFitTag { Name = "val6" } }; list.GetAll <SortTag>().Select(x => x.Name).Should().BeEquivalentTo("val1", "val2", "val3", "val5"); }
protected void Page_Load(object sender, EventArgs e) { RandomID.Text = Request["RandomID"]; if (!IsPostBack) { if (Session["UserID"] == null) { Util.ShowMessage("会话超期,请重新登录", "Login.aspx"); } else { using (SqlConnection conn = new DB().GetConnection()) { string userid = Convert.ToString(Session["UserID"]); string sql = "select * from UserTags order by ID desc"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } init(); } }
public CollectiblesViewModel(CollectiblesList list, TagsList tags) { SearchText = new ReactiveProperty <string>(""); AllItems = list.Collectibles.Select(item => new CollectibleViewModel(item, SearchText, tags.Tags)).ToReactiveCollection(); Func <CollectibleViewModel, CollectibleViewModel, int> sortByTitle = (a, b) => String.Compare(a.OriginalTitle, b.OriginalTitle); Func <CollectibleViewModel, bool> filter = vm => { if (string.IsNullOrEmpty(SearchText.Value)) { return(true); } if (SearchText.Value.StartsWith("t:")) { var tag = SearchText.Value.Substring(2).ToLower(); return(vm.Tags.Any(t => t.Name.ToLower().Contains(tag))); } if (vm.OriginalTitle.ToLower().Contains(SearchText.Value.ToLower())) { return(true); } return(false); }; Items = AllItems.WhereMany(filter, t => t.Tags.ObserveCountChanged().AsUnitObservable(), SearchText.AsUnitObservable()).Sort(sortByTitle, null); SelectedItems = Items.WhereMany(vm => vm.IsSelected.Value, vm => vm.IsSelected.AsUnitObservable()).Sort(sortByTitle, null); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string UserID = Convert.ToString(Session["UserID"]); if (Session["RoleID"] != null && !String.IsNullOrEmpty(Session["RoleID"].ToString()) && (Session["RoleID"].ToString() == "1" || Session["RoleID"].ToString() == "2")) { //ClassifyPanel.Visible = true; } else { //ClassifyPanel.Visible = false; } using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from [UserTags] where [UserID] = @UserID order by ID asc "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", UserID); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } }
public void ReloadTagsData() { List <ColorTagState> backupTags = null; if (TagsList == null) { TagsList = new List <ColorTagState> (); } else { backupTags = new List <ColorTagState> (); backupTags.AddRange(TagsList); TagsList.Clear(); } if (AnnCategoryTagUtil.Instance == null) { return; } var tagList = AnnCategoryTagUtil.Instance.GetTags(); var tempTagList = new List <AnnotationTag> (); tempTagList.AddRange(tagList); if (tagList != null) { foreach (var tag in tempTagList) { var colorTag = new ColorTagState(); colorTag.CheckState = NSCellStateValue.Off; if (backupTags != null) { for (int i = 0; i < backupTags.Count; i++) { if (tag.TagId == backupTags [i].Tag.TagId) { colorTag.CheckState = backupTags [i].CheckState; break; } } } colorTag.Tag = tag; TagsList.Add(colorTag); } } if (backupTags != null) { backupTags.Clear(); backupTags = null; } if (TagsTableView != null) { TagsTableView.ReloadData(); } }
public void SetTagItems(IEnumerable <Tag> tags) { foreach (var tag in tags) { TagsList.Add(new SelectListItem() { Value = tag.TagID.ToString(), Text = tag.TagName }); } }
internal RangeTemplate(IXLNamedRange range, TempSheetBuffer buff) { _rowRange = range.Ranges.First(); _cells = new TemplateCells(this); _tagsEvaluator = new TagsEvaluator(); var wb = _rowRange.Worksheet.Workbook; _buff = buff; _tags = new TagsList(); _rangeTags = new TagsList(); Name = range.Name; Source = range.Name; wb.NamedRanges.Add(range.Name + "_tpl", range.Ranges); }
public void Add_with_same_priority_should_increase_count() { var list = new TagsList { new GroupTag { Name = "val1" }, new GroupTag { Name = "val2" } }; list.Count.Should().Be(2); }
private void RenderSubrange(RangeTemplate ownRng, object item, FormulaEvaluator evaluator, TemplateCell cell, TagsList tags, ref int iCell, ref int row) { var start = _buff.NextAddress; // the child template to which the cell belongs var formula = ownRng.Source.ReplaceLast("_", "."); if (evaluator.Evaluate(formula, new Parameter(Name, item)) is IEnumerable value) { var valArr = value.Cast <object>().ToArray(); ownRng.Generate(valArr); if (ownRng.IsHorizontal) { int shiftLen = ownRng._colCnt * (valArr.Length - 1); tags.Where(tag => tag.Cell.Row == cell.Row && tag.Cell.Column > cell.Column) .ForEach(t => { t.Cell.Column += shiftLen; t.Cell.XLCell = _rowRange.Cell(t.Cell.Row, t.Cell.Column); }); } else { // move current template cell to next (skip subrange) row += ownRng._rowCnt + 1; while (_cells[iCell].Row <= row - 1) { iCell++; } iCell--; // roll back. After it became clear that it was too much, we must go back. int shiftLen = ownRng._rowCnt * (valArr.Length - 1); tags.Where(tag => tag.Cell.Row > cell.Row) .ForEach(t => { t.Cell.Row += shiftLen; t.Cell.XLCell = _rowRange.Cell(t.Cell.Row, t.Cell.Column); }); } } var rng = _buff.GetRange(start, _buff.PrevAddress); var rangeName = ownRng.Name; var dnr = rng.Worksheet.Workbook.NamedRange(rangeName); dnr.SetRefersTo(rng); }
public void Add_with_same_priority_should_increase_count() { var errList = new TemplateErrors(); var list = new TagsList(errList) { new GroupTag { Name = "val1" }, new GroupTag { Name = "val2" } }; list.Count.Should().Be(2); }
internal RangeTemplate(IXLNamedRange range, TempSheetBuffer buff, TemplateErrors errors, IDictionary <string, object> globalVariables) { _rowRange = range.Ranges.First(); _cells = new TemplateCells(this); _tagsEvaluator = new TagsEvaluator(); var wb = _rowRange.Worksheet.Workbook; _buff = buff; _errors = errors; _globalVariables = globalVariables; _tags = new TagsList(_errors); _rangeTags = new TagsList(_errors); Name = range.Name; Source = range.Name; wb.NamedRanges.Add(range.Name + "_tpl", range.Ranges); }
private void MyDataBind() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = "select * from [CommonWord] order by ID desc "; SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "CommonWord"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } }
public void DragItemFromIndexToIndex(NSTableView tableView, int dragRow, int toRow) { IsDraggedTag = true; //Console.WriteLine("from:{0} to:{1}", dragRow, toRow); AnnotationTag dragItem = TagsList [dragRow]; if (dragRow < toRow) { TagsList.Insert(toRow, dragItem); TagsList.RemoveAt(dragRow); } else { TagsList.RemoveAt(dragRow); TagsList.Insert(toRow, dragItem); } }
async void tagsListviewcloseClicked(object sender, EventArgs e1) { tagsListView.ItemsSource = tagsList1; tagsListView.ItemsSource = null; var args = (TappedEventArgs)e1; TagsList t2 = args.Parameter as TagsList; var itemToRemove = tagsList.Single(r => r.name == t2.name); tagsList.Remove(itemToRemove); int cusid = App.tagsDict.FirstOrDefault(x => x.Value == t2.name.ToString()).Key; tagIdsList.Remove(cusid); tagsListView.ItemsSource = tagsList; tagsListView.RowHeight = 40; tagsListView.HeightRequest = 40 * tagsList.Count; mainstack.HeightRequest = mainstack.HeightRequest - 40; }
private void UpdateTags() { string userid = Convert.ToString(Session["UserID"]); using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from UserTags where UserID = @UserID order by ID desc"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", userid); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } }
private void OnAddClickHandler(object obj) { if (TagText != string.Empty && TagsList.Count(t => t.Name == TagText) == 0) { Tag newTag = dataRepository.TagCollection.FirstOrDefault(t => t.Name == TagText); if (newTag == null) { newTag = new Tag(); newTag.Name = TagText; dataRepository.CreateTag(newTag); newTag = dataRepository.TagCollection.FirstOrDefault(t => t.Name == TagText); } currentBlurb.Tags.Add(newTag); TagsList.Add(newTag); OnPropertyChanged("TagsList"); TagText = string.Empty; } }
private void GetTags() { using (var logic = new TagService()) { foreach (var link in Links) { foreach (var tag in logic.GetCollection(link.Id)) { TagsList.Add(tag); } link.Tags = TagsList; } foreach (var tag in logic.GetCollectionTags()) { AllTagsList.Add(tag); } } }
public override void ViewDidLoad() { if (TagsList == null) { TagsList = new List <AnnotationTag> (0); } else { TagsList.Clear(); } var tagList = AnnCategoryTagUtil.Instance.GetTags(); if (tagList != null) { TagsList.AddRange(tagList); } TagTableView.UsesAlternatingRowBackgroundColors = false; TagTableView.EnclosingScrollView.ScrollerKnobStyle = NSScrollerKnobStyle.Default; TagTableView.EnclosingScrollView.VerticalScroller.ControlSize = NSControlSize.Small; TagTableView.SelectionHighlightStyle = NSTableViewSelectionHighlightStyle.Regular; TagTableView.EnclosingScrollView.BackgroundColor = NSColor.White; TagTableView.EnclosingScrollView.BorderType = NSBorderType.BezelBorder; TagTableView.GridStyleMask = NSTableViewGridStyle.None; TagTableView.DataSource = new EditTagTableDataSource(TagsList, this); TagTableView.Delegate = new EditTagTableDelegate(TagsList, this); TagTableView.ReloadData(); var attributedTitle = Utility.AttributeTitle("Done", NSColor.Red, 13); DoneButton.AttributedTitle = attributedTitle; var alterTitle = Utility.AttributeTitle("Done", NSColor.Red, 13); DoneButton.AttributedAlternateTitle = alterTitle; string[] typeArray = { "NSStringPboardType" }; TagTableView.RegisterForDraggedTypes(typeArray); this.CurrentTagIndex = -1; }
public void Items_should_be_sorted_by_priority() { var list = new TagsList { new GroupTag { Name = "val1" }, new GroupTag { Name = "val2" }, new OnlyValuesTag { Name = "val3" }, new ProtectedTag { Name = "val4" } }; list.Count.Should().Be(4); list.Select(x => x.Name).Should().BeEquivalentTo("val3", "val1", "val2", "val4"); }
public void AddTagToTableView(string color, string title) { if (this.IsTagEdit) { var curTag = TagsList [this.CurrentTagIndex]; curTag.Color = color; curTag.Title = title; AnnCategoryTagUtil.Instance.UpdateTag(curTag.TagId, title, color); } else { var newTag = new AnnotationTag(); newTag.Color = color; newTag.Title = title; Guid id = AnnCategoryTagUtil.Instance.AddTag(title, color); newTag.TagId = id; TagsList.Add(newTag); } TagTableView.ReloadData(); }
public void ReloadAnnotationData() { if (AnnCategoryTagUtil.Instance == null) { return; } if (TagsList == null) { TagsList = new List <AnnotationTag> (); } else { TagsList.Clear(); } var tag = new AnnotationTag(); tag.Color = string.Empty; tag.Title = "All Tags"; tag.TagId = Guid.Empty; TagsList.Add(tag); var noTag = new AnnotationTag(); noTag.Color = string.Empty; noTag.Title = "No tag"; noTag.TagId = Guid.Empty; TagsList.Add(noTag); var tags = AnnCategoryTagUtil.Instance.GetTags(); TagsList.AddRange(tags); if (TagsTableView != null) { TagsTableView.ReloadData(); } }
public TagsList[] GetTaskList() { List <TagsList> data = new List <TagsList>(); var tags = context.Tasks.Select(m => m.Tags).Distinct().ToArray(); foreach (var tag in tags) { TagsList list = new TagsList() { Tag = tag, Tasks = context.Tasks.Where(m => m.Tags == tag).ToList().Select(m => new TaskDispayModel() { Tag = tag, Title = m.Name, ComplexLevel = m.Level.ToString() }).ToArray() }; data.Add(list); } return(data.ToArray()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string UserID = Convert.ToString(Session["UserID"]); using (SqlConnection conn = new DB().GetConnection()) { string sql = "select * from [ArticleTags] where [UserID] = @UserID order by ID asc "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@UserID", UserID); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); TagsList.DataSource = rd; TagsList.DataTextField = "TagName"; TagsList.DataValueField = "ID"; TagsList.DataBind(); rd.Close(); } } }
public void UpdateTags() { TagsClean = ""; if (tags == null) // TODO: v0.7.7 returns null tags when there are no plugins enabled. { tags = ""; // Use empty string as fallback instead } var separatedTags = tags.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var s in separatedTags) { TagsClean += s.Substring(Math.Max(s.IndexOf(':') + 1, 0)).Trim() + ", "; } TagsClean = TagsClean.Trim().TrimEnd(','); TagsList.Clear(); foreach (var s in separatedTags) { TagsList.Add(s.Trim()); } // TODO: Apparently we can crash here with a COMException try { TagsGroups.Clear(); } catch (Exception e) { // Drop original collection, can cause more COMExceptions TagsGroups = new ObservableCollection <ArchiveTagsGroup>(); #if WINDOWS_UWP Crashes.TrackError(e); #endif } var tmp = new List <ArchiveTagsGroup>(); foreach (var s in separatedTags) { var parts = s.Trim().Split(new char[] { ':' }, 2); var @namespace = parts.Length == 2 ? parts[0] : "other"; var group = tmp.FirstOrDefault(tg => tg.Namespace.Equals(@namespace)); if (group == null) { group = AddTagsGroup(tmp, @namespace); } var tag = parts[parts.Length - 1]; if (parts[0].Equals("date_added")) { if (long.TryParse(tag, out long unixTime)) { tag = Util.UnixTimeToDateTime(unixTime).ToString(); } } group.Tags.Add(new ArchiveTagsGroupTag { FullTag = s.Trim(), Tag = tag, Namespace = @namespace }); } tmp.Sort((a, b) => string.Compare(a.Namespace, b.Namespace)); var c = tmp.Find(g => g.Namespace.Equals("other")); if (c != null) { tmp.Remove(c); tmp.Add(c); } try { tmp.ForEach(g => { g.Namespace = g.Namespace.UpperFirstLetter().Replace('_', ' '); TagsGroups.Add(g); }); } catch (Exception e) { // Handle damaged collection just in case #if WINDOWS_UWP Crashes.TrackError(e); #endif } }
public void Load(TagsList tags) { Tags = tags; FillList(); }