public bool PutIntro(NU nU)
{
SqlConnection sqlConnection = new SqlConnection(connectionstring);
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
string sql = $"update UserTable set Introduction ='{nU.Intorduction}' where Userid='{nU.Userid}'";
sqlCommand.CommandText = sql;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.ExecuteNonQuery();
sqlTransaction.Commit();
return(true);
}
catch (SqlException)
{
return(false);
}
finally
{
sqlConnection.Close();
}
}
}
/// <summary>
/// 更新昵称
/// </summary>
/// <param name="nU"></param>
/// <returns></returns>
public bool PutName(NU nU)
{
SqlConnection sqlConnection = new SqlConnection(connectionstring);
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
string str = $"update UserTable set Name =@Name where Userid=@Userid;" +
$"update CommentTable set UseridName=@Name where Userid=@Userid;" +
$"update CommentTable set CmdUseridName=@Name where CmtUserid=@Userid;" +
$"update CommentTable set CmtedUseridName=@Name where CmtedUserid=@Userid;" +
$"update ArticalTable set Username=@Name where Userid=@Userid;" +
$"update ArticalCmtTable set UserName=@Name where Userid=@Userid;" +
$"update ArticalCmtTable set ArtCmtUserName=@Name where ArtCmtUserid=@Userid;" +
$"update ArticalCmtTable set ArtCmtedUserName =@Name where ArtCmtedUserid=@Userid";
sqlCommand.Parameters.AddWithValue("@Name", nU.Name);
sqlCommand.Parameters.AddWithValue("@Userid", nU.Userid);
sqlCommand.CommandText = str;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.ExecuteNonQuery();
sqlTransaction.Commit();
return(true);
}
catch (SqlException)
{
sqlTransaction.Rollback();
return(false);
}
finally
{
sqlConnection.Close();
}
}
}
