/// <summary> /// 保存一篇文章(管理) /// </summary> /// <param name="mo"></param> /// <returns></returns> public ActionResultVM WriteAdminSave(UserWriting mo) { var vm = new ActionResultVM(); var uinfo = new UserAuthAid(HttpContext).Get(); using (var db = new ContextBase()) { var oldmo = db.UserWriting.FirstOrDefault(x => x.UwId == mo.UwId); if (oldmo != null) { oldmo.UwStatus = mo.UwStatus; oldmo.UwReplyNum = mo.UwReplyNum; oldmo.UwReadNum = mo.UwReadNum; oldmo.UwLaud = mo.UwLaud; oldmo.UwMark = mo.UwMark; oldmo.UwOpen = mo.UwOpen; db.UserWriting.Update(oldmo); int num = db.SaveChanges(); vm.Set(num > 0); } } return(vm); }
public ActionResultVM WriteEditSave(UserWriting mo, int UwId, string TagIds) { var vm = new ActionResultVM(); var lisTagId = new List <int>(); TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x))); var lisTagName = Func.Common.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList(); int uid = new UserAuthAid(HttpContext).Get().UserId; using (var db = new ContextBase()) { var oldmo = db.UserWriting.Where(x => x.Uid == uid && x.UwId == UwId).FirstOrDefault(); if (oldmo.UwStatus == -1) { vm.Set(ARTag.unauthorized); } else if (oldmo != null) { oldmo.UwTitle = mo.UwTitle; oldmo.UwCategory = mo.UwCategory; oldmo.UwContentMd = mo.UwContentMd; oldmo.UwContent = mo.UwContent; oldmo.UwUpdateTime = DateTime.Now; db.UserWriting.Update(oldmo); var wt = db.UserWritingTags.Where(x => x.UwId == UwId).ToList(); db.UserWritingTags.RemoveRange(wt); var listwt = new List <UserWritingTags>(); foreach (var tag in lisTagId) { var wtmo = new UserWritingTags { UwId = mo.UwId, TagId = tag, TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName }; listwt.Add(wtmo); } db.UserWritingTags.AddRange(listwt); int num = db.SaveChanges(); vm.Set(num > 0); } } return(vm); }
public ActionResultVM WriteSave(UserWriting mo, string TagIds) { var vm = new ActionResultVM(); var uinfo = new Func.UserAuthAid(HttpContext).Get(); using (var db = new ContextBase()) { var lisTagId = new List <int>(); TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x))); var lisTagName = Func.Common.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList(); mo.Uid = uinfo.UserId; mo.UwCreateTime = DateTime.Now; mo.UwUpdateTime = mo.UwCreateTime; mo.UwLastUid = mo.Uid; mo.UwLastDate = mo.UwCreateTime; mo.UwReplyNum = 0; mo.UwReadNum = 0; mo.UwOpen = 1; mo.UwLaud = 0; mo.UwMark = 0; mo.UwStatus = 1; db.UserWriting.Add(mo); db.SaveChanges(); var listwt = new List <UserWritingTags>(); foreach (var tag in lisTagId) { var wtmo = new UserWritingTags { UwId = mo.UwId, TagId = tag, TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName }; listwt.Add(wtmo); } db.UserWritingTags.AddRange(listwt); //标签热点+1 var listTagId = listwt.Select(x => x.TagId.Value); var listTags = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList(); listTags.ForEach(x => x.TagHot += 1); db.Tags.UpdateRange(listTags); int num = db.SaveChanges(); vm.Set(num > 0); } return(vm); }
public SharedResultVM WriteSave(UserWriting mo, string TagIds) { var vm = new SharedResultVM(); try { vm = Apps.LoginService.CompleteInfoValid(HttpContext); if (vm.Code == 200) { var uinfo = Apps.LoginService.Get(HttpContext); var lisTagId = new List <int>(); TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x))); var lisTagName = Application.CommonService.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList(); mo.Uid = uinfo.UserId; mo.UwCreateTime = DateTime.Now; mo.UwUpdateTime = mo.UwCreateTime; mo.UwLastUid = mo.Uid; mo.UwLastDate = mo.UwCreateTime; mo.UwReplyNum = 0; mo.UwReadNum = 0; mo.UwOpen = 1; mo.UwLaud = 0; mo.UwMark = 0; mo.UwStatus = 1; db.UserWriting.Add(mo); db.SaveChanges(); var listwt = new List <UserWritingTags>(); foreach (var tag in lisTagId) { var wtmo = new UserWritingTags { UwId = mo.UwId, TagId = tag, TagName = lisTagName.FirstOrDefault(x => x.TagId == tag).TagName }; listwt.Add(wtmo); } db.UserWritingTags.AddRange(listwt); //标签热点+1 var listTagId = listwt.Select(x => x.TagId.Value); var listTags = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList(); listTags.ForEach(x => x.TagHot += 1); db.Tags.UpdateRange(listTags); int num = db.SaveChanges(); vm.Data = mo.UwId; vm.Set(num > 0); } } catch (Exception ex) { ConsoleTo.Log(ex); vm.Set(ex); } return(vm); }
public ActionResultVM WriteSave(UserWriting mo, string TagIds) { var vm = new ActionResultVM(); var uinfo = new Application.UserAuthService(HttpContext).Get(); using (var db = new ContextBase()) { //已验证邮箱 uinfo = db.UserInfo.Find(uinfo.UserId); if (uinfo.UserId != 1 && uinfo.UserMailValid != 1) { vm.Set(ARTag.unauthorized); vm.Msg = "请验证邮箱后再操作"; return(vm); } //有昵称 if (string.IsNullOrWhiteSpace(uinfo.Nickname)) { vm.Set(ARTag.refuse); vm.Msg = "请填写昵称后再操作"; return(vm); } var lisTagId = new List <int>(); TagIds.Split(',').ToList().ForEach(x => lisTagId.Add(Convert.ToInt32(x))); var lisTagName = Application.CommonService.TagsQuery().Where(x => lisTagId.Contains(x.TagId)).ToList(); mo.Uid = uinfo.UserId; mo.UwCreateTime = DateTime.Now; mo.UwUpdateTime = mo.UwCreateTime; mo.UwLastUid = mo.Uid; mo.UwLastDate = mo.UwCreateTime; mo.UwReplyNum = 0; mo.UwReadNum = 0; mo.UwOpen = 1; mo.UwLaud = 0; mo.UwMark = 0; mo.UwStatus = 1; db.UserWriting.Add(mo); db.SaveChanges(); var listwt = new List <UserWritingTags>(); foreach (var tag in lisTagId) { var wtmo = new UserWritingTags { UwId = mo.UwId, TagId = tag, TagName = lisTagName.Where(x => x.TagId == tag).FirstOrDefault().TagName }; listwt.Add(wtmo); } db.UserWritingTags.AddRange(listwt); //标签热点+1 var listTagId = listwt.Select(x => x.TagId.Value); var listTags = db.Tags.Where(x => listTagId.Contains(x.TagId)).ToList(); listTags.ForEach(x => x.TagHot += 1); db.Tags.UpdateRange(listTags); int num = db.SaveChanges(); vm.Data = mo.UwId; vm.Set(num > 0); } return(vm); }