C# (CSharp) ReleaseDate.ToUnixTimeStamp示例

示例#1

 public string ToSQLInsert()
 {
     return(string.Format("INSERT INTO `{0}` (`album_id`, `title`, `creation_date`, `release_date`, `reviewer_id`, `artist_id`, `score`, `label`, `cover_path`, `similar_albums_nodes`, `additionnal_similar_albums_titles` `sorting_weight`) VALUES ('{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}');"
                          , SQLTableName, Id, Title.ToCamelCase().GetSafeMySQL(), CreationDate.ToUnixTimeStamp(), ReleaseDate.ToUnixTimeStamp()
                          , Reviewer.Id, Artist.Id, Score, LabelVendor.Label.ToCamelCase(), CoverName.GetSafeMySQL()
                          , SimilarAlbums.Aggregate(string.Empty, (seed, entry) => seed + "|" + entry.Id).Trim('|')
                          , RawSimilarAlbums.Aggregate(string.Empty, (seed, entry) => seed + "|" + entry.ToCamelCase().GetSafeMySQL()).Trim('|')
                          , SortWeight));
 }