コード例 #1
0
        public static void Update(string constructionCode)
        {
            var sql = string.Empty;

            sql = @"UPDATE ConvertionLightSerials 
                    SET ConfirmedFlag = 'true' WHERE ConstructionCode = '" + constructionCode + "'";

            var database = ConvertionLightSerial.GetDatabase();

            database.ExecuteNonQuery(sql);
        }
コード例 #2
0
        public static List <ConvertionLightSerial> GetSerials(string constructionCode)
        {
            var result = new List <ConvertionLightSerial>();
            var sql    = @"
            SELECT *
            FROM  ConvertionLightSerials
            WHERE ConstructionCode = '" + constructionCode + @"'";

            var db = ConvertionLightSerial.GetDatabase();

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