zjh
6 天以前 98958cdd70d3a63a562e9238ddecb9c6c6865e95
StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -121,6 +121,23 @@
        }
    }
    // 执行查询并返回单个值(带参数)
    public object ExecuteScalar(string sql, CommandType commandType, OracleParameter[] parameters)
    {
        using (var connection = new OracleConnection(_connectionString))
        {
            using (var command = new OracleCommand(sql, connection))
            {
                command.CommandType = commandType;
                if (parameters != null)
                    command.Parameters.AddRange(parameters);
                connection.Open();
                return command.ExecuteScalar();
            }
        }
    }
    // 执行存储过程
    //OracleParameter[] parameters = new OracleParameter[]