public int Update(Entities.OAMQMessage message)
{
//string sql = @"update OAMQMessages set Status = :Status, ErrorCount = :ErrorCount WHERE MessageId = :MessageId ";
//System.Data.Common.DbCommand cmd = this.DataSource.GetSqlStringCommand(sql);
//string prefix = ":";
//this.AddParameter(this.DataSource, cmd, System.Data.DbType.Int32, prefix + "Status", message.Status);
//this.AddParameter(this.DataSource, cmd, System.Data.DbType.Int32, prefix + "ErrorCount", message.ErrorCount);
//this.AddParameter(this.DataSource, cmd, System.Data.DbType.String, prefix + "MessageId", message.MessageId.ToString());
string sql = @"update OAMQMessages set
Sendertime = :Sendertime
,Status = :Status
,ErrorCount = :ErrorCount
WHERE MessageId = :MessageId ;";
System.Data.Common.DbCommand cmd = this.DbConnection.CreateCommand();
cmd.CommandText = sql;
string prefix = string.Empty;
this.AddParameter(cmd, System.Data.DbType.String, prefix + "Sendertime", message.Sendertime.ToString("yyyy-MM-dd HH:mm:ss"));
this.AddParameter(cmd, System.Data.DbType.Int32, prefix + "Status", message.Status);
this.AddParameter(cmd, System.Data.DbType.Int32, prefix + "ErrorCount", message.ErrorCount);
this.AddParameter(cmd, System.Data.DbType.String, prefix + "MessageId", message.MessageId.ToString());
return(cmd.ExecuteNonQuery());
}
public int Update(Entities.OAMQMessage message)
{
string sql = @"update OAMQMessages set
Sendertime = @Sendertime
,Status = @Status
,ErrorCount = @ErrorCount
,MessageRemark=@MessageRemark
WHERE MessageId = @MessageId ;";
System.Data.Common.DbCommand cmd = this.DbConnection.CreateCommand();
cmd.CommandText = sql;
string prefix = string.Empty;
this.AddParameter(cmd, System.Data.DbType.DateTime, prefix + "Sendertime", message.Sendertime);
this.AddParameter(cmd, System.Data.DbType.Int32, prefix + "Status", message.Status);
this.AddParameter(cmd, System.Data.DbType.Int32, prefix + "ErrorCount", message.ErrorCount);
this.AddParameter(cmd, System.Data.DbType.String, prefix + "MessageId", message.MessageId);
this.AddParameter(cmd, System.Data.DbType.String, prefix + "MessageRemark", message.MessageRemark);
return(cmd.ExecuteNonQuery());
}
