public static List <RimokonNicheEntry> Get(string constructionCode) { string sql = @" SELECT * FROM RimokonNicheEntries WHERE ConstructionCode = '" + constructionCode + "'"; var db = RimokonNicheEntry.GetDatabase(); return(db.ExecuteQuery <RimokonNicheEntry>(sql)); }
public static void DeleteRemainedEntries(string constructionCode, int maxSeq) { string sql = @" DELETE FROM RimokonNicheEntries WHERE ConstructionCode = '" + constructionCode + @"' AND NicheSeq > " + maxSeq; var db = RimokonNicheEntry.GetDatabase(); db.ExecuteNonQuery(sql); }