/// <summary>
/// 更新某一状态下所有时间的完成时间
/// </summary>
/// <param name="endTime"></param>
/// <param name="state"></param>
/// <returns></returns>
public int UpdateEndTime(DateTime endTime, AMSEventState state)
{
SqlClauseBuilderBase wBuilder = new WhereSqlClauseBuilder().AppendItem("State", state.ToString());
SqlClauseBuilderBase uBuilder = new UpdateSqlClauseBuilder().AppendItem("EndTime", endTime);
Dictionary <string, object> context = new Dictionary <string, object>();
ORMappingItemCollection mappings = this.GetMappingInfo(context);
string sql = string.Format("UPDATE {0} SET {1} WHERE {2}",
mappings.TableName, uBuilder.ToSqlString(TSqlBuilder.Instance), wBuilder.ToSqlString(TSqlBuilder.Instance));
return(DbHelper.RunSql(sql, this.GetConnectionName()));
}
public int UpdateEventChannelState(string eventID, string channelID, AMSEventState state)
{
eventID.CheckStringIsNullOrEmpty("eventID");
channelID.CheckStringIsNullOrEmpty("channelID");
WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder();
wBuilder.AppendItem("EventID", eventID);
wBuilder.AppendItem("ChannelID", channelID);
ORMappingItemCollection mappings = ORMapping.GetMappingInfo <AMSEventChannel>();
SqlClauseBuilderBase uBuilder = new UpdateSqlClauseBuilder().AppendItem("State", state.ToString());
string sql = string.Format("UPDATE {0} SET {1} WHERE {2}",
mappings.TableName, uBuilder.ToSqlString(TSqlBuilder.Instance),
wBuilder.ToSqlString(TSqlBuilder.Instance));
return(DbHelper.RunSql(sql, this.GetConnectionName()));
}
