private ArticalCmt GetCmtByRow(DataRow dataRow)
{
ArticalCmt articalCmt = new ArticalCmt
{
Articalid = Convert.ToInt32(dataRow["Articalid"]),
ArtCmtUserid = Convert.ToInt32(dataRow["ArtCmtUserid"]),
ArtCmtTime = Convert.ToDateTime(dataRow["ArtCmtTime"]),
ArtCmtContent = dataRow["ArtCmtContent"].ToString(),
UpArtCmtnum = Convert.ToInt32(dataRow["UpArtCmtnum"]),
DownArtCmtnum = Convert.ToInt32(dataRow["DownArtCmtnum"]),
ArtCmtedUserid = Convert.ToInt32(dataRow["ArtCmtedUserid"]),
CmdUseridName = dataRow["ArtCmtUserName"].ToString(),
CmtedUseridName = dataRow["ArtCmtedUserName"].ToString(),
UseridName = dataRow["UserName"].ToString(),
};
return(articalCmt);
}
public bool PostArtComment(ArticalCmt articalCmt)
{
SqlConnection sqlConnection = new SqlConnection(connectionstring);
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
string sql = "insert into ArticalCmtTable (Articalid,ArtCmtUserid,ArtCmtedUserid,ArtCmtTime,ArtCmtContent,UserName,ArtCmtUserName,ArtCmtedUserName,Userid)values(@Articalid,@ArtCmtUserid,@ArtCmtedUserid,@ArtCmtTime,@ArtCmtContent,@UserName,@ArtCmtUserName,@ArtCmtedUserName,@Userid);update ArticalTable set ArtCmtnum =ArtCmtnum+1 where Articalid=@Articalid";
sqlCommand.CommandText = sql;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.Parameters.AddWithValue("@Articalid", articalCmt.Articalid);
sqlCommand.Parameters.AddWithValue("@ArtCmtUserid", articalCmt.ArtCmtUserid);
sqlCommand.Parameters.AddWithValue("@ArtCmtedUserid", articalCmt.ArtCmtedUserid);
sqlCommand.Parameters.AddWithValue("@ArtCmtTime", articalCmt.ArtCmtTime);
sqlCommand.Parameters.AddWithValue("@ArtCmtContent", articalCmt.ArtCmtContent);
sqlCommand.Parameters.AddWithValue("@UserName", articalCmt.UseridName);
sqlCommand.Parameters.AddWithValue("@ArtCmtUserName", articalCmt.CmdUseridName);
sqlCommand.Parameters.AddWithValue("@ArtCmtedUserName", articalCmt.CmtedUseridName);
sqlCommand.Parameters.AddWithValue("@Userid", articalCmt.Userid);
sqlCommand.ExecuteNonQuery();
sqlTransaction.Commit();
return(true);
}
catch (SqlException)
{
sqlTransaction.Rollback();
return(false);
}
finally
{
sqlConnection.Close();
}
}
}
public bool PostComment([FromBody] ArticalCmt articalCmt)
{
ArtCommentAccess artCommentAccess = new ArtCommentAccess();
return(artCommentAccess.PostArtComment(articalCmt));
}
