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); }
public static void Update(string constructionCode, List <RimokonNicheEntry> entries, int nicheSeq) { RimokonNicheEntry.Delete(constructionCode, nicheSeq); entries.ForEach(p => p.Store()); }