public IActionResult UpdInformationsheet(Informationsheet i)
{
int h;
try
{
h = bll.UpdInformationsheet(i);
}
catch (Exception ex)
{
log.Error(ex.Message);
throw;
}
return(Ok(new { state = h > 0 ? true : false, msg = h > 0 ? "修改成功" : "修改失败" }));
}
//后台资讯信息修改
public int UpdInformationsheet(Informationsheet i)
{
string sql = $"UPDATE Informationsheet SET Image='{i.Image}',Title='{i.Title}',Contont='{i.Contont}',Releasetime=NOW(),State='禁用' WHERE Id={i.Id}";
return(DB.ExceuteNonQuery(sql));
}
//后台资讯信息添加
public int InsertInformationsheet(Informationsheet i)
{
string sql = $"INSERT INTO Informationsheet VALUES(NULL, '{i.Image}', '{i.Title}', '{i.Contont}', {i.Views}, NOW(), {i.Nid}, '未审核')";
return(DB.ExceuteNonQuery(sql));
}
