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));
}
}
