/// <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())); }