public int Add(string TweetComment, string User_Phone)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO TW_TweetComment (TweetComment,TweetID,TweetCommentPID,TC_PromotersDeID,TC_PromotersDe,TC_PromotersID,TC_PromotersName,TC_StartTime,TweetCommentID) ");
strSql.Append(" SELECT @TweetComment,TweetID,1,Organization_ID ,Organization_Name ,User_ID ,USER_NAME ,GETDATE() ,0 FROM View_Base_UserInfo WHERE User_Phone=@User_Phone ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@TweetComment", SqlDbType.NVarChar,500),
new SqlParameter("@User_Phone", SqlDbType.VarChar,11)};
parameters[0].Value = TweetComment;
parameters[1].Value = User_Phone;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
//这里提示列名 'TweetID' 无效。
数据库里实实在在的存在'TweetID' ,这点上请不要质疑。
自己仔细核对一下,本回答被网友采纳