public string DateTimeStructToString(DateTimeStruct dateTimeStruct)
{
return new DateTime(dateTimeStruct.year, dateTimeStruct.month, dateTimeStruct.day, dateTimeStruct.hour, dateTimeStruct.minute, dateTimeStruct.second).ToString("yy-MM-dd T");
}
private int SetValue(DateTimeStruct value)
{
string tableName = "tmValue";
string autoIncrementColumn = GetAutoIncrementColumnName(tableName);
int autoIncrementValue = GetTableAutoIncrementValue(tableName, 1);
string query = "INSERT INTO " + tableName + " (" + autoIncrementColumn
+ ",ValueSubTypeID,InfinityTypeID,ValueDate) VALUES "
+ "(" + autoIncrementValue + ","
+ constants.ValueSubTypeEnumDictionary[ValueSubTypeEnum.DateTimeType] + ","
+ constants.InfinityTypeEnumDictionary[InfinityTypeEnum.None] + ","
+ "'" + constants.DateTimeStructToString(value) + "'"
+ ")";
ExecuteInsertQuery(query, tableName);
return autoIncrementValue;
}