string sqlUpdateVersion = "UPDATE DocumentInfo SET HighestVersion=0 WHERE DocumentCode=@docode and code<>@code";
Response.Write(sqlUpdateVersion);
Database database = DatabaseFactory.CreateDatabase();
DbCommand commandUpdateRole = database.GetSqlStringCommand(sqlUpdateVersion);
database.AddInParameter(commandUpdateRole, "@docode", DbType.String, Dcode);
database.AddInParameter(commandUpdateRole, "@code", DbType.Int32, code);
int nResult = database.ExecuteNonQuery(commandUpdateRole);
return nResult;为什么执行不成功啊 看了半天也没看出错误在哪里
Response.Write(sqlUpdateVersion);
Database database = DatabaseFactory.CreateDatabase();
DbCommand commandUpdateRole = database.GetSqlStringCommand(sqlUpdateVersion);
database.AddInParameter(commandUpdateRole, "@docode", DbType.String, Dcode);
database.AddInParameter(commandUpdateRole, "@code", DbType.Int32, code);
int nResult = database.ExecuteNonQuery(commandUpdateRole);
return nResult;为什么执行不成功啊 看了半天也没看出错误在哪里
Database database = DatabaseFactory.CreateDatabase();
DbCommand commandUpdateRole = database.GetSqlStringCommand(sqlUpdateVersion);
database.AddInParameter(commandUpdateRole, "@docode", DbType.String, Dcode);
database.AddInParameter(commandUpdateRole, "@code", DbType.Int32, code);
int nResult = database.ExecuteNonQuery(commandUpdateRole);
AddInParameter方法是如何传递commandUpdateRole的?检查是否第一次传参的时候commmand就被重新设置了呢?