Exemplo n.º 1
0
        public static void Delete(string constructionCode)
        {
            string sql = @"
                DELETE FROM PartsColorEntries
                WHERE
                    ConstructionCode = '" + constructionCode + "'";

            var db = PartsColorEntry.GetDatabase();

            db.ExecuteNonQuery(sql);
        }
Exemplo n.º 2
0
        public static List <PartsColorEntry> Get(string constructionCode)
        {
            string sql = @"
                SELECT * FROM PartsColorEntries
                WHERE
                    ConstructionCode = '" + constructionCode + @"'
                ORDER BY
                    ConstructionCode,
                    Seq";

            var db = PartsColorEntry.GetDatabase();

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