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

            var db = HemsRoom.GetDatabase();

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

            var db = HemsRoom.GetDatabase();

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