예제 #1
0
        public static void Delete(string constructionCode)
        {
            string sql = @"
                DELETE FROM HemsRoomBlocks
                WHERE
                    ConstructionCode = '" + constructionCode + @"'";

            var db = HemsRoomBlock.GetDatabase();

            db.ExecuteNonQuery(sql);
        }
예제 #2
0
        public static List <HemsRoomBlock> Get(string constructionCode)
        {
            string sql = @"
                SELECT *
                FROM HemsRoomBlocks
                WHERE
                    ConstructionCode = '" + constructionCode + @"'";

            var db = HemsRoomBlock.GetDatabase();

            return(db.ExecuteQuery <HemsRoomBlock>(sql));
        }