关于.net 中更新oracle更新时间的问题
public void UpdateScore(int baseScore, int Special,string caseNumber)
{
Database db = DatabaseFactory.CreateDatabase("EpointMis_ConnectionString");
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"update Punish_MemberScore set BaseScore_End=:baseScore,SpecialScore_end=@Special,EndTime=@endTime where CaseNumber=@caseNumber" :
"update Punish_MemberScore set BaseScore_End=:baseScore,SpecialScore_end=:special,EndTime=:endTime where CaseNumber=:caseNumber";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "baseScore", DbType.Int32, baseScore);
db.AddInParameter(cmd, "special", DbType.Int32, Special);
db.AddInParameter(cmd, "endTime", DbType.Date, System.DateTime.Now.ToString());
db.AddInParameter(cmd, "caseNumber", DbType.String, caseNumber);
db.ExecuteNonQuery(cmd);
}
不报错,页面一直显示请稍后,