/// <summary>
/// 修改 意见
/// </summary>
/// <param name="blogDto"></param>
/// <returns></returns>
public async Task <bool> UpdateBlog(SuggestDto suggestDto)
{
string sql = "update `suggest` set SuggestContact=@SuggestContact,SuggestContent=@SuggestContent where SuggestID=@SuggestID";
using (var connect = CreateConnection())
{
return(await connect.ExecuteAsync(sql, new { SuggestID = suggestDto.SuggestID, SuggestContact = suggestDto.SuggestContact, SuggestContent = suggestDto.SuggestContent }) > 0);
}
}
/// <summary>
/// 删除意见
/// </summary>
/// <param name="blogDto"></param>
/// <returns></returns>
public async Task <bool> DeleteBlog(SuggestDto suggestDto)
{
string sql = "update `suggest` set IsDelete=1 where SuggestID=@SuggestID";
using (var connect = CreateConnection())
{
return(await connect.ExecuteAsync(sql, new { SuggestID = suggestDto.SuggestID }) > 0);
}
}
/// <summary>
/// 添加 意见
/// </summary>
/// <param name="suggestDto"></param>
/// <returns></returns>
public async Task <bool> AddBlog(SuggestDto suggestDto)
{
string sql = "insert into `suggest`(SuggestContact,SuggestContent,CreateDate) VALUES(@SuggestContact,@SuggestContent,@CreateDate)";
using (var connect = CreateConnection())
{
return(await connect.ExecuteAsync(sql, new { SuggestContact = suggestDto.SuggestContact, SuggestContent = suggestDto.SuggestContent, CreateDate = DateTime.Now }) > 0);
}
}
