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