public static bool HasHemsBundenban(string constructionCode)
{
var sql = @"
SELECT * FROM ShikakuTableEntries
WHERE
ConstructionCode = '" + constructionCode + @"' AND
ItemId = 81"; // 81:HEMS分電盤：有
var db = ShikakuTableEntry.GetDatabase();
var entries = db.ExecuteQuery <ShikakuTableEntry>(sql);
if (entries.Count == 0)
{
return(false);
}
var ari = entries[0];
if (ari.Value == "True")
{
return(true);
}
else
{
return(false);
}
}
public static void Delete(string constructionCode)
{
string sql = @"
DELETE FROM ShikakuTableEntries
WHERE
ConstructionCode = '" + constructionCode + "'";
var db = ShikakuTableEntry.GetDatabase();
db.ExecuteNonQuery(sql);
}
public static List <ShikakuTableEntry> Get(string constructionCode)
{
string sql = @"
SELECT * FROM ShikakuTableEntries
WHERE
ConstructionCode = '" + constructionCode + "'";
var db = ShikakuTableEntry.GetDatabase();
return(db.ExecuteQuery <ShikakuTableEntry>(sql));
}