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