public ActionResult AttentionDel(int id) { AttentionInfo atten = db.AttentionInfo.Find(id); db.AttentionInfo.Remove(atten); db.SaveChanges(); return(RedirectToAction("index", "PersonalBlog")); }
//添加关注作者 public ActionResult Add(string attenUser) { try { using (StoryBlog_DBEntities db = new StoryBlog_DBEntities()) { string account = Server.HtmlEncode(Request.Cookies["Accout"].Value); //检测数据库是否有改数据,没有则添加 var at = db.AttentionInfo.Where(a => a.attenUser == attenUser).FirstOrDefault(); if (at == null) { AttentionInfo atten = new AttentionInfo(); atten.attenUser = attenUser; atten.uAccount = account; db.AttentionInfo.Add(atten); db.SaveChanges(); var obj = new { ok = "true" }; return(Json(obj, JsonRequestBehavior.AllowGet)); } else { var obj = new { no = "true" }; return(Json(obj, JsonRequestBehavior.AllowGet)); } } } catch (Exception) { var obj = new { dl = "true" }; return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId) { var req = acceptParam.AnalyzeParam <AttentionUserReq>(); if (req == null) { return(ResultModel.GetNullErrorModel()); } var msg = req.ValidInfo(); if (msg != string.Empty) { return(ResultModel.GetParamErrorModel(msg)); } if (req.AttentionUser == userId) { return(ResultModel.GetParamErrorModel()); } var conn = appSetting.GetMysqlConn(context); AttentionInfo oldInfo = await DapperTools.GetItem <AttentionInfo>(conn, EntityTools.GetTableName <AttentionInfo>(), new[] { $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))} ={req.AttentionUser}", $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))} ={userId}", }, new[] { nameof(BaseModel.Id), }); // var isExists = await DapperTools.IsExists(conn, EntityTools.GetTableName<AttentionInfo>(), // new[] // { // $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))} ={req.AttentionUser}", // $"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))} ={userId}", // }); if (oldInfo == null) { var param = (CreateAttentionParam)req; param.UserId = userId; var result = await DapperTools.CreateItem(conn, EntityTools.GetTableName <AttentionInfo>(), param); return(ResultModel.GetSuccessModel(result)); } else { var editParam = new { UpdateTime = DateTime.Now, ValidFlag = (int)ValidFlagMenu.UseFul, req.Description, req.GroupKey, }; var setFieldList = new List <string>(); setFieldList.Add(nameof(BaseModel.UpdateTime)); setFieldList.Add(nameof(BaseModel.ValidFlag)); var result = await DapperTools.Edit(conn, EntityTools.GetTableName <AttentionInfo>(), new[] { $"{nameof(BaseModel.Id)}={oldInfo.Id}" }, null, editParam); return(ResultModel.GetSuccessModel(result)); } }