public string GeTeamRank() { UserGroupService usergSerivice = new UserGroupService(); UserService userService = new UserService(); List<UserGroup> usergList = usergSerivice.FindAll(); List<RankListTeam> rankListTeam = new List<RankListTeam>(); List<User> userList = new List<User>(); for (int i = 2; i < usergList.Count; i++) { userList = userService.FindUsersByGroupId(usergList[i].Id); int count = 0; for (int j = 0; j < userList.Count; j++) { //获取每个用户的发表的知识数量,并求和 AriticleService ariticleService = new AriticleService(); int n = ariticleService.GetAriticleCount(userList[j].Id); count += n; } RankListTeam rlt = new RankListTeam(); rlt.Title = usergList[i].Title; rlt.AriticleCount = count; rankListTeam.Add(rlt); } //对结果排序 var queryResults = from n in rankListTeam orderby n.AriticleCount descending select n; List<RankListTeam> rktList = new List<RankListTeam>(); foreach (var n in queryResults) { rktList.Add(n); } string result = JsonConvert.SerializeObject(rktList); return result; }
private void grdUserGroupDataBind() { UserGroupService userGroupService = new UserGroupService(); grdUserGroup.DataSource = userGroupService.FindAll(); grdUserGroup.DataBind(); }
public string Add(string title) { UserGroup ug = new UserGroup(); ug.Title = title; UserGroupService ugs = new UserGroupService(); ugs.Add(ug); List<UserGroup> list = ugs.FindAll(); UserGroupViewModel ugv = new UserGroupViewModel(list[list.Count-1]); string result = JsonConvert.SerializeObject(ugv); return result; }
//得到所有用户分组 public string GetUserGroups() { UserGroupService ugs = new UserGroupService(); List<UserGroup> list = ugs.FindAll(); List<UserGroupViewModel> ugvList = new List<UserGroupViewModel>(); for (int i = 0; i < list.Count; i ++ ) { UserGroupViewModel ugv = new UserGroupViewModel(list[i]); ugvList.Add(ugv); } string result = JsonConvert.SerializeObject(ugvList); return result; }
public string Rename(string id,string name) { UserGroupService ugs = new UserGroupService(); List<UserGroup> list = ugs.FindAll(); UserGroup ug = new UserGroup(); for (int i = 0; i < list.Count; i++) { if (id == list[i].Id + "") { ug = list[i]; } } ug.Title = name; ugs.Update(ug); return null; }
// GET: Users/Create public async Task <IActionResult> Create() { if (_userService.VerificarAutenticacao() == 0 || _userService.VerificarAutenticacao() == 1) { return(RedirectToAction("Login", "Users")); } var userGroups = await _userGroupsService.FindAll(); var viewModel = new UserViewModel { UserGroups = userGroups }; return(View(viewModel)); }
public ActionResult UploadAriticle() { UserGroupService ugs = new UserGroupService(); List<UserGroup> list = ugs.FindAll(); List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>(); UserGroupViewModel ugv; for (int i = 0; i < list.Count; i++) { ugv = new UserGroupViewModel(list[i]); ugvlist.Add(ugv); } string result = JsonConvert.SerializeObject(ugvlist); ViewBag.OpenString = result; return View(); }
//动态获取当前数据库中的 组 列表 public ActionResult GetGroups() { UserGroupService usergroup = new UserGroupService(); List<UserGroup> usergrouplist = new List<UserGroup>(); usergrouplist = usergroup.FindAll(); List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>(); UserGroupViewModel ugv; for (int i = 0; i < usergrouplist.Count; i++) { ugv = new UserGroupViewModel(usergrouplist[i]); ugvlist.Add(ugv); } //string resultlist = JsonConvert.SerializeObject(ugvlist); string result = JsonConvert.SerializeObject(ugvlist); return Content(result); }
public ActionResult ToKnowledgeModify(string ariticleId) { using (RRDLEntities db = new RRDLEntities()) { AriticleService ars = new AriticleService(db); Ariticle ariticle = ars.FindById(ariticleId); AriticleViewModel avm = new AriticleViewModel(ariticle); List<AriticleVisibility> visibilityList = ars.GetAriticleVisibility(ariticle.Id); avm.Id = ariticle.Id; string result = JsonConvert.SerializeObject(avm); ViewBag.Ariticle = result; UserGroupService ugs = new UserGroupService(); List<UserGroup> list = ugs.FindAll(); List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>(); UserGroupViewModel ugv; for (int i = 0; i < list.Count; i++) { ugv = new UserGroupViewModel(list[i]); ugvlist.Add(ugv); } string resultlist = JsonConvert.SerializeObject(ugvlist); ViewBag.OpenString = resultlist; Tree tree = new Tree(); TreeNode treeNode = tree.SearchByAriticle(ariticle.Id); List<TreeNode> treelist = tree.GetTreeNodePath(treeNode); string treeresult = ""; for (int i = treelist.Count - 1; i >= 0; i--) { treeresult = treeresult + treelist[i].Title + "TreePathSplit"; } ViewBag.TreeId = treeNode.ParentId; ViewBag.TreePath = treeresult; VisibilityViewModel vvm = new VisibilityViewModel(); List<VisibilityViewModel> vvlist = new List<VisibilityViewModel>(); int count = ugs.FindAll().Count; if (count == visibilityList.Count) { ViewBag.visibilityList = "all"; } else { for (int i = 0; i < visibilityList.Count; i++) { vvm = new VisibilityViewModel(); vvm.Id = visibilityList[i].Id; vvm.UserGroupId = visibilityList[i].UserGroupId; vvlist.Add(vvm); } string vlist = JsonConvert.SerializeObject(vvlist); ViewBag.visibilityList = vlist; } string author = ariticle.User.NickName; string createTime = ariticle.Createtime.ToString(); ViewBag.author = author; ViewBag.createTime = createTime; return View(); } }
/// <summary> /// 后台返回:所有小组名称和小组ID /// </summary> /// <returns></returns> public JsonResult GetAllGroups() { RRDLEntities rr = new RRDLEntities(); UserGroupService ugs = new UserGroupService(rr); rr.Configuration.ProxyCreationEnabled = false; List<UserGroup> list = ugs.FindAll(); List<UserGroup> newList = new List<UserGroup>();//去除了游客和超级管理员之后的UserGroup foreach (var l in list) { if (l.Id != 1 && l.Id != 2) { newList.Add(l); } } return Json(newList); }
//public string getMemberById(string userId) { // UserService userservice = new UserService(); // User user = userservice.FindById(userId); // MemberViewModel mvm = new MemberViewModel(user); // UserGroupService ugs = new UserGroupService(); // List<UserGroup> list = ugs.FindAll(); // string memberResult = JsonConvert.SerializeObject(mvm); // List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>(); // UserGroupViewModel ugv; // for (int i = 0; i < list.Count; i++) // { // ugv = new UserGroupViewModel(list[i]); // ugvlist.Add(ugv); // } // string result = JsonConvert.SerializeObject(ugvlist); // return memberResult+"MemberAndGroupList"+result; //} public string getMemberById(string userId) { using (RRDLEntities db = new RRDLEntities()) { UserService userservice = new UserService(); User user = userservice.FindById(userId); MemberViewModel mvm = new MemberViewModel(user); int approvedcount = 0; int allcount = 0; AriticleService ariticleService = new AriticleService(); Expression<Func<Ariticle, bool>> condition = a => a.Approve.ApproveStatus == EnumAriticleApproveStatus.Approved && a.UserId == user.Id; approvedcount = ariticleService.GetAriticleCount(condition); condition = a => a.UserId == user.Id; allcount = ariticleService.GetAriticleCount(condition); mvm.approvedArticleCount = approvedcount; mvm.allArticleCount = allcount; UserGroupService ugs = new UserGroupService(); List<UserGroup> list = ugs.FindAll(); string memberResult = JsonConvert.SerializeObject(mvm); List<UserGroupViewModel> ugvlist = new List<UserGroupViewModel>(); UserGroupViewModel ugv; for (int i = 0; i < list.Count; i++) { ugv = new UserGroupViewModel(list[i]); ugvlist.Add(ugv); } string result = JsonConvert.SerializeObject(ugvlist); return memberResult + "MemberAndGroupList" + result; } }
public ActionResult SearchPorformUser(string key) { int groupId = 0; string newkey = System.Web.HttpUtility.UrlDecode(key).ToLower().Trim(); R2.RRDL.BusinessModel.UserService us = new UserService(); UserGroupService ugs = new UserGroupService(); List<User> lists = new List<User>(); List<UserGroup> listsgroup = new List<UserGroup>(); listsgroup = ugs.FindAll(); lists = us.FindAll(); List<UserViewModel> listuvm = new List<UserViewModel>(); for (int i = 0; i < listsgroup.Count; i++) { UserGroup ug = new UserGroup(); ug = listsgroup[i]; if (ug.Title.ToLower().Contains(newkey)) { groupId = ug.Id; for (int j = 0; j < lists.Count; j++) { UserViewModel uvm = new UserViewModel(); uvm.Id = lists[j].Id; uvm.ApproveStatus = lists[j].ApproveStatus; uvm.RealName = lists[j].RealName; uvm.RegisterName = lists[j].RegisterName; uvm.ReplyContent = lists[j].ReplyContent; uvm.NickName = lists[j].NickName; uvm.Gender = lists[j].Gender; uvm.AuthorityCategory = lists[j].AuthorityCategory; uvm.PersonalDescription = lists[j].PersonalDescription; if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && lists[j].ContentGroupId == groupId) { if (!isExtence(listuvm, uvm)) { listuvm.Add(uvm); } } } } } if (listuvm.Count <= 0) { for (int j = 0; j < lists.Count; j++) { UserViewModel uvm1 = new UserViewModel(); uvm1.Id = lists[j].Id; uvm1.ApproveStatus = lists[j].ApproveStatus; uvm1.RealName = lists[j].RealName; uvm1.RegisterName = lists[j].RegisterName; uvm1.ReplyContent = lists[j].ReplyContent; uvm1.NickName = lists[j].NickName; uvm1.Gender = lists[j].Gender; uvm1.AuthorityCategory = lists[j].AuthorityCategory; uvm1.PersonalDescription = lists[j].PersonalDescription; if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm1.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && uvm1.RealName.Contains(newkey)) { if (!isExtence(listuvm, uvm1)) { listuvm.Add(uvm1); } } } } if (newkey.ToLower().Contains("管理员") || newkey.ToLower().Contains("管理") || newkey.ToLower().Contains("管") || newkey.ToLower().Contains("理")) { for (int k = 0; k < lists.Count; k++) { UserViewModel uvm2 = new UserViewModel(); uvm2.Id = lists[k].Id; uvm2.ApproveStatus = lists[k].ApproveStatus; uvm2.RealName = lists[k].RealName; uvm2.RegisterName = lists[k].RegisterName; uvm2.ReplyContent = lists[k].ReplyContent; uvm2.NickName = lists[k].NickName; uvm2.Gender = lists[k].Gender; uvm2.AuthorityCategory = lists[k].AuthorityCategory; uvm2.PersonalDescription = lists[k].PersonalDescription; if ((R2.RRDL.Models.EnumAriticleApproveStatus)uvm2.ApproveStatus == R2.RRDL.Models.EnumAriticleApproveStatus.Approved && uvm2.AuthorityCategory == R2.RRDL.Models.EnumUserCategory.Administrator) { if (!isExtence(listuvm, uvm2)) { listuvm.Add(uvm2); } } } } string result = JsonConvert.SerializeObject(listuvm); result = result + "ContentAndCount" + listuvm.Count.ToString(); return Content(result); }
public ActionResult GetAriticleById(string ariticleId) { using (RRDLEntities db = new RRDLEntities()) { AriticleService ars = new AriticleService(db); Ariticle ariticle = ars.FindById(ariticleId); AriticleViewModel avm = new AriticleViewModel(ariticle); avm.Title = ariticle.Title; avm.UGC = ariticle.UGC; avm.author = ariticle.User.NickName; avm.Createtime = ariticle.Createtime.ToString(); Tree tree = new Tree(); TreeNode treeNode = tree.SearchByAriticle(ariticle.Id); List<TreeNode> list = tree.GetTreeNodePath(treeNode); string result = ""; for (int i = list.Count - 1; i >= 0; i--) { result = result + list[i].Title + "#"; } string arrayList = ""; List<AriticleVisibility> visibilityList = ars.GetAriticleVisibility(ariticle.Id); UserGroupService ugs = new UserGroupService(); int count = ugs.FindAll().Count; if (0 == visibilityList.Count) { arrayList = JsonConvert.SerializeObject(avm) + "AriticleAndTreeNode" + result + "AriticleAndTreeNodeall"; } else { VisibilityViewModel vvm = new VisibilityViewModel(); List<VisibilityViewModel> vvlist = new List<VisibilityViewModel>(); for (int i = 0; i < visibilityList.Count; i++) { vvm = new VisibilityViewModel(); vvm.Id = visibilityList[i].Id; vvm.UserGroupId = visibilityList[i].UserGroupId; vvm.userGroupTitle = visibilityList[i].UserGroup.Title; vvlist.Add(vvm); } string vlist = JsonConvert.SerializeObject(vvlist); arrayList = JsonConvert.SerializeObject(avm) + "AriticleAndTreeNode" + result + "AriticleAndTreeNode" + vlist; } return Content(arrayList); } }