public static List <HemsDevice> Get(string constructionCode) { string sql = @" Select * FROM HemsDevices WHERE ConstructionCode = '" + constructionCode + @"'"; var db = HemsDevice.GetDatabase(); return(db.ExecuteQuery <HemsDevice>(sql)); }
public static void Delete(string constructionCode) { string sql = @" DELETE FROM HemsDevices WHERE ConstructionCode = '" + constructionCode + @"'"; var db = HemsDevice.GetDatabase(); db.ExecuteNonQuery(sql); }