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