public static object[] SelectTagsBySelectedGroupId(int groupId, int userTypeEnumValue, string keyword, int pageSize, int skipOffset) { if (groupId == -1) { return(SelectTags(userTypeEnumValue, keyword, pageSize, skipOffset)); } if (groupId == 0) { return(SelectTagsForGroup(userTypeEnumValue, keyword, pageSize, skipOffset)); } //var query=HostTagGroupStatus.All() // .Where(u => u.TagId != 0 && u.HostGroupId == userTypeEnumValue) // .Select(u => new { // Id = u.TagId, // TagName = u.HostName // }); //yzhu HostGroupInfo groupInfo = HostGroupInfo.GetById(groupId); if (groupInfo == null) { return(SelectTagsForGroup(userTypeEnumValue, keyword, pageSize, skipOffset)); } if (groupInfo.ParentGroupId == 0) { return(SelectTagsForGroup(userTypeEnumValue, keyword, pageSize, skipOffset)); } //yyang,090927,轨迹用户分类暂时取消 //var query = (HostTagGroupStatus.All // .Where(u => u.HostGroupId == groupInfo.ParentGroupId) // .Select(u => new // { // Id = u.HostId, // TagName = u.HostName // })).Distinct(); //modified by Tan //lyz,tagid大于0,即用户必须已经绑定标签 var query = (HostTagGroupStatus.All .Where(u => u.TagId > 0 && u.HostGroupId == groupInfo.ParentGroupId) .Select(u => new { Id = u.HostId, TagName = u.HostName })).Distinct(); //modified by Tan if (!string.IsNullOrEmpty(keyword)) { query = query.Where(t => t.TagName.Contains(keyword.Trim())); } return(query.OrderBy(t => t.TagName).Skip(skipOffset).Take(pageSize).ToArray()); }
private void LoadGroupList() { var hostGroupName = HostGroupInfo.GetByParentId((int)_userType); if (hostGroupName == null || hostGroupName.Count == 0) { grouplist.Items.Insert(0, new ListItem("无", "0")); } else { foreach (var name in hostGroupName) { grouplist.Items.Add(new ListItem(name.HostGroupName, name.HostGroupId.ToString())); } grouplist.Items.Insert(0, new ListItem("无", "0")); } }
protected void groupList_ItemCreated(object sender, RepeaterItemEventArgs e) { //TagGroupCounterView group = e.Item.DataItem as TagGroupCounterView; HostCountByGroup group = e.Item.DataItem as HostCountByGroup; if (group != null) { Anchor groupName = e.Item.FindControl("groupName") as Anchor; groupName.Text = group.GroupName; groupName.Href = PathUtil.ResolveUrl("Organize/TagGroup.aspx?id=" + group.Id); groupName.Attributes.Add("id", "g_" + group.Id); NumericLabel tagCount = e.Item.FindControl("tagCount") as NumericLabel; tagCount.Value = group.TagCount; SmartLabel groupDescription = e.Item.FindControl("groupDescription") as SmartLabel; groupDescription.Text = Strings.MonospacedLeft(group.GroupDescription, 50); Anchor detail = e.Item.FindControl("detail") as Anchor; detail.Href = groupName.Href; //不能删除根级组 int idelgroupid = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["DelFootGroup"]); int parentid = HostGroupInfo.GetById(group.Id).ParentGroupId; Anchor deleteLink = e.Item.FindControl("delete") as Anchor; if (parentid > 0 || idelgroupid > 0) { deleteLink.Href = "javascript:deleteTagGroup(" + group.Id + ");"; } else { groupName.Href = ""; deleteLink.Href = ""; deleteLink.ToolTip = "一级组不能删除"; detail.ToolTip = "一级组不能编辑"; groupName.ToolTip = "一级组不能编辑"; detail.Href = ""; //deleteLink.Text = ""; } } }
public static object[] SelectTagsBySelectedGroupName(string groupName, int groupId, int userTypeEnumValue, string keyword, int pageSize, int skipOffset) { if (groupName == null || groupName == "" || groupName == "未指定组") { } else { //int pos = groupName.IndexOf("已选组: "); if (groupName.Length >= 5) //"已选组: " ==> 5 char { groupName = groupName.Substring(5); groupName = groupName.Replace(", ", ","); string[] aGroupIds = groupName.Split(','); if (aGroupIds != null && aGroupIds.Length > 0) { if (aGroupIds.Length == 1) { groupId = Convert.ToInt32(aGroupIds[0]); } else { //var query2 = from q in HostTagGroupStatus.All // where (aGroupIds.Contains(q.HostGroupId.ToString())) // select new // { // Id = q.HostId, // TagName = q.HostName // }; //var query2 = (HostTagGroupStatus.All //.Where(u => aGroupIds.Contains(u.HostGroupId.ToString())) //.Select(u => new // { // Id = u.HostId, // TagName = u.HostName // })).Distinct(); //modified by Tan //lyz,tagid大于0,即用户必须已经绑定标签 var query2 = (HostTagGroupStatus.All .Where(u => u.TagId > 0 && aGroupIds.Contains(u.HostGroupId.ToString())) .Select(u => new { Id = u.HostId, TagName = u.HostName })).Distinct(); if (!string.IsNullOrEmpty(keyword)) { query2 = query2.Where(t => t.TagName.Contains(keyword.Trim())); } return(query2.OrderBy(t => t.TagName).Skip(skipOffset).Take(pageSize).ToArray()); } } } } if (groupId == -1) { return(SelectTags(userTypeEnumValue, keyword, pageSize, skipOffset)); } if (groupId == 0) { return(SelectTagsForGroup(userTypeEnumValue, keyword, pageSize, skipOffset)); } //var query=HostTagGroupStatus.All() // .Where(u => u.TagId != 0 && u.HostGroupId == userTypeEnumValue) // .Select(u => new { // Id = u.TagId, // TagName = u.HostName // }); //yzhu HostGroupInfo groupInfo = HostGroupInfo.GetById(groupId); if (groupInfo == null) { return(SelectTagsForGroup(userTypeEnumValue, keyword, pageSize, skipOffset)); } //if (groupInfo.ParentGroupId == 0) return(SelectTagsForGroup(groupId, keyword, pageSize, skipOffset)); //yyang,090927,轨迹用户分类暂时取消 //var query = (HostTagGroupStatus.All // .Where(u => u.HostGroupId == groupInfo.ParentGroupId) // .Select(u => new // { // Id = u.HostId, // TagName = u.HostName // })).Distinct(); //modified by Tan //if (!string.IsNullOrEmpty(keyword)) //{ // query = query.Where(t => t.TagName.Contains(keyword.Trim())); //} //return query.OrderBy(t => t.TagName).Skip(skipOffset).Take(pageSize).ToArray(); }
private void LoadDefaullView() { try { grouplist.Items.Clear(); //var hostGroupName = HostGroupInfo.All.OrderBy(x => x.ParentGroupId); //bool bParentGroupID = false; //foreach (var name in hostGroupName) //{ // grouplist.Items.Add(new ListItem(name.HostGroupName, name.HostGroupId.ToString())); // if (name.ParentGroupId == 0) // { // bParentGroupID = true; // } //} //if (!bParentGroupID) //{ // grouplist.Items.Insert(0, new ListItem("无", "0")); //} if (_editMode == EditMode.AddNew) { // tagSelector.SelectedGroupId = 0; ////////////// save.Text = "新增"; try { //GTang2010/01/27 根据项目绑定显示内容 IList <HostGroupInfo> hostGroupName; if (Config.Settings.ProjectType == ProjectTypeEnum.NMPrison) { hostGroupName = HostGroupInfo.GetGroupNameByProjectType((int)ProjectTypeEnum.NMPrison);//HostGroupInfo.GetByParentId(0); } else if (Config.Settings.ProjectType == ProjectTypeEnum.YZPrison) { hostGroupName = HostGroupInfo.GetGroupNameByProjectType((int)ProjectTypeEnum.YZPrison); } else { hostGroupName = HostGroupInfo.GetByParentId(0); } // var hostGroupName = HostGroupInfo.GetByParentId(0); if (hostGroupName == null || hostGroupName.Count == 0) { grouplist.Items.Insert(0, new ListItem("无", "0")); } else { foreach (var name in hostGroupName) { grouplist.Items.Add(new ListItem(name.HostGroupName, name.HostGroupId.ToString())); } } //grouplist.Items.Insert(0, new ListItem("无", "0")); } catch { } } else { //tagSelector.SelectedGroupId = _id;///////////////// HostGroupInfo groupInfo = HostGroupInfo.GetById(_id); if (groupInfo == null) { return; } if (groupInfo.ParentGroupId == 0) { grouplist.Items.Insert(0, new ListItem("无", "0")); tagSelector.Visible = false; } else { tagSelector.Visible = true; HostGroupInfo parentGroupInfo = HostGroupInfo.GetById(groupInfo.ParentGroupId); if (parentGroupInfo == null) { return; } grouplist.Items.Add(new ListItem(parentGroupInfo.HostGroupName, parentGroupInfo.HostGroupId.ToString())); } save.Text = "保存"; /*TagGroup group = TagGroup.Select(_id); * groupName.Text = group.GroupName; * groupDescription.Text = group.GroupDescription; * tagSelector.SelectedTagIdArray = TagGroupCoverage.GetCoveredTagIdArray(_id); * */ HostGroupInfo group = HostGroupInfo.GetById(_id); groupName.Text = group.HostGroupName.Trim(); groupDescription.Text = group.Description; //tagSelector.SelectedTagIdArray = HostTagGroupStatus.GetCoveredHostIdArray(_id); //HostTagGroupStatus.GetCoveredTagIdArray(_id);///////////////// grouplist.SelectedValue = Convert.ToString(group.ParentGroupId); if (group.ParentGroupId == 0) { if (grouplist.Items.Count > 1) { for (int i = grouplist.Items.Count - 1; i > 0; i--) { grouplist.Items.RemoveAt(i); } } } else { for (int i = 0; i < grouplist.Items.Count; i++) { if (grouplist.Items[i].Value == Convert.ToString(group.HostGroupId)) { grouplist.Items.RemoveAt(i); break; } } } } } catch (Exception ex) { feedbacks.Items.AddError("Error:" + ex.Message); } }
protected void save_click(object sender, EventArgs e) { if (groupName.Text.Trim().Length == 0) { feedbacks.Items.AddError("请输入对象组名称。"); } //if (_editMode == EditMode.AddNew && TagGroup.All.Any(g => g.GroupName == groupName.Text.Trim())) { //if (HostGroupInfo.All.Any(g => g.HostGroupName.Trim() == groupName.Text.Trim() && g.HostGroupId != tagSelector.SelectedGroupId)) if (HostGroupInfo.All.Any(g => g.HostGroupName.Trim() == groupName.Text.Trim() && g.HostGroupId != (_id == -1 ? 0 : _id))) { feedbacks.Items.AddError("对象组名称“" + groupName.Text.Trim() + "”已存在。"); } if (feedbacks.Items.Count > 0) { return; } if (_editMode == EditMode.AddNew) { //_id = TagGroup.Insert(groupName.Text.Trim(), Strings.Left(groupDescription.Text.Trim(), 200), tagSelector.SelectedTagIdArray); //yzhu 20091002, add parent Group _id = HostGroupInfo.AddHostGroupInfo(0, groupName.Text.Trim(), Strings.Left(groupDescription.Text.Trim(), 200), Convert.ToInt32(this.grouplist.SelectedValue)); HostTag.RemoveHostGroupByGroupId(_id); //如果是根组,把tagid=0的用户都插入该组,下面的插入数据代码后期需要写在数据层HostGroup里 /*if (Convert.ToInt32(this.grouplist.SelectedValue) == 0) * { * var query = HostTag.All.Where(t =>t.TagId == 0).Select(x => x.HostId).ToList(); * * using (AppDataContext db = new AppDataContext()) * { * for (int i = 0; i < query.Count; i++) * { * HostGroup hg = new HostGroup(); * hg.HostId = Convert.ToInt32(query[i].ToString()); * hg.HostGroupId = _id; * db.HostGroups.InsertOnSubmit(hg); * db.SubmitChanges(); * } * } * } */ if (tagSelector.SelectedUserIds != null) { AddHostTagGroup(tagSelector.SelectedUserIds, _id); } Terminator.Redirect("TagGroupList.aspx"); } else { //TagGroup.UpdateById(_id, groupName.Text.Trim(), Strings.Left(groupDescription.Text.Trim(), 200), tagSelector.SelectedTagIdArray); HostGroupInfo.UpdateHostGroupInfo(_id, groupName.Text.Trim(), Strings.Left(groupDescription.Text.Trim(), 200), Convert.ToInt32(this.grouplist.SelectedValue)); HostTag.RemoveHostGroupByGroupId(_id); if (tagSelector.SelectedUserIds != null) { AddHostTagGroup(tagSelector.SelectedUserIds, _id); } //add 2009-10-21 //////////////////tagSelector.SelectedTagIdArray = HostTagGroupStatus.GetCoveredHostIdArray(_id); feedbacks.Items.AddPrompt("保存成功。"); } }